Microsoft MCSA: SQL Server 2012 - Only 9 Days
Seven reasons why you should sit your MCSA SQL course with Firebrand Training
- 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 won the Institute of IT Training’s "Training Company of the Year" a record three times. 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?
Start |
Finish |
Status |
Location |
Book now |
|---|---|---|---|---|
|
|
|
Finished |
- |
|
|
|
|
Open |
Nationwide |
|
|
|
|
Open |
Nationwide |
|
|
|
|
Open |
Nationwide |
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)
"Super intense but really worth while.
So please I have sat this with Firebrand, its been a great experiance and the knowledge will be invaluable.
Thanks"
Anthony Bowman. - Microsoft Dynamics CRM 2011 (8 days) (19/5/2013 to 26/5/2013)
"Richard was a fantastic trainer that just helped things click"
K.S. - Microsoft Dynamics CRM 2011 (8 days) (19/5/2013 to 26/5/2013)
"Long hours but the instructors are incredibly knowledgeable and get the course material over very well"
R.J. - Microsoft MCSE: Messaging (Exchange 2013) (6 days) (13/5/2013 to 18/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 080 80 800 888
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 080 80 800 888
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 080 80 800 888
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 080 80 800 888
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 080 80 800 888
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 080 80 800 888
For further information about Firebrand Training contact us on 080 80 800 888 or info@firebrandtraining.co.uk
Copyright 2001 - 2013. Firebrand Training is a registered trademark. All other names and terms are trademarks or registered trademarks of their respective companies.
PRINCE2®, ITIL® and MSP® are Registered Trade Marks of the Cabinet Office.
CAPM® and PMP® are registered marks of the Project Management Institute, Inc.