Call us Today ! 214-504-6299 | info@qatestingtraining.com
QA Training | Selenium Training

SQL Online Training Course Syllabus| SQL Server 2012 Online Training And Pricing Details

1. Data and Database

  • What is Data
  • Types of Data
  • How is data collected
  • What is the importance of data
  • Where is data stored
  • Introduction to Database
  • Types of Database
  • What is DBMS
  • Hierarchial DBMS
  • Network DBMS
  • RElational DBMS
  • Object Oriented DBMS

2. Types of DBMS

  • Hierarchical database
  • Network database
  • Relational database
  • Object Oriented database
  • RDBMS
  • Definition of RDBMS
  • E.F.CODD
  • E.F.Codd 12 rules for RDBMS–skit
  • Example of Customer and Address data
  • Sql Server Versions and Editions
  • Installing Sql Server

3. Install Configurations

  • Windows authentication
  • Sql Server authentication
  • Mixed mode authentication
  • Starting and stopping sql server services
  • Overview of SQL Server Components
  • SSMS – Sql Server Management Studio
  • SSRS – Sql Server Reporting Services
  • SSIS – Sql Server Integration Services
  • ETL stands for extraction transformation and loading
  • SSAS – Sql Server Analysis Services
  • Connecting to Sql Server
  • How to use SSMS

 

4. SQL Introduction

  • How to use SQL Server Management Studio (SSMS)
  • Connecting to Sql Server
  • Window authentication
  • Sql Server authentication
  • System Databases
  • Master Database
  • Model Database
  • Msdb Database
  • Tempdb Database
  • Resource Database –hidden database
  • User Defined Database
  • Introduction to Sql
  • SQL – Structured query language
  • DDL commands –DATA DEFINITION LANGUAGE
  • DML commands –DATA MANIPULATION LANGUAGE

5. DDL & DML

  • Creating a database
  • Data File
  • Primary File
  • Secondary File
  • Log File
  • File properties
  • Filegroup
  • Primary Filegroup
  • User Defined Filegroup
  • Altering a database
  • Dropping a database
  • Creating a Table
  • Altering a Table
  • add columns
  • alter columns
  • drop columns
  • Dropping a Table
  • DML
  • Inserting data
  • Updating data
  • Deleting data
  • Selecting data

6. Tables

  • System Tables
  • User Defined Tables
  • DDL for Table
  • Create a Table
  • Alter a Table
  • Drop a Table
  • DML for Table
  • Insert into Table
  • Update Table
  • Delete Table
  • Select Statement

7. Tables

  • Select
  • Table Alias
  • Column Alias
  • Where Clause
  • Relational Operators and Wild Characters
  • Select Into
  • Top and Distinct
  • DML for Table
  • Update
  • Delete
  • Truncate table
  • Table Identity Property
  • Order by Clause
  • Unit of data in Sql Server

8. Attaching and Detaching a database

  • Table Identity Property
  • Order by Clause
  • Union all and Union
  • Intersect and Except
  • Constraints
  • What are constraints
  • Uses of constraints

9. Constraints

  • Types of constraints
  • Primary Key Constraint
  • Foreign Key Constraint
  • Unique Key Constraint
  • Check Constraint
  • Default Constraint
  • Null and Not Null Constraint

 

10. Joins

  • Temp Tables and Global Temp Tables
  • Table Variables
  • Conditional statements
  • IF Else statements
  • Case Statement
  • Using Case statement in Update
  • Exists
  • Select Into
  • Insert into Using Select
  • Joins
  • Inner Join —intersecting data
  • Outer Join —
  • Left Outer Join –left table
  • Right Outer Join –right
  • Full Join –all the data from both tables
  • Cross join –2 3 –6
  • Self Join

 

 

11. More Examples of Joins

  • Subqueries
  • Table Alias
  • Update with Case Statements

12. Index

  • What is an Index
  • What is the use of Index
  • What are the types of Index available in sql server
  • Clustered Index
  • NonClustered Index
  • Covered Index
  • Filter Index
  • Column Store Index
  • DDL with Index

 

13.Index ctnd..

  • Covered Index
  • Filter Index
  • Column Store Index –COLUMNAR FASHIION
  • CLUSTERED AND NON CLUSTERED INDEXS ARE ROW FASHIOIN
  • Fill Factor–
  • Column Consideration while Indexing
  • Introduction to View –LOGICAL TABLE
  • What is a View
  • Uses of View
  • DDL with View
  • View with Encryption
  • View with Schemabinding
  • View with MetaData
  • Updating data through Views
  • VIew with Check Option
  • Partitioned View
  • Indexed View

 

