Learn mostly used queries in the industry step by step

What you'll learn
How to create local & global temp tables
How to use different SQL functions
Student will learn queries that are frequently used in the industry
How to write high performance sub queries
After completing this course students can write SQL queries to fetch data for developing SSRS reports, Power BI direct query mode dashboards and lot more.

Requirements
Students should know about the basic understanding of database because this course is purely based on how write different SQL queries.

Description
SQL queries are the backbone of any data analytics project. SQL queries are used to fetch data from Microsoft SQL Server Management Studio, which stands for Structured Query Language.There are 4 modes of SQL Queries1- DDL - It is Data Definition Language and is used to define the structures like schema, database, tables, constraints etc. Examples of DDL are create and alter statements.2- DML - It is Data Manipulation Language used to manipulate data. Examples of DML are insert, update and delete statements.3- DCL - It is Data Control Language that is used to grant or revoke permissions.4- DQL - It is Data Query Language that is used to fetch the data from database using Select statement.The ultimate focus of this course is to learn DQL - Data Query Language. You will learn the following topics.- SQL Installation and Attaching adventureworks database- SQL Select statement- Selected columns in sql- Where clause in SQL- IN operator in SQL- NULL and Not NULL in SQL- Order by in SQL- TOP in SQL- SQL Distinct function- Rename columns in SQL- Lower, Upper, Trim, LTRIM, RTRIM function in SQL- Substring function in SQL- Replace function in SQL- SQL Charindex- SQL ISNULL- Coalesce in SQL- Group functions (sum, min, max, count, avg) & Group by in SQL- Having clause in SQL- Subqueries in SQL- Subqueries using IN operator- Another variation of SQL Subquery- Case statement and pivoting in SQL- Joins in SQL- Temp tables in SQL Server with non clustered index- How to create global temp table in SQL

Overview
Section 1: Introduction
Lecture 1 SQL Installation and Attaching adventureworks database
Lecture 2 SQL Select statement
Lecture 3 Selected columns in sql
Lecture 4 Where clause in SQL
Lecture 5 IN operator in SQL
Lecture 6 NULL and Not NULL in SQL
Lecture 7 Order by in SQL
Lecture 8 TOP in SQL
Lecture 9 SQL Distinct function
Lecture 10 Rename columns in SQL
Lecture 11 Lower, Upper, Trim, LTRIM, RTRIM functions
Lecture 12 Substring function in SQL
Lecture 13 Replace function in SQL
Lecture 14 SQL Charindex
Lecture 15 SQL ISNULL
Lecture 16 Coalesce in SQL
Lecture 17 Group functions
Lecture 18 Having clause in SQL
Lecture 19 Subqueries in SQL
Lecture 20 Subqueries using IN operator
Lecture 21 Another variation of SQL Subquery
Lecture 22 Case statement and pivoting in SQL
Lecture 23 SQL JOINS
Lecture 24 Temp tables in SQL Server
Lecture 25 Global temp table in SQL
Any one who is new to writing SQL queries or any one who want to refresh his/her knowledge about writing SQL Queries.

To Support My Work Buy Premium From My Links.