Questions? Feedback? powered by Olark live chat software

MCSA: SQL Server 2012 Prep Boot Camp

About the MCSA: SQL Server 2012 Prep Boot Camp

Duration: 6 days (60 hours)

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
 

20462: Administering Microsoft SQL Server 2014 Databases

Nov 6, 2017–Nov 10, 2017
 

Back to Top

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

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

arrow Course Objectives

  • » Write SELECT Queries
  • » Query Multiple Tables
  • » Use Built-In Functions
  • » Use Subqueries
  • » Execute Stored Procedures
  • » Use Set Operators
  • » Implement Error Handling
  • » Implementing Transactions
  • » Use Table Expressions
  • » Sort and Filter Data
  • » Use Window Ranking, Offset and Aggregate Functions
  • » Query SQL Server Metadata
  • » Program with T-SQL
  • » Improve Query Performance

Back to Top

arrow Course Outline

  • Module 1: Introduction to Microsoft SQL Server 2012
    1. Describe SQL Server components
    2. Create and save T-SQL scripts in SQL Server Management Studio
    3. Browse the objects in a database
    4. Search T-SQL syntax definitions in Books Online
  • Module 2: Introduction to Transact-SQL Querying
    1. Describe the elements of T-SQL and its role in writing queries
    2. Describe the use of sets in SQL Server
    3. Describe the use of predicate logic in SQL Server
    4. Define the logical order of operations in SELECT statements
  • Module 3: Writing SELECT Queries
    1. Write Simple SELECT statements
    2. Eliminate duplicates using the DISTINCT clause
    3. Use column and table aliases
    4. Write simple CASE expressions
  • Module 4: Querying Multiple Tables
    1. Describe how multiple tables may be queried in a SELECT statement using joins
    2. Write queries which use inner joins
    3. Write queries which use outer joins
    4. Write queries which use self-joins and cross joins
  • Module 5: Sorting and Filtering Data
    1. Filter data with predicates in the WHERE clause
    2. Sort data using ORDER BY
    3. Filter data in the SELECT clause with TOP
    4. Filter data with OFFSET and FETCH
    5. Understand and handle NULLs
  • Module 6: Working with SQL Server Denali Data Types
    1. Describe numeric data types, type precedence and type conversions
    2. Write queries using character data types
    3. Write queries using date and time data types
  • Module 7: Using Built-In Functions
    1. Write queries with built-in scalar functions
    2. Use conversion functions
    3. Use logical functions
    4. Use functions that work with NULL
  • Module 8: Grouping and Aggregating Data
    1. Write queries which summarize data using built-in aggregate functions
    2. Use the GROUP BY clause to arrange rows into groups
    3. Use the HAVING clause to filter out groups based on a search condition
  • Module 9: Using Subqueries
    1. Use self-contained subqueries, correlated subqueries, scalar subqueries, and multi-valued subqueries
    2. Use the IN and EXISTS predicates
  • Module 10: Using Table Expressions
    1. Write queries against views
    2. Use derived tables
    3. Use common table expressions
    4. Use inline table-valued expressions
  • Module 11: Use Set Operators
    1. Describe the difference between a set and a multi-set
    2. Use the UNION and UNION ALL operators
    3. Use CROSS APPLY, OUTER APPLY and APPLY
    4. Use EXCEPT and INTERSECT operators
  • Module 12: Using Window Ranking, Offset and Aggregate Functions
    1. Use window ranking functions ROW_NUMBER, RANK, DENSE_RANK, NTILE
    2. Use offset functions LAG, LEAD, FIRST_VALUE, LAST_VALUE
    3. Use window aggregate functions
    4. Use the basic forms of window partitioning, window ordering and window framing
  • Module 13: Pivoting and Grouping Sets
    1. Use the basic form of PIVOT and UNPIVOT operators
    2. Use the fundamental form of GROUPING SETS clause
  • Module 14: Querying SQL Server Metadata
    1. Write queries against system catalog views and functions
    2. Execute system stored procedures
    3. Identify and query system dynamic management objects
    4. Describe security permissions necessary to query system objects
  • Module 15: Executing Stored Procedures
    1. Invoke existing stored procedures with EXECUTE
    2. Pass input parameters and receive output parameters
    3. Generate dynamic SQL statements
  • Module 16: Programming with T-SQL
    1. Understand where T-SQL programming objects can be used
    2. Declare variables and delimit batches
    3. Use control of flow elements such as IF, WHILE, BEGIN, END, RETURN
    4. Use synonyms
  • Module 17: Implementing Error Handling
    1. Describe the behavior of SQL Server when errors occur in T-SQL code
    2. Use TRY/CATCH blocks to handle error flow
    3. Understand ERROR class functions
  • Module 18: Implementing Transactions
    1. Describe the benefits of using transactions
    2. Control transactions with BEGIN, COMMIT, ROLLBACK
    3. Describe error handling behavior in transactions
  • Module 19: Improving Query Performance
    1. Describe how SQL Server uses indexes to support query execution
    2. Enable the display of execution plans in SQL Server Management Studio
    3. Enable system IO and time information in query results
    4. Describe the differences between accessing data in sets versus via cursors

