Getting Started
  • Introduction
  • Please Read
  • Database Concepts
SQL Server 2019 Setup
  • What is SQL Server
  • SQL Server 2019 Hardware | Software Installation Requirements
  • SQL Server Editions
  • Download SQL Server 2019 Developer Edition
  • SQL Server 2019 Developer Edition Installation
  • Installing SQL Server Management Studio
  • Connecting to SQL Server with SSMS
  • SSMS Quick Tour
  • SQL Server Configuration Manager
  • Installing adventureworks 2016 database
  • Installing adventureworksDW 2016 database
  • Attach Adventureworks 2014 to SQL Server
SQL Server Reporting Services Setup
  • Installing Reporting Services
  • Configure Report Server
  • Accessing Report Server Web Portal Locally
  • Accessing Report Server Web Portal Remotely
  • Configure SSMS for local SSRS administration
  • Adding users and groups to SSRS
  • Installing Report Builder
Setup for : Visual studio 2019 | SSIS | SSRS| SSAS BI Designer Templates
  • What is Visual Studio
  • Minimum Installation Requirements for visual studio 2019
  • Installing Visual Studio
  • Installing SQL Server Data Tools (SSDT)
  • Installing Designers for SSIS,SSAS,SSRS
T-SQL
  • What is T-SQL
  • What is a Database
  • Primary Key
  • Foreign Key
  • Intellisense
  • Normalization
  • Querying Data with SELECT Statement
  • Using Aliases in T- SQL Queries
  • Case Expressions
  • Creating Views
  • Adding comments to T- SQL Queries
  • Using Stored Procedures
  • Using T-SQL Top Command
  • T-SQL GO Command
  • Using SQL Distinct to remove duplicate records
  • Introduction to Table Joins
  • Why Table Joins are important
  • INNER Join
  • LEFT Outer Join
  • RIGHT OUTER Join
  • Introduction to filtering records
  • Filtering using equality filters
  • Filtering with basic comparisons
  • Filtering with logical comparisons
  • Filtering with String Comparisons
  • Filtering with NULL Comparisons
  • Introduction to sorting returned records
  • Order by clause
  • Sorting by ascending
  • Sorting by descending
  • Sorting by multiple columns
  • Introduction to Aggregate Functions
  • COUNT ()
  • AVG()
  • MAX ()
  • MIN()
  • SUM()
  • Using Multiple Aggregate functions
  • Grouping Data
  • Introduction to modifying data
  • Adding new records to database
  • Updating Records
  • Deleting Records
SQL Server Integration Services - SSIS
  • Introduction to SSIS
  • Creating a new SSIS Project with Visual studio 2019
  • Create basic ETL: New SSIS project
  • Add a Flat File Connection Manager
  • Remapping Column Data Types
  • Add and Configure OLE DB Connection Manager
  • Add a Data Flow Task to a Package
  • Add and configure flat file source
  • Add and configure lookup transformation
  • Add and configure Lookup Datekey Transformation
  • Add and configure OLE DB Destination
  • Test SSIS Package
  • Introduction to implementing Lookup Logic
  • Create new SSIS Package
  • Write data to cache - part 1
  • Write data to cache - part 2
  • Perform Lookups from cached data -part 1
  • Perform Lookups from cached data -part 2
  • Running your SSIS Package
SQL Server Reporting Services - SSRS
  • What is SQL Server
  • What is SQL Server Reporting Services - SSRS
  • Requirements for creating basic report with -SSRS
  • How to enable built-in administrator account in Windows