SQL Server 2022 - Database & Query
Expert Level Course Basic to Advanced
Duration : - 30 to 35 Hours 1-3 Batch Size
Class Time : - Mon to Fri Daily 1 Hours / Sun-Sat - 2Hours Classes Direct Contact Trainer
Course Fee - 10,000/ Call + 91 8802579388 , +91 8826828093
SQL SERVER INTRODUCTION
Microsoft SQL Server Advantages, Use
Versions and Editions of SQL Server Import and Export Wizard in SSMS
SQL : Purpose, Real-time Usage Options Data Imports with Excel File Data
SQL Server Components and Usage Performing Bulk Operations in SSMS
System Configuration Checker Tool Temporary Tables : Real-time Use
SQL Server and SSMS Installation Plan # and ## Prefix, Scope of Usage
SQL Server 2022 Installation Constraints and Keys - Data Integrity
SQL Server Management Studio 20.2 NULL, NOT NULL Property on Tables
Local and Remote Connections UNIQUE KEY Constraints: Importance
System Databases: Master and Model PRIMARY KEY Constraint: Importance
MSDB, TempDB, Resource Databases FOREIGN KEY Constraint: Importance
Creating Databases : Files [MDF, LDF] Index Sort Options, Search Advantages
Creating Tables in User Interface Create database
Create Table
Data Insertion & Storage. Limitations
Creating Databases & Tables in SSMS
Single Row Inserts, Multi Row Inserts
SQL Query
SELECT Statement @ Data Retrieval GROUP BY Queries and Aggregations
SELECT with WHERE Conditions Group By Queries with Having Clause
Batch Concept and Go Statement Group By Queries with Where Clause
AND and OR Operators Usage UNION and UNION ALL Operators
IN Operator and NOT IN Operator Comparing Where, Having Conditions
Between, Not Between Operators FUNCTION in SQL
>100 Function for Table and Data
LIKE and NOT LIKE Operators
Summery
UPDATE Statement & Conditions
DELETE & TRUNCATE Statements
Logged and Non-Logged Operations
ADD, ALTER and DROP Columns
ALTER & DROP Table Statements
Join Table Data / Query / Report Export
JOINS - Table Comparisons Queries
INNER JOINS For Matching Data Excel Pivot Tables and Reports
OUTER JOINS For (non) Match Data Export Via VBA
Left Outer Joins with Example Queries Get data from VBA
Right Outer Joins with Example Queries Get Data for Access VBA
FULL Outer Joins - Realtime Scenarios Power Query with SQL Query
Join Queries with "ON" Conditions SQL Query with Power BI
Join Unrelated Tables in SQL Server
NULL, IS NULL Operators in Joins
CROSS JOIN and CROSS APPLY
CROSS JOIN Versus CROSS APPLY
One-way & Two Way Data Comparisons
Join Options: Merge, Loop, Hash
Joins with Group By, Sub Queries
Using Joins with Nested Sub Queries
Function
Function Types, Usage in Real-time
Scalar, Inline and Multi-Line Functions
GetDate, Year, Month, Day Functions
Rollup with Having & Grouping
Date and Time Functions in SQL
Convert Functions with DateTime
DateTime Styles, DateAdd, DateDiff
String Functions: Trim, SubString
StringSplit, Concat, Len, Left, Right
