+91-892 015 0908

SQL Server Training Institute

SQL Server Training Institute

Quick Enquiry

MS SQL SERVER BASIC TO ADVANCED

Microsoft SQL Server is a relational database management system (RDMBS) (RDMBS) developed by Microsoft. As a database server software, The primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network. MS SQL SERVER is platform-dependent, & can work on GUI & command-based software

Microsoft SQL Server provides flexible options for app migration, modemization, and development. After completing MS SQL SERVER, will be able to: -Query data efficiently from tables in the SQL Server database. Create database objects such as tables, views, indexes, sequences, synonyms, stored procedures, user- defined functions, and triggers.Administer SQL Server effectively.

The key interface tool for SQL Serveris SQL Server Management Studio (SSMS). Its main purpose is to build and maintain databases. It is used to analyze the data using SQL Server Analysis Services (SSAS). It is used to generate reports using SQL Server Reporting Services (SSRS). It is used to perform ETL operations using SQL Server Integration Services (SSIS).

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)
  • Conceptual Data Models
  • Entity - Relationship (E-R) Model

Introduction To SQL Server

  • Connecting To Server
  • Server Type and Server Name
  • Sql Server Authentication Mode
  • Windows Authentication Mode
  • Login and Password
  • •Sql Server Management Studio and Tools In Management Studio
  • Object Explorer and Object Explorer Details
  • Query Editor

TSQL (Transact-Structured Query Language)

  • Introduction 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 With Tables

  • DATABASE - Creating / Altering/Deleting Database
  • 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

Working with Constraints

Create a constraint,

  • The difference between unique, not null, and primary key constraints.
  • Not NULL + Primary Key
  • Null + Unique
  • Default Check Foreign Key

Data Manipulation Language

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

Data Query Language (DQL)

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

Built In 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


Set Operators

  • Union
  • Intersect
  • Page No
  • Except

Joins

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

Sub Queries

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

Indexes

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

Views

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

Transaction Management

  • Begin Transaction
  • Commit Transaction
  • Rollback Transaction
  • Save Transaction and Implicit Transactions

Conditional Control Statements

  • If
  • Nested if with conditions
  • 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

User Defined Functions

  • Creating, Altering and Dropping
  • Types Of User Defined Functions
  • Inline Table Valued Functions
  • Multi Statement Table Valued Functions
  • Permissions On User Defined Functions

Triggers

  • Purpose of Triggers
  • Differences B/W Stored Procedures & User Defined Functions & 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

CLR WEB Integration

  • What is CLR Integration and The Steps For Implementing It
  • A Simple Example With CLR Integration
  • Working With External Data Sources
  • Backup and Restore Of Database
  • Import and Export Of databases
  • Web integrations of databases

Security

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

PROJECTS ASSIGNMENTS