Structured Query Language
SQL Basics
1. SQL Fundamentals, CRUD Operations & Setting Environment - https://lnkd.in/gTxrDMM5
2. Primary Key vs Unique Key, Auto Increment Values - https://lnkd.in/gTxrDMM5
3. DDL vs DML, Truncate vs Delete - https://lnkd.in/gaMhc7TD
4. Foreign Key Constraint - https://lnkd.in/gA8SmZWB
5. Distinct, Order By, Limit, Like Keyword - https://lnkd.in/gXA62xx7
6. Order of execution in SQL - https://lnkd.in/gmkKHqt6
7. Aggregate Functions in SQL - https://lnkd.in/gDkH-8jP
8. Datatypes in SQL - https://lnkd.in/g7Tr3Yc5
9. Logical Operators in SQL - https://lnkd.in/gwa5TNcX
10. Joins in SQL - https://lnkd.in/guqQeqJh
11. Difference between where and having in mysql - https://lnkd.in/guqQeqJh
12. Over Clause & Partition By Clause - https://lnkd.in/gpUMq2qd
13. Row Number Function in MySQL - https://lnkd.in/gGiar28J
14. Rank & Dense Rank - https://lnkd.in/gPWqFACZ
SQL Advanced
1. CTE in SQL - https://lnkd.in/gYZBApWj
2. SQL internals - https://lnkd.in/dhHHCiES
SQL Leetcode
SQL Practice
1. Codecademy
Codecademy offers an interactive SQL course that covers topics like SELECT queries, filtering and sorting data, and joining tables.
Link: https://lnkd.in/gcWu2GDR
2. Khan Academy
Khan Academy offers a free course that covers the basics of SQL, including querying data and manipulating data with SQL.
Link: https://lnkd.in/gUtqK8ri
3. W3Schools
W3Schools has a comprehensive SQL tutorial that covers all the basics of SQL syntax and functionality.
Link: https://lnkd.in/gaU9cABV
4. Mode Analytics
Mode Analytics offers a free SQL tutorial that focuses on data analysis and visualization with SQL. It covers topics like filtering, aggregation, and window functions.
Link: https://lnkd.in/giudrqXs
5. SQLZoo
SQLZoo provides a series of interactive SQL tutorials that allow users to learn SQL by practicing with real data sets.
Link: https://sqlzoo.net/
6. Learn SQL the Hard Way
Learn SQL the Hard Way is a free book that provides a step-by-step guide to learning SQL. It includes plenty of exercises and examples to help users practice.
Link: https://lnkd.in/gGmxV_sv
7. Stanford Database Course
Stanford University offers a free course on databases that covers the basics of SQL and other database management concepts.
Link: https://lnkd.in/gQYSYseq
8. SQLBolt
SQLBolt provides a series of interactive SQL lessons that teach users how to write queries and interact with databases.
Link: https://sqlbolt.com/
9. Udacity Intro to SQL
Udacity offers a free course that teaches the basics of SQL and how to work with databases using SQL.
Link: https://lnkd.in/gzcjMpfY
10. PostgreSQL Exercises
PostgreSQL Exercises is a collection of exercises and challenges designed to help users practice SQL queries and sharpen their skills.
Link: https://pgexercises.com/