Back to Top

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

arrow Course Objectives

  • » Plan and install SQL Server.
  • » Describes the system databases, the physical structure of databases and the most common configuration options related to them.
  • » Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
  • » Create SQL Server Backups.
  • » Restore SQL Server databases.
  • » Use the import/export wizards and explain how they relate to SSIS.
  • » Work with SQL Server security models, logins and users.
  • » Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
  • » Work with permissions and the assignment of permissions.
  • » Work with SQL Server Audit.
  • » Work with SQL Server Agent, jobs and job history.
  • » Implement SQL Server agent security, proxy accounts and credentials.
  • » Configure database mail, alerts and notifications.
  • » Create database maintenance plans.
  • » Work with SQL Profiler and SQL Trace stored procedures.
  • » Introduce DMVs and the configuration of data collection.
  • » Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
  • » Troubleshoot SQL Server databases.

Back to Top

arrow Course Outline

  • Module 1: Introduction to SQL Server 2012 and its Toolset
    1. Introduction to the SQL Server Platform
    2. Working with SQL Server Tools
    3. Configuring SQL Server Services
  • Module 2: Preparing Systems for SQL Server 2012
    1. Overview of SQL Server Architecture
    2. Planning Server Resource Requirements
    3. Pre-installation Testing for SQL Server
  • Module 3: Installing and Configuring SQL Server 2012
    1. Preparing to Install SQL Server
    2. Installing SQL Server
    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 2012 Recovery Models
    1. Backup Strategies
    2. Understanding SQL Server Transaction Logging
    3. Planning a SQL Server Backup Strategy
  • Module 6: Backup of SQL Server 2012 Databases
    1. Backing up Databases and Transaction Logs
    2. Managing Database Backups
    3. Working with Backup Options
  • Module 7: Restoring SQL Server 2012 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
    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
    2. Implementing SQL Server Audit
    3. Managing SQL Server Audit
  • Module 13: Automating SQL Server 2012 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 2012 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 2012
    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 2012
    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 2012 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

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

  • » 70-462: Administering Microsoft SQL Server 2012/2014 Databases

Back to Top

Why should you take the MCSA: SQL Server 2012 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-461, 70-462 & 70-463), 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.

Back to Top

Do you have the right background for MCSA: SQL Server 2012 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

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

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 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

Redeem Your Microsoft Software Assurance Training Vouchers

Microsoft Software 
Assurance Training Vouchers

As a Microsoft Gold Learning Solutions Partner, NetCom Learning proudly accepts Microsoft Software Assurance Training Vouchers. You can attend Microsoft training at NetCom Learning for free, by redeeming your Microsoft vouchers.

Call 1-(888)-563-8266 for more information.

Back to Top