Questions? Feedback? powered by Olark live chat software

MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Prep Boot Camp

About the MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Prep Boot Camp

Duration: 7 days (70 hours)

Microsoft SQL Server 2008 R2

Next Class Dates

No schedules is available for this course, however, there are other similar courses with available schedules:

20461: Querying Microsoft SQL Server 2014

Oct 2, 2017–Oct 6, 2017
 

Oct 30, 2017–Nov 3, 2017
 

Back to Top

This boot camp training combines and covers materials from the following courses:

2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL Boot Camp (2 days)   More on this course...

arrow Course Objectives

  • » Describe the uses of and ways to execute the Transact-SQL language.
  • » Use querying tool.
  • » Write SELECT queries to retrieve data.
  • » Group and summarize data by using Transact-SQL.
  • » Join data from multiple tables.
  • » Write queries that retrieve and modify data by using subqueries.
  • » Modify data in tables.
  • » Query text fields with full-text search.
  • » Describe how to create programming objects.
  • » Use various techniques when working with complex queries.

Back to Top

arrow Course Outline

  • Getting Started with Databases and Transact-SQL in SQL Server 2008
    1. Overview of SQL Server 2008
    2. Overview of SQL Server Databases
    3. Overview and Syntax Elements of T-SQL
    4. Working with T-SQL Scripts
    5. Using T-SQL Querying Tools
  • Querying and Filtering Data
    1. Using the SELECT Statement
    2. Filtering Data
    3. Working with NULL Values
    4. Formatting Result Sets
    5. Performance Considerations for Writing Queries
  • Grouping and Summarizing Data
    1. Summarizing Data by Using Aggregate Functions
    2. Summarizing Grouped Data
    3. Ranking Grouped Data
    4. Creating Crosstab Queries
  • Joining Data from Multiple Tables
    1. Querying Multiple Tables by Using Joins
    2. Applying Joins for Typical Reporting Needs
    3. Combining and Limiting Result Set
  • Working with Subqueries
    1. Writing Basic Subqueries
    2. Writing Correlated Subqueries
    3. Comparing Subqueries with Joins and Temporary Tables
    4. Using Common Table Expressions
  • Modifying Data in Tables
    1. Inserting Data into Tables
    2. Deleting Data from Tables
    3. Updating Data in Tables
    4. Overview of Transactions
  • Querying Metadata, XML, and Full-Text Indexes
    1. Querying Metadata
    2. Overview of XML
    3. Querying XML Data
    4. Overview of Full-Text Indexes
    5. Querying Full-Text Indexes
  • Using Programming Objects for Data Retrieval
    1. Overview of Views
    2. Overview of User-Defined Functions
    3. Overview of Stored Procedures
    4. Overview of Triggers
    5. Writing Distributed Queries
  • Using Advanced Querying Techniques
    1. Considerations for Querying Data
    2. Working with Data Types
    3. Cursors and Set-Based Queries
    4. Dynamic SQL
    5. Maintaining Query Files

Back to Top

6231: Maintaining a Microsoft SQL Server 2008 R2 Database Boot Camp (2.5 days)   More on this course...

arrow Course Objectives

  • » Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
  • » Plan, install and configure SQL Server 2008 R2
  • » Backup and restore databases
  • » Import and export wizards and explain how they relate to SSIS
  • » Use BCP and BULK INSERT to import data
  • » Manage security
  • » Assign, configure fixed database roles and create and assign user defined database roles
  • » Configure and assign permissions
  • » Implement SQL Server 2008 R2 Audits
  • » Manage SQL Server 2008 R2 Agent and Jobs
  • » Configure database mails, alerts and notifications
  • » Maintain databases
  • » Configure SQL Profiler Traces and Use the Database Tuning Advisor
  • » Monitor data by using Dynamic Management Views
  • » Execute multi-server queries and configure a central management server
  • » Deploy a data-tier-application
  • » Troubleshoot common issues

Back to Top

