Certified SQL Server 2008 Programmer
Course
Online
*Indicative price
Original amount in USD:
$ 125
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
This SQL Server 2008 Programmer certification assesses the candidate for a company’s SQL Server 2008 related software development and maintenance needs. The certification tests the candidates on various areas in SQL Server 2008 which include knowledge of syntax and semantics of T-SQL, usage of triggers, UDFs and stored procedures and interfacing with XML.
Facilities
Location
Start date
Start date
About this course
Job seekers looking to find employment in website and web application development and maintenance department of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.
Reviews
Subjects
- Design
- Database training
- SQL
- Database
- Server
- XML
- Database Design
- XML training
- Installation
- SQL Server
- Configuration
- RDBMS
- Normalization
- Authentication Mode
- SQL Operations
- DML commands
Teachers and trainers (1)
Name Name
Teacher
Course programme
Introduction
- RDBMS
- SQL Server Versions
- SQL Server Components
- New Features
- SQL Server Files
Installation
- System requirements
- Installation Overview
- Selecting Instance
- Authentication Mode
- Service Accounts
- Collation
- Installation Steps
- Upgrading SQL Server
- Built-In Databases
SQL Server Tools
- SQL Server Management Studio
- SQL Server Configuration Manager
- Query Editor
- sqlcmd
Database Design
- RDBMS
- Design Objective
- Design Process
- Keys and Relationships
- E-R Diagram
- Integrity Rules
- Normalization
- Data Types
SQL Operations
- Constraints
- DDL commands
- Queries
- Joins
- EXISTS, INTERSECT and EXCEPT operator
- Subqueries
- Correlated queries
- Table Expressions
- The APPLY Operator
- DML commands
Indexes
- Index Types
- Create, Drop and alter index
- Index Performance
- Index Optimization
Stored Procedures and UDF
- UDF and their types
- Stored procedures and create procedure
Transact-SQL
- Block of Statements
- Data Types
- Variables
- Flow Control
- Error Handling
- Pivoting
- Ranking functions
- Powershell
Concurrency
- Transactions
- Locking
- Isolation Levels
- Row Versioning
Trigger
- Create and execute triggers
- DDL Trigger
- DML Trigger
Optimization
- Partitioning
- Indexing
Performance Tuning
- Degrading Factors
- Monitoring Performance
- SQL Server Profiler
- Database Engine Tuning Advisor
- Resource Governor
XML
- XML Basics
- Store and retrieve XML documents
- XQuery Methods
Security
- Security Basics
- Roles
- Schemas
- Authorization
- Authentication
Administration
- Declarative Management Framework
- Maintenance Plan Wizard
- Backup
- Recovery
- Database Availability
Additional information
Certified SQL Server 2008 Programmer
*Indicative price
Original amount in USD:
$ 125