SQL Server Tutorial For Beginners | Microsoft SQL Server Tutorial | SQL Server Training | Edureka

This Edureka tutorial video on Microsoft SQL Server tutorial explains all the fundamentals of MS SQL Server with examples. The following are the topics covered in this Microsoft Server tutorial:

1:35 What is DBMS?
2:40 Types of DBMS
4:10 What is SQL?
5:25 What is SQL Server?
7:15 Features of SQL Server
10:30 SQL Server Installation
18:53 SQL Server Architecture
20:28 SQL Server Command Categories
21:18 SQL Server Data Types
22:53 DDL Commands
31:53 Keys in Database
33:13 Constraints in Database
40:00 DML Commands
1:15:47 Operators
1:28:07 Nested Queries
1:29:32 Joins
1:33:17 Stored Procedures
1:35:32 DCL Commands
1:37:52 TCL Commands
1:41:47 Exception Handling

--------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
#Edureka #EdurekaSQL #sqlservertutorial #sqlserver #microsoftsqlserver #sqlservertutorialforbeginners #sqltraining

How does it work?

1. This is a 4 Week Instructor-led Online Course.
2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project
3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course.
4. You will get Lifetime Access to the recordings in the LMS.
5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate!

- - - - - - - - - - - - - -

About the Course

MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data.

- - - - - - - - - - - - - -

Who should go for this course?

This course can be beneficial for people having the below professional background:
Database Developers
Application Developers
Database Designers
Database Administrators
- - - - - - - - - - - - - -

Project

In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :-

• Employee list to be maintained having id, name, designation, experience
• Salary details having employee id, current salary
• Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee
• Salary increment to be given by next year if any depending upon constraints
• Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted.

- - - - - - - - - - - - - -

Got a question on the topic? Please share it in the comment section below and our experts will answer it for you.

[BudgetDiety]

Hey, narrator. In case nobody told you today, your awesome at your job and you've sincerely helped a computer science major on his way to make a career.

[TheAssbot]

This was a fantastic tutorial with loads of information and a great framework to introduce the topics. It was I little bit too fast for beginners so took me a few hours to follow through with notes and examples. Thanks for the hard work!

[HichigoShirosaki]

There's nothing like seeing it first hand. It's very packed with info. Awesome tutorial!

[millicentcooper]

One of the best tutorial. Makes me want to take SQL by the horn.
Thank you!

[theplatinums]

Initially I thought, this is a very speedy session, but then realized that this is a very well organized sprint which gives you a very quick overview of the overall SQL, in least possible time. And this is up to you to search for further details on any topic, later on. A thumbs UP for hard efforts....

[El-onue]

This tutorial has precisely everything I was looking for. Thank you so much, Edureka.

[IceCold_Inc]

Solid tutorial! The teacher speaks a bit too fast but I got used to the speed pretty quick

[syednoumanullahshah]

Dear Eudreka, your teaching method is very amazing, it helps us alot in mastering sql server, can you please make a detail video on "SECURING SQL SERVER".
Like logins, server roles, database roles, granting and revoking permissions, etc.
Will be waiting for your kind response.
Thanks in Advance
Regards:
Syed Noumanullah from Pakistan

[mdabduljalil]

One of the best tutorials I have ever seen.

[rahulmittal]

Informative video!!
Thanks for this.
One feedback - You can slow down your speed to little extent then it will be more beneficial.

[michaelroberts]

A superb, thorough, well explained and highly detailed tutorial that I would hugely recommend to anyone looking to upskill. Great work Edureka and thank you!

[artemburov]

Thank you very much for such a great tutorial! I had to recall T-SQL after several years of working with Oracle. There are some differences :) All the topics I need have been covered. Thanks!

[sudeshparate]

That was a thoroughly followed tutorial 1st time. Such a great vice to learn from. Want more tutorial videos from her.

[ronaldlangbecker]

I tried to 'add' the Sql Server Package from inside Microsoft Visual Studio. For some reason, I thought this would take the place of going through the install. Obviously, it didn't work or I didn't do something right. Now I'm following the install directions from this video. Thank you.

[Surya-npbb]

Such a fantastic tutorial, no time waste, just pure content to learn. Thanks❤

[pannaperis]

Huge knowledge based video it is. Thank you very much edureka! It's really very much helpful and important video for the first-hands to get a strong knowledge by the time of starting. Thanks again!

[praveenkumar_]

Thank you Edureka and I have gained basic understanding of SQL server and will do hands on...

[Dinesh_kuku]

If your rename function is not working try,
adding 'exec' at the start of command.

[syedbilal]

Edruka ! One of the best tutorials i have ever seen..May ALLAH bless u <3

[avinashk]

too fast for beginners... watch on .75 playback speed.