SQL Server DBA Training in Hyderabad Kukatpally

Trainer Details:

#####################################

Module 1
Lecture 1 –Introduction to Databases
Lecture 2 –Ms-Sql Server Installation
Lecture 3 –Tables in SQL
Module 2 -Data Warehousing
Lecture 4 –Data Mart
Lecture 5 -Data Modelling
Module 3
Lecture 6 –Create, Use & Drop Database
Lecture 7 –Data types in SQL
Lecture 8 –Constraints in SQL
Lecture 8.1 –Database Normalization
Module 4
Lecture 9 –Create Table Statement
Lecture 9.1 –Insert into Statement
Lecture 10 –Select Statement
Lecture 11 –Where Clause
Lecture 12 –AND, OR & NOT Operators
Lecture 13 –Like & Between Operators
Module 5
Lecture 14 –Inner Join
Lecture 15 –Left Join
Lecture 16 –Right Join
Lecture 17 –Full Join
Lecture 18 –Delete & Truncate Statements
Lecture 19 –Update Statement
Lecture 20 –Update & Delete using Join
Lecture 21 –Merge in SQL
Lecture 22 –Alter Table Statement
lecture 23 –Temporary Table in SQL
Lecture 24 –Basic Functions in SQL
Lecture 25 –String Functions in SQL
Lecture 26 –Case Statement
Lecture 27 –IIF Function
Lecture 28 –User-Defined Functions
Module 6
Lecture 29 –Order By clause
Lecture 30 –Group By clause
Lecture 31 –Having Clause
Lecture 32 –Union & Union All Operators
Lecture 33 –Except Operator
Lecture 34 –Intersect Operator
===============================PLSQL/TSQL==========================================
Module 7
Lecture 35 –Stored Procedure in SQL
Lecture 36 –Views in SQL
Module 7 –Quiz
Lecture 37 –Transactions in SQL
Lecture 38 –Exception Handling in SQL
MODULE 9 -USER DEFINED FUNCTIONS, TRIGGERS & AUDIT TRAILS
Lecture 39 –Catch Block
Lecture 40 –Scalability of UDF
Lecture 41 –Rank Function
Lecture 42 –Trigger
MODULE 10 -INTRODUCTION TO OPTIMIZATION THEORY, TRANSACTIONS, LOCKING & BLOCKING, INDEXING FOR PERFORMANCE
Lecture 43 –Pivot
Lecture 44 –Stuff
Lecture 45 –Indexes
Lecture 46 –CTE
Module 11 Optimizing Database Objects
Indexes, Index Structure & Types of Indexes
Stored Procedures & Views
Sql server
07 February 2022
09:14
New Section 4 Page 1
Stored Procedures & Views
Transactions & Types of Transactions
Module 12 Implementing Programming Objects
Lecture 1 –Aggregate Functions & User Defined Functions
Lecture 2 –Order By, Group By, Having, Union vs Union all
Lecture 3 –Indexes
Lecture 4 –Stored Procedure
Lecture 5 –Views
Lecture 6 –DML Operation on a View & Transaction
Lecture 7 –Error/Exception Handling
Module 12
Additional Topic
Normalization
SQL Case Study
Project
Project 1 –Subqueries
Project 2 –Querying a Large Relational Database
New Section 4 Page 2

#####################################

BASIC CONCEPTS

• Database Concepts
• RDBMS Concepts
• Data Models
• Constraints
• Normalization- 1NF,2NF,3NF,BCNF etc
• ER Diagrams

SQL SERVER CONCEPTS

• Introduction to Sql Server 2008 R2
• Sql Server 2008 Features
• Server Types
• Editions
• Components
• Management Studio
• T-SQL Features
• New Operators
• DML Statements

T-SQL

• DDL
• Data Types
• System Defined Data Types
• User defined Data
• Create/modify/delete tables
• Operators
• DML
• DCL
• Using Select Statement

MAINTAINING DATABASE INTEGRITY

• Constraints
• Rules
• Entity Integrity
• Domain Integrity
• Referential Integrity

SUBQUERIES

• Built-in function
• Nested Sub Queries
• Correlated Sub Queries
• Derived tables
• Recursive queries
• Common Table Expression

JOINS

• Cross Join, Inner Join, Self Join, Outer Join

INDEXES

• Types of Indexes
• • Creating indexes
• Modifying indexes
• Dropping indexes

VIEWS

• About View
• Creating Views
• Altering Views
• Materialized Views
• Distributed View

STORED PROCEDURES

• Advantages
• System Stored Procedures
• Extended Stored Procedures
• Parameter Handling

USER DEFINED FUNCTIONS

• Returning Scalar Value
• Returning Table of Data
• Deterministic Functions
• Non Deterministic Functions

TRIGGERS

• Constraints Vs Triggers
• After Triggers
• Instead of Trigger
• DDL Triggers
• Altering and Dropping Triggers

CURSORS

• Select Vs Cursors
• Types of Cursors
• Creating Cursors
• Open/Fetch/Close Cursors
• Using Cursors in Stored Procedures and Triggers

MICROSOFT .NET FRAME WORK INTEGRATION

• CLR Integration
• UDA
• UDF
• Stored Procedures
• Triggers

TRANSACTIONS AND LOCKS

• ACID Properties
• Implicit Transactions
• Explicit Transactions
• Transaction Process
• Concurrency Problems
• Lock Types
• Distributed Transactions
• Dead Locks

DATA TRANSFORMATION SERVICES

• BCP
• DTS

ADMINISTRATIVE TASKS

• Creating Database
• Copy, Maintaining Database
• Security Concepts
• Schemas, Permissions
• Backup and Restore Database
• Sql Server Agent
• Sql Server Profiler
• Database Engine Tuning Adviser

SQL SERVER MANAGEMENT OBJECTS

• Programming with SMO
• Connecting to Sql Server
• Scripting

XML IN SQL SERVER

• XML in Sql Server

WORKING WITH IMAGES

• Working with Images

INTRODUCTION TO MS- BI

• SSRS
• Standard, Ad- hoc Embedded Reports
• SSIS
• SSAS

SQL SERVER 2012 FEATURES

• Sequence
• OFFSET and FETCH
• WITH RESULT SETS in stored procedure THROW in triggers