Course Outline
 

 

Introduction

  • Understanding the concepts of RDBMS
  • Describing the various SQL Server Versions, it’s components and new features
  • Explaining the files utilized by SQL Server

Installation

  • Detailing the steps for SQL Server installation with background on system requirements, an overview of installation
  • Understanding the basics of selecting instance, authentication mode, service accounts and collation
  • Elucidating the SQL Server installation steps
  • Explaining the steps for upgrading SQL Server and basics of built-in databases

SQL Server Tools

  • Illustrating various SQL Server tools like SQL Server Management Studio, SQL Server Configuration Manager, Query Editor and Sqlcmd

Database Design

  • Describing the various aspects and basics of database design like the concept of RDBMS, objective for design and it’s process, details on keys and relationships, knowledge of E-R Diagram, integrity rules, normalization and various data types in SQL Server 2008

SQL Operations

  • Detailing the various constraints in an RDBMS like integrity and referential, describing the DDL commands, concept and usage of queries, joins and need and syntax of EXISTS, INTERSECT and EXCEPT operator
  • Understanding subqueries, correlated queries, various table expressions and usage of The APPLY Operator and various DML commands

Indexes

  • Describing the various types of index and process to create, drop and alter index
  • Explaining the index performance and need for index optimization

Stored Procedures and UDF

  • Detailing UDF and their types along with stored procedures and usage of create procedure

Transact-SQL

  • Explaining the basics of Transact-SQL (or T-SQL) with coverage of block of statements, data types, variables, flow control, error handling, pivoting, ranking functions and Powershell

Concurrency

  • Describing the utility of concurrency as applicable to SQL Server 2008 by explaining transactions, locking, isolation levels and row versioning

Trigger

  • Detailing the process of using create and execute triggers, DDL Trigger and DML Trigger

Optimization

  • Understanding the need of partitioning and indexing for optimizing SQL server 2008

Performance Tuning

  • Illustrating the factors which degrade performance, SQL Server tools for monitoring performance, usage of SQL Server Profiler, database engine tuning advisor and resource governor

XML

  • Describing the basics of XML, techniques in SQL Server to store and retrieve XML documents and usage of XQuery Methods

Security

  • Explaining the basics of security as applicable to SQL Server 2008, usage of roles, schemas, authorization and authentication

Administration

  • Detailing the ease of administration of SQL Server by using Declarative Management Framework (DMF) and maintenance plan wizard
  • Understanding the techniques of backup, recovery and database availability for SQL Server

Apply for Certification

https://www.vskills.in/certification/Certified-SQL-Server-2008-Programmer