Advanced Training>>Course Catalogue>>Visual C#.NET>>SQL Server
 

Course ID :-

D03

Course Title :-

SQL Server

Course Duration :-

4 Weeks

Hardware Requirements :-

  • Intel-based PC Workstation (Windows XP, NT or 2000) with minimum Intel Pentium III processor. 
    (Pentium IV 1.8 GHZ or higher recommended).

  • 512 MB RAM minimum recommended.

  • 20 GB disk space.
    (Disk space can be reduced if optional features and run-time environments are not installed).

  • 800 x 600 minimum display resolution(1024 x 768 recommended)

Software Requirements :-

 >  IIS 5.1
 >  SQL Server 2005
 >  One of the following operating systems:
       >  Windows XP Professional with Service Pack 2
       >  Windows 2000 Professional with Service Pack 3 or higher
       > Windows NT Workstation or Server Version 4.0 with Service Pack 5 or higher

Objectives :-

Upon completion of the course, participants will be able to:

  • Understand the concepts of relational databases.

  • Understand to create, update & delete tables, databases.

Description :-

This course provides a foundation for professionals in the C# language.

Prerequisites :-

Basic programming background is required.

Outlines :-

Introduction to SQL Server :-

An Overview of Training Phases
An overview of RDBMS
Types of Relationships
Normalization
 

SQL :-

Transact SQL (DDL, DML), Operators & Functions                                                          Group Functions, Joins (inner joins, outer joins) & Subqueries                                                       Constraints (Primary key, Foreign Key, Unique, identity) & Views                                                      Indexes & Programming Constructs (if else, Select Case)                                                                     Cursors & Triggers                                                     Stored Procedures & Transactions.                           Data Dictionary.