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:
14 views
91
26
2 months ago 00:12:44 1
Welcome to Building an Online TicTacToe Game with SignalR and React | Introduction .Net 8.0
2 months ago 00:05:01 1
How to Use Full Text Indexes for beginners | Full Text Indexing in Laravel for Beginners #laravel
3 months ago 00:12:20 1
Módulos y Paquetes en Python 🐍 | Importación de módulos, paquetes y subpaquetes ✅
3 months ago 00:13:02 1
Как создать таблицу в бд / Как работают таблицы SQL [Базы данных для C# программиста] #2
4 months ago 04:26:52 1
Learn Python - Full Course for Beginners [Tutorial]
4 months ago 00:04:22 1
Laravel Data SQL Update: Migrations or One-Time Package?
4 months ago 01:07:50 1
Учим Базы Данных за 1 час! #От Профессионала
4 months ago 00:08:28 7
Лучшие бесплатные курсы и книги по Python в 2024 год.
5 months ago 06:42:29 1
Python App Development: Build Modern GUIs in 7 Hours (Beginners Course)
5 months ago 19:23:46 1
Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)
5 months ago 04:22:13 1
Data Analysis with Python - Full Course for Beginners (Numpy, Pandas, Matplotlib, Seaborn)
5 months ago 00:04:59 13
Allen & Heath SQ Compression Tutorial
5 months ago 00:26:16 1
C++ Introduction | C ++ Tutorial | Mr. Kishore
5 months ago 01:06:23 1
Energy power meters 3 units connect wtih WinCC Explorer SCADA Server and Client configuration
5 months ago 00:08:40 2
Tutorial Setup Emulator Cabal Online (Breaklee)
6 months ago 00:03:35 6
C++ Лучшие бесплатные курсы и книги 2024!
6 months ago 00:25:44 1
Structures in C | C Language Tutorial
6 months ago 00:11:51 1
Introduction to Pointers | C Language Tutorial
6 months ago 00:24:21 1
How to Install Oracle 19c and SQL Developer on windows 10/11 [ 2023 Update ] Complete guide
6 months ago 01:08:11 1
Core MVC CRUD Operations using .NET 8 and Entity Framework Core - MVC For Beginners Tutorial
6 months ago 00:20:44 1
Как собрать Скваер-0 | | How to Solve the Square-0 | SQ-0 Tutorial
7 months ago 01:15:36 1
How to Create Hotel Management System in C# with SQLite Database - Full Tutorial
7 months ago 00:27:02 12
How To Migrate ZABBIX from MySQL to PostgreSQL
7 months ago 00:51:43 1
Туториал по базе данных на демонстрационный экзамен 2023 по правилам WorldSkills в колледжах