Sql Server Training Course Content

Spread the love

Sql Server Training Course Content Details

What is Sqlserver

Microsoft SQL Server may be a computer database management system developed by Microsoft. As a information server, it’s a wares with the first perform of storing and retrieving knowledge as requested by alternative computer code applications—which might run either on identical pc or on another pc across a network (including the Internet).SQL Server Training in hyderabad kukatpally
Microsoft markets a minimum of a dozen completely different editions of Microsoft SQL Server, geared towardcompletely different audiences and for workloads starting from little single-machine applications to massive Internet-facing applications with several coincidental users.
SQL Server Enterprise Edition includes each the core information engine and add-on services, with a spread of tools for making and managing a SQL Server cluster. It will manage databases as massive as 524 petabytes and address twelve terabytes of memory and supports 640 logical processors (CPU cores). for more info click here



Sql server Course Content

01.Introduction To SQL Server

  • Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
  • Connecting To Server
  • Server Type
  • Server Name
  • Authentication Modes
  • Sql Server Authentication Mode
  • Windows Authentication Mode
  • Login and Password
  • Sql Server Management Studio and Tools In Management Studio
  • Object Explorer
  • Object Explorer Details
  • Query Editor

02.Introduction To TSQL

  • History and Features of TSQL
  • Types Of TSQL Commands
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Data Query Language (DQL)
  • Data Control Language (DCL)
  • Transaction Control Language (TCL)
  • Database
  • Creating Database
  • Altering Database
  • Deleting Database
  • Constrains
  • Procedural Integrity Constraints
  • Declarative Integrity Constraints
  • Not Null, Unique, Default and Check constraints
  • Primary Key and Referential Integrity or foreign key constraints
  • Data Types In TSQL
  • Table
  • Creating Table
  • Altering Table
  • Deleting Table

03.Data Manipulation Language

  • Insert
  • Identity
  • Creating A Table From Another Table
  • Inserting Rows From One Table To Another
  • Update
  • Computed Columns
  • Delete
  • Truncate
  • Differences Between Delete and Truncate

04.Data Query Language (DQL)

  • Select
  • Where clause
  • Order By Clause
  • Distinct Keyword
  • Isnull() function
  • Column aliases
  • Predicates
  • Between … And
  • In
  • Like
  • Is Null

05.Built In Functions

  • Scalar Functions
  • Numeric Functions
  • Character Functions
  • Conversion Functions
  • Date Functions
  • Aggregate Functions
  • Convenient Aggregate Functions
  • Statistical Aggregate Functions
  • Group By and Having Clauses
  • Super Aggregates
  • Over(partition by …) Clause
  • Ranking Functions
  • Common Table Expressions (CTE)

06.Set Operators

  • Union
  • Intersect
  • Except

07.Joins

  • Inner Join
  • Equi Join
  • Natural Join
  • Non-Equi Join
  • Self Join
  • Outer Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Cross Join

08.Sub Queries

  • Single Row Sub Queries
  • Multi Row Sub Queries
  • Any or Some
  • ALL
  • Nested Sub Queries
  • Co-Related Sub Queries
  • Exists and Not Exists

09.Indexes

  • Clustered Index
  • NonClustered Index
  • Create , Alter and Drop Indexes
  • Using Indexes




10.Security

  • Login Creation
  • SQL Server Authenticated Login
  • Windows Authenticated Login
  • User Creation
  • Granting Permissions
  • Revoking Permissions
  • Roles

11.Views

  • Purpose Of Views
  • Creating , Altering and Dropping Indexes
  • Simple and Complex Views
  • Encryption and Schema Binding Options in creating views

12.Transaction Management

  • Introduction
  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction
  • Role Of Log File In Transaction Management
  • Implicit Transactions

 

13.TSQL Programming

  • Drawbacks Of TSQL that leads to TSQL Programming
  • Introduction To TSQL Programming
  • Control statements In TSQL Programming
  • Conditional Control Statements
  • If
  • Case
  • Looping Control Statements
  • While

14.Cursors

  • Working With Cursors
  • Types Of Cursors
  • Forward_Only and Scroll Cursors
  • Static, Dynamic and Keyset Cursors
  • Local and Global Cursors

15.Stored Sub Programs

  • Advantages Of Stored Sub Programs compared to Independent SQL Statements
  • Stored Procedures
  • Creating , Altering and Dropping
  • Optional Parameters
  • Input and Output Parameters
  • Permissions on Stored Procedures
  • User Defined Functions
  • Creating, Altering and Dropping
  • Types Of User Defined Functions
  • Scalar Functions
  • Table Valued Functions
  • Inline Table Valued Functions
  • Multi Statement Table Valued Functions
  • Permissions On User Defined Functions
  • Triggers
  • Purpose of Triggers
  • Differences Between Stored Procedures and User Defined Functions and Triggers
  • Creating, Altering and Dropping Triggers
  • Magic Tables
  • Instead Of Triggers
  • Exception Handling
  • Implementing Exception Handling
  • Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
  • Raising Exceptions Manual

16.CLR Integration

  • What is CLR Integration and The Steps For Implementing It
  • A Simple Example With CLR Integratio




Sql server Training Demo

Contact Us for Sql server Online and Classroom Training

venkat: 9059868766
email:[email protected]
Address: PlotNo 126/c,2nd floor,Street Number 4, Addagutta Society, Jal Vayu Vihar, Kukatpally, Hyderabad, Telangana 500085

Sharing is caring!

Updated: May 11, 2017 — 7:05 am

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.