Data Management and Database Design Part 2

Northeastern University via Coursera

Go to class Write review

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off

One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.

Unlock All Certificates

Data Management and Database Design Part 2 advances your database expertise with performance optimization, advanced SQL, enterprise administration, and cloud technologies. Complete your project database while mastering production-level skills in security, scaling, and distributed systems. Build the advanced competencies needed for senior database and data architect roles.

Syllabus

Transaction Management/ACID Properties

In Module 8, you will learn the critical aspects of transaction management and concurrency control in database systems, which are essential tools for maintaining data integrity and performance in multi-user environments. This module is also designed to help you evaluate different concurrency control mechanisms and understand their implications on data integrity and transaction efficiency. You'll learn to analyze transaction blocking and understand its effects on database operations, equipping you with the skills to design more reliable and consistent database systems.

SQL DDL, Horizontal Reporting, and Graph Traversal

In Module 9, we tackle the multifaceted challenges of data security, encryption, and effective data presentation within database environments. Through this module, you will deepen your understanding of data vulnerabilities and the strategies used to mitigate them, assess various encryption algorithms for protecting sensitive information, and develop skills in creating streamlined reports in horizontal reporting format for efficient data analysis. You will also gain proficiency in manipulating graph data by leveraging advanced SQL programming techniques to handle complex data structures effectively.

Data Governance and SQL Server-Side Modules

In Module 10, you will explore the critical components of data governance and advanced SQL server-side programming, enhancing your ability to manage and manipulate organizational data effectively. This module will provide you with a thorough understanding of the principles of data governance, including its role in ensuring data quality, usability, and security. You will also analyze the advantages and limitations of SQL server-side modules compared to client-side code and learn to design and implement SQL functions and stored procedures for efficient data processing. Additionally, you will master effective error-handling techniques in SQL programming to ensure robustness and reliability in database operations.

Database Implementation

In Module 11, you will engage in the practical application of SQL server-side modules to implement and manage robust and efficient database systems. Specifically, we will focus on harnessing SQL functions, stored procedures, and triggers to automate processes and how they enforce business rules and maintain high standards of data integrity. You will learn how to create and deploy these SQL components proficiently, ensuring that your database not only functions effectively but also adheres to organizational data governance standards.

Data Mining

In Module 12, you will navigate the complex landscape of data warehouse design and data mining, gaining expertise in crafting efficient data storage solutions and extracting meaningful insights through advanced SQL operations and data visualization techniques. This module will guide you through various data warehouse design strategies, such as the Inmon and Kimball models, helping you understand their applications and effectiveness in different organizational contexts. You will also master SQL PIVOT operations to create horizontal-format reports for concise data representation and employ contemporary data visualization tools to communicate data-driven insights effectively.

SQL Set-Based Processing vs. Procedural Processing

In Module 13, you will learn the intricacies of SQL processing techniques, analyzing the contrasts between procedural and set-based processing to determine the most effective approach for a range of database tasks. This module will empower you to compare and evaluate the strengths and limitations of these processing styles, enhancing your ability to choose the right method based on the specific requirements of different data tasks. You will also assess various data movement strategies, gaining insights into their suitability for different data integration scenarios.

Data Resilience and Continuity Management

In Module 14, you will explore critical aspects of database resilience, focusing on redundancy and disaster recovery strategies to ensure data availability and business continuity. This module provides a comprehensive understanding of how to manage data redundancy effectively and evaluate disaster recovery plans for their efficacy in various operational environments. You will learn different synchronization methods and their applications in maintaining high database availability, preparing you to implement robust strategies that safeguard data against unforeseen events.