<img src="https://secure.leadforensics.com/114361.png" style="display:none;">

Course List

+

MICROSOFT TECHNICAL

MOC 6232 - SQL Server 2008 Database - Implementing a Microsoft SQL Server 2008 Database

\

OVERVIEW

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database

OBJECTIVES

After completing this course, students will be able to:

  • Create databases and database files.
  • Create data types and tables.
  • Use XML-related features in Microsoft SQL Server 2008.
  • Plan, create, and optimize indexes.
  • Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
  • Implement data integrity in Microsoft SQL Server 2008 databases by using triggers.
  • Implement views.
  • Implement stored procedures

PREREQUISITES

Before attending this course, students must have:

  • Working knowledge of Transact-SQL.
  • Working knowledge of Relational databases.
  • Core Windows Server skills.
  • Database design skills.
  • SQL Server skills - ability to write Transact-SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

CONTENT

Module 1: Creating Databases and Database Files

The students will learn one of the most fundamental tasks that a database developer must perform, the creation of a database and its major components, such as creating databases, setting database options, creating filegroups, schemas, and database snapshots.

Lessons

  • Creating Databases
  • Creating Filegroups
  • Creating Schemas
  • Creating Database Snapshots

Lab : Creating Databases and Database Files

  • Creating a Database
  • Creating Schemas
  • Creating a Database Snapshot

After completing this course, students will be able to:

  • Create databases
  • Create filegroups
  • Create schemas
  • Create database snapshots

Module 2: Creating Data Types and Tables

The students will learn about the system-supplied data types in SQL Server 2008. They will learn how to define custom Transact-SQL data types and how to create tables and how to use partitioned tables to organize data into multiple partitions.

Lessons

  • Creating Data Types
  • Creating Tables
  • Creating Partitioned Tables

Lab : Creating Data Types and Tables

  • Creating Data Types
  • Using New Date and Time Data Types
  • Creating Tables
  • Creating Partitioned Tables

After completing this course, students will be able to:

  • Create new data types.
  • Create new tables.
  • Create partitioned tables.

Module 3: Creating and Tuning Indexes

The students will learn how to plan, create, and optimize indexes to attain optimal performance benefits.

Lessons

  • Planning Indexes
  • Creating Indexes
  • Optimizing Indexes

Lab : Creating and Tuning Indexes

  • Creating Indexes
  • Optimizing Indexes

After completing this course, students will be able to:

  • Plan indexes.
  • Create indexes.
  • Optimize indexes.

Module 4: Implementing Data Integrity by Using Constraints and Triggers

The students will learn about implementing data integrity in SQL Server 2008 by using constraints. They will also implement data integrity by using triggers.

Lessons

  • Data Integrity Overview
  • Implementing Constraints
  • Implementing Triggers

Lab : Implementing Data Integrity by Using Constraints and Triggers

  • Creating Constraints
  • Disabling Constraints
  • Creating Triggers

After completing this course, students will be able to:

  • Describe the options for enforcing data integrity in SQL Server 2008.
  • Implement data integrity in SQL Server 2008 databases by using constraints.
  • Implement data integrity in SQL Server 2008 databases by using triggers.

Module 5: Using XML

The students will learn how to work with XML, including use of the FOR XML clause, the OPENXML function, XQuery expressions, and the xml native data type. They will learn the considerations to be taken into account when creating XML indexes and the syntax used to create the XML indexes. They will also learn what XML schemas and XML schema collections are as well as how to use them to implement typed XML data.

Lessons

  • Using the XML Data Type
  • Retrieving XML by Using FOR XML
  • Shredding XML by Using OPENXML
  • Introducing XQuery
  • Creating XML Indexes
  • Implementing XML Schemas

Lab : Using XML

  • Mapping Relational Data and XML
  • Storing XML Natively in the Database
  • Using XQuery with XML Methods
  • Creating XML Indexes

After completing this course, students will be able to:

  • Use the xml data type.
  • Retrieve XML by using the FOR XML clause.
  • Shred XML by using the OPENXML function.
  • Use XQuery expressions.
  • Create XML indexes.
  • Implement data integrity in SQL Server 2008 databases by using XML schemas.

Module 6: Implementing Views

The students will be introduced to the different types of views available in Microsoft SQL Server 2008 which provide a convenient way to access data through a predefined query.

Lessons

  • Introduction to Views
  • Creating and Managing Views
  • Optimizing Performance by Using Views

Lab : Implementing Views

  • Creating Views
  • Creating Indexed Views
  • Creating Partitioned Views

After completing this course, students will be able to:

  • Describe the purpose of views.
  • Create and manage views.
  • Explain how to optimize query performance by using views.

Module 7: Implementing Stored Procedures

The students will learn the design and implementation of stored procedures to enforce business rules or data consistency, or to modify and maintain existing stored procedures written by other developers.

Lessons

  • Using Stored Procedures
  • Creating Parameterized Stored Procedures
  • Working With Execution Plans
  • Handling Exceptions

Lab : Implementing Stored Procedures

  • Creating Stored Procedures
  • Working with Execution Plans

After completing this course, students will be able to:

  • Implement stored procedures.
  • Create parameterized stored procedures.
  • Work with execution plans.
  • Handle errors in stored procedures.

Module 8: Implementing Functions

The students will learn the design and implementation of user-defined functions that enforce business rules or data consistency, or to modify and maintain existing functions written by other developers.

Lessons

  • Introducing Functions
  • Working with Functions
  • Controlling Execution Context

Lab : Implementing Functions

  • Creating Functions
  • Controlling Execution Context