arrow Course Outline

  • Module 1: Introduction to SQL Server 2008 R2 and its Toolset
    1. Introduction to SQL Server Platform
    2. Working with SQL Server Tools
    3. Configuring SQL Server Services
  • Module 2: Preparing Systems for SQL Server 2008 R2
    1. Overview of SQL Server 2008 R2 Architecture
    2. Planning Server Resource Requirements
    3. Pre-installation Testing for SQL Server 2008 R2
  • Module 3: Installing and Configuring SQL Server 2008 R2
    1. Preparing to Install SQL Server 2008 R2
    2. Installing SQL Server 2008 R2
    3. Upgrading and Automating Installation
  • Module 4: Working with Databases
    1. Overview of SQL Server Databases
    2. Working with Files and Filegroups
    3. Moving Database Files
  • Module 5: Understanding SQL Server 2008 R2 Recovery Models
    1. Backup Strategies
    2. Understanding SQL Server Transaction Logging
    3. Planning a SQL Server Backup Strategy
  • Module 6: Backup of SQL Server 2008 R2 Databases
    1. Backing up Databases and Transaction Logs
    2. Managing Database Backups
    3. Working with Backup Options
  • Module 7: Restoring SQL Server 2008 R2 Databases
    1. Understanding the Restore Process
    2. Restoring Databases
    3. Working with Point-in-time Recovery
    4. Restoring System Databases and Individual Files
  • Module 8: Importing and Exporting Data
    1. Transferring Data To/From SQL Server 2008 R2
    2. Importing & Exporting Table Data
    3. Inserting Data in Bulk
  • Module 9: Authenticating and Authorizing Users
    1. Authenticating Connections to SQL Server
    2. Authorizing Logins to Access Databases
    3. Authorization Across Servers
  • Module 10: Assigning Server and Database Roles
    1. Working with Server Roles
    2. Working with Fixed Database Roles
    3. Creating User-defined Database Roles
  • Module 11: Authorizing Users to Access Resources
    1. Authorizing User Access to Objects
    2. Authorizing Users to Execute Code
    3. Configuring Permissions at the Schema Level
  • Module 12: Auditing SQL Server Environments
    1. Options for Auditing Data Access in SQL Server
    2. Implementing SQL Server Audit
    3. Managing SQL Server Audit
  • Module 13: Automating SQL Server 2008 R2 Management
    1. Automating SQL Server Management
    2. Working with SQL Server Agent
    3. Managing SQL Server Agent Jobs
  • Module 14: Configuring Security for SQL Server Agent
    1. Understanding SQL Server Agent Security
    2. Configuring Credentials
    3. Configuring Proxy Accounts
  • Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications
    1. Configuration of Database Mail
    2. Monitoring SQL Server Errors
    3. Configuring Operators, Alerts and Notifications
  • Module 16: Performing Ongoing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
  • Module 17: Tracing Access to SQL Server 2008 R2
    1. Capturing Activity using SQL Server Profiler
    2. Improving Performance with the Database Engine Tuning Advisor
    3. Working with Tracing Options
  • Module 18: Monitoring SQL Server 2008 R2
    1. Monitoring Activity
    2. Capturing and Managing Performance Data
    3. Analyzing Collected Performance Data
  • Module 19: Managing Multiple Servers
    1. Working with Multiple Servers
    2. Virtualizing SQL Server
    3. Deploying and Upgrading Data-Tier Applications
  • Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues
    1. SQL Server Troubleshooting Methodology
    2. Resolving Service-related Issues
    3. Resolving Concurrency Issues
    4. Resolving Login and Connectivity Issues

Back to Top

6232: Implementing a Microsoft SQL Server 2008 R2 Database Boot Camp (2.5 days)   More on this course...

arrow Course Objectives

  • » Understand the product, its components, and basic configuration.
  • » Work with the data types supported by SQL Server.
  • » Design and implement tables and work with schemas.
  • » Design and implement views and partitioned views.
  • » Describe the concept of an index and determine the appropriate data type for indexes and composite index structures.
  • » Identify the appropriate table structures and implement clustered indexes and heaps.
  • » Describe and capture execution plans.
  • » Design and implement non-clustered indexes, covering indexes, and included columns.
  • » Design and implement stored procedures.
  • » Implement table types, table valued parameters, and the MERGE statement.
  • » Describe transactions, transaction isolation levels, and application design patterns for highly-concurrent applications.
  • » Design and implement T-SQL error handling and structured exception handling.
  • » Design and implement scalar and table-valued functions.
  • » Design and implement constraints.
  • » Design and implement triggers.
  • » Describe and implement target use cases of SQL CLR integration.
  • » Describe and implement XML data and schema in SQL Server.
  • » Use FOR XML and XPath queries.
  • » Describe and use spatial data types in SQL Server.
  • » Implement and query full-text indexes.

