Course Highlights
  • Government certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 20+ hrs
  • Life Time Job Support
  • Job Profile Tagging
Curriculum

5 Topics
RDBMS
SQL Server Versions
SQL Server Components
New Features
SQL Server Files

9 Topics
System requirements
Installation Overview
Selecting Instance
Authentication Mode
Service Accounts
Collation
Installation Steps
Upgrading SQL Server
Built-In Databases

4 Topics
SQL Server Management Studio
SQL Server Configuration Manager
Query Editor
sqlcmd

8 Topics
RDBMS
Design Objective
Design Process
Keys and Relationships
E-R Diagram
Integrity Rules
Normalization
Data Types

10 Topics
Constraints
DDL commands
Queries
Joins
EXISTS INTERSECT and EXCEPT operator
Subqueries
Correlated queries
Table Expressions
The APPLY Operator
DML commands

4 Topics
Index Types
Create Drop and alter index
Index Performance
Index Optimization

2 Topics
UDF and their types
Stored procedures and create procedure

8 Topics
Block of Statements
Data Types
Variables
Flow Control
Error Handling
Pivoting
Ranking functions
Powershell

4 Topics
Transactions
Locking
Isolation Levels
Row Versioning

3 Topics
Create and execute triggers
DDL Trigger
DML Trigger

2 Topics
Partitioning
Indexing

5 Topics
Degrading Factors
Monitoring Performance
SQL Server Profiler
Database Engine Tuning Advisor
Resource Governor

3 Topics
XML Basics
Store and retrieve XML documents
XQuery Methods

5 Topics
Security Basics
Roles
Schemas
Authorization
Authentication

5 Topics
Declarative Management Framework
Maintenance Plan Wizard
Backup
Recovery
Database Availability

  Write a Review

Certificate in SQL Server 2008

Go to Paid Course