तुम्हाला SQL अगदी काहीच येत नसेल किंवा अगदी basic SQL येत असेल तर हा कोर्स तुमच्यासाठी आहे, जिथे तुम्हाला ह्या संपूर्ण व्हिडिओ मध्ये पूर्ण SQL (mySQL) हे शिकायला भेटणार आहे.. Basic to Advanced..
Topics covered:
Basic SQL – Introduction & Download and install MySQL
SELECT statement in SQL
Where Clause in SQL
group by + order by in SQL
Limit and Alias
Intermediate – Joins
Union in SQL
String Functions in SQL
Case Statement in SQL
Subqueries in SQL
Window Functions in SQL
Advanced SQL – CTE in SQL
Temporary Tables in SQL
Stored Prcedures in SQL
Triggers & Events in SQL
Database vs Data Warehouse vs Data Lake
——————————————————————————-
Course Resources:
📖 Download MySQL here: https://dev.mysql.com/downloads/installer/
📖 Download Database file from Github : https://shorturl.at/DtpRu
📖 Download SELECT query from Github : https://shorturl.at/zJGcy
📖 Download WHere clause query file from Github : https://shorturl.at/uZKih
📖 Download group by order by clause query file from Github : https://shorturl.at/585vl
📖 Download having vs Where query file from Github : https://shorturl.at/580iS
📖 Download Limit and Alias query file from Github : https://tinyurl.com/mc6w654v
📖 Download SQL joins Query file from Github : https://github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20joins.sql
📖 Download SQL Union Query file from Github :
https://github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20Union.sql
📖 Download SQL string functions Query file from Github :
https://github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20String%20Functions.sql
📖 Download Case Statement Query file from Github :
https://github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20Case%20Statement.sql
📖 Download subquery file from Github :
https://github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20Subqueries.sql
📖 Download windwos function file from Github :
https://github.com/AtulKadlag/MySQL_Intermediate_YTSeries/blob/main/Intermediate%20-%20Window%20Functions.sql
00:00:00 Basic SQL – Introduction & Download and install MySQL
00:12:44 SELECT statement in SQL
00:25:19 Where Clause in SQL
00:34:34 group by + order by in SQL
00:46:54 Limit and Alias
00:51:16 Intermediate – Joins
01:06:20 Union in SQL
01:14:13 String Functions in SQL
01:29:30 Case Statement in SQL
01:39:30 Subqueries in SQL
01:55:51 Window Functions in SQL
02:08:15 Advanced SQL – CTE in SQL
02:17:01 Temporary Tables in SQL
02:24:17 Stored Prcedures in SQL
02:37:05 Triggers & Events in SQL
02:48:49 Database vs Data Warehouse vs Data Lake
This is the full course in SQL which covers concepts from Basic to advanced. If you want to be SQL developer or Data Analyst or Data Scientist, SQL is base for many of the Data project. So learn full SQL here with simple explanation.
#sql
コメント