Popular Training Course
- Microsoft Office 2010 Training
- PMP Training
- MCSE Certification Training
- CompTIA A+ Certification Training
- Cisco CCNA CertificationTraining
- Windows 7 Training
- Microsoft Excel Training
- CISSP Training
- Microsoft Office Training
- CompTIA Network+ Training
- MCITP Training
- Microsoft Project Training
- Project Management Training
- QuickBooks Pro Training
- Microsoft Windows Server Training
CBT Training Courses
In the News
Microsoft Certifications
Computer Based Training (CBT) :: Microsoft Technical Training
MCTS: SQL 2005
Self-Study Microsoft SQL Server 2005 - Implementation and Maintenance CBT Online Training Course
Online Training Course ID:CBT 88-70431D
Training Course Description:
CBT Planet's self-study Microsoft SQL Server 2005 - Implementation and Maintenance CBT course prepares you for the Microsoft 70-431 exam. By following this computer based training exam prep program, you will learn everything you need to know to pass this exam. If you are preparing for a career as a Database Administrator or Developer, or a Business Intelligence Developer, you'll want to possess this knowledge. This Microsoft SQL Server 2005 - Implementation and Maintenance tutorial training course on CD will give you a technical understanding of and background knowledge in SQL Server 2005's features and implementation.
When you prepare for a Microsoft exam, it pays to follow the exam's objectives. The Microsoft SQL Server 2005 - Implementation and Maintenance training course thoroughly covers Microsoft's objectives for this exam giving you the exact training in all the core areas that you need. When you choose a format such as this, you get an interactive training program loaded with animations, demonstrations, videos, narrations, hands-on exercises, and high-quality material designed to teach and motivate.
Using the Microsoft SQL Server 2005 - Implementation and Maintenance CBT training course is easy, simply install the disc onto your PC or laptop and begin learning. The user-friendly interface is easy to navigate. You'll spend your time studying and learning the material, not tinkering with software. In addition, your schedule is your own. You can study as quickly or as slowly as you need to. By the time you are ready to take the exam, you will have all the tools, experience, and knowledge needed for success.
Exam Number |
Total Learning Hours |
Certification |
70-431 |
32 |
Course objectives
You will learn about the SQL Server Configuration Manager, SQL Server Surface Area Configuration, SQL Server Management Studio, performance management and reporting tools, command-line utilities, preparing for installation, hardware requirements, software requirements, operating system requirements, installing SQL Server from a command prompt, installing named instances, installing, upgrading or migrating to SQL Server 2005, verifying a SQL Server 2005 installation, reviewing installation errors, services, installing SQL native clients and workstations, installation prompts, features of various SQL Server 2005 editions, key services, database management system languages, and computing models supported by SQL Server 2005.
In addition, we'll teach you to optimize performance, attach and detach databases using SQL Server Management Studio as well as Transact SQL, change a database's collation, determine space requirements, drop a database, rename databases, manage files and filegroups, add filegroups, create databases, modify databases, work with database properties, use files and filegroups, configure and enable Database Mail, store data, manage server instances, and set server properties,
Other topics include creating foreign key constraints, displaying table information, modifying tables, altering tables, object identifiers, types of tables, creating tables, creating generated values and computed columns, creating check constraints, creating primary key constraints, creating unique constraints, objects, database schema, CLR user-defined types, alias data types, data types, de-normalization and normalization, 3NF, types of data integrity, table design, business requirements, processing models, and data design phases.
You will also learn about creating Query and Script templates, viewing system functions, deterministic and nondeterministic system functions, data type conversions commands, organizing data, summarizing data, Query Editor, SELECT statements, data retrieval models, dropping indexes, retrieving index information, creating and modifying indexes, index operations, index design considerations, and characteristics of indexes,
We'll show you how to use the RETURN statement, the GOTO statement, and the WAITFOR statement. We'll show you the advantages of views, guidelines for defining views, limitations of views, how to create standard views, alter views, drop views, define indexed views, define partitioned views, and retrieve view information. You'll learn about batch guidelines, saving and retrieving scripts, declaring variables, setting variable values, using various expressions and statements, designing queries, writing batches and scripts, deleting data, updating data, inserting data, check points, DML statements, creating Common Table Expressions, subqueries, and joining multiple tables.
After taking this course, you'll know how to create, use and manage full-text indexes, understand partitioned tables, manage collations and functions, create CLR functions, create user-defined functions, and create, manage, and execute stored procedures.
You'll work with XML files and data types, XML schema collections, create DML triggers, view and retrieve trigger information, use predefined triggers, use inserted and deleted tables, and work with transactions, locks and error handling.
We also cover importing rows using the OPENROWSET command, SQL Server Import and Export Wizard, importing and exporting data to a flat file, copying databases, importing and exporting XML data using the bcp command and the BULK INSERT command, SQL Server Integration Services Wizards, optimizing bulk transfer operations, retrieving data using the OPENXML clause, retrieving relational data using the FORXML clause, index management, manipulating and retrieving data in XML objects, computing models, XQuery element queries, and basic manipulation statements for working with XML data types.
Your studies will include configuring Secure Sockets Layer, encrypting single connections, encrypting data, encryption key hierarchy, creating database master keys, encrypting and decrypting data using passphrases, asymmetric keys, symmetric keys, and certificates. You will know about code access security, Host Policy Permission sets, database and schema securables, application roles, ownership chaining, auditing,
C2 audit tracking, fixed server roles, permissions, logins, SQL Server login accounts, Windows login accounts, and authentication types supported by SQL Server 2005.
Other processes include running queries on a remote server, running distributed transactions, non-linked server operations, running distributed transactions, security options for distributed queries, linked server objects, configuring provider's properties, Job Activity Monitor, Maintenance Plan Wizard, SQL Server Agent, working with proxies, alerts and operators, schedules, jobs, and the MSDB database roles,
You'll learn how to use database statistics, correct index fragmentation, use database consistency checker, tune databases, optimize queries, optimize database server performance, use dynamic management views, view index usage, monitor hardware performance, identify hardware bottlenecks, open the Log Viewer, start a trace, create counter logs, work with System Monitor and identify design considerations.
You'll also learn to use and monitor database mirroring, work with log shipping, database snapshots, role switching, backup and restore databases, work with file states, retrieve information on locks, define and resolve blocks and deadlocks, review log information, validate database data storage on the hard disk, create and manage endpoints, monitor and troubleshoot queues, manage Service Broker, send and receive messages, secure dialogs, configure routing, understand messaging, create Service Broker applications, and understand the Service Broker architecture.
FREE MeasureUP Practice Exam with Study Guide:
Purchase this Microsoft SQL Server 2005 - Implementation and Maintenance cbt course with an optional Study Guide. The study guide include free MeasureUP practice exams to help you prepare for your certication tests. MeasureUP is a certified Microsoft Certified Practice Test Provider.
| Optional Add-ons: |