The Ultimate SQL Course for Beginner's to Advanced- 2023
IN this video learn the concepts of sql from the very basic level to advanced level which i srequired to crack any sql interviews for analytics. In this video i have discussed the below concepts-
05:38 - Why Store data on cloud
08:27 - Intro to DBMS
09:46 - What can dbms do
14:35 - CRUD overview
16:00 - Relational and non relatinal database
23:05 - Relational Database - SQL
25:32 - Why SQL ?
27:00 - Datatypes in sql
30:27 - String datatypes
35:24 - Numeric Datatypes
37:41 - Date time datatypes
41:00 - Installation of SSMS
45:23 - CRUD Operations in details
47:00 - DDL
1:09:05 - DML
1:14:30 - DCL
1:15:09 - TCL
1:16:35 Primary key
1:39:04 - Suroogate key
1:40:30 - foriegn key
1:43:40 - composite key
1:50:44 - sql operators
2:35:30 - wildcard
2:43:58 - TOP / LIMIT
2:46:35 ORDER BY
2:52:20 functions in sql
2:53:06 string functions in sql
3:45:04 - date and time functions
3:55:15 mathematical functions
4:01:45 - Aggregate functions and group by
4:38:01 - having clause
4:55:23 - JOINS in sql
Resources used -
ppt - https://drive.google.com/file/d/1QtT9...
dataset2 -
https://docs.google.com/spreadsheets/...
https://github.com/ashutoshkr103/SQL-...
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - https://docs.google.com/forms/d/e/1FA...
Why you should definitely fill the analytics job updates google form - • Job Openings into business analyst data an...
_______________________________________________________________________
Connect with me
📸Instagram - / ashutoszh
💻Linkedin- / ashutosh.analytics
_____________________________________________________________________
Comment down if you have any doubts
Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science.
_____________________________________________________________________
🏷️ Tags
sql,
sql complete course for beginners,
best course for sql for freshers,
sql for analytics,
sql tutorials for beginners,
portfolio project sql,
sql portfolio project,
portfolio project on sql for resume,
sql interview portfolio project,
sql interview questions and answers,
sql for data analytics,
sql data science,
interview questions on sql,
sql hard questions,
sql problem solving,
ashutosh,
ashutosh kumar,
ashutosh kumar analytics
🏷️ HashTags
#sql #tutorials #project