- Current Class Schedules
- Customized Contractual Education
- 4 Ways to Register
- Rent a Computer Lab
- Upcoming Events
- Directions & Parking
- General Information About CTU
- MCE&CE Home Page
MCTS Implementing a SQL Server 2008 Database
Description: This course will help you to specialize your technological knowledge for Microsoft SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover implementing databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.
Suggested Prerequisites: Querying and processing SQL Server Data with SQL Statements
Attend and You Will Learn
- Lesson 1:
Introduction to SQL Server 2008
What is SQL Server
- Database engine
- Analysis Services
- Reporting Services
- Integration Services
- Notification Services
- .Net framework
A few implementation examples
- Web applications
- Windows forms application
- High-Availability introduction
Review of relational data and ACID traits
- Lesson 2:
Installing and Configuring SQL Server 2008
Selecting the correct edition
Determining infrastructure Requirements
Using Default, named, and Multiple Instances of SLQ Server 2008
Installing SQL 2008
Upgrading to SQL 2008
- Lesson 3:
SQL Server Tools Introduction
Management Studio
Surface Area Configuration
SQL Server Profiler
SQL Server Books Online
SQL Configuration Manager
Business Intelligence Development Studio
- Lesson 4:
Managing Databases and Filegroups
Configure log and data files
Specifying a Recovery Model
- Lesson 5:
Working with Transact SQL
Querying Data
Formatting Result Sets
Modifying Data
Working with Transactions
- Lesson 6:
Creating Tables, Constraints and User-Defined Types
Creating Tables
Implementing Constraints
Creating User-Defined Types
- Lesson 7:
Creating Indexes
Understanding Index Structure
Creating Clustered Indexes
Creating Non-Clustered Indexes
- Lesson 8:
Implementing Views
Creating a View
Modifying Data through Views
Creating an Indexed View
- Lesson 9:
Creating Functions, Stored Procedures, and Triggers
Implementing Functions
Implementing Stored Procedures
Implementing Triggers
- Lesson 10:
Creating Partitions
Creating a partition Function
Creating a Partition Scheme
Partitioning Tables and Indexes
Querying Partitions
Managing Partitions
- Lesson 11:
Using Transact SQL to Manage Databases
Managing Index Fragmentation
Managing Statistics
Shrinking Files
Using DBCC CHECKDB
- Lesson 12:
Managing XML Data
Working with XML Structures
Retrieving XML Data by Using SL Server-Side Technologies
Retrieving XML Data by Using SLQ Server Middle-Tier Technologies
Modifying XML Data
Converting Between XML Data and Relational Data
- Lesson 13:
Working with HTTP Endpoints
Understanding HTTP Endpoint Security
Creating a Secure Endpoint
- Lesson 14:
Using Managed Code in SQL Server 2008(not in text)
CLR Integration
Using Assemblies
Enforcing Security
- Lesson 15:
Working with Service Broker
Exploring the Service Broker Architecture
Creating Message Types and Contracts
Creating Queues and Services
Creating Conversations
Sending and Receiving Messages
For available dates, Click Here.
Upcoming Events
919.515.8163 - NC State University - 1101 Gorman Street - Campus Box 7401 - Raleigh, NC 27695
Computer Training Unit is a unit of McKimmon Center for Extension & Continuing Education
Copyright © 2008 - North Carolina State University - All Rights Reserved - Policy Disclaimer
