MCSA SQL Server 2012/2014 (Official Exams Included + Free MTA Course)

SQL training to get you qualified at career level. Ideal for pushing in to a new career and you need some paper to prove competence, or even for getting a promotion! Even better? We're an Official Microsoft Learning Partner.

We ensure that you receive a high quality learning experience through us!

If you're looking at this course listing, you're probably already informed to a point - why not enquire about it and ask our course advisors exactly what you need to know? They are there to help you out with anything you need!

About Robust IT

Since 2011 Robust IT has delivered industry leading IT and Project Management training to more than 80,000 students. Founded by our Directors Darren Bilmen and Rizwan Qayyum, at the time both highly respected Microsoft Certified Trainers and with a mutual frustration with the training providers they worked for. Darren and Rizwan shared the same belief that it is not simply about helping students gain a qualification but also ensuring they learn the practical skills to apply their knowledge and also to provide a genuine career path. Robust IT was founded with the mission statement to offer a route into IT for everyone - regardless of background, experience or financial situation. If you want to further your IT career or start one from scratch, Robust IT can help. Here is why Robust IT standout as the IT training provider of choice:

Official vendor certification. We don't do Robust IT certificates of achievement because to be blunt they wouldn't be worth the paper they were printed on! Our courses build to the official examinations where you will gain only the vendor certification. Your certifications will be globally recognised and with vendors such as Microsoft, CompTIA, CISCO and the EC-Council.

Credentials. We proudly boast several key partnerships that we feel recognise us as an industry leader. We are Microsoft Gold Partner and are a recognised supplier by GCHQ. We work closely with the Ministry of Defence as the only training provider permitted to deliver Cyber Security training to leaving members of the armed forces. Our student success rates are as high as 100% and as low as a still superb 94% depending on study route.

Able to work to your budget and schedule. We understand that time and money are often in short supply. Our training centres are based in London, Essex, Birmingham and Manchester means our classroom reach is wide. Our best in class online training portal allows us to reach you no matter where you are in the World or when you are able to study. With Robust IT you choose when, where and how you study. Our generous 2 year course access gives you plenty of time to study and achieve. We strive to keep our price point lower than all of our competition. For those of you unable to pay the entire balance of your training up front, we are partnered with 3 fantastic Finance companies and also have our own in house repayment scheme - this means we can break the cost of training down to monthly installments to suit your budget.

Unrivaled support. Our motto is if you want to pass your course, you will and if you want to work in the IT industry, you will. Everything you need to achieve those goals is provided by Robust IT. We have experienced Trainers and a dedicated Customer Service team on standby to provide 1-1 support whenever required. We also provide ongoing career support with the goal of helping you secure a job in the IT industry at the end of your training. Until you have achieved your certifications and have started your career in IT, we do not consider our work done!

Robust IT is the training provider built and operated by highly experienced IT Trainers who are industry experts. We provide unrivaled support and have a proven history of starting careers in IT. Get in touch for a no obligation chat about your goals today.

This course package will start you off at the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. It will also help you people prepare for exams 70-461, 70-462 and 70-463.

What do you get with this package?

• Microsoft instructor videos and recordings
• Anytime access online for 1-year
• Anywhere access to recorded instructor
• Microsoft lab access & support
• 3 Official Microsoft Training Kit e-Books (.PDF)
• Practice exam access for 180 days upon activation (per exam module)
• 3 certification exams

The MCSA (Microsoft Certified Solutions Associate) SQL Server consists of the following 3 exam courses:

70-461: Querying Microsoft SQL Server

• Module 1: Getting Started with SQL Server 2012
• Module 2: Working with T-SQL
• Module 3: Writing SELECT Queries
• Module 4: Working with SQL Data Types
• Module 5: Sorting and Filtering Data
• Module 6: Querying Data from Multiple Tables
• Module 7: Modifying Data
• Module 8: Working with SQL Server Built-in Functions
• Module 9: Programming in T-SQL
• Module 10: Implementing Stored Procedures
• Module 11: Working with Subqueries and Table Expressions
• Module 12: Working with Set Operators, Conditional Operators, and Window Functions
• Module 13: Working with PIVOT, UNPIVOT, and Grouping Sets
• Module 14: Managing Error Handling and Transactions
• Module 15: Querying SQL Server System
• Module 16: Optimizing Query Performance

70-462: Administering Microsoft SQL Server Databases

• Module 1: Identifying the SQL Server Platform
• Module 2: Deploying SQL Server
• Module 3: Configuring SQL Server
• Module 4: Managing Databases in SQL Server 2012
• Module 5: Managing SQL Server Security
• Module 6: Implementing Advanced Security Settings
• Module 7: Applying Encryption and Compression
• Module 8: Working with Indexes and Log Files
• Module 9: Working with Backup and Restore
• Module 10: Implementing High Availability
• Module 11: Optimizing Server Performance
• Module 12: Troubleshooting Issues and Recovering Databases
• Module 13: Performing Advanced Database Management Tasks

70-463: Implementing a Data Warehouse with Microsoft SQL Server

• Module 1: Introduction to Data Warehouse
• Module 2: Creating Dimensions and Changing Granularity of Dimensions
• Module 3: Creating Fact Tables and ColumnStore Indexes
• Module 4: Implementing Data Warehouse in SQL Server 2012
• Module 5: Working with Integration Services
• Module 6: Managing Control Flow
• Module 7: Working with Dynamic Variables
• Module 8: Implementing Data Flow
• Module 9: Managing Data Flow
• Module 10: Managing SSIS Package Execution
• Module 11: Debugging and Troubleshooting
• Module 12: Deploying Packages
• Module 13: Securing Packages and Databases
• Module 14: Working with MDS and Windows

This course package is ideal for anyone with a basic level of IT who are looking to move into or are already working in a SQL Server career.

What's excellent about getting in to SQL is that you won't need any prior knowledge or training at all! The prerequisites below are literally all you need and we will give you these skills prior to starting if you need.

• Working knowledge of relational databases.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.

Earning an MCSA: SQL Server 2012/2014 certification will qualify you for:

• SQL Developer
• SQL Analyst
• Business Analyst

In these roles, you could earn an average of £55,000 per annum (source:itjobswatch, 2016, UK)