IIRF Online > Development > Database Design & Development > SQL Server > Certificate in SQL Server 2008
Certificate in SQL Server 2008 by Vskills
Course Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 20+ hrs
- Life Time Job Support
- Job Profile Tagging
Skills you will learn!
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
Certificate in SQL Server 2008
Related SQL Server Courses
Thank You!
Your review has been submitted successfully.