SQL - Microsoft SQL Crash Course for Absolute Beginners

[Prohibitive]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 53 lectures (1 hour, 54 mins) | Size: 959 MB

This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.

What you'll learn

Start your career by learning all the basic 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

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 crash 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