Clicky

L O A D I N G

MS SQL

Beginners

  1. What is MS SQL Server? Introduction, Version History
    • What is SQL Server?
    • Version History SQL Server
    • SQL Server Editions
    • MS SQL Server as Client-Server Architecture
    • Key Components and Services of SQL Server
    • SQL Server Instances
    • Importance of SQL Server Instances
  2. Download & Install SQL Server
    • How to download SQL Server Setup
    • How to Install SQL Server
  3. SQL Server Architecture 
    • Protocol Layer - SNI
      • Shared Memory
      • TCP/IP
      • Named Pipes
      • What is TDS?
    • Relational Engine 
      • CMD Parser
      • Optimizer
      • Query Executor
    • Storage Engine
      • File types
      • Access Method
      • Buffer Manager
      • Plan Cache 
      • Data Parsing: Buffer cache & Data Storage 
      • Transaction Manager
  4. SQL Server Management Studio
    • What is Server Management Studio
    • Download & Install SQL Server Management Studio
    • How to access "Management Studio"
    • Access "Management Studio" using Command line
    • Introduction to Data Management Studio IDE
    • SSMS Tips and Issues 
    • SSMS Versions and Updates 

 

Advanced

  1. SQL Server Database 
    • What is Database?
    • Rules to Create a Database
    • Create Database using SQL Server Management Studio
    • Create Database with T-SQL
    • Alter Database with SQL Server Management  Studio
    • Alter Database with Transact-SQL
    • Delete Database SQL Server Management Studio
    • Delete Database using Transact-SQL
    • Restore Database
  2. SQL Server DataTypes
    • What is DataType?
      • How to use MS SQL datatype
    • Why use Datatypes?
      • Exact Numeric 
      • Approximate Numeric 
      • Date and Time
      • Character Strings
      • Unicode Character String
      • Binary String
      • Other Datatypes
  3. SQL Server Variable 
    • What is Variable?
    • Types of Variable: Local, Global
    • How to DECLARE a variable
    • Assigning a value to a Variable 
      • During variable declaration using DECLARE keyword.
      • Using SET
      • Using SELECT
      • Other Examples
    • Interesting Examples!
  4. SQL Server Table
    • What is a Table?
    • How to create a Table
      • Using T-SQL
      • T-SQL: Create a New Table using an existing table.
      • Using Table Designer 
    • Alter Table
      • Using T-SQL
      • Using Table designer 
    • Delete Table
      • Using SQL Server Management Studio
      • Using T-SQL
  5. SQL Server PRIMARY KEY
    • What is a Primary Key
      • Rules for Primary Key
    • How to create a Primary Key
      • Using SQL Server Management Studio
      • Using T-SQL: Create Table
      • Using T-SQL: Alter Table(Add to Existing table)
      • Interesting Facts
  6. SQL Server Foreign Key
    • What is a Foreign Key?
      • Rules for Foreign Key
    • How to create Foreign Key
      • Using SQL Server Management Studio
      • Using T-SQL: Create Child Table 
      • Using ALTER TABLE
      • Example Query Foreign Key
  7. IF...ELSE Statement
    • Why do you need Conditional Statements?
    • If...Else Statement 
      • If...Else with the variable in Boolean Expression
      • If...Else with Begin End 
    • If Statement with No Else
    • Nested If...Else Statements 
  8. CASE Statement 
    • Overview of Case in Real life
    • What is CASE?
    • Simple CASE
    • Searched CASE
    • Difference between Simple and Searched CASE
    • Nested CASE: CASE in If Else 
    • Nested CASE: CASE inside CASE
    • CASE with UPDATE
    • CASE with Order By
  9. SQL Server SUBSTRING()
    • What is Substring?
    • Rules for using SUBSTRING
  10. SQL Server Joins
    • INNER JOIN
    • LEFT OUTER JOIN
    • RIGHT OUTER JOIN 
    • FULL OUTER JOIN
  11. SQL Server Create User 
    • How to create a Login
    • How to create a User
    • Create User using SQL Server Management Studio
    • Create User using T-SQL
    • Assigning Permission to a User 
    • Assigning Permission Using SQL Server Management Studio
    • Grant Permission using T-SQL
  12. Oracle vs SQL Server 
    • What is MS SQL Server?
    • What is Oracle Database
    • Early History of MS SQL
    • Early History of Oracle 
    • Features of MS SQL Server 
    • Features of Oracle 
    • Difference between SQL Server and Oracle 
  13. SSIS Tutorial
    • What is SSIS
    • Why we use SSIS
    • History of SIS
    • SSIS Features 
    • SSIS Architecture 
    • SSIS Tasks
    • Advantages and DisAdvantages of  using SSIS
    • Other important ETL Tools
    • SSIS Best Practices 
  14. SSRS Tutorial
    • What is SSRS?
    • Types of reporting services
    • Why SSRS
    • Examples of SSRS reporting
    • Features of SSRS
    • How SSRS works
    • SSRS Architecture
    • Reporting Lifecycle
    • what is RDL?
    • Type of SSRS Reports
    • Advantages of using SSRS 
    • Disadvantages of using SSRS
  15. SSAS Tutorial 
    • What is SSAS
    • Architecture of SSAS
    • History of SSAS
    • Important SSAS Terminology
    • Type of model in SSAS
    • Tabular vs Multidimensional model
    • Key features of SSAS
    • SSAS vs PowerPivot
    • Advantages of SSAS
    • Disadvantages of using SSAS
    • Best practices of using SSAS

 

Request A Call Back

tvisha chat support
tvisha support
Chat with us
24x7 Available
accept chat