SQL Server Online Training

SQL Server Online Training Course Content

Introduction To DBMS

• File Management System And Its Drawbacks
• Database Management System (DBMS) and Data Models
• Physical Data Models, Logical Data Models
• Hierarchical Data Model (HDBMS)
• Network Data Model (NDBMS)
• Relational Data Model (RDBMS)
• Object Data Model (ODBMS)
• Object Relational Data Model (ORDBMS)

Introduction To SQL Server

• 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

TSQL (Transact Structured Query Language)

• 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)

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

Data Manipulation Language

• Insert
• Creating A Table From Another Table
• Update
• Computed Columns
• Delete,Truncate

Data Query Language (DQL)

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

Built In Functions

• Scalar Functions
• Numeric Functions
• Character Functions
• Conversion Functions
• Date Functions
• Aggregate Functions
• Group By and Having Clauses
• Ranking Functions

Common Table Expressions (CTE)

• Top n Clause
• Set Operators
• Union
• Intersect
• Except

Joins

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

Sub Queries

• Single Row Sub Queries
• Multi Row Sub Queries
• Nested Sub Queries
• Co-Related Sub Queries
• Exists and Not Exists

Indexes

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

Security

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

Views

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

Transaction Management

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

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

Cursors

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

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

Working With XML Data Type

• Backup and Restore Of Database
• Attach and Detach of Database
• Normalization

QaTrainingHub.com | Students Also Viewed this Online Course Suggestions




For DotNet : Click here

For Active Server Page & .NET : Click here

For C Sharp : Click here

For SQL SERVER + DBA : Click here

For DB Testing : Click here

For ORACLE +DBA : Click here




More ideas & Relevant Searches for this Online Training Course Content...

• SQL Server Online Training
• best SQL Server Online course
• SQL Server Online Training in Ameerpet
• SQL Server Training institutes in hyderabad
• MS SQL Server Training in Ameerpet
• SQL Server Classes
• Microsoft .NET online Classes
• Best MS .NET Online Training in India



Thanks for visiting our qatraininghub.com

"Let's Share, Sharing is Caring" & Like Our Fb Page..!