call us on 0121 248 2400
 
To receive updates and new releases, subscribe today


Save up to 30%
Off Publishers Retail Prices

courses / products
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
View Complete List...
100% Satisfaction Guaranteed

CareerVision is committed to providing our customers with the best service and products available.

We back our training products with a 100% Satisfaction or Your Money Back Guarantee, so you can buy worry free. More....



FAST, FREE UK DELIVERY
Order Today, Learn Tomorrow!


SECURE PAYMENT
PROCESSING


We Accept All Major Credit Cards, PayPal and Google Checkout

Credit Cards Accepted
PayPal Accepted




Implementing a MS SQL Server 2005 Database

 
Bookmark and Share
MOC 2779 - Implementing a MS SQL Server 2005 Database Training
CareerVision
Limited Time Offer
Save up to 30%
Implementing a MS SQL Server 2005 Database
 

More on Single User, Multi User & Network Licences



PACKAGE INCLUDES

  • 9 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • Step-by-step hands-on-labs
  • Comprehensive, understandable, and reusable as reference material
  • Focused on practical solutions to real-world development problems

    COURSE INTRODUCTION

    The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

    This video-based training course will provides students with the 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. The course is intended for IT Professionals wanting to learn SQL Server 2005 product features and technologies.


    SPECIAL FEATURES OF OUR TRAINING COURSES


    Comprehensive Menu Structure 
    Move through hours of in-depth content - quickly and easily with the time saving Main Menu and Sub-Menu structure. Search for a specific topic or go through the course step by step. The choice is yours.   


    Player Controls
    Move forward or back, repeat entire topics or just a section. A progress bar illuminates as you advance through the video tutorials and exercises. Play, pause rewind, fast forward or stop at any time


    Continue Where You Left Off 
    All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you were.


    Full Motion Video and Audio 
    All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.


    Printable Study Guides
    Printable study guides for the entire course are included. This allows all material to be viewed, reviewed, and printed for viewing at a later date.


    Review Exercises
    Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.


    24/7 Online Tutor Support
    Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.


    Authorised Practice Exams
    We include an Online Subscription to Authorised Practice Exams from Certified Practice Test Providers to fully prepare you for the certification exams. Take the Practice Exams as many times as needed until you are 100% confident of passing the Certification Exam.


    Live Demonstrations
    Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.


    Interactive Labs
    This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software without the need for purchasing it or having it installed on your computer.


    PowerPoint Presentations 
    Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...


    Multi-User Licencing 
    All of our courses can be purchased with a standard Single User Licence, Multi User Library Licence or a Network Licence. Please contact us for more information and prices.


    Certificate of Completion 
    Our Training Courses are recognized worldwide for their technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a CareerVision Distance Education Certificate of Completion.



    View CareerAcademy Demo Videos

  • COURSE OUTLINE


    Course Introduction

    Course Introduction

    Creating Databases and Database Files

    Lesson 1: Databases
    Considerations
    Transaction Logging
    Options
    Finding Information about Databases
    Demo: Creating a Database
    Lesson 2: Filegroups
    What Are Filegroups?
    Why Create Filegroups?
    Demo: Creating a Filegroup
    Lesson 3: Schemas
    What is a Schema?
    Object Name Resolution
    Demo: Creating a Schema
    Lesson 4: Database Snapshots
    What is a Database Snapshot?
    How does a Database Snapshot Work?
    Demo: Creating a Database Snapshot
    Module 1 Review

    Creating Data Types and Tables

    Lesson 1: Data Types
    System-Supplied Data Types
    Alias Data Types
    Demo: Creating a Data Type
    Lesson 2: Tables
    Data Organization in Rows
    Large Data Value Organization
    Considerations
    Demo: Creating a Table
    Lesson 3: Partitioning a Table
    What is a Partitioned Table?
    What is a Partition Function?
    What is a Partition Scheme?
    Demo: Creating a Partitioned Table
    What can you do with Partitioned Data?
    Module 2 Review

    Using XML

    Lesson 1: Using FOR XML
    Introduction
    RAW Mode Queries
    AUTO Mode Queries
    EXPLICIT Mode Queries
    PATH Mode Queries
    Retrieving Nested XML
    Demo: Using FOR XML
    Lesson 2: Using OPENXML
    Overview
    Managing In-Memory Node Trees
    OPENXML Syntax
    XML Namespaces
    Demo: Shredding XML
    Lesson 3: xml Data Type
    Introduction to the xml Data Type
    Xquery
    Query, Value, and Exist Methods
    Modify Method
    The nodes Method
    Demo: The xml Data Type
    Module 3 Review

    Creating and Tuning Indexes

    Lesson 1: Planning
    SQL Server Data Access
    Clustered Indexes
    Heaps
    Nonclustered Indexes
    Lesson 2: Creating
    Introduction
    Unique Indexes
    Creating Indexes with Multiple Columns
    Indexes on Computed Columns
    Partitioned Indexes
    Incorporating Free Space in Indexes
    Obtaining Index Information
    Demo: Creating Indexes
    Lesson 3: Optimizing
    Database Tuning Advisor
    Demo: Database Tuning Advisor
    Index Fragmentation
    Defragmenting Indexes
    Demo: Defragmenting Indexes
    Lesson 4: XML Indexes
    Kinds of XML Indexes
    Module 4 Review

    Implementing Data Integrity

    Lesson 1: Overview
    Types of Data Integrity
    Enforcing Data Integrity
    Lesson 2: Constraints
    Introduction
    PRIMARY KEY
    DEFAULT
    CHECK
    UNIQUE
    FOREIGN KEY
    Cascading Referential Integrity
    Considerations
    Demo: Creating Constraints
    Lesson 3: Triggers
    Introduction
    INSERT Triggers
    DELETE Triggers
    UPDATE Triggers
    How an INSTEAD OF Trigger Works
    Nested Triggers
    Recursive Triggers
    Demo: Creating Triggers
    Lesson 4: XML Schemas
    Introduction
    XML Schema Collections
    Typed XML
    Demo: Typed XML
    Module 5 Review

     
     
    Print Image Printer friendly version   
    Top of page
    A-Z COURSE LIST   PROVIDERS   CBT TRAINING  CONTACT US   SITEMAP  

    MCITP Training Courses   MCPD Training Courses   MCTS Training Courses
    MCITP Database Developer Training Courses   MCITP Database Administrator Training Courses
    Flash Tutorials & Training Courses   MCSE CBT Courses   Adobe Photoshop Tutorials & Training   Microsoft Certification Training

    CareerVision
    61 Caroline Street, Birmingham, B3 1UF, UK
    Tel: 0121 248 2400, Fax: 0121248 2800,
    Email: sales@cvision.co.uk |Web: www.cvision.co.uk


    red arrow Website design by Aimpro UK red arrow Terms