What you'll learn

Skills you'll gain

There are 7 modules in this course

By the end of this course, students will be able to: • Describe relational databases and their core components, including tables, rows, columns, and keys. • Implement relational database and usage of indexes, views, triggers, temporary tables, functions, and stored procedures. • Describe their role in enforcing business logic and data integrity in database environment. • Apply database design and SQL knowledge to real-world application development. • Develop database-driven applications using programming languages, such as Java, Python or C/C++ and frameworks. • Describe the concepts of indexing and hashing in efficient support for search operations. • Describe the concepts of transactions and their properties (ACID: Atomicity, Consistency, Isolation, Durability). • Define concurrency control and understand the impact of uncontrolled concurrent transactions on data integrity. Software Requirements: VS Code editor, MySQL Workbench, PostgreSQL To succeed in this course, learners should possess a solid understanding of relational database design. If you haven't yet mastered these skills, we strongly recommend completing Introduction to Relational Databases and Relational Database Design beforehand. These foundational courses are designed to equip you with the essential knowledge necessary to excel in this material.

Module 2: Advanced Window Functions and OLAP Queries in SQL

Module 3: Database Application Development

Module 4: Indexing and Hashing

Module 5: Transaction Concepts

Module 6: Concurrency Control

Summative Course Assessment

Explore more from Data Analysis