Overview
Dive into a comprehensive 5-hour SQL tutorial designed for beginners and those preparing for technical interviews. Master the fundamentals of relational databases and SQL, starting with MySQL setup and progressing to advanced topics like aggregation, joins, and executing queries with Python and SQL Alchemy. Learn to insert data, work with dates, and combine tables effectively. Gain practical experience through hands-on exercises and boost your interview readiness with a dedicated section on solving technical questions from top tech companies like Apple, LinkedIn, Meta, Uber, Amazon, and Google. By the end, acquire the skills and confidence to excel in SQL and tackle real-world database challenges.
Syllabus
⌨️ Introduction
⌨️ Relational Databases & SQL
⌨️ Setting up MySQL
⌨️ Inserting Data into the Table
⌨️ Practice Exercises
⌨️ Aggregation, grouping & pagination in SQL queries
⌨️ Mapping and Arithmetic Functions
⌨️ Working with Dates
⌨️ Combining Tables using Joins
⌨️ Executing SQL queries using Python and SQL Alchemy
⌨️ 3 step approach to Interview Questions
⌨️ Interview Q - Apple
⌨️ Interview Q - Linkedin
⌨️ Interview Q - Meta
⌨️ Interview Q - Uber
⌨️ Interview Q - Amazon
⌨️ Interview Q - Google
Taught by
freeCodeCamp.org