SQL Tutorial for Beginners (and Technical Interview Questions Solved)
Offered By: freeCodeCamp
Course Description
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
Related Courses
Managing Big Data with MySQLDuke University via Coursera Database Management Essentials
University of Colorado System via Coursera Business Metrics for Data-Driven Companies
Duke University via Coursera Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique Базы данных (Databases)
Saint Petersburg State University via Coursera