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
Artificial Intelligence for RoboticsStanford University via Udacity Intro to Computer Science
University of Virginia via Udacity Design of Computer Programs
Stanford University via Udacity Web Development
Udacity Programming Languages
University of Virginia via Udacity