MCSA - SQL Server 2012 Data Platform

Training Square is the UK’s only digital media learning and development provider. we are a MICROSOFT Authorized Training Center with Industry Certified Expert Trainers.

MCSA SQL Server 2012 Data Platform Training Include's: Classroom-based, Tutor Led, hands-on training giving you real-life experience, Lab Exercises, Project work, Unlimited Lab Access, Books, Materials, Course Completion Certificate, Free Re-training, and free refreshment.

Training Options: (Flexible Time & Start Dates)

1. Fast Track
2. Weekend Track

Detail Syllabus:

MCSA: SQL Server 2012 Data PlatformMCSA SQL Exam: Querying Microsoft SQL Server 2012 70-461Microsoft SQL Server 2012 and Tools

• Overview Microsoft SQL Server 2012
• MS SQL Server Management Studio
• Creating and Managing T-SQL scripts
• Microsoft SQL Server 2012 architecture

SQL Azure

• Overview of SQL Azure
• Features of SQL Azure.
• Provision a SQL Azure server and configure its security.

T-SQL Querying

• (This Topic covers many sub-topics)

SELECT Queries

• (This Topic covers many sub-topics)

Querying Multiple Tables

• Understanding Joins, Inner Joins, Outer Joins, Cross Joins, Self Joins,
• Multiple-Table Inner Join, self-joins and cross join queries

Sorting and Filtering Data

• Sorting Data, WHERE Clause, TOP, and OFFSET-FETCH, ORDER BY

Working with SQL Server 2012 Data Types

• SQL Server 2012 Data Types, Character Data, Character Functions

Using Built-In Functions, Grouping and Aggregating Data

• (This Topic covers many sub-topics)

Using Subqueries and Table Expressions

• (This Topic covers many sub-topics)

Using Set Operators

• (This Topic covers many sub-topics)

Pivoting and Grouping Sets

• PIVOT and UNPIVOT, GROUPING SETS subclause

Querying SQL Server Metadata

• (This Topic covers many sub-topics)

Executing Stored Procedures

• (This Topic covers many sub-topics)

Programming with T-SQL

• (This Topic covers many sub-topics)

Implementing Transactions

• Transactions and the Database Engine, Controlling Transactions, BEGIN, COMMIT, and ROLLBACK
• Adding error handling to a CATCH block

Improving Query Performance

• Factors in Query Performance, Execution Plans, role of indexes

MCSA SQL Exam: Administering Microsoft SQL Server 2012 Databases 70-462MS SQL Server 2012 and its Toolset

• (This Topic covers many sub-topics)

Preparing Systems for SQL Server 2012

• SQL Server Architecture, Resource Requirement,
• Test Server, Memory Configuration

Installing and Configuring SQL Server 2012

• Installing SQL Server, Upgrading and Automating Installation
• Install the SQL Server instance, Configure Server Memory

Database, Datafiles, and SQL Server 2012 Recovery Models

• (This Topic covers many sub-topics)
  .

Backup of SQL Server 2012 Databases

• (This Topic covers many sub-topics)

Restoring SQL Server 2012 Databases

• (This Topic covers many sub-topics)

Importing and Exporting Data

• Importing & Exporting Table Data, Inserting Data in Bulk
• Import the Excel spreadsheet, CSV File

Authentication and Authorizing Users

• (This Topic covers many sub-topics)

Server and Database Roles

• Server Roles, Fixed Database Roles, User-defined Database Roles, Check Role Assignments

Authorizing Users to Access Resources

• User Access to Objects, Execute Code, Permission Schema Level

Auditing SQL Server Environments

• Auditing Data Access in SQL, SQL Server Audit
• Audit configuration and create audit

Automating SQL Server 2012 Management

• (This Topic covers many sub-topics)

Monitoring SQL Server 2012 with Alerts and Notifications

• (This Topic covers many sub-topics)

Performing Ongoing Database Maintenance

• (This Topic covers many sub-topics)

Tracing Access to SQL Server 2012

• (This Topic covers many sub-topics)

Monitoring SQL Server 2012

• (This Topic covers many sub-topics)

Managing Multiple Servers

• Working with Multiple Servers, Virtualizing, Data-Tier Applications,

Implementing a Data Warehouse with Microsoft SQL Server 2012 70-463MS SQL 2012 Data Warehousing

• (This Topic covers many sub-topics)

Designing and Implementing a Data Warehouse

• (This Topic covers many sub-topics)

Creating an ETL Solution with SSIS and SSIS Package

• (This Topic covers many sub-topics)

Troubleshooting SSIS Packages

• Debugging an SSIS Package, Logging, Errors, Event Handler

Implementing an Incremental ETL Process

• (This Topic covers many sub-topics)

Cloud Data into a Data Warehouse

• Cloud Data Sources, SQL Server Database
• The Windows Azure Marketplace, SQL Azure Database

Enforcing Data Quality and Deduplicating Data

• (This Topic covers many sub-topics)

Using Master Data Services

• (This Topic covers many sub-topics)

Deploying and Configuring SSIS Packages

• (This Topic covers many sub-topics)

Consuming Data in a Data Warehouse

• Business Intelligence, Reporting, Data Analysis, PowerPivot

Get trained by Microsoft Certified Solutions Associate (MCSA) Certification - SQL Server 2012 and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses.

MCSA SQL Server 2012 will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSA SQL 2012 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.

Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2012 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market.

SQL Server 2012 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2012 also provides higher productivity for DBAs, System Admins, and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large-scale data warehousing capabilities, make SQL Server 2012 stands out in the market.

-----------------------------------------------------------------------------------

Finance Available:

Choose from one of the following Finance Options @ 0% interest:

• 3 months - £145 Upfront and monthly payments of £435.00
• 6 months - £145 Upfront and monthly payments of £217.00
• 12 months - £145 Upfront and monthly payments of £108.00

----------------------------------------------------------------------------------

People aspiring for a career in Database

Whether you are a novice in database technology or a basic user, we have a well-structured classroom-based, hands-on, tutor-led training on SQL courses in London, delivered by our expert, certified and industry experienced trainers.

We would like to warmly welcome you to our SQL server 2012 course where you would be well equipped with SQL Server industrial skills and eventually be fully prepared for MCSA SQL 2012 Certification.

Basic knowledge in Database / Web Design

Plan a career in a technical Database field as SQL Server Database Administrator (DBA), SQL Server Developer, SQL Server Business Intelligence (BI) Developer.

Enhance your skills by joining our Career packages.

Professional Package > £4200 Save £550 [Package Includes: MCSA SQL Server + Oracle 11g OCP]

* Call us to find out more about career packages.

Join us Now 100% satisfaction guarantee.