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

Managing Big Data with MySQL
Duke 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