Training for IT and Business Professionals - Sept - Dec 2010 - (Page 36)

Developing and Implementing a SQL Server 2008 Database (M6232) Learn how to develop and implement databases. • 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 • Implement functions • Implement managed code in the database • Manage transactions and locks • Use Service Broker to build a messaging-based solution Course 6187 Course Content 1. Creating Databases and Database Files 2. Creating Data Types and Tables 3. Creating and Tuning Indexes 4. Implementing Data Integrity by Using Constraints and Triggers 5. Using XML 6. Implementing Views 7. Implementing Stored Procedures 8. Implementing Functions 9. Implementing Managed Code in the Database 10. Managing Transactions and Locks 11. Using Service Broker Authorized Course Official Microsoft Learning Product SATVs redeemable on this course. Course Description In this course, you will gain the knowledge and skills to develop and implement a Microsoft SQL Server 2008 database. You will learn how to use SQL Server 2008 product features and tools related to developing and implementing a database. This course incorporates material from the Official Microsoft Learning Product 6232: Implementing a Microsoft SQL Server 2008 Database. Who Needs to Attend Prerequisite IT professionals who administer and maintain SQL Server databases What You’ll Learn in Class • Create databases and database files • Create data types and tables • Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (see our web site) Classroom Learning 5 days $2,475 Classroom Learning BC Vancouver ON Ottawa ON Toronto Oct 18-22 Oct 4-8 Oct 4-8 On-Site Learning Call for info. Maintaining a Microsoft SQL Server 2008 Database (M6231) Course 6186 Learn to install and configure SQL Server 2008. • Manage security • Transfer data into and out of SQL Server • Automate administrative tasks • Replicate data between SQL Server instances • Maintain high availability • Monitor SQL Server Course Content 1. Installing and Configuring SQL Server 2. Managing Databases and Files 3. Disaster Recovery 4. Managing Security 5. Transferring Data 6. Automating Administrative Tasks 7. Implementing Replication 8. Maintaining High Availability 9. Monitoring SQL Server 10. Troubleshooting and Performance Tuning Authorized Course Official Microsoft Learning Product SATVs redeemable on this course. Course Description In this instructor-led course, students will gain the knowledge and skills to maintain a Microsoft SQL Server 2008 database, focusing on learning how to use SQL Server 2008 database maintenance features and tools. This course incorporates material from the Official Microsoft Learning Product 6231: Maintaining a Microsoft SQL Server 2008 Database. Who Needs to Attend Prerequisites IT professionals who administer and maintain SQL Server databases What You’ll Learn in Class • Install and configure SQL Server 2008 • Manage database files • Back up and restore databases • Basic knowledge of the Microsoft Windows operating system and its core functionality • Working knowledge of Transact-SQL • Working knowledge of Relational databases • Core Windows Server skills • Database design skills • Recommended, but not required: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (see our web site) Classroom Learning 5 days $2,475 Classroom Learning AB Calgary BC Vancouver MB Winnipeg Oct 4-8 Sep 20-24 On-Site Learning Call for info. Nov 1-5 36 REGISTER NOW 1-800-COURSES www.globalknowledge.ca  http://www.globalknowledge.ca/training/olm/go.asp?find=can405_6187C&country=Canada http://www.globalknowledge.ca/training/olm/go.asp?find=can405_6186C&country=Canada http://www.globalknowledge.ca

Table of Contents for the Digital Edition of Training for IT and Business Professionals - Sept - Dec 2010

Training for IT and Business Professionals - Sept-Dec 2010
Contents
Networking & Wireless
Security
Cisco®
Routing & Switching
Data Center and Storage
Unified Communications
Security
Contact Center
Unified Wireless
Avaya
Microsoft®
Boot Camps
Windows 7
Windows Server 2008
Exchange Server
Unified Communications
Windows SharePoint
SQL
VMware
Red Hat®
Citrix®
SAP Business Objects™
ITIL®
Business Training
Project Management
Business Skills

Training for IT and Business Professionals - Sept - Dec 2010

https://www.nxtbookmedia.com