Questions? Feedback? powered by Olark live chat software

MCSA: SQL Server (2012/2014) Prep Boot Camp

About the MCSA: SQL Server (2012/2014) Prep Boot Camp

Duration: 9 days (90 hours)

Next Class Dates

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

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

20461: Querying Microsoft SQL Server 2014 Boot Camp (3 days)   More on this course...

arrow Course Objectives

  • » Write SELECT queries
  • » Query multiple tables
  • » Sort and filter data
  • » Describe the use of data types in SQL Server
  • » Modify data using Transact-SQL
  • » Use built-in functions
  • » Group and aggregate data
  • » Use subqueries
  • » Use table expressions
  • » Use set operators
  • » Use window ranking, offset and aggregate functions
  • » Implement pivoting and grouping sets
  • » Execute stored procedures
  • » Program with T-SQL
  • » Implement error handling
  • » Implement transactions

Back to Top

arrow Course Outline

  • Module 1: Introduction to Microsoft SQL Server 2014
    1. The Basic Architecture of SQL Server
    2. SQL Server Editions and Versions
    3. Getting Started with SQL Server Management Studio
    4. Lab : Working with SQL Server 2014 Tools
  • Module 2: Introduction to T-SQL Querying
    1. Introducing T-SQL
    2. Understanding Sets
    3. Understanding Predicate Logic
    4. Understanding the Logical Order of Operations in SELECT statements
    5. Lab : Introduction to Transact-SQL Querying
  • Module 3: Writing SELECT Queries
    1. Writing Simple SELECT Statements
    2. Eliminating Duplicates with DISTINCT
    3. Using Column and Table Aliases
    4. Writing Simple CASE Expressions
    5. Lab : Writing Basic SELECT Statements
  • Module 4: Querying Multiple Tables
    1. Understanding Joins
    2. Querying with Inner Joins
    3. Querying with Outer Joins
    4. Querying with Cross Joins and Self Joins
    5. Lab : Querying Multiple Tables
  • Module 5: Sorting and Filtering Data
    1. Sorting Data
    2. Filtering Data with a WHERE Clause
    3. Filtering with the TOP and OFFSET-FETCH Options
    4. Working with Unknown and Missing Values
    5. Lab : Sorting and Filtering Data
  • Module 6: Working with SQL Server 2014 Data Types
    1. Introducing SQL Server 2014 Data Types
    2. Working with Character Data
    3. Working with Date and Time Data
    4. Lab : Working with SQL Server 2014 Data Types
  • Module 7: Using DML to Modify Data
    1. Inserting Data
    2. Modifying and Deleting Data
    3. Lab : Using DML to Modify Data
  • Module 8: Using Built-In Functions
    1. Writing Queries with Built-In Functions
    2. Using Conversion Functions
    3. Using Logical Functions
    4. Using Functions to Work with NULL
    5. Lab : Using Built-In Functions
  • Module 9: Grouping and Aggregating Data
    1. Using Aggregate Functions
    2. Using the GROUP BY Clause
    3. Filtering Groups with HAVING
    4. Lab : Grouping and Aggregating Data
  • Module 10: Using Subqueries
    1. Writing Self-Contained Subqueries
    2. Writing Correlated Subqueries
    3. Using the EXISTS Predicate with Subqueries
    4. Lab : Using Subqueries
  • Module 11: Using Table Expressions
    1. Using Derived Tables
    2. Using Common Table Expressions
    3. Using Views
    4. Using Inline Table-Valued Functions
    5. Lab : Using Table Expressions
  • Module 12: Using Set Operators
    1. Writing Queries with the UNION Operator
    2. Using EXCEPT and INTERSECT
    3. Using APPLY
    4. Lab : Using Set Operators
  • Module 13: Using Window Ranking, Offset, and Aggregate Functions
    1. Creating Windows with OVER
    2. Exploring Window Functions
    3. Lab : Using Window Ranking, Offset and Aggregate Functions
  • Module 14: Pivoting and Grouping Sets
    1. Writing Queries with PIVOT and UNPIVOT
    2. Working with Grouping Sets
    3. Lab : Pivoting and Grouping Sets
  • Module 15: Executing Stored Procedures
    1. Querying Data with Stored Procedures
    2. Passing Parameters to Stored Procedures
    3. Creating Simple Stored Procedures
    4. Working with Dynamic SQL
    5. Lab : Executing Stored Procedures
  • Module 16: Programming with T-SQL
    1. T-SQL Programming Elements
    2. Controlling Program Flow
    3. Lab : Programming with T-SQL
  • Module 17: Implementing Error Handling
    1. Using TRY / CATCH Blocks
    2. Working with Error Information
    3. Lab : Implementing Error Handling
  • Module 18: Implementing Transactions
    1. Transactions and the Database Engine
    2. Controlling Transactions
    3. Isolation Levels
    4. Lab : Implementing Transactions

