Microsoft MCSA: SQL Server 2012 - Only 9 Days

Win free training for life

Get every certification for free. Enter here

Seven reasons why you should sit your MCSA SQL course with Firebrand Training

Get a 50% discount from the Flemish Government. Call to find out how.

You'll be MCSA SQL certified in just 9 days. With us, you’ll be MCSA SQL trained in record time
Our MCSA SQL course is all-inclusive. A one-off fee covers all course materials, exams, accommodation and meals. No hidden extras
Pass MCSA SQL first time or train again for free. This is our guarantee. We're sure you'll pass your MCSA SQL course first time. But if you don’t, come back within a year, and only pay for accommodation and exams. Everything else is free
You’ll learn more MCSA SQL. A day with a traditional training provider generally runs from 9am – 5pm, with a nice long break for lunch. With Firebrand Training you’ll get at least 12 hours/day quality learning time, with your instructor
You’ll learn MCSA SQL faster. Chances are, you’ll have a different learning style to those around you. We combine visual, auditory and tactile styles to deliver the material in a way that ensures you will learn faster and more easily
You’ll be studying MCSA SQL with the best. We have the Q-For quality label, recognising our standards and professionalism in the training market. As well as winning many more awards, we’ve trained and certified 30,000 professionals, and we’re partners with all of the big names in the business
You'll do more than study MCSA SQL courseware. We use practical exercises to make sure you can apply your new knowledge to the work environment. Our instructors use demonstrations and real-world experience to keep the day interesting and engaging

Think you are ready for the course? Take a FREE practice test to assess your knowledge!

When do you want to sit your accelerated course?

Microsoft - MCSA: SQL Server 2012
Start	Finish	Status	Location	Book now
7/4/2013 (Sunday)	15/4/2013 (Monday)	Finished	-
14/10/2013 (Monday)	22/10/2013 (Tuesday)	Open	Nationwide	Book now

We've trained more than 30,000 students in ten years. We asked them all to review our Accelerated Learning. Currently, 95.88% have said Firebrand exceeded their expectations:

"Fantastic environment that enables you to take the certification with rapid-fire preparation."
Sasi Thonangi. - Microsoft MCSA: SQL Server 2012 (9 days) (23/2/2013 to 3/3/2013)

"Very intensive but very rewarding"
Ryan Gillett. - Microsoft MCSA: SQL Server 2012 (9 days) (5/1/2013 to 13/1/2013)

"A tough but hugely rewarding week of my life "
Paul Bailey. - Microsoft MCSA: SQL Server 2012 (9 days) (5/1/2013 to 13/1/2013)

"Getting Nine Days to do fifteen days worth of work is hard going, but if you're prepared to put in the effort then Firebrand do an excellent job of getting you through it a friendly environment"
Krystofer Kujawa. - Microsoft MCSA: SQL Server 2012 (9 days) (5/1/2013 to 13/1/2013)

"It has been a rewarding experience to do training with Firebrand Training. "
Anonymous - Microsoft MCSA: SQL Server 2012 (9 days) (19/11/2012 to 27/11/2012)

"100% focus from instructor and everything prepared for students to have full focus on learning"
Robin Ingmarsson . - Microsoft MCSA: SQL Server 2012 (9 days) (19/11/2012 to 27/11/2012)

"A fast and efficient way of learning"
Paw Mouritzen. - Microsoft MCSA: SQL Server 2012 (9 days) (10/9/2012 to 18/9/2012)

"Great teacher, extremely skilled, great personality. "
Steven Pringels . - Microsoft Dynamics AX 2012 Development - Advanced (4 days) (15/12/2011 to 18/12/2011)

"Excellent facilities. Excellent instructor."
Christopher Hopkins. - Microsoft MCSA: Windows Server 2012 (8 days) (28/4/2013 to 5/5/2013)

"An excellent way to train and sit exams"
L.M. - Microsoft MCSA: Windows Server 2012 (8 days) (28/4/2013 to 5/5/2013)

The Microsoft MCSA: SQL Server 2012 course is your first step towards earning an MCSE: Data Platform or MCSE: Business Intelligence certification.

The course provides you with the knowledge and skills needed to maintain a Microsoft SQL Server 2012 database. You'll be able to use SQL Server 2012 product features and tools to maintain your database.

You'll learn how to:

Create a Data Warehouse with SQL Server 2012
Implement ETL (extract, transform, load) with SQL Server Integration Services
Validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services

Interested? See prices or call +32 (0)2 234 77 05

Other accelerated training providers rely heavily on lecture and independent self-testing and study.

Effective technical instruction must be highly varied and interactive to keep attention levels high, promote camaraderie and teamwork between the students and instructor, and solidify knowledge through hands-on learning.

Firebrand Training provides instruction to meet every learning need:

Intensive group instruction
One-on-one instruction attention
Hands-on labs
Lab partner and group exercises
Question and answer drills
Independent study

