- Query data across multiple tables
- Answer business questions using SQL
- Define table relations
Intermediate SQL for Data Engineering [6 lessons]
Joining Data in SQL 2hLesson Objectives
- Employ the four common join types
- Employ joins with subqueries to write intermediate queries
- Answer business questions using joins
Intermediate Joins in SQL 2hLesson Objectives
- Write queries that join three or more tables
- Define recursive joins, pattern matching, and the case statement
- Write advanced joins
Building and Organizing Complex Queries 2hLesson Objectives
- Format queries to make them readable
- Organize your queries using the "with" clause
- Combine tables using set operations
Querying SQLite from Python 1hLesson Objectives
- Run SQL queries using sqlite3 in Python
- Employ cursors and tuples
Table Relations and Normalization 2hLesson Objectives
- Apply the SQLite shell with databases
- Normalize database tables
- Update data in database tables
Guided Project: Answering Business Questions using SQL 1hLesson Objectives
- Frame a business question into advanced SQL queries
- Create visualizations of your query results using pandas
- Write analyses of your work
Projects in this course
Guided Project: Answering Business Questions using SQL
Learn and practice the SQL data analysis workflow.
The Dataquest guarantee
Dataquest has helped thousands of people start new careers in data. If you put in the work and follow our path, you’ll master data skills and grow your career.
We believe so strongly in our paths that we offer a full satisfaction guarantee. If you complete a career path on Dataquest and aren’t satisfied with your outcome, we’ll give you a refund.
Master skills faster with Dataquest
Go from zero to job-ready
Learn exactly what you need to achieve your goal. Don’t waste time on unrelated lessons.
Build your project portfolio
Build confidence with our in-depth projects, and show off your data skills.
Challenge yourself with exercises
Work with real data from day one with interactive lessons and hands-on exercises.
Showcase your path certification
Impress employers by completing a capstone project and certifying it with an expert review.
ChatGPT is an artificial intelligence chatbot developed...
With the ever-growing applications of Artificial Intell...
Kevin Johnson, Data Analyst Kevin Johnson is a data ana...
Introduction Deep learning is a rapidly growing subfiel...
Grow your career with
of learners recommend
Dataquest for career advancement
Dataquest rating on
G2Crowd and SwitchUp
Average salary boost
for learners who complete a path
Join 1M+ data learners on
Sign up for a free account
Choose a course or path
Learn with hands-on exercises