Skip to content Skip to sidebar Skip to footer

Microsoft SQL Server Essentials

Microsoft SQL Server Essentials

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 37 lectures (5h) | Size: 1.9 GB

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

DMAILDCETRDSAOEQLKEHSZAESSENDTIEL

 

you must be registered member to see linkes Register Now

Leave a comment