Back to Top

20462: Administering Microsoft SQL Server 2014 Databases Boot Camp (3 days)   More on this course...

arrow Course Objectives

  • » Describe core database administration tasks and tools.
  • » Install and configure SQL Server 2014.
  • » Configure SQL Server databases and storage.
  • » Plan and implement a backup strategy.
  • » Restore databases from backups.
  • » Import and export data.
  • » Monitor SQL Server.
  • » Trace SQL Server activity.
  • » Manage SQL Server security.
  • » Audit data access and encrypt data.
  • » Perform ongoing database maintenance.
  • » Automate SQL Server maintenance with SQL Server Agent Jobs.
  • » Configure Database Mail, alerts and notifications.

Back to Top

arrow Course Outline

  • Module 1: Introduction to SQL Server 2014 Database Administration
    1. Database Administration Overview
    2. Introduction to the SQL Server Platform
    3. Database Management Tools and Techniques
    4. Lab : Using SQL Server Administrative Tools
    5. Using SQL Server Management Studio
  • Module 2: Installing and Configuring SQL Server 2014
    1. Planning SQL Server Installation
    2. Installing SQL Server 2014
    3. Post-Installation Configuration
    4. Lab : Installing SQL Server 2014
  • Module 3: Working with Databases and Storage
    1. Introduction to Data Storage with SQL Server
    2. Managing Storage for System Databases
    3. Managing Storage for User Databases
    4. Moving Database Files
    5. Configuring the Buffer Pool Extension
    6. Lab : Managing Database Storage
  • Module 4: Planning and Implementing a Backup Strategy
    1. Understanding SQL Server Recovery Models
    2. Planning a Backup Strategy
    3. Backing up Databases and Transaction Logs
    4. Using Backup Options
    5. Ensuring Backup Reliability
    6. Lab : Backing Up SQL Server Databases
  • Module 5: Restoring SQL Server 2014 Databases
    1. Understanding the Restore Process
    2. Restoring Databases
    3. Advanced Restore Scenarios
    4. Working with Point-in-Time Recovery
    5. Lab : Restoring SQL Server Databases
  • Module 6: Importing and Exporting Data
    1. Introduction to Transferring Data
    2. Importing and Exporting Table Data
    3. Copying or Moving a Database
    4. Lab : Importing and Exporting Data
  • Module 7: Monitoring SQL Server 2014
    1. Introduction to Monitoring SQL Server
    2. Dynamic Management Views and Functions
    3. Performance Monitor
    4. Lab : Monitoring SQL Server 2014
  • Module 8: Tracing SQL Server Activity
    1. Tracing SQL Server Workload Activity
    2. Using Traces
    3. Lab : Tracing SQL Server Workload Activity
  • Module 9: Managing SQL Server Security
    1. Introduction to SQL Server Security
    2. Managing Server-Level Security
    3. Managing Database-Level Principals
    4. Managing Database Permissions
    5. Lab : Managing SQL Server Security
  • Module 10: Auditing Data Access and Encrypting Data
    1. Auditing Data Access in SQL Server
    2. Implementing SQL Server Audit
    3. Encrypting Databases
    4. Lab : Auditing Data Access and Encrypting Data
  • Module 11: Performing Ongoing Database Maintenance
    1. Ensuring Database Integrity
    2. Maintaining Indexes
    3. Automating Routine Database Maintenance
    4. Lab : Performing Ongoing Database Maintenance
  • Module 12: Automating SQL Server 2014 Management
    1. Automating SQL Server Management
    2. Implementing SQL Server Agent Jobs
    3. Managing SQL Server Agent Jobs
    4. Managing Job Step Security Contexts
    5. Managing Jobs on Multiple Servers
    6. Lab : Automating SQL Server Management
  • Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications
    1. Monitoring SQL Server Errors
    2. Configuring Database Mail
    3. Configuring Operators, Alerts, and Notifications
    4. Lab : Monitoring SQL Server by Using Alerts and Notifications

Back to Top

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 Boot Camp (3 days)   More on this course...

