The Complete Microsoft SQL Masterclass: Bner to Expert
Genre: eLearning | MP4 | Video: h264, 1280×720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 5.08 GB | Duration: 10h 41m
Master course using Microsoft SQL Server 2019.
These SQL can also used in Oracle, MySQL, PostgreSQL, SQLite, DB2, etc.
What you’ll learn
Start your career by mastering complete SQL statements in Microsoft SQL Server
Queries and Files Included
Learn different ways to select Records from Tables
Filter the Records of the Table
How to sort the result
GROUP BY Clause
Learn all aggregate Functions
JOINs in table
UNION and UNION ALL
Create Tables
Insert Records
Update data inside table
Modify the column and constraints
The same set of SQL statements can be used with Oracle, PostgreSQL, MySQL, etc
All the Keys and Constraints are explained in detail
Requirements
No knowledge of SQL required for this course
We will install free version of Microsoft SQL Server 2019 in Windows
A laptop with Windows 8 or Windows 10
Description
‘This Course covers SQL using Microsft SQL Server but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2’.
“Welcome to the most popular Quality complete Course on Microsoft SQL Server(MS SQL Server)”
Covers different forms of SELECT Statements
Explains how to filter the Records
All the Arithmetic operators are explained
NULL Values are explained
Beautiful examples of all the operators
ORDER BY, GROUP BY, HAVING clauses has examples in detail
The course covers all the Aggregate Functions and other Functions
UNION and JOINs are explained with real-life examples
I have explained all types of Joins
Data types used in Microsoft SQL
Keys and Constraints are explained in detail
