Lesson 1
Data and Tables
Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
Course
Relational databases are a powerful tool used throughout the industry. Learn the basics of SQL and how to connect your Python code to a relational database.
Relational databases are a powerful tool used throughout the industry. Learn the basics of SQL and how to connect your Python code to a relational database.
Last Updated March 7, 2022
Prerequisites:
No experience required
Lesson 1
Learn the principles behind relational data organization: tables, queries, aggregations, keys, and joins.
Lesson 2
Start learning SQL by using the select and insert statements to read and write data in database tables.
Lesson 3
Learn the Python database API, and apply your knowledge to fix common bugs that arise in database-backed web services.
Lesson 4
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.
Command Line Instructor
Before joining Udacity, Karl was a Site Reliability Engineer (SRE) at Google for eight years, building automation and monitoring to keep the world's busiest web services online.
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
3 weeks
, Beginner
1 month
, Intermediate
1 month
2 weeks
4 weeks
, Beginner
1 month
, Beginner
1 week
1 month
(113)
2 months
, Intermediate
5 hours
1 month
(288)
2 months
, Beginner
2 months
, Beginner
4 weeks
, Beginner
2 weeks