SQL SERVER

SQL Server online training institute in Hyderabad.We offer course training in Global world.SQL server is a Microsoft Product.Ms SQL is Relational database management system.A database server is a computer program that provides database services to other program or computer as defined by the client – server model SQL Stands for structured Query Languages the languages used to manage the database server.

SQL SERVER Course Content

sql server online training

Chapter 1: About Database & Data Warehouse

  • What is Database?
  • What is Data Warehouse?
  • Difference between Database & Data Warehouse

Chapter 2: SQL Server 2012/2014 Database Design

  • Database Creation using GUI
  • Database Creation using T-SQL Scripts
  • DB Design using Files
  • File locations and Size Parameters
  • DB Log Files, Growth & Placement
  • DB Structure Modifications and Ownership

Chapter 3: SQL Server Tables & T-SQL Queries

  • Table creation using T-SQL Scripts
  • DML Operations: INSERT, UPDATE, DELETE
  • Single Row and Multi-Row Insert Statements
  • Table Aliases, Column Aliases & Usage
  • Table creation with Schemas
  • DELETE versus TRUNCATE Statements
  • SELECT Queries & Sub Queries
  • Schemas & Nested Queries with Aliases

Chapter4: Constraints, Keys, and Data Validation

  • Data Integrity & Normal Forms
  • Tables with Keys & Constraints
  • NULL and IDENTITY Properties – Usage
  • UNIQUE KEY Constraint and NOT NULL
  • PRIMARY KEY Constraint & Importance
  • FOREIGN KEY and REFERENCE Attributes
  • CHECK and DEFAULT Constraints, Usage

Chapter 5: Joins, Sub Queries & Nested Queries

  • SELECT Statements – IIF, SWITCH, CHOOSE
  • ORDER BY, GROUP BY, GROUPING, HAVING
  • Sub Queries, Nested Queries & EXISTS
  • DELETE from SELECT, UPDATE from SELECT
  • INSERT INTO … SELECT & Data Copy
  • Inner Joins – Purpose & Performance
  • Outer Joins – Types, Advantages & Usage
  • Cross Joins – Advantages & Limitations
  • Self Joins & Sub Queries

Chapter 6: Joins, Views and Nested Queries

  • Benefits of Views – End User Access
  • Defining Views on Tables & Views
  • SCHEMABINDING & ENCRYPTION Options
  • ALTER TABLE Issues & Solutions with Views
  • System Views & Management Views: Audits
  • Joins & Nested Sub Queries in Views

Chapter 7: User Defined Functions & Joins

  • Functions – Syntax, Usage & Importance
  • Scalar-Valued Functions & Examples
  • Table Valued Functions & Examples
  • System Functions & Joins – CROSS APPLY
  • Date, Time and Conversion Functions
  • String Functions and Meta-data Functions
  • ROWCOUNT, GROUPING, ROLLUP Functions
  • Joining Functions and Tables / Views

Chapter 8: Indexes and Query Tuning

  • Need for Indexes, Index Types & Usage
  • Indexing Table & View Columns
  • Index SCAN AND SEEK
  • PRIMARY KEYS and Non-Clustered Indexes

Chapter 9: Stored Procedures and Benefits

  • Need for Stored Procedures & Syntax
  • Use of Variables and Query Parameters
  • Stored Procedures with Loops &IF… ELSE
  • SCHEMABINDING and Encryption Options
  • INPUT, OUTPUT & RESULTSET Parameters
  • System Stored Procedures and Nesting
  • Dynamic SQL Queries and Parameters
  • Stored Procedures, Data Validation Options
  • OUTPUT Parameters and Result set Options

Chapter 10: Triggers and Memory Limitations

  • Triggers – Architecture, Types & Usage
  • DML Triggers and Performance Impact
  • INSERTED and DELETED Memory Tables
  • Triggers for Audit Operations (Memory)

Chapter 11: Cursors, Stored Procedures, CTE

  • Cursor Declaration and Fetch Options
  • STATIC and DYNAMIC Cursor Types
  • SCROLL and FORWARD_ONLY Cursors
  • LOCAL and GLOBAL Cursors – Scope
  • KEYSET Cursors and Temp Objects
  • Embedding Cursors in SPs and Functions
  • Temp Tables and Procedures with Cursors
  • Common Table Expressions (CTE) and Queries
  • Stored Procedures with CTE: Tuning Options

Chapter 12: Transactions & Procedures

  • Transaction Options and Stored Procedures
  • ACID Properties in T-SQL and Scope
  • EXPLICIT Transaction Types and Issues
  • IMPLICIT Transactions Types and Issues
  • AUTOCOMMIT Transaction and Advantages
  • Nested Points and Save Points usage
  • Query Blocking Issues and Query Hints
  • SPs with Transactions & Temp Objects