Udacity part of Accenture logo

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.

  • Beginner

  • 1 month

  • Last Updated March 13, 2024

Skills you'll learn:

MongodbSQL CRUD commandsDatabase normalization

Prerequisites:

Basic SQL

Course Lessons

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.

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

Photo of Ziad Saab

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.

The Udacity Difference

Combine technology training for employees with industry experts, mentors, and projects, for critical thinking that pushes innovation. Our proven upskilling system goes after success—relentlessly.

Demonstrate proficiency with practical projects

Projects are based on real-world scenarios and challenges, allowing you to apply the skills you learn to practical situations, while giving you real hands-on experience.

  • Gain proven experience

  • Retain knowledge longer

  • Apply new skills immediately

Top-tier services to ensure learner success

Reviewers provide timely and constructive feedback on your project submissions, highlighting areas of improvement and offering practical tips to enhance your work.

  • Get help from subject matter experts

  • Learn industry best practices

  • Gain valuable insights and improve your skills

Enroll in Management of Relational and Non-relational Databases. Choose the plan that works for you

All Access monthly

  • Unlimited access to our top-rated courses

  • Personalized Career Services

  • Cancel Anytime

  • Real-world projects

  • Personalized project reviews

  • Program certificates

Best Value

All Access bundle1

  • All the same great benefits as our monthly plan

  • The most cost-effective way to develop the skills you want

  1. 1Discount applies to the first 4 months of membership, after which plans are converted to month-to-month.

Your subscription also includes:

(288)

2 months

, Beginner

Udacity Accenture logo

Company

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

© 2011-2024 Udacity, Inc. "Nanodegree" is a registered trademark of Udacity. © 2011-2024 Udacity, Inc.
We use cookies and other data collection technologies to provide the best experience for our customers.