About SQL Server DBA Online Training
Course Objectives
What are the Course Objectives?
- Working in DBA Support/ DBA Developer activities in the real-time project.
- Advanced knowledge of SQL server and DBA.
- Successfully installation and configuration of SQL server.
- Manage file and able to create a table.
- Write SQL queries and manage security.
- Scheduling Job in SQL server.
- Learn how efficiently manage SQL server instance.
- Designing a Database and implement.
Who should go for this Course?
- Any IT experienced Professional who are interested to build their career in Database Developer or DBA or Database Support or Database Tester.
- Any B.E/ B.Tech/ BSC/ M.C.A/ M.Sc Computers/ M.Tech/ BCA/ BCom College Students in any stream.
- Fresh Graduates.
Pre-requisites:
- Computer System
- DBMS Concept
Course Curriculum
SQL Server DBA Online Training Overview
SQL Server DBA Online Training Overview
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