Lesson 1
Intro to DBMS: Relational and Non-Relational Databases
Get introduced to database management systems, as well as learning the difference between relational and non-relational databases.
Management of Relational and Non-relational Databases
Course
Databases need to be structured properly to enable efficient and effective querying and analysis of data. Build normalized, consistent, and performant relational data models. Use SQL Database Definition Language (DDL) to create the data schemas designed in Postgres and apply SQL Database Manipulation Language (DML) to migrate data from a denormalized schema to a normalized one. Understand the tradeoffs between relational databases and their non-relational counterparts, and justify which one is best for different scenarios. With a radical shift of paradigms, learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases.
Databases need to be structured properly to enable efficient and effective querying and analysis of data. Build normalized, consistent, and performant relational data models. Use SQL Database Definition Language (DDL) to create the data schemas designed in Postgres and apply SQL Database Manipulation Language (DML) to migrate data from a denormalized schema to a normalized one. Understand the tradeoffs between relational databases and their non-relational counterparts, and justify which one is best for different scenarios. With a radical shift of paradigms, learn about MongoDB and Redis to get an understanding of the differences in behaviors and requirements for non-relational databases.
4 weeks
Real-world Projects
Completion Certificate
Last Updated March 23, 2023
No experience required
Course Lessons
Lesson 2
Normalizing Data
Find out about the different forms of normalized data for optimizing database storage.
Lesson 3
Data Definition Language (DDL)
Learn about the data definition language, such as creating tables and different data types.
Lesson 4
Data Manipulation Language (DML)
Dive into the data manipulation language in order to alter existing tables and data.
Lesson 5
Consistency with Constraints
Find out how to keep consistency amongst your data by adding constraints.
Lesson 6
Performance with Indexes
Maximize your database performance by using indexes when and where appropriate.
Lesson 7
Intro to Non-Relational Databases
With your relational database skills in hand, you’re ready for a look into the other side of data, with non-relational databases.
Lesson 8 • Project
Udiddit, A Social News Aggregator
Investigate a poorly designed database for Udiddit, a social news aggregator. You’ll design a new, normalized and performant database and migrate over data from the previous database.
Taught By The Best
Ziad Saab
Software Developer and Co-Founder DecodeMTL
Ziad is a seasoned software developer who loves mentoring and teaching. Currently working as an independent contractor, he previously co-founded and taught full-stack web development at DecodeMTL, Montreal's first web development bootcamp.
Taught By The Best
Ziad Saab
Software Developer and Co-Founder DecodeMTL
Ziad is a seasoned software developer who loves mentoring and teaching. Currently working as an independent contractor, he previously co-founded and taught full-stack web development at DecodeMTL, Montreal's first web development bootcamp.
Get Started Today
Management of Relational and Non-relational Databases