SQL Tutorial for Beginners (and Technical Interview Questions Solved)
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 -
🔗 Advanced SQL Aggregation & Joins notebook -
🔗 SQL data file:
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:
Read hundreds of articles on programming:
13 views
91
25
3 months ago 00:08:30 2
Как собрать Зеркальный Скваер-0 | | How to Solve the Mirror Square-0 | SQ-0 Tutorial
3 months ago 00:14:06 2
How to Connect to PostgreSQL with EF Core: A Step-by-Step Guide
3 months ago 00:08:28 10
Лучшие бесплатные курсы и книги по Python в 2024 год.
3 months ago 02:49:35 1
Inventory Management System(C# Full Project using SQL server with source code)
3 months ago 00:09:42 1
SQL Tutorial #13 - SQL EXISTS and NOT EXISTS Operator
4 months ago 01:01:21 1
Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard
4 months ago 00:40:50 1
Full Project in Excel | Excel Tutorials for Beginners
4 months ago 00:19:07 1
Как создать базу данных MSSQL Server [Базы данных для C# программиста] #1
4 months ago 01:28:06 2
#002 Django СТРИМ 🔴 Рабочее окружение Backend разработчика + необходимые знания
4 months ago 02:37:26 1
Linux сервер для Django проекта (Nginx, gunicorn, PostgreSQL) + простой CI/CD 🔴 #008 Django СТРИМ
4 months ago 04:19:34 48
Learn PostgreSQL Tutorial - Full Course for Beginners
4 months ago 04:52:51 1
Artificial Intelligence Full Course | Artificial Intelligence Tutorial for Beginners | Edureka
4 months ago 00:59:12 40
face-to-many comfyui pinokio (PS2 Graphics) tutorial + more
5 months ago 03:10:25 1
СУБД для начинающих - Windows-приложение на C# c базой данных в MySQL - туториал на русском
5 months ago 00:09:34 1
C# MongoDB Beginner’s Guide: How To Update Documents
5 months ago 00:27:23 2
FastAPI - Базы данных и миграции Alembic #4
5 months ago 00:15:58 1
A Beginner’s Guide to MongoDB Filtering in C#
5 months ago 00:21:20 1
ВСЁ про Базы Данных в одном месте / ХАЙЛАЙТЫ
5 months ago 01:07:50 1
Учим Базы Данных за 1 час! #От Профессионала
5 months ago 15:18:23 1
IBM Data Analyst Complete Course | Data Analyst Tutorial For Beginners,
6 months ago 00:29:47 1
How I would learn & master it if I were to start over again
6 months ago 00:05:30 1
SQL. Урок 1.2 - Создание пользователя через PgAdmin