Training Course:Implementing a Microsoft SQL Server 2005 Database (Certificate)School/Trainer:Techno-ed
Islamabad, Karachi, Lahore, Pakistan
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This three-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.
Who will the course benefit?
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.
Course Objectives
To provide basic SQL Server 2005 skills for the Database Developer and Programmer.
Skills Gained
This course will enable delegates to:
Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2005.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas.
Implement views.
Implement stored procedures and functions.
Implement managed code in the database.
Use Service Broker to build a messaging-based solution.
Prerequisites
Before attending this course, students must have: �Basic knowledge of the Microsoft Windows operating system and its core functionality. �Working knowledge of Transact-SQL. It is recommended, but not required, that students have completed Parity course Introduction to SQL ( SQL ) or have equivalent skills. �Working knowledge of relational databases. �Some experience with database design.
Follow-on Courses
Maintaining a Microsoft SQL Server 2005 Database ( MS2780A )
Course Content
Creating Databases and Database Files
Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots.
Creating Data Types and Tables
Creating Data Types.
Creating Tables.
Creating Partitioned Tables.
Using XML
Retrieving XML by Using FOR XML.
Shredding XML by Using OPENXML.
Using the xml Data Type.
Creating and Tuning Indexes
Planning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes.
Implementing Data Integrity
Data Integrity Overview.
Implementing Constraints.
Implementing Triggers.
Implementing XML Schemas.
Implementing Views
Introduction to Views.
Creating and Managing Views.
Optimizing Performance by Using Views.
Implementing Stored Procedures and Functions
Implementing Stored Procedures.
Creating Parameterized Stored Procedures.
Creating Functions.
Handling Errors.
Controlling Execution Context.
Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime.
Importing and Configuring Assemblies.
Creating Managed Database Objects.
Using Service Broker
Service Broker Overview.
Creating Service Broker Objects.
Sending and Receiving Messages.
Examinations
The combination of this course and MS2780A lead to Exam 70-431 : Microsoft SQL Server 2005—Implementation and Maintenance, which is at the Technology Specialist level.
...''
Please go to the school's official website for training price and schedule:
http://www.techno-ed.com/
Phone:+92-42- 585 4881-5
School Address:
Lahore
33-L, Gulberg III, Near Askari Flats, Kalma Chowk, Lahore
Ph: +92-42- 585 4881-5
Islamabad
Address: 13-P, Empire Center, 2 nd Floor, F-7 Markaz, Jinnah Super, Islamabad.
Ph: +92-51- 2654108
Karachi
190-A, Block -AS.M.C.H, Shahrah-e-Faisal, Karachi.
Ph: +92-21- 4381833-4
Jobs & Resumes: Islamabad, Karachi, Lahore
Houses & Roommates: Islamabad, Karachi, Lahore
Travel Agencies: Islamabad, Karachi, Lahore
Search other schools for Implementing a Microsoft SQL Server 2005 Database training resources.
Other training courses offered by Techno-ed:
Oracle9i Database: Performance Tuning
Oracle9i Database: Fundamentals
Oracle Database 10g: Programming with PL/SQL
Oracle9i Forms Developer: Build Internet Applications
Oracle9i Reports Developer
Oracle Database 10g Admin- (OCA)
Oracle Database 10g Admin (OCP)
Oracle 11i E-biz Solutions
Oracle 11i Financials General Ledger
Oracle Jdeveloper
Implementing and Maintaining a Microsoft SQL 2005 Database
Maintaining a Microsoft SQL Server 2005 Database
Updating Your Database Administration Skills to Microsoft SQL Server 2005
Updating Your Database Development Skills to Microsoft SQL Server 2005
RH 033 Red Hat Linux Essentials
RH 133 Red hat Linux System Administration
RH 253 Red hat Linux Network & Security
IT Essentials
Network Operating Systems
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges. |
|
|
