Lesson 1
Introduction to Relational Databases
Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
Course
SQL is one of the most versatile tools available for extracting insights from stored data. In this course, you will learn how databases work. You will also learn some basic SQL queries for that can be used to select, manipulate and aggregate data in databases.
SQL is one of the most versatile tools available for extracting insights from stored data. In this course, you will learn how databases work. You will also learn some basic SQL queries for that can be used to select, manipulate and aggregate data in databases.
Fluency
2 weeks
Completion Certificate
Last Updated January 8, 2024
Skills you'll learn:
Prerequisites:
No experience required
Lesson 1
Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
Lesson 2
In this section, you will gain knowledge about SQL basics for working with a single table. You will learn the key commands to filter a table in many different ways.
Lesson 3
Create your own database tables using normalized table design, using keys to declare relationships between tables; then apply these relationships to draw conclusions from data.
Lesson 4
In this lesson, you will learn how to combine data from multiple tables together.
Lesson 5
In this lesson, you will learn how to aggregate data using SQL functions which allow you to count, sum, find the minimum value, the maximum value, or an average of the data values.
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
Unlimited access to our top-rated courses
Real-world projects
Personalized project reviews
Program certificates
Proven career outcomes
Full Catalog Access
One subscription opens up this course and our entire catalog of projects and skills.
Average time to complete a Nanodegree program
2 weeks
, Fluency
4 weeks
, Beginner
1 week
, Fluency
2 weeks
, Fluency
5 hours
, Fluency
1 week
, Fluency
1 week
, Fluency
2 weeks
, Fluency
2 weeks
, Fluency
1 month
, Intermediate
(270)
2 months
, Beginner
5 hours
, Fluency
2 weeks
, Fluency
1 week
, Fluency
5 hours
, Fluency
1 week
, Fluency