Course in SQL Server 2x

+ Information by E-mail

Entry requirements - PC with reasonably good configuration
- Broadband connection (or Internet access using your Company/Organisation network etc.)
- Headphones with microphone.
- Basic knowledge of working with PC and Internet
Course description
Microsoft SQL Server is a Relational Database Server produced by Microsoft. The SQL Server 2008 course is designed to cover the basic concepts of database administration and database development by using Microsoft SQL Server 2008. It provides students with the knowledge and skills to maintain and develop a Microsoft SQL Server 2008 database. It helps in attaining the basic skills of query writing using T-SQL and build up on the knowledge gained to enable to develop the various types of database objects.

Microsoft SQL Server
- Installation of SQL Server
- Introduction TO SQL Server
- Introduction to RDBMS
- Normalization
- Database concepts
- Introduction to SQL Server 2008
- Introduction to T-SQL
- T-SQL Data types
- T-SQL Operators
- Working with databases & Tables using DDL & DML commands
- T-SQL Functions
- Advanced Query Concepts
- Data Integrity
- Views
- Stored Procedures
- Managing Errors & Triggers
- Cursors
- Data Consistency
- Concurrency & locking