Back to Top

arrow Course Outline

  • Module 1: Introduction to SQL Server and its Toolset
    1. Introduction to SQL Server Platform
    2. Working with SQL Server Tools
    3. Configuring SQL Server Services
  • Module 2: Working with Data Types
    1. Using Data Types
    2. Working with Character Data
    3. Converting Data Types
    4. Working with Specialized Data Types
  • Module 3: Designing and Implementing Tables
    1. Designing Tables
    2. Working with Schemas
    3. Creating and Altering Tables
  • Module 4: Designing and Implementing Views
    1. Introduction to Views
    2. Creating and Managing Views
    3. Performance Considerations for Views
  • Module 5: Planning for SQL Server Indexing
    1. Core Indexing Concepts
    2. Data Types and Indexes
    3. Single Column and Composite Indexes
  • Module 6: Implementing Table Structures in SQL Server
    1. SQL Server Table Structures
    2. Working with Clustered Indexes
    3. Designing Effective Clustered Indexes
  • Module 7: Reading SQL Server Execution Plans
    1. Execution Plan Core Concepts
    2. Common Execution Plan Elements
    3. Working with Execution Plans
  • Module 8: Improving Performance through Nonclustered Indexes
    1. Designing Effective Nonclustered Indexes
    2. Implementing Nonclustered Indexes
    3. Using the Database Engine Tuning Advisor
  • Module 9: Designing and Implementing Stored Procedures
    1. Introduction to Stored Procedures
    2. Working With Stored Procedures
    3. Implementing Parameterized Stored Procedures
    4. Controlling Execution Context
  • Module 10: Merging Data and Passing Tables
    1. Using the MERGE Statement
    2. Implementing Table Types
    3. Using Table Types as Parameters
  • Module 11: Creating Highly Concurrent SQL Server Applications
    1. Introduction to Transactions
    2. Introduction to Locks
    3. Management of Locking
    4. Transaction Isolation Levels
  • Module 12: Handling Errors in T-SQL Code
    1. Designing T-SQL Error Handling
    2. Implementing T-SQL Error Handling
    3. Implementing Structured Exception Handling
  • Module 13: Designing and Implementing User-Defined Functions
    1. Designing and Implementing Scalar Functions
    2. Designing and Implementing Table-valued Functions
    3. Implementation Considerations for Functions
    4. Alternatives To Functions
  • Module 14: Ensuring Data Integrity through Constraints
    1. Enforcing Data Integrity
    2. Implementing Domain Integrity
    3. Implementing Entity and Referential Integrity
  • Module 15: Responding to Data Manipulation via Triggers
    1. Designing DML Triggers
    2. Implementing DML Triggers
    3. Advanced Trigger Concepts
  • Module 16: Implementing Managed Code in SQL Server
    1. Introduction to SQL CLR Integration
    2. Importing and Configuring Assemblies
    3. Implementing SQL CLR Integration
  • Module 17: Storing XML Data in SQL Server
    1. Introduction to XML and XML Schemas
    2. Storing XML Data and Schemas in SQL Server
    3. Implementing the XML Data Type
  • Module 18: Querying XML Data in SQL Server
    1. Using the T-SQL FOR XML Statement
    2. Getting Started with XQuery
    3. Shredding XML
  • Module 19: Working with SQL Server Spatial Data
    1. Introduction to Spatial Data
    2. Working with SQL Server Spatial Data Types
    3. Using Spatial Data in Applications
  • Module 20: Working with Full-Text Indexes and Queries
    1. Introduction to Full-Text Indexing
    2. Implementing Full-Text Indexes in SQL Server
    3. Working with Full-Text Queries

Back to Top

Why should you take the MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Prep Boot Camp

