Diplomas
Certificates
Courses

MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Call our Sales
   Clients Testimonials
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   SQL Server 2005 Core

Admission

Database Designers, Application Developers.


SQL Server 2005 Core
Exam # Duration Language Level Type Classroom Code Fees
-- 24 English Core Course Classroom Cs451 0 LE
Description :

This course covers the basic techniques for the Microsoft SQL Server 2005 program that specifically used to design and build database applications. Trainees will start through this course to learn about basic databases concepts and then how to use, create and customize SQL Server database objects in order to build a database application that fulfills the user needs and requirements.



Objectives :
  • Demonstrate very good understanding of basic database concepts
  • Differentiate between the different editions of SQL Server 2005
  • Install SQL Server 2005
  • Create and maintain SQL Server 2005 databases
  • Perform different operations on data using Transact-SQL commands
  • Create and manage Views
  • Create Stored Procedure and Functions
  • Create Triggers
  • Use XML features in SQL Server 2005
  • Use Transactions to ensure data integrity


Topics :

Introduction to Databases

  • Database Fundamentals
  • Database Terminologies
  • Database Relationships
  • Database Normalization

SQL Server 2005 Fundamentals

  • Installing SQL Server 2005
  • Working with SQL Server 2005
  • Introduction to Transact-SQL
  • Describing DDL, DML and DCL statements
  • SQL Server 2005 Data Types

Displaying and Managing Data

  • Retrieving Data
  • Formatting and Summarizing Data
  • Joining Data
  • Manipulating Data

Creating and Managing Databases

  • Working with Databases
  • Working with Tables
  • Working with Constraints
  • Working with Database Diagrams
  • Controlling Database Transactions
  • Working with Views

Database Programming and Administration

  • Working with Stored Procedures
  • Working with Functions
  • Working with Triggers
  • Working with XML
  • Working with Database Tools
  • Introduction to SQL Server Administration




Recommended Knowledge :

This course requires to have the basic skills about using the with Microsoft Windows operating system (Version XP or any later version).

Recommended Course(s) :

 Database Concepts

 Windows XP Core


Training Materials :

EnterCaps Official Courseware


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience.


Credential :

This course is a necessary starting point for anyone wants to step into the database applications field.

Category :
DataBase


The Instructor:
Copyright © 2008-2012 - EnterCaps for Design and Development - All rights reserved.