· 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
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.
Audience :
Database Designers, Application Developers.
Topics :
Introduction to Databases
o Database Fundamentals
o Database Terminologies
o Database Relationships
o Database Normalization
SQL Server 2005 Fundamentals
o Installing SQL Server 2005
o Working with SQL Server 2005
o Introduction to Transact-SQL
o Describing DDL, DML and DCL statements
o SQL Server 2005 Data Types
Displaying and Managing Data
o Retrieving Data
o Formatting and Summarizing Data
o Joining Data
o Manipulating Data
Creating and Managing Databases
o Working with Databases
o Working with Tables
o Working with Constraints
o Working with Database Diagrams
o Controlling Database Transactions
o Working with Views
Database Programming and Administration
o Working with Stored Procedures
o Working with Functions
o Working with Triggers
o Working with XML
o Working with Database Tools
o 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) :
Category :
Training Materials :
YAT 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.
