This FULL course in SQL, In this video will cover how to write SQL using MS SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL.
#SQL #SQLServer #SQLTutorials
▬▬▬▬▬▬▬▬ SQL SERVER – Tutorials – FULL COURSE ▬▬▬▬▬▬▬▬
1) 00:00 – Introduction About the Complete Free SQL Course
2) 02:46 – Why we need Database
3) 16:31 – What is DBMS
3.1 What is MS SQL Server
4) 30:42 – Installation Link
5) 34:14 – SQL Server Demo
5.1 Creating Database
5.2 Exploring SSMS
5.3 SQL Server Service
6) 51:07 – System database
7) 54:37 – SQL (Structured Query Language)
7.1 DDL ( Create, Alter, Drop )
7.2 DML ( Insert, Update, Delete)
7.3 DQL (Select)
7.4 Datatype in SQL
8) 01:31:00 – Constraints
8.1 Not Null, Unique
8.2 Check, Default,
9) 01:58:14 – Primary Key, Foreign Key
10) 02:34:00 – SQL Queries
10.1 Select, Where, Order by
10.2 Distinct
11) 02:59:23 – String and Arithmetic Functions
11.1 Logical Conditions
11.2 Like (Pattern search)
12) 03:29:05 – SQL Operators and Aggregate Function
13) 03:58:45 – SQL Join
13.1 Left / Right/ Inner / Full
14) 05:24:30 – Set Operations
14.1 Union / Intersect / Except
15) 05:33:16 – DBA | Security | User Access
16) 06:10:47 – PL SQL and Views
16.1 Stored Procedures |Functions
16.2 Views | CTE | Temp tables
17) 07:24:47 – Triggers / Cursors
18) 07:57:41 – Indexing
18.1 Clustered / Non clustered
How to install SQL Server DBMS
https://youtu.be/mK8a07Evkcs
Video to install Sample Databases
https://youtu.be/vfh_Kdp8M7o
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬
Telegram Channel – http://t.me/analyticswithnags
LinkedIn Page – https://www.linkedin.com/company/analyticswithnags
Complete Playlists
Power BI Tutorials – Complete Playlist 📚📖 https://www.youtube.com/watch?v=T_bRcvmOMSM&list=PLjNd3r1KLjQt0xN_y8F6BSIOVNvdQmq4d
Power BI Desktop Tips and Tricks 📚📖 https://www.youtube.com/watch?v=PyFQh8MmDWo&list=PLjNd3r1KLjQv4ds9tM-HbWDrrugMADmgp
Power BI DAX – Complete Playlist 📚📖 https://www.youtube.com/watch?v=sCAQtqHINAQ&list=PLjNd3r1KLjQuVWrPuygE8QwEmCL6rrUrx
Power BI Services Playlist 📚📖 https://www.youtube.com/watch?v=F1BtmioYzGw&list=PLjNd3r1KLjQvi8p21uS522Xi3qEiFQH2r
Power BI Project Dashboards – Power BI Realtime Projects – Playlist 📚📖 https://www.youtube.com/watch?v=wS2Hw9CPJeY&list=PLjNd3r1KLjQty8rRYWwTUhS_gnzk0f2VK
Data Warehouse Tutorials 📚📖 https://www.youtube.com/watch?v=t52xNJTBicc&list=PLjNd3r1KLjQu4f2V9aa9C7NHqn-lTqppN
SQL Full Course | SQL Tutorial For Beginners 📚📖 https://www.youtube.com/watch?v=5FrBJ4PXj2s&list=PLjNd3r1KLjQtFEklcPDhidqC_2lmpjk5H
SSAS Tutorials – SQL Server Analysis Services 📚📖 https://www.youtube.com/watch?v=0YY7_k-Asmk&list=PLjNd3r1KLjQvvRu_EZ-TSydhIqNr3ZG94
SSIS Tutorials – SQL Server Integration Services 📚📖 https://www.youtube.com/watch?v=YyL88pQTFmk&list=PLjNd3r1KLjQsh6EP222gEz_XmW_DcvhXi
Power BI Interview Topics 📚📖 https://www.youtube.com/watch?v=Om_DqqvZWOM&list=PLjNd3r1KLjQtX-KTIk1_CjG5_3b5dxnGI
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 https://www.youtube.com/watch?v=bZRuQ6XJFYk&list=PLjNd3r1KLjQvj26IO4Wxz40YA198zVxP-
Excel for Data Analysis 📚📖 https://www.youtube.com/watch?v=dMBM9KamF4k&list=PLjNd3r1KLjQtfYL5UUfd92ME0CbL9uPKF
Power BI + R 📚📖 https://www.youtube.com/watch?v=dMBM9KamF4k&list=PLjNd3r1KLjQvPFEU7rlhwnw9fvBP40-2F
Azure for Analytics – Complete Tutorials 📚📖 https://www.youtube.com/watch?v=dMBM9KamF4k&list=PLjNd3r1KLjQsQqRO7qInxEeX3a4DGRj1k
Catch with Nags 📚📖 https://www.youtube.com/watch?v=_qZZCD26quw&list=PLjNd3r1KLjQstljLO-5SLmCM2AThWenqw
Nags Checklist 📚📖 https://www.youtube.com/watch?v=auQbMvQSx0w&list=PLjNd3r1KLjQv1zMF08IjuCIsG1Inuv2cF
Visuals with Nags 📚📖 https://www.youtube.com/watch?v=LfEz7jUAbEc&list=PLjNd3r1KLjQtDEEeTGmcouBc0WJQftvGv