|
|
|
|
|
|
|
|
|
|
|
|
SQL Server 2005
Implementation and Maintenance
(Exam 70-431)
Interactive Instructor Based
Video Training Course
Running Time: 23.5 hours
|
Prices Vary
(See below) |
|
SQL Server 2005 Implementation and Maintenance (Exam 70-431) is a course designed to help organizations build, manage, and deploy secure, scalable, and reliable enterprise applications based on Microsoft’s SQL Server 2005 platform. This course will enable your organization to leverage the many new features in SQL Server 2005 to increase availability, reliability, and performance of critical systems. The lessons are designed to help organizations reduce costs and improve efficiency where knowledge is key to increasing the bottom line. KeyStone’s SQL Server 2005 Implementation and Maintenance (Exam 70-431) video training course will provide professionals with the knowledge and skills required to implement, maintain, and troubleshoot SQL Server 2005 databases in complicated and competitive business and non-profit environments.
|
|
|
Trainer
|
Outline
|
Specials
|
Buy Options
|
|
|
Trainer Information:
|
|
Anil Desai is an independent consultant and author based in Austin, TX. He specializes in implementing and managing solutions based on Microsoft technologies. He has worked extensively with Microsoft's Server products and the .NET development platform. Anil is certified as an MCITP, MCSE, MCDBA, and MCSD and is a Microsoft MVP. In his consulting and professional experience, Anil has designed and managed hundreds of SQL Server databases.
Anil is the author of numerous technical books focusing on SQL Server , the Windows Server platform, virtualization technology, Active Directory, and IT management. He has made dozens of conference presentations at national events and is also a contributor to technical magazines. For more information, please see his web site at AnilDesai.net.
|
|
|
About This Course:
|
|
KeyStone’s SQL Server 2005 Implementation and Maintenance (Exam 70-431) video training course will first take professionals through the processes of installation, configuring, and upgrading to Microsoft SQL Server 2005. Topics such as creating new database instances and configuring SQL Server 2005 security will also be covered in the beginning. Then, the course will guide professionals through supporting database clients, importing and exporting data, and working with XML data.
Next, KeyStone’s SQL Server 2005 Implementation and Maintenance (Exam 70-431) video training course will explain how to create and manage various database objects, including tables, views, triggers, functions, stored procedures, constraints. The course will then present professionals with many operations related to maintaining SQL Server 2005 databases. Next, the important tasks of planning for and implementing backup and recovery processes will be covered.
After that, KeyStone’s SQL Server 2005 Implementation and Maintenance (Exam 70-431) video training course will continue on to monitoring and troubleshooting SQL Server 2005 performance, processes that are vital to ensuring that databases are running optimally. The course will then discuss important high-availability and reliability topics, including disaster recovery, database mirroring, and database snapshots. Finally, the course will delve into the many different ways in which professionals can work with distributed data. Finally, advanced topics such as working with Full-Text Search, implementing partitions, and implementing Service Broker will be covered.
|
| |
|
|
|
|
| |
1.1 Understanding SQL Server 
1.2 New Features in SQL Server 2005
1.3 Editions of the SQL Server Platform
1.4 About Exam 70-431
2.1 System Requirements and Prerequisites
2.2 Installing a New Instance
2.3 Upgrading to SQL Server 2005
2.4 Configuring SQL Server Features and Services
2.5 Using SQL Server 2005 Management Studio
|
3.1 Understanding Databases
3.2 Understanding Database File Structure
3.3 Creating Databases
3.4 Configuring Collation Options
4.1 Understanding SQL Server’s Security Architecture
4.2 Creating and Managing Logins
4.3 Managing Database Users and Roles
4.4 Understanding Database Schemas
4.5 Managing Permissions
4.6 Configuring Certificates and Encryption
5.1 Recap of Level 1
|
|
| |
|
|
|
|
| |
1.1 Writing Queries using SQL Server Management Studio
1.2 Using SELECT, INSERT, UPDATE, and DELETE Commands
1.3 Creating and Managing Transactions
1.4 Implementing Error Handling
2.1 Understanding Import and Export Options
2.2 Using SQL Server Integration Services (SSIS)
2.3 Using bcp
2.4 Using BULK INSERT
2.5 Using OPENROWSET
|
3.1 Creating HTTP Endpoints
3.2 Securing HTTP Endpoints
4.1 Understanding XML
4.2 Using the FOR XML clause
4.3 Importing XML Data
4.4 Working with XML Schemas and Typed XML
4.5 Creating XML Indexes
5.1 Recap of Level 2
|
|
| |
|
|
|
|
| |
1.1 Using System Views
1.2 Managing Objects in SQL Server Management Studio
2.1 Designing Tables
2.2 Creating Tables
3.1 Understanding Data Integrity and Constraints
3.2 Creating Constraints
4.1 Understanding Views
4.2 Creating and Managing Views
|
5.1 Understanding User-Defined Types
5.2 Creating Alias Types
5.3 Creating CLR User-Defined Types
6.1 Understanding Triggers
6.2 Creating DML Triggers
6.3 Creating DDL Triggers
7.1 Understanding User-Defined Functions
7.2 Creating Functions
8.1 Understanding Stored Procedures
8.2 Creating Stored Procedures
9.1 Recap of Level 3
|
|
| |
|
|
|
|
| |
1.1 Understanding and Designing Indexes
1.2 Creating Indexes
1.3 Maintaining Indexes
1.4 Maintaining Statistics
2.1 Understanding Full-Text Search
2.2 Creating and Populating FTS Indexes
2.3 Performing Full-Text Queries
|
3.1 Understanding SQL Server Agent
3.2 Configuring SQL Server Agent
3.3 Creating and Scheduling Jobs
3.4 Monitoring SQL Server Agent Jobs
3.5 Defining Alerts
3.6 Configuring Operators
3.7 Configuring DatabaseMail
4.1 Shrinking Database Files
4.2 Verifying Database Integrity using DBCC CHECKDB
5.1 Recap of Level 4
|
|
| |
|
|
|
|
| |
1.1 Overview of Backups
1.2 Understanding Recovery Models
1.3 Understanding Backup Types and Options
1.4 Creating Database Backups
1.5 Creating Database Maintenance Plans
2.1 Understanding the Restore Process
2.2 Restoring User Databases
2.3 Restoring System Databases
|
3.1 Understanding Backup Storage Options
3.2 Working with Backup Devices and Media
3.3 Getting Backup-Related Information
4.1 Overview of Moving Databases
4.2 Attaching and Detaching Databases
4.3 Using the Copy Database Wizard
5.1 Recap of Level 5
|
|
| |
|
|
|
|
| |
1.1 An Overview of Performance Monitoring
1.2 Understanding SQL Profiler
1.3 Creating and Configuring SQL Server Profiler Traces
1.4 Using System Monitor with SQL Profiler
1.5 Using Dynamic Management Views (DMVs)
1.6 Viewing SQL Server Management Studio Reports
2.1 Understanding the Database Engine Tuning Advisor
2.2 Analyzing Performance with the Database Engine Tuning Advisor
3.1 Monitoring and Managing Processes
3.2 Understanding and Monitoring Locking
3.3 Understanding and Monitoring Deadlocks
|
4.1 Using the Dedicated Administrator Connection (DAC)
4.2 Monitoring SQL Server Logs
4.3 Using SQLDiag
5.1 Understanding Partitions
5.2 Implementing Partitions
5.3 Managing Partitions
6.1 Recap of Level 6
|
|
| |
|
|
|
|
| |
1.1 Understanding Database Mirroring
1.2 Database Mirroring Modes
1.3 Implementing Database Mirroring
1.4 Monitoring and Managing Database Mirrors
2.1 Understanding Log Shipping
2.2 Implementing Log Shipping
2.3 Monitoring Log Shipping
|
3.1 Understanding Snapshots
3.2 Creating and Using Snapshots
3.3 Managing Snapshots
4.1 Recap of Level 7
|
|
| |
|
|
|
|
| |
1.1 Understanding Linked Servers
1.2 Configuring and Securing Linked Servers
1.3 Querying Linked Servers
2.1 Understanding Replication
2.2 Replication Roles and Architecture
2.3 Understanding Replication Types
2.4 Creating and Configuring Publications
2.5 Subscribing to a Publication
2.6 Monitoring Replication
2.7 Managing Replication
|
3.1 Understanding Service Broker
3.2 Understanding Service Broker Components
3.3 Implementing Service Broker
3.4 Enabling Distributed Messaging
4.1 Recap of Level 8
5.1 Course Recap
|
|
Note: Course outlines are subject to change.
|
|
|
|
 |
SQL Server 2005 (Exam 70-431) Online: 365-Day License
|
 |
|
|
|