Microsoft SQL Server Essentials
Microsoft SQL Server Essentials
Duration: 5h | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.85 GB
Genre: eLearning | Language: English
Duration: 5h | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.85 GB
Genre: eLearning | Language: English
Learn the fundamentals of Microsoft SQL Server Database - No prior knowledge of SQL is required!
What you'll learn:
Understand the concept of a relational database
Become familiar with Microsoft SQL Server
Create databases from the ground up and work with an existing database
Understand & write T-SQL which is Microsoft’s version of SQL
Get comfortable with SQL Server Management Studio
Master DML & DDL Concepts
Requirements:
No programming experience or database experience needed. You will be taught everything from the ground up
You only need a working PC and access to the internet to download the required tools
Description:
Microsoft SQL Server Essentials takes you through the journey of learning about the SQL Server database from Microsoft from the ground up. You will become familiar with concepts such as the Structured Query Language (SQL) and Microsoft's version (T-SQL).
At the end of the course, you should:
- Understand the concept of a relational database
- Become familiar with Microsoft SQL Server
- Work with Microsoft's IDE: SQL Server Management Studio
- Learn how to perform many database tasks using the Graphical User Interface (GUI)
- Understand & write T-SQL which is Microsoft’s version of SQL
- Create databases from the ground up and work with existing database
- Create database tables and define relationships between them
- Understand the concept of table constraints
- Create primary keys, foreign keys etc.
- Get comfortable with SQL Server Management Studio
- Master DDL – Data Definition Language
- Master DML – Data Manipulation Language
- Write simple to complex queries
- Learn how to use the various built-in functions in SQL Server such as DATE and STRING functions
- Learn how to filter queries with various commands
- Learn how to aggregate your query results
- Work with triggers, views and stored procedure
- Learn how to schedule jobs using SQL Server Agent
- Learn how to optimize your database queries for optimal execution
This course is ideal if you are getting started with backend development, data analytics or full stack development. You will learn everything you need to know in order to go from beginner to pro in Microsoft SQL Server.
Who this course is for:
Beginners who are interested in backend programming, database administration and data analytics
More Info