arrow Course Objectives

  • » Describe data warehouse concepts and architecture considerations.
  • » Select an appropriate hardware platform for a data warehouse.
  • » Design and implement a data warehouse.
  • » Implement Data Flow in an SSIS Package.
  • » Implement Control Flow in an SSIS Package.
  • » Debug and Troubleshoot SSIS packages.
  • » Implement an ETL solution that supports incremental data extraction.
  • » Implement an ETL solution that supports incremental data loading.
  • » Implement data cleansing by using Microsoft Data Quality Services.
  • » Implement Master Data Services to enforce data integrity.
  • » Extend SSIS with custom scripts and components.
  • » Deploy and Configure SSIS packages.
  • » Describe how BI solutions can consume data from the data warehouse.

Back to Top

arrow Course Outline

  • Module 1: Introduction to Data Warehousing
    1. Overview of Data Warehousing
    2. Considerations for a Data Warehouse Solution
    3. Lab : Exploring a Data Warehousing Solution
  • Module 2: Planning Data Warehouse Infrastructure
    1. Considerations for Data Warehouse Infrastructure
    2. Planning Data Warehouse Hardware
    3. Lab : Planning Data Warehouse Infrastructure
  • Module 3: Designing and Implementing a Data Warehouse
    1. Data Warehouse Design Overview
    2. Designing Dimension Tables
    3. Designing Fact Tables
    4. Physical Design for a Data Warehouse
    5. Lab : Implementing a Data Warehouse
  • Module 4: Creating an ETL Solution with SSIS
    1. Introduction to ETL with SSIS
    2. Exploring Data Sources
    3. Implementing Data Flow
    4. Lab : Implementing Data Flow in an SSIS Package
  • Module 5: Implementing Control Flow in an SSIS Package
    1. Introduction to Control Flow
    2. Creating Dynamic Packages
    3. Using Containers
    4. Managing Consistency
    5. Lab : Implementing Control Flow in an SSIS Package
    6. Lab : Using Transactions and Checkpoints
  • Module 6: Debugging and Troubleshooting SSIS Packages
    1. Debugging an SSIS Package
    2. Logging SSIS Package Events
    3. Handling Errors in an SSIS Package
    4. Lab : Debugging and Troubleshooting an SSIS Package
  • Module 7: Implementing a Data Extraction Solution
    1. Planning Data Extraction
    2. Extracting Modified Data
    3. Lab : Extracting Modified Data
  • Module 8: Loading Data into a Data Warehouse
    1. Planning Data Loads
    2. Using SSIS for Incremental Loads
    3. Using Transact-SQL Loading Techniques
    4. Lab : Loading a Data Warehouse
  • Module 9: Enforcing Data Quality
    1. Introduction to Data Quality
    2. Using Data Quality Services to Cleanse Data
    3. Using Data Quality Services to Cleanse Data
    4. Lab : Cleansing Data
  • Module 10: Master Data Services
    1. Introduction to Master Data Services
    2. Implementing a Master Data Services Model
    3. Managing Master Data
    4. Creating a Master Data Hub
    5. Lab : Implementing Master Data Services
  • Module 11: Extending SQL Server Integration Services
    1. Using Scripts in SSIS
    2. Using Custom Components in SSIS
    3. Lab : Using Custom Scripts
  • Module 12: Deploying and Configuring SSIS Packages
    1. Overview of SSIS Deployment
    2. Deploying SSIS Projects
    3. Planning SSIS Package Execution
    4. Lab : Deploying and Configuring SSIS Packages
  • Module 13: Consuming Data in a Data Warehouse
    1. Introduction to Business Intelligence
    2. Enterprise Business Intelligence
    3. Self-Service BI and Big Data
    4. Lab : Using a Data Warehouse

Back to Top

This boot camp training prepares students for the following exam(s):

  • » 70-462: Administering Microsoft SQL Server 2012/2014 Databases
  • » 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Back to Top

Why should you take the MCSA: SQL Server (2012/2014) 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 expert instructors who are themselves certified 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 -- Vendor Authorized course ware. In addition you will get pre-study material when you sign up, so you are well prepared for the course.

» 2 Exam vouchers -- The boot camp includes two exam voucher for Exam 70-462 and Exam 70-462.

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

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

Back to Top

Do you have the right background for MCSA: SQL Server (2012/2014) 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 database professionals who need to create and support a data warehousing solution.

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.

Certification Attainment Policy (CAP)

If you are not able to attain all certifications during the boot camp, you can attend the boot camp again within a period of one year, if it is still being offered and has availability. To attend, simply retain your course materials. You will need to pay for test vouchers and optional travel. If the courseware has changed, you must purchase the latest material. CAP would not apply if the class you want to reattend is for a different certification.

Back to Top

Next Step, how do I attend the MCSA: SQL Server (2012/2014) 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