This boot camp class prepares the student for the certification exam and on the path of getting certified.

Benefits of Certification

For IT professionals, certification is a third party validation of your skills, that helps distinguish you from your peers. Beyond demonstrating a level of competency and proficiency, certification proves that you are committed to your cause and that you've invested the time and money to prove it. Holding a certification also makes you a more valuable employee, and often results in raises, promotions, and a better career.

For organizations, certifications identify the credentials that can be used to hire the right employee. Having certified employees also increases sales for the organization by proving to prospective clients that the organization has the skills to support its claims.

Back to Top

What is Included

» Instructor-led Training -- Learn from an expert Microsoft Certified Trainer (MCT). Our expert instructors are themselves certified in the technologies they teach and have years of experience in the real world as well as in teaching. A large majority of our instructors are part-time consultants and provide solutions to a wide variety of companies.

» High Quality Courseware -- Learn using the best course ware -- directly from Microsoft. We use custom MS curriculum for our training and customize it to meet the objectives of this boot camp style course.

» Test Vouchers -- The Boot Camp includes test vouchers (70-433 & 70-432), at no additional cost.

» Certification Attainment Policy (CAP) -- We are confident of the quality of our Boot Camp. Please see our CAP section below for details.

» 7 days of complete-immersion and distraction-free training -- Includes 70 hours of lectures, hands on labs, topic reviews, test preparation and testing.

Back to Top

Do you have the right background for MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Prep Boot Camp?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Target Audience for this boot camp training

This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries.

Back to Top

Award winning, world-class Instructors

Carmille A.
- Highly-skilled in graphics and web software including Adobe CS3, CS4 & CS5 Photoshop, Dreamweaver, Illustrator, InDesign, Captivate, Acrobat and Quark; - Expert in Microsoft Office, including Excel, Word and PowerPoint. Licensed Application Instructor and Microsoft Certified Trainer since 2000. - Over 20 years of experience as Creative Director for multinational corporations such as McCann Erickson, Lintas, and Publicis. Bio: Carmille has been a Licensed Application Instructor and Microsoft Certified Trainer for years. She specializes in web development, business productivity and digital media applications such as SharePoint, Quark and the Adobe Creative Suite as well as numerous programming languages including XML, XHMTL, HTML and CSS. Carmille is passionate about educating and has a unique talent for making complex design and development principals seem "easy" to students from all levels of expertise. She currently teaches Adobe Graphic and Web Designer, Microsoft Office Specialist, SharePoint End User and the acclaimed Website Development Professional courses at NetCom Learning. Her 20+ years of experience as Creative Director for multinational corporations bring a special and innovative approach to her classes at NetCom Learning.
Charles W.
- Expert in Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access as well as Adobe Graphic and Web Designer (InDesign, Acrobat, Photoshop, Illustrator, Dreamweaver and Flash Catalyst)
- Holds an A.A.S in Graphic Design as well as various Awards and Affiliations, including MCT, MCP, MCAS, and Office 2007 Master.
- Senior Lead Trainer for over 10 years.

Bio:

Charles is a Technical Trainer & Instructional Designer for over 10 years. He is a Microsoft Certified Trainer and dedicates himself to Microsoft Office applications such as Excel, Word, PowerPoint, Outlook, Project, Visio, and Access. He is also an Adobe specialist and holds a degree in Graphic Design.

