Microsoft SQL Server 2005/2008 Ultimate Bootcamp®
The MCTS SQL Server Exam Preparation
Overview
In this challenging IT world certification stands out. It gets your foot in door which provides you the chance to move forward in the hiring line. The MCTS SQL Server boot camp will prepare you for the 70-431 / 70-432 exams. When you become certified you:
- Stand out with proof of your specific, real-world technology skills
- Are productive and help increase customer satisfaction, reduce network downtime, and push service to a higher level
- Achieve success with each Microsoft certification it increases your professional recognition
The MCTS SQL Server certification highlights your area of expertise in managing and maintaining a Microsoft SQL Server 2005/2008. The candidate will have displayed their experience installing, managing, monitoring, troubleshooting Microsoft SQL Server 2005 / 2008, managing security, creating databases, complex queries, views, stored procedures, functions and learning how to get the most of the Microsoft SQL Server.
Course Objectives
- Install and configure SQL Server 2005
- Manage database files
- Backup and restore databases
- Manage Security
- Monitor SQL Server
- Transfer data into and out of SQL Server
- Automate administrative tasks
- Replicate data between SQL Server instances
- Maintain high availability within the SQL Server 2005 environment
- Create databases and database files
- Create data types and tables
- Use XML-related features in Microsoft SQL Server 2005 / 2008
- Plan, create and optimize indexes
- Implement data integrity in Microsoft SQL Server 2005 databases by using constraints
- Implement data integrity in Microsoft SQL Server 2005 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
- Use Notification Services to generate and send notifications
- Get started with databases and Transact-SQL
- Perform basic queries
- Group and summarize data
- Join data from multiple tables
- Work with subqueries
- Modify data
- Query metadata, XML, and full-text indexes
- Use programming objects for data retrieval
- Use advanced querying techniques
- Learn the difference between 2005 / 2008
- MCTS Certification Readiness 70-431 / 70-432
Who Should Attend
IT Professionals, IT generalists, and help desk professionals who want to learn about Microsoft SQL Server 2005 /2008. IT Professionals, IT generalists and help desk professionals should have at least 3 years experience working in the IT field. You will learn all of the features and technologies for maintaining and implementing a database on Microsoft SQL Server 2005 /2008.
Prerequisites
- Working knowledge of relational databases
- Some experience with database design
- Experience with running commands from a command window, such as the DOS command prompt.
- An understanding of basic relational database concepts, including:
- Logical database design.
- Physical database design.
- How data is stored in tables (rows and columns).
- Data integrity concepts.
- Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
- Basic knowledge of the Microsoft Windows operating system and its core functionality. For example, how to use Windows Explorer, open and save files, and what a client/server application interaction means.
Course Length
5 Days (9 am - 6 pm)
What's Included...
- All VHD’s for the class
- Test Prep Materials
- Test Vouchers
- Snacks
- Lunch
For a limited time, register for the Microsoft Exchange Ultimate Bootcamp and receive a FREE laptop!
Dual-Core, 3-4 GB DDR2 MEMORY, 160 GIG HARD DRIVE, 3D AUDIO, 3D VIDEO, 10/100 LAN DVD+-RW BURNER, 802.11G WIRELESS LAN, 17"WXGA ULTRA-BRIGHT SCREEN, WINDOWS VISTA PREMIUM EDITION, BUILT-IN MEMORY CARD READER, 4-USB 2.0 PORTS, PCMCIA PORTS