14.Views & Functions

  • Updatable Views
  • View with Check Option
  • Indexed View
  • System Views
  •  
  • Functions
  • What is Function
  • What are the uses of Functions
  • Types of Functions
  • Built in Functions
  • User Defined Function
  • Scalar Function
  • Inline Table Valued Function
  • Multi Statement Table Valued Function
  • Deterministic Functions and Non Deterministic Functions

 

15. Functions cntd..

  • Built-in Functions
  • Ranking Functions
  • ROW_NUMBER
  • RANK
  • DENSE_RANK
  • String Functions
  • Group By Clause
  • Having Clause
  • User Defined Function
  • Scalar Function
  • Inline Table Valued Function
  • Multi Statement Table Valued Function

16 Functions cntd…

  • Inline Table Valued Function
  • Multi Statement Table Valued Function
  • Permissions for Functions
  • Using Functions with other tables
  •  
  • While Loop
  • Subqueries

17. Triggers

  • INTRODUCTION TO TRIGGERS
  • TYPES OF TRIGGERS
  • CREATE ALTER AND DROP TRIGGER
  • DML TRIGGERS
  • DDL TRIGGERS
  • LOGON TRIGGERS
  • USE OF TRIGGERS

18. Stored Procedures

  • What is a stored procedure
  • Types of stored procedures
  • System Procedures
  • User Defined Procedures
  • Uses of Stored Procedures
  • DDL with Stored Procedures
  • Executing Stored Procedures
  • Permissions on Stored Procedures
  • Difference between functions and stored procedures
  • Temporary and Global temp stored procedures

 

 19. Logins

What is a Login

Uses of Login

Create, Alter and Drop a login

 

20. Users

What is a User

Difference between User and Login

Create, Alter and Drop a User

 

 

 21. Backup

  • Import and Export Wizard
  • Database Backups
  • What is database backup
  • Why do we need backup
  • Where do we backup
  • Type of database backup
  • Database Backup
  • Filegroup Backup
  • Full Backup
  • Differential Backup
  • Transactional Log Backup
  • Recovery Model
  • Full
  • Bulk Logged
  • Simple

 

22. Backup cntd…

Type of database backup

  • Database Backup
  • Filegroup Backup
  • Full Backup
  • Differential Backup
  • Transactional Log Backup
  • Recovery Model
  • Full
  • Bulk Logged
  • Simple

 

 23. backup cntd..

 24. Sql Server Integration Services – SSIS

  • Introduction
  • Enterprise level data Integration and
  • Enterprise level data transformation
  • Source – All types of Files, All types of databases
  • Destinations – Files and Databases
  • ETL- Extraction Transformation and Loading
  • ETL tools – SSIS
  • Informatica
  • Datastage
  • and others…..
  •  
  • Use of SSIS

 

 25. SSIS _Tasks

  • FILE TRANSFER PROTOCOL – FTP
  • Control Flow Tasks
  • Execute SQL Task
  • Data Flow Task
  • Script Task
  • Connection Manager
  • Flat File Connection
  • Excel Connection
  • OleDB connection
  • Source
  • Excel Source
  • Flat File Source
  • OleDb source
  • Destination
  • Excel destination
  • Flat File destination
  • OleDb destination

 

26. Tasks  cntd..

  • Control Flow Tasks
  • Execute Sql Task
  • File System Task
  • Script Task
  • Variables
  • Expressions in Variables
  • Create a destination file with current date and time (Automating the file generation)

 

 27. Transformations

  • Transformations
  • Data Conversion –convert the datatype of source
  • Derived Column –is used to add new columns ..do some concatenation or ..new values
  • Data Viewers –it is for viewing the data in between transformations..debugging purpose
  • Conditional split– splitting the source data
  • RowCount –gets the count of rows from source
  • Multicast –copies of source data
  • Lookup –looking up for data
  • Union all –works same way as union all in sql
  • Union all with Sort is equal to union in sql

28. SSIS Containers

  • Transformations
  • Merge
  • Merge Join
  • Difference between Merge and Union all
  • Aggregate
  • Containers –control flow
  • Sequence Container
  • For loop container –for loop
  • For each loop container
  • Precedence Constraints
  • Control Flow Tasks
  • Data Profiling Task
  • Execute package Task
  • Expression Task
  • Sendmail Task
  • Bulk insert Task

 

 

 29. SSIS Config

  • SSIS Logging
  • Package Configuration

 

30. SSIS Deployment

  • Package Configurations
  • Package Deployment
  • CheckPoint Files

 

 

Purchase Live SQL Server Online Training

Copy Rights © All rights reserved.