Charles is well known for his high evaluation scores, achieving 8.75 out of 9 on a regular basis, teaching in one-on-one, instructor-led, and web-based environments; one of the reasons for his high evaluation is his expertise in increasing personnel performance by developing and implementing programs constructed from the job task analysis process. Charles currently teaches Adobe Graphic and Web Designer, and Microsoft Office Specialist courses at NetCom Learning.
Emilio G.
- Vastly experienced working within multinational environments and capable of connecting to different audiences - In-depth expertise in the implementation, troubleshooting and documentation of networks and security systems, with strong "hands on" technical knowledge of CISSP, CEH and CHFI. - Master of Science in Electronics Engineering, and holder of several technical certifications. - Highly-skilled in diverse fields ranging from Security, Computer Forensics, Networking, Routing Protocols, Programming, Databases and Applications to name a few. Bio: With over 25 years of technical experience, Emilio brings a dynamic set of skills supported by a Masters Degree in Electronics Engineering and on-the-field experience working in multinational environments. He also holds more than 12 Cisco, CompTIA, and Microsoft certifications. Although he is well versed and thorough in multiple technological fields, his technical forte lies in the security domain, specifically CISSP, CEH and CHFI. Emilio's skills have evolved over time, studying closely and constantly staying well informed of the growing cyber threats. These are just some of the few reasons why Emilio brings to his classes more than just what's in the books.
Enayat M.
- Bachelors Degree in Mathematics and holder of several Cisco, CompTIA and Microsoft certifications. - Experienced instructor working in the field since 1999 and Subject Matter Expert at NetCom Learning since 2006. - Worked as Technical Support at Solomon Smith Barney/Citibank. Bio: Enayat Meer has a Bachelors Degree in Mathematics and holds numerous certifications such as A+, Network+, Security+, CCNA, MCT, and MCTS to name a few. He is an experienced trainer, and has served as an A+, NT4.0, Window 2000 and Windows 2003 instructor in a variety of New York schools since 1999. Since that time, he has also provided technical support at Solomon Smith Barney/Citibank in its private banking and global assets management group. Enayat has trained over 800 students at NetCom Learning. He has been a Subject Matter Expert at NetCom Learning since 2006 and his hands-on project expertise is an invaluable addition to NetCom Learning's classroom instruction, helping to bring theoretical topics to life.

Back to Top

Recent Client Testimonials & Reviews

Aug 10 2017
The instructor has excellent knowledge on the subject.

- Surafeal K.

Course(s) Taken

» MCSA: Windows Server 2016 Combo

Jul 21 2017
Great instructor. Great Experience.

- Ronald G.

Course(s) Taken

» MCSE: Mobility 2016 combo

Jul 12 2017
The instructor is very responsive and creative.

- Brian G.

Course(s) Taken

» DevOps Using Visual Studio TFS 2015

Jun 23 2017
The instructor was well prepared and very friendly.

- Syed Z.

Course(s) Taken

» MCSA: Windows Server 2012 (R2 Update) Combo

Jun 23 2017
The instructor has great knowledge and made an excellent class environment.

- Deiguel V.

Course(s) Taken

» 20762: Developing SQL Databases SQL Server 2016

  More testimonials »  

Back to Top

Benefit of taking this boot camp training at NetCom Learning

Our customers come first. Awards come second, naturally.

As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2013 Learning Partner finalist and 2007 Worldwide Learning Solutions Partner of the Year out of more than 1400 training companies globally.

In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience! See our list of awards.

Why choose Microsoft - Technical Training at NetCom Learning?

NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft training content. NetCom was honored by Microsoft as the 2007 Worldwide Partner of the Year for Learning Solutions. Selected as the Number One CPLS from over 1400 worldwide CPLSs, Microsoft recognized our commitment and ability to deliver high-quality learning services using a consultative engagement model.

Microsoft Certified Partner for Learning Solutions Value Proposition:

Microsoft Certified Partner for Learning Solutions Non-authorized Training Center
Only MCT (Microsoft Certified Trainers) are authorized to teach the class Non MCT can teach the course
Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training Do not have access to official courseware
Partners adhere to stringent Microsoft designated lab requirements Computer and lab equipment may not be up to requirements of course
Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the courses Not authorized to issue Certificate of Completion
Software Assurance Vouchers can only be redeemed at a CPLS Cannot redeem Software Assurance Vouchers from Microsoft
Overall, a better quality training experience Substandard training experience

Some important links:

» Certifications
» Learning Plans
» PDF Course Catalog
» FREE Webinars
» Student Loans as low as $25 per month
» Why NetCom?

NetCom Learning provides Authorized Training

NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

See our comprehensive list of partner authorizations.

Back to Top

Next Step, how do I attend the MCTS: SQL Server 2008 R2, Implementation, Maintenance and Database Development - Prep Boot Camp?

Enrollment Options

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Still have questions about boot camp training?

For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp Frequently Asked Questions (FAQ) section.

Back to Top

Ways to contact us

Back to Top