After completing this course, students will be able to:

  • Create and use functions.
  • Work with functions.
  • Control execution context.

Module 9: Implementing Managed Code in the Database

The students will learn to use managed code to implement database objects, such as stored procedures, user-defined data types, user-defined functions, and triggers.

Lessons

  • Introduction to the SQL Server Common Language Runtime
  • Importing and Configuring Assemblies
  • Creating Managed Database Objects

Lab : Implementing Managed Code in the Database

  • Importing an Assembly
  • Creating Managed Database Objects

After completing this course, students will be able to:

  • Identify appropriate scenarios for managed code in the database.
  • Import and configure assemblies.
  • Create managed database objects.

Module 10: Managing Transactions and Locks

The students will learn to use transactions and SQL Server locking mechanisms to meet the performance and data integrity requirements of their applications.

Lessons

  • Overview of Transactions and Locks
  • Managing Transactions
  • Understanding SQL Server Locking Architecture
  • Managing Locks

Lab : Managing Transactions and Locks

  • Using Transactions
  • Managing Locks

After completing this course, students will be able to:

  • Describe how SQL Server 2008 transactions use locks.
  • Execute and cancel a transaction.
  • Describe concurrency issues and SQL Server 2008 locking mechanisms.
  • Manage locks.

Module 11: Using Service Broker

The students will learn to use Service Broker to create secure, reliable, and scalable applications.

Lessons

  • Service Broker Overview
  • Creating Service Broker Objects
  • Sending and Receiving Messages

Lab : Using Service Broker

  • Creating Service Broker Objects
  • Implementing the Initiating Service
  • Implementing the Target Service

AUDIENCE PROFILE

This course is intended for IT Professionals who administer and maintain SQL Server databases.

ACCREDITATION

  • Certificate of attendance.

DURATION

5 days

COST

€1,995

AVAILABILITY

Cork - Call for dates
Galway - Call for dates

Back to Course List
-

Training with PFH

+

WHY TRAIN WITH PFH?

  • Pre-training evaluation - PFH will assess your training requirements and levels prior to attending training:
  • Instructor led tuition by highly qualified instructor
  • Comprehensive manual to accompany PFH public courses
  • Training can be customised to meet customer's specific requirements
  • Money back guarantee – If you are not happy with the quality of training received, PFH will refund payment
  • All PFH trainers are Certified which guarantees that the training you receive will be of the highest quality.

 

DURING TRAINING:

  • Each student will have their own PC
  • Comprehensive manual to accompany each training course
  • Complimentary coffee, tea, biscuits and fruit provided, along with light lunch provided for courses delivered in PFH
  • Certificates of Attendance provided to each student on completion of training
  • Air conditioned comfortable and spacious training rooms
  • Free parking

 

LEARNING GUARANTEE:

  • If a student feels they have not managed to reach their own personal course objectives, they are welcome to attend the:
  • Same public class within 6 months, at no charge
  • 60 day post training support – Students can call or email our instructors with any questions / problems they may be experiencing at home or work (or a maximum of 5 calls per course/delegate)

 

TRAINING FACILITIES PROVIDED BY PFH

When you're learning new skills and meeting new people it's important that you do so in comfortable, modern surroundings.

You'll enjoy a rewarding training course here at PFH premises and benefit from our modern training facilities.

Facilities provided include:

  • Air-conditioned training rooms
  • High-spec student PC's plus an instructor PC
  • Internet access and wireless internet access 
  • Convenient locations in Cork and Galway 
  • Overhead projector, whiteboard and flipchart in each room 
  • Course materials 
  • Free parking 
  • Daily refreshments & lunch

 

Please note that the above facilities are available to rent for your specialised training event also. Please contact PFH Training for rates and information.

Read More -

Training Types

+

INSTRUCTOR-LED TRAINING

Instructor-led training is an effective means of delivering information, as it allows for real-time feedback, questions and answers, manipulation and changeable delivery to suit the needs of learners in a real-time environment. Few educational opportunities are considered more valuable than meeting and interfacing directly with an instructor. 

 

All of our trainers are MCPs [Microsoft Certified Professionals], ECDL certified and MOS Experts which guarantees that the training you receive will be of the highest quality.

 

PFH has a large portfolio of trainers who can deliver training at our training centres in Cork and Galway, or Nationwide at customer premises or another training centre.

 

PFH offers instructor led training on our Public Schedule at our training centres in Cork and Galway. 

 

CUSTOMISED INSTRUCTOR- LED TRAINING

PFH provides customised training for groups of 1 to 12 at either PFH's Training Centres at Cork or Galway or on-site at your premises. Content can be taken from any of our course oulines and customised to suit the exact requirmements of your group and scheduled on dates that suit your delegates.  Group rates apply contact us for rates.

 

This method of training ensures your delegates get trained on exactly the topics they require in the duration of time that you can allow to give them.

 

SEMINAR STYLE TRAINING

Seminar training can be offered where companies require a large number of people to receive initial overview training on the New Interface of an Operating System or Office Applications. 

 

Seminar Training is based solely on demonstrating the New Features and is non hands-on training.  The benefits of this type of training is that attendees can get an initial feel for the New Interface of any given application and it can save a lot of time and money during an initial roll out.  This type of training instils an element of confidence when people return to their desks to work with the New Interface or Application.

 

Depending on how the roll out is managed with the installations, training could be run in tandem with this, and groups may also benefit from the trainer doing some “floor walking”  following the seminars to assist people when they are back at their desks.

 

The number of attendees is optional and can range from 20-50 per session.  This is dependant on the size of your room!

All training/seminar can be customised specifically to suit group requirements.

Read More -