fbpx

Course Description

Noble IT Solutions is a Pune based institution engaged in providing training and development courses and services such as web application development for students and corporate professionals. The company was founded in 2008 by Mr. Prashant Amritkar with the specific aim of working for training and development of core and advanced IT courses to boost the knowledge of students, corporate entities and corporate people in their respective IT field.

Course:  SQL Server
Duration: 30 Hrs

• 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

TSQL (Transact-Structured Query Language)

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

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

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

• Scalar Functions
• Numeric Functions
• Character Functions
• Conversion Functions
• Date Functions
• Aggregate Functions
• Convenient Aggregate Functions
• Statistical Aggregate Functions
• Group By and Having Clauses
• Ranking Functions
• Common Table Expressions (CTE)

Top n Clause

• Union
• Intersect
• Except

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

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

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

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

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

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

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

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

Backup and Restore Of Database

Attach and Detach of Database

CALL NOW
Quick Contact
close slider

QUICK ENQUIRY