MSSQL

Duration : 30 Hrs

MS SQL Server is a RDBMS established by Microsoft. We give Sql Server Admin Online Training. As a database, it is a software product whose main function is to store and recover data as demanded by other software applications, be it those on the similar computer or those running on another computer across a network . There are a minimum of dozen different editions of Microsoft SQL Server pointed at different audiences and for different workloads extending from small applications that store and regain data on the similar computer, to millions of users and computers that contact huge amounts of data from the Internet at the same time. Its key query languages are T-SQL and ANSI SQL.

DB CONCEPTS
  • What is data
  • Difference between data & information
  • What is database
  • What is DBMS
  • Advantages of DBMS
  • RDBMS Tools
  • Normalization (1NF,2NF,3NF)
INTRODUCTION TO SQL SERVER 2012
  • Introduction To SQL Server 2008
  • SQL Server Management Studio
  • Editions
DDL AND DML
  • Create Table
  • Using New Date and Time Data Types
  • Alter Table
  • Drop Table
  • Insert
  • Insert trough select
  • Update
  • Delete
SELECTING DATA FROM COLUMNS
  • All columns
  • Some columns
  • Derived columns
  • Using DISTINCT
  • Naming result columns
  • WHERE and comparison operators
  • Nulls
SELECTING USING OPERATORS
  • Arithmetic Operators
  • Relational Operators
  • Logical Operators
  • Other Operators
SELECTING USING FUNCTIONS
  • Number Functions
  • Character Functions
  • Date and Time Functions
  • Aggregate Functions
  • Other Functions
ORDER BY
  • ASC
  • DESC
  • Multiple columns
  • Expressions
  • Columns not in SELECT list
GROUP BY
  • Single column
  • Multiple columns
  • HAVING considerations
  • With ORDER BY
JOINS
  • INNER
  • OUTER (LEFT, RIGHT & FULL)
  • ON vs. WHERE
  • Cartesian product
T-SQL PROGRAMMING
  • Variable Declarations
  • Programming Constructs
  • Conditional statements
  • If-else
  • Case
  • While
  • Break
  • Continue
IMPLEMENTING DATA INTEGRITY BY USING CONSTRAINTS
  • Data Integrity Overview
  • Creating Constraints
  • Implementing Constraints
  • Not Null
  • Unique Key
  • Primary key
  • Check Constraints
  • Default
  • Foreign Key
  • Disabling Constraints
 TRANSACTION MANAGEMENT
  • What is Transaction
  • Commit
  • Savepoint
  • Rollback
INDEXES
  • Requirement of index
  • Advantages of index
  • Create index
  • Optimizing Indexes
  • Tuning Indexes
  • Drop index
DATA CONTROL LANGUAGE
  • Creating Logins
  • Creating Users
  • Grant
  • Revoke
  • Deny
IMPLEMENTING VIEWS
  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views
  • Creating Indexed Views
  • Creating Partitioned Views
CURSORS
  • What is Cursor
  • Cursor Life Cycle
  • Implementation of Cursor
IMPLEMENTING STORED PROCEDURES
  • What is Stored Procedure
  • Creating Stored Procedures
  • Executing Stored Procedures
  • Creating Parameterized Stored Procedures
  • Handle errors in a stored procedure
IMPLEMENTING FUNCTIONS
  • Creating Functions.
  • Implement Scalar Functions
  • Create Table Valued Functions
 IMPLEMENTING TRIGGERS
  • INSERT triggers
  • DELETE triggers
  • UPDATE triggers

Reviews

No reviews

Post Review

Name
Email
Review Title
Rating
Review Content
View All Categories

Quick Enquiry

Technology Portfolio