Welcome to this comprehensive SQL tutorial course. This course covers the basics of relational databases and SQL, including setting up MySQL, inserting data, and working with aggregation, grouping, and pagination in SQL queries. It also covers advanced topics such as combining tables using joins, executing SQL queries using Python and SQL Alchemy, and solving technical interview questions. By the end of this course, you'll have the knowledge and confidence to excel in SQL.

️ Course created by@jovianhq

Important Links
Relational Databases notebook - https://jovian.com/aakashns/relational-databases-and-sql
Advanced SQL Aggregation & Joins notebook - https://jovian.com/aakashns/advanced-sql-aggregation-and-joins
SQL data file: https://raw.githubusercontent.com/harsha547/ClassicModels-Database-Queries/master/database.sql

A database is an organized collection of structured information, typically stored in the form of tables (rows & columns). Relational databases allow storing and retrieving different kinds of related information e.g. products, customers, and orders for an online shopping site. Structured Query Language or SQL (pronounced "sequel") is the most widely used language for interacting with relational databases, and is an essential skill for Data Science professionals.

⭐️ Contents ⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:01:28) Relational Databases & SQL
⌨️ (0:03:05) Setting up MySQL
⌨️ (0:29:23) Inserting Data into the Table
⌨️ (0:56:32) Practice Exercises
⌨️ (1:22:12) Aggregation, grouping & pagination in SQL queries
⌨️ (2:23:17) Mapping and Arithmetic Functions
⌨️ (2:54:53) Working with Dates
⌨️ (3:12:16) Combining Tables using Joins
⌨️ (3:30:14) Executing SQL queries using Python and SQL Alchemy
⌨️ (4:11:06) 3 step approach to Interview Questions
⌨️ (4:36:58) Interview Q - Apple
⌨️ (4:38:59) Interview Q - Linkedin
⌨️ (4:43:09) Interview Q - Meta
⌨️ (4:50:41) Interview Q - Uber
⌨️ (4:59:18) Interview Q - Amazon
⌨️ (5:07:27) Interview Q - Google

Thanks to our Champion and Sponsor supporters:
davthecoder
jedi-or-sith
南宮千影
Agustín Kussrow
Nattira Maneerat
Heather Wcislo
Serhiy Kalinets
Justin Hual
Otis Morgan

--

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news