All courses
Data Science
Beginner
SQL & Database Design for Beginners
Learn SQL from the ground up — write queries, design databases, and analyze data like a professional. No prior experience needed.
J
Instructor
Jose Portilla · Head of Data Science · Pierian Training
What you’ll learn
- Write SQL queries with confidence — SELECT, WHERE, JOIN, GROUP BY, and more
- Understand relational database concepts: tables, keys, relationships, normalization
- Design databases from scratch using ER diagrams
- Use aggregate functions to analyze and summarize data
- Work with subqueries, views, and stored procedures
- Apply SQL in real scenarios: sales analysis, inventory tracking, customer reporting
Who this is for
- Complete beginners curious about databases and data analysis
- Business analysts who want to query data without relying on engineers
- Developers who want to strengthen their database fundamentals
- Anyone preparing for a data analyst or backend developer role
Curriculum
4 modules · 15 lessons
- What is a Database & Why SQL?15 min
- Setting Up PostgreSQL & pgAdmin20 min
- Tables, Rows & Columns20 min
About the instructor
Jose Portilla · Head of Data Science · Pierian Training
Jose Portilla has a BS and MS in Mechanical Engineering from Santa Clara University. He has been teaching online courses for over 8 years and has trained more than 3 million students in Python, SQL, machine learning, and data engineering.
Student reviews
5.0
2 reviews
5
2
4
0
3
0
2
0
1
0
L
Lucas Walker
Emma's explanations of JOINs finally made them click for me after years of confusion. Clear, practical, and well-paced.
M
Mia Carter
I used this course to prep for a job interview. Got the role. The database design section in particular is extremely well taught.