SQL Server Training

SQL Server Training Overview

Download PDF

MS SQL Server is a relational database management system. As a database server, SQL Server is used for storing and retrieving data as required by other applications. SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).

SQL Server Training Objective

  • Understand the concepts of SQL Server Management Studio and Transact-SQL language
  • Views, Stored Procedures and Modifying data using T-SQL
  • Learn how to write simple and complex queries to retrieve data from the database
  • Understand how to retrieve files and working with Triggers

SQL Server Training Audience

  • Those who want to learn SQL Server Database.
  • SQL and Database Administrators
  • Software Developers

SQL Server Training Prerequisites

The participant should be aware of what is Database, Database concepts, SQL and RDBMS.

SQL Server Training Outline

  • SQL Server Installation
  • Service Accounts & Use, Authentication Modes & Usage, Instance Configurations
  • SQL Server Features & Purpose
  • Using Management Studio (SSMS)
  • Configuration Tools & SQLCMD
  • Conventions & Collation
  • Basics of SQL Types of SQL Statements
  • DDL, DML, DQL, DCL and TCL
  • Create Database using Management Studio
  • Datatypes in SQL Server
  • Exploring DDL Statements on Table using Management Studio
  • Create, Alter and Drop Table Insert,
  • Update and Delete Statement Truncate Statement
  • Understanding Select Statement
  • Usage of Top, Distinct, Null etc…keywords
  • Exploring Where Clause with Operators
  • Using Advanced Operators
  • Sorting data using Order By clause
  • Working with basic of Sub Queries
  • Using functions in Queries
  • Using Predefined functions
  • Count, Sum, Min, Max, Avg Group By and Having Clause
  • Using Group By with Rollup and Cube
  • Introduction to Joins
  • Cross Join, Inner Join, Outer Join, and Self Join
  • Set Operations using Unions, Intersect and Except
  • Entity integrity
  • Domain integrity
  • Referential integrity
  • Types of constraints
  • Unique, Not NULL, Primary Key and Default Check Foreign Key
  • Introduction & Advantages of Views
  • Creating, Altering, Dropping Views
  • Advance Options while Creating a View
  • SQL Server Catalogue Views
  • Creating Users & Roles
  • Granting & Revoking of Roles & privileges
  • Managing using Management Studio
  • Introduction Clustered and Non-Clustered Index
  • Creating and Dropping Indexes
  • What is T-SQL?
  • Scripts and Batches Declaring Variables
  • Using Statements
  • Working with Temp tables
  • Error Handling
  • Using System Functions / Global Variables Using Dynamic SQL
  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping
  • Input-Output and Optional Parameters
  • System defined SP’s and Functions.
  • User-defined Functions
  • Introduction to triggers
  • Constraints vs Triggers
  • Creating, Altering, Dropping triggers
  • for/after/instead of triggers
  • Using Rollback Tran
  • Creating Cursors
  • Cursors vs. Select
  • Types of cursors
  • Locks on cursors
  • Advantages of cursors
  • Introduction Transactions process
  • Types of transactions (Implicit, explicit)
  • Working with Locks, Types of locks
  • Generating SQL Script
  • Executing SQL Script
  • Generating Change Script
  • Taking database Backup
  • Restoring database using backup
  • Attaching and Detaching of database
Skills

Register

[miniorange_social_login shape="longbuttonwithtext" theme="default" space="4" width="300" height="50" color="000000"]