This information has been provided as a helpful tool for candidates considering training. Courses that include certification come with a certification guarantee. Pass first time or train again for free (just pay for accommodation and exams on your return). We do not make any guarantees about personal successes or benefits of obtaining certification. Benefits of certification determined through studies do not guarantee any particular personal successes.

Interested? See prices or call +32 (0)2 234 77 05

Querying Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012
Getting Started with SQL Azure
Introducing Transact-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2012 Data Types
Using Built-In Functions
Grouping and Aggregating Data
Subqueries
Table Expressions
Set Operators
Window Ranking, Offset and Aggregate Functions
Pivoting and Grouping Sets
Querying SQL Server Metadata
Executing Stored Procedures
Programming with T-SQL
Error Handling
Implementing Transactions
How to improve Query Performance

Administering Microsoft SQL Server 2012 Databases

Introducing SQL Server 2012 and its Toolset
Preparing Systems for SQL Server 2012
Install and Configure SQL Server 2012
Working with Databases
Understand SQL Server 2012 Recovery Models
Backup of SQL Server 2012 Databases
Restoring SQL Server 2012 Databases
Importing and Exporting Data
Authenticating and Authorising Users
Assigning Server and Database Roles
Authorising Users to Access Resources
Auditing SQL Server Environments
Automating SQL Server 2012 Management
Configure Security for SQL Server Agent
Monitoring SQL Server 2012 with Alerts and Notifications
Performing Ongoing Database Maintenance
Tracing Access to SQL Server 2012
Monitoring SQL Server 2012
Manage Multiple Servers
Troubleshooting Common SQL Server 2012 Administrative Issues

Implementing a Data Warehouse with Microsoft SQL Server 2012

Introducing Data Warehousing
Data Warehouse Hardware
Design and Implement a Data Warehouse
Creating an ETL Solution with SSIS
Implement Control Flow in an SSIS Package
Debug and Troubleshoot SSIS Packages
Implement an Incremental ETL Process
Incorporate Data from the Cloud in a Data Warehouse
Enforce Data Quality
Use Master Data Services
Extend SSIS
Deploy and Configure SSIS Packages
Consume Data in a Data Warehouse

Interested? See prices or call +32 (0)2 234 77 05

Our certification guarantee just got better. In the unlikely event that you fail a Microsoft exam, you can sit it again for free. Act fast, because this offer doesn’t last for long: all exams (including the second shot) need to be taken by 31 May 2013.

You also have the chance to win a 5* weekend away for two or a £500 Amazon voucher.
Contact us for more details

You'll sit the following exams:

Exam 70-461: Querying Microsoft SQL Server 2012
Exam 70-462: Administering Microsoft SQL Server 2012 Databases
Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Interested? See prices or call +32 (0)2 234 77 05

Microsoft Official Curriculum

MOC 10774A: Querying Microsoft SQL Server 2012
MOC 10775A: Administering Microsoft SQL Server 2012 Databases
MOC 10777A: Implementing a Data Warehouse with Microsoft SQL Server 2012

Books provided for free on the course

T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure - ISBN 9780735658141
Training Kit Exam 70-462: Administering Microsoft SQL Server 2012 Databases Book/CD Package - ISBN 82039780735666078
Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 - ISBN 9780735666054
Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 - ISBN 9780735666092

Firebrand Training offers top-quality technical education and certification training in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their studies and certification goals.

Our Certification Programs includes

Intensive Hands-on Training Utilising our (Lecture | Lab | Review)^TM Delivery
Comprehensive Study Materials, Program Courseware and Self-Testing Software
Fully instructor-led program with 24 hour lab access
Examination vouchers *
On site testing **
Accommodation, all meals, unlimited beverages, snacks and tea / coffee***
Transportation to/from designated local railway stations
Examination Passing Policy

Please note

*Examination vouchers are not included for the following courses: PMP, CAPM, CISA, CISM and CISSP CBK Review
**On site testing is not included in our PMP, ISACA, or ITIL Managers and Revision Certifications
***Accommodation not included on the CISSP CBK Review Seminar

Our instructors teach to accommodate every student's learning needs through individualised instruction, hands-on labs, lab partner and group exercises, independent study, self-testing, and question/answer drills.

Firebrand Training has dedicated, well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and lounging rooms. Our students consistently say our facilities are second-to-none.

Examination Passing Policy

Should a student complete a Firebrand Training Program without having successfully passed all vendor examinations, the student may re-attend that program for a period of one year. Students will only be responsible for accommodations and vendor exam fees.

Interested? See prices or call +32 (0)2 234 77 05

In addition to professional experience, you must have:

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Experience with database design
Understanding of virtualisation technology (Classroom labs utilise virtual machines)
Minimum two years’ experience of working with relational databases, including:
- Designing a normalized database
- Creating tables and relationships
- Querying with Transact-SQL
Exposure to basic programming constructs (such as looping and branching)

Being aware of key business priorities such as revenue, profitability, and financial accounting is also recommended.

Interested? See prices or call +32 (0)2 234 77 05