YoVDO

SQL Tutorial for Beginners (and Technical Interview Questions Solved)

Offered By: freeCodeCamp

Tags

SQL Courses Python Courses MySQL Courses Relational Databases Courses

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

Introduction to Databases
Meta via Coursera
Web Development
Udacity
Introduction to Data Science
University of Washington via Coursera
Datenmanagement mit SQL
openHPI
Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX