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 2008 Core

Admission

Database Designers, Application Developers.


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

This course covers the basic techniques for the Microsoft SQL Server 2008 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 :
  • Learning the basic concepts of database
  • Getting familiar with using Microsoft SQL Server 2008
  • Designing and developing databases through SQL Server 2008
  • Creating and customizing the main objects of SQL Server databases


Topics :

Introduction to Databases

  • Basic Concepts
  • Table Elements
  • Database Constraints
  • System Development Life Cycle
  • Table Relationships and Integration
  • Normalization Overview
  • Normal Forms

SQL Server 2008 Fundamentals

  • SQL Server 2008 Editions
  • SQL Server 2008 Overview
  • The SQL Server 2008 Environment
  • Management Studio Components
  • Predefined Databases
  • Transact-SQL Basic Concepts
  • Transact-SQL Commands
  • Data Type Significance
  • Data Type Categories

Basic Data Operations

  • Writing SELECT Statements
  • Using SQL Operators
  • Customizing Data Display
  • Grouping Data
  • Set Operators
  • Join Syntax and Types
  • Inserting Data
  • Updating and Deleting Data

Managing Databases

  • Database Files
  • Creating Databases
  • Detaching and Attaching Databases
  • Creating Tables
  • Modifying Tables
  • Removing Tables
  • Constraint Guides and Considerations
  • Applying and Testing Constraints
  • Database Diagram Basics
  • Using Database Diagrams
  • Basic Concepts of Database Transaction
  • Controlling Database Transactions
  • Creating and Modifying Views
  • Controlling and Removing Views

Programming and Administering Databases

  • Basic Concepts of Stored Procedure
  • Creating and Executing Stored Procedures
  • Modifying and Removing Stored Procedures
  • Basic Concepts of Functions
  • Creating and Calling Functions
  • Modifying and Removing Functions
  • Basic Concepts of Triggers
  • Managing INSTEAD OF triggers
  • Basic Concepts of XML
  • XML Related Technologies
  • SQL Server Interaction with XML
  • Interacting with Scripts
  • Using Database Tools
  • Basic Concepts of Permissions
  • Controlling Database Access




Recommended Knowledge :

This course requires having the basic skills of using Microsoft Windows operating system (XP version or any later version).

Recommended Course(s) :

Windows 7 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.