[[ 8.5 HOURS ]] Complete SQL End to End – SQL Server Tutorial { End to End } Full Course Beginners

SQL — 21/10/2022 · 21 Comments



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 ✉ : [email protected]

💬 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

21 Comments

  1. Got to learn so much about SQL in detail.. thank you so much for your tutorial💚so grateful of you sir💯 you deserve the best ✨

    Also if possible, could you suggest me the best way to practice and excel in it please

  4. Sir, what are the architectural difference between Oracle and MySQL server

    Whether the SQL syntanx are different for different RDBMS?

  9. Hello Sir, Please accept my sincere thanks and appreciation for teaching and providing this course. Although i took few days and found the last few topics challenging (Store procedure, functions, trigger & curser) which i think will need more practise and exposure. At last much thanks again. 🙏

  10. Super Grateful for getting this in such a crisp and precise manner and that too for free, it's easy to understand. Thank you!

  16. That Was Great Learning , i mean i have watched multiple Videos on SQL at different platforms however Nobody Provided Such Contents with Clarity As you did . Tq So much for This Exquisite and Wonderful Video.

  18. great efforts in this channel.

    I have only simple enquiry as a new sql learner.

    I haven't made my mind yet whether to use sql server or not.

    Is sql server the best solution available for those who want to manage and automate databases inside a medium size company.

    Is there any alternative i need to consider right from the beginning or any applications that is relevant to integrate with the database being used.

    I consider myself a machine learning enthusiast and and would mostly like to automate business solutions with the engine being used.

    Thanks for taking time to read this.. God bless you.

  21. Mohd is a terrorist name..IN our village which is in haryana.They are killing people who doesn't convert to their cult islamic group.

Leave a Reply

© 2023 53GB