The Complete Microsoft SQL Server Course: From A to Z

Focused View

Meta Brains

2:52:42

244 View

1 - Introduction

1 - Introduction to Microsoft SQL.mp4

02:37

2 - What is SQL.mp4

01:57

2 - What is a DBMS Database Management System

3 - Types of Databases.mp4

02:24

4 - How a DBMS Works.mp4

01:59

3 - Tables Relationships and Installation

5 - What is a Table data.mp4

04:04

6 - Onetoone Relationships.mp4

02:41

7 - Onetomany Relationships.mp4

03:10

8 - Manytomany Relationships.mp4

03:16

9 - Installation of SQL Server.mp4

06:06

10 - Creating Tables in SQL Server.mp4

06:43

4 - Data Types in SQL server

11 - Numeric data types.mp4

04:09

12 - String data types.mp4

09:27

13 - Data types.mp4

02:10

5 - Basics of SQL server

14 - Insert key.mp4

07:58

15 - Select Key.mp4

05:03

16 - Avg min and max.mp4

03:14

17 - where class with logic.mp4

04:38

18 - order.mp4

03:28

19 - null or not null.mp4

03:33

20 - Delete and Update.mp4

03:51

21 - Like Operator.mp4

08:59

22 - Wildcards.mp4

07:58

23 - Constraints.mp4

09:44

24 - Primary and Foreign key.mp4

08:48

25 - Joins.mp4

04:52

26 - Normalization.mp4

17:28

27 - Database Design.mp4

10:29

28 - Union Intersect or except.mp4

08:00

29 - Index.mp4

11:08

6 - Conclusion

30 - Conclusion.mp4

02:48

Description

A thorough guide to writing SQL queries in Microsoft SQL Server

What You'll Learn?

You’ll learn how to create databases and tables using Microsoft SQL
You'll learn how to write UPDATE, SELECT, and DELETE statements
You’ll learn how to write SOL Table Join Statements
You’ll learn the GROUP By Clause and how to use it to put data in a group
You’ll learn how to select records from tables
You’ll learn how to integrate SQL Server into real-world applications, gaining the requisite experience for working in a team

Who is this for?

Anybody that wants to go into personal data processing or seeking employment as a Data Scientist, Database Administrator, Business Analyst, ETL Administrator, etc.

Intermediate developers working on a project involving Microsoft’s database engine

Beginners in SQL database systems. Learning about Microsoft SQL Server is a great foundational template for learning other database management engines

More details

Description
Databases are crucial in the typical software development process, and developers use SQL (Structural Query Language) to communicate with databases. Released in 1989, Microsoft SQL Server is one of the most popular database engines in the world, and itâ€™s a must-learn for anyone that wants to become an expert.
When developing software, developers need a database server to store information theyâ€™ll collect from prospective users, and the Microsoft SQL Server is an attractive option. To use Microsoft SQL Server, however, you need robust knowledge of the languages it supports.
This course will teach everything you need to know about Microsoft SQL (Transact-SQL or T-SQL), from introductory topics like creating databases and tables to more complex ones like creating stored procedures and sorting data from multiple tables. While the course is designed for beginners, itâ€™s perfect for intermediate Microsoft SQL users looking to brush up their knowledge.
Youâ€™ll get clear, concise, and comprehensive lecture videos to enhance your understanding of the subject matter. The instructor is also available through the chat, ready to answer any potential questions you might have about Microsoft SQL. Plus, the course has many exercises and additional recommended study materials to help you better understand it.
Why Should You Enroll in this Course?
Microsoft SQL Server is the third most popular database management system out there, trailing Oracle SQL Developer and MySQL. From that data, itâ€™s clear that there are opportunities in the market for experienced Microsoft SQL developers.
As far as Microsoft SQL courses go, you wonâ€™t find anything much better than what this course has to offer. It explains the fundamentals of the Microsoft SQL Server, helping you grow from being a complete noob to a near expert in database technology.
The course highlights many of Microsoft SQLâ€™s features, teaching you how to simplify your workload using AI for instance. Also, youâ€™ll be learning from instructors using the latest version of the database software, so you donâ€™t have to deal with missing lessons and deprecated functions.
Who this course is for:
Anybody that wants to go into personal data processing or seeking employment as a Data Scientist, Database Administrator, Business Analyst, ETL Administrator, etc.
Intermediate developers working on a project involving Microsoftâ€™s database engine
Beginners in SQL database systems. Learning about Microsoft SQL Server is a great foundational template for learning other database management engines

User Reviews

Rating

average 0

Total votes0

Focused display

Meta Brains is a professional training brand developed by a team of software developers and finance professionals who have a passion for Coding, Finance & Excel.We bring together both professional and educational experiences to create world-class training programs accessible to everyone.Currently, we're focused on the next great revolution in computing: The Metaverse. Our ultimate objective is to train the next generation of talent so we can code & build the metaverse together!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.