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
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
Video to install Sample Databases
✉ 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
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
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
Thank you sir explanation is super
Sir, what are the architectural difference between Oracle and MySQL server
Whether the SQL syntanx are different for different RDBMS?
Sir, I would like to request you
Making videos on Java script and J2EE concepts
It's a great lecture. Thank you! 🥰
Is it sufficient for data analyst role?
sir mysql aur sql server me kyon sa job ke liya acha hoga?
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. 🙏
Super Grateful for getting this in such a crisp and precise manner and that too for free, it's easy to understand. Thank you!
Thank you So Much Sir 🙏
Sir SQL+PBI will be enough for entry-level or I have to go with SQL+PBI+DAX
Does this SQL version use data analytics employees?
Those documents can u share pls
Hiw can we jnstall
english ma video banana joruri ha kiya
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.
Pl sql covered in this 8 hrs video???
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.
where is backup
Thank you so much for sharing these valuable knowledge..I need to brush up all sql commands.
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.