course-premium

Course not currently available

MCSA: SQL Server 2012 Data Platform

4.5
5 reviews
  • Awesome training services, I had a great learning experience and I would recommend the same to others, Excellent course and trainers were simply amazing and all my expectations were met from this cousre. Thanks for everything.
    |
  • The course was so informative and useful. I have enjoyed there a lot. Eagerly waiting for my new skills to use in the future. The tutor was so knowledgeable and patient.
    |
  • Training Sqaure is an amazing place to get trained, I recently finished my MCSA SQL SERVER training, After training I would 100% suggest this place for aspirants. Saif Siddiqui was an amazing trainer and he made SQL like a breeze. All the staff was amazing and I learned a lot from them. The company is really wonderful and I had an amazing time overall, thanks!
    |

Course

In City Of London ()

Save 10%
£ 1,305 VAT inc.

Maximise your chances of becoming more employable and more marketable in the current competitive IT job market!

  • Type

    Course

  • Level

    Intermediate

  • Duration

    4 Weeks

Get trained in 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, thanks to this MCSA: SQL Server 2012 Data Platform Course imparted by Training Square.

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.

Are you interested in this course? If so, you should contact Training Square through Emagister.co.uk right now! The opportunities are on the palm of your hand.

About this course

Novice/Mediocre/Expert.

Computer Illiterate.

Diploma/Corporate Training/Hands-On Practical Training/Exam Preparation.

Expert, Industry Experienced and Certified Trainers.
State of the Art Facilities.
Maximum 5-6 Delegates Per Class. Quality that matters.
100% Practical Hands-on Training, Classroom Based and Instructor Led.
Flexible Starting Dates: Weekdays, Weekends and Evenings
Location: Central London

Our Course Advicer will contact him/her and explain further about the Course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.5
excellent
  • Awesome training services, I had a great learning experience and I would recommend the same to others, Excellent course and trainers were simply amazing and all my expectations were met from this cousre. Thanks for everything.
    |
  • The course was so informative and useful. I have enjoyed there a lot. Eagerly waiting for my new skills to use in the future. The tutor was so knowledgeable and patient.
    |
  • Training Sqaure is an amazing place to get trained, I recently finished my MCSA SQL SERVER training, After training I would 100% suggest this place for aspirants. Saif Siddiqui was an amazing trainer and he made SQL like a breeze. All the staff was amazing and I learned a lot from them. The company is really wonderful and I had an amazing time overall, thanks!
    |
100%
4.5
excellent

Course rating

Recommended

Centre rating

Amelia Smith

5.0
23/04/2019
About the course: Awesome training services, I had a great learning experience and I would recommend the same to others, Excellent course and trainers were simply amazing and all my expectations were met from this cousre. Thanks for everything.
Would you recommend this course?: Yes

Leila

4.0
22/04/2019
About the course: The course was so informative and useful. I have enjoyed there a lot. Eagerly waiting for my new skills to use in the future. The tutor was so knowledgeable and patient.
Would you recommend this course?: Yes

Edwin Jackson

4.0
20/04/2019
About the course: Training Sqaure is an amazing place to get trained, I recently finished my MCSA SQL SERVER training, After training I would 100% suggest this place for aspirants. Saif Siddiqui was an amazing trainer and he made SQL like a breeze. All the staff was amazing and I learned a lot from them. The company is really wonderful and I had an amazing time overall, thanks!
Would you recommend this course?: Yes

Kate

5.0
18/02/2018
What I would highlight: Good examples and explanations of topics, teaches at good pace and easy to follow.
What could be improved: .
Would you recommend this course?: Yes

Alice

4.5
24/04/2017
What I would highlight: I've attended MCSE: SQL Server 2012 course at Training Square lately and found extremely talented trainers with consistent delivery of classes. Excellent Instructors and Great Service!
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

  • Monitoring
  • Access
  • Transactions
  • Market
  • Audit
  • Data warehousing
  • Server
  • Database
  • SQL
  • Database training
  • MCSA training
  • MCSA
  • Quality
  • Warehousing
  • Planning
  • Quality Training

Teachers and trainers (1)

Teaching Staff

Teaching Staff

Teacher

Course programme

MCSA SQL Exam: Querying Microsoft SQL Server 2012 70-461

Microsoft 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
  • T-SQL Scripts, Sets, Predicate Logic
  • Logical Order of Operations in SELECT statements
  • SELECT Statements, filter data, sort data using ORDER BY
SELECT Queries
  • SELECT statement, focusing on queries against a single table.
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • CASE Expressions, DISTINCT clause
Querying Multiple Tables
  • Understanding Joins, Inner Joins, Outer Joins, Cross Joins, Self Joins,
  • Multiple-Table Inner Join, self-joins and cross joins 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
  • Writing Queries with Built-In Functions, Conversion Functions
  • Using Logical Functions, Functions to Work with NULL
  • Using Aggregate Functions, GROUP BY Clause,
  • Filtering Groups with HAVING
Using Subqueries and Table Expressions
  • Correlated Subqueries, Self-Contained Subqueries
  • Using Derived Tables, Common Table Expressions
  • Using Views, Inline Table-Valued Functions
Using Set Operators
  • Using EXCEPT and INTERSECT, Set Operators
  • UNION set operators and UNION ALL multi-set operators
  • CROSS APPLY and OUTER APPLY operators
  • EXCEPT and INTERSECT operators
Pivoting and Grouping Sets
  • PIVOT and UNPIVOT, GROUPING SETS subclause
Querying SQL Server Metadata
  • Querying System Catalog Views and Functions
  • Executing System Stored Procedures
  • Querying Dynamic Management Objects
  • Querying System Catalog Views
  • Querying System Functions
  • Querying System Dynamic Management Views
Executing Stored Procedures
  • Passing Parameters to Stored Procedures, Dynamic SQL
  • Pass parameters to stored procedures
  • Execute system stored procedures
Programming with T-SQL
  • Controlling Program Flow and Elements
  • Variables and Delimiting Batches, Synonyms, Error Handling, TRY / CATCH Blocks, THROW
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-462

MS SQL Server 2012 and its Toolset
  • SQL Server Platform, Server Tools, SQL Service Services, Component Installation
  • SQL Server New Instance, Name Pipes Protocol, Aias
  • Ensuring SQL Browser is Disabled and Configure a Fixed TCP/IP Port
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
  • MS SQL Server Databases Data Files, Log files
  • Working with Files and Filegroups
  • Moving Database Files, tempdb configuration, RateTracking datbase
  • Adjust tempdb configuration
  • Create the RateTracking database
  • Attach the OldProspects database
  • Add multiple files to tempdb
  • Backup Strategies, SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy, Recovery Models
  • Plan a backup strategy, Configure Reovery Models
  • Critical concepts surrounding backup strategies.
  • Transaction logging capabilities within the SQL Server database engine.
  • .
Backup of SQL Server 2012 Databases
  • Backing up Databases and Transaction Logs, Managing Database Backups
  • Working with Backup Options, Investigate backup compression
  • Differential, Copy-only, Partial backup
Restoring SQL Server 2012 Databases
  • Restoring Databases, Restore Process, Point-in-time recovery
  • Restoring System Databases and Individual Files
  • Restore strategy, STANDBY mode
Importing and Exporting Data
  • Importing & Exporting Table Data, Inserting Data in Bulk
  • Import the Excel spreadsheet, CSV File
Authenticaton and Authorizing Users
  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers, Create and Manage Logins, Database Users vs OS Users
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
  • Automating SQL Server Management
  • SQL Server Agent, Agent Jobs
  • Troubleshoot a Failing Job
  • SQL Server Agent Security, Configuring Credentials
Monitoring SQL Server 2012 with Alerts and Notifications
  • Configuration of Database Mail, SQL Server Errors
  • Monitoring SQL Server Errors, Alerts and Notifications
  • Configuring Operators, Alerts and Notifications
Performing Ongoing Database Maintenance
  • Ensuring Database Integrity, Maintaining Indexes
  • Check database integrity using DBCC CHECKDB
  • Correct index fragmentation
  • Create a database maintenance plan
  • Investigate table lock performance
Tracing Access to SQL Server 2012
  • Capturing Activity using SQL Server Profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Configure SQL Trace
Monitoring SQL Server 2012
  • Monitoring Activity, Capturing and Managing Performance Data
  • Configure Management Data Warehouse
  • Configure Instances for Data Collection
  • Work with Data Collector Reports
Managing Multiple Servers
  • Working with Multiple Servers, Virtualizing, Data-Tier Applications,
Implementing a Data Warehouse with Microsoft SQL Server 2012 70-463

MS SQL 2012 Data Warehousing
  • Data Warehousing, Data Warehouse Solution, ETL solution
  • Planning and Building a Data Warehouse
  • Data Warehouse Reference Architectures and Appliances
Designing and Implementing a Data Warehouse
  • Logical Design for a Data Warehouse, Physical Design for a Data Warehouse
  • Implementing a Star Schema, Snowflake Schema and Time Dimension Table
Creating an ETL Solution with SSIS and SSIS Package
  • ETL with SSIS, Source Data, Data, Flow
  • Control Flow, Creating Dynamic Packages
  • Using Containers, Managing Consistency
  • Using Variables and Parameters, Containers, Transactions, Checkpoints
Troubleshooting SSIS Packages
  • Debugging an SSIS Package, Logging, Errors, Event Handler
Implementing an Incremental ETL Process
  • Incremental ETL, Extracting Modified Data
  • Loading Modified Data, Using a DateTime Column to Incrementally Extract Data
  • Using a Change Data Capture, Using Change Tracking
  • Using a Lookup Transformation to Insert Dimension Data
  • Using a MERGE Statement to Load Fact Data
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
  • Data Quality, Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data
  • Creating a Matching Policy, DQS Project to Match Data
Using Master Data Services
  • Implement a Master Data Services
  • Using the Master Data Services Add-in for Excel
  • Enforcing Business Rules
Deploying and Configuring SSIS Packages
  • Overview of SSIS Deployment
  • Planning SSIS Package Execution, Create a SSIS Catalog
  • SSIS Solution
  • Scheduling SSIS Packages with SQL Server Agent
Consuming Data in a Data Warehouse
  • Business Intelligence, Reporting, Data Analysis, PowerPivot

Additional information

Pay all at once at get flat £100.00 off the course fee.


Discounted Price

£1350.00 (Actual Price £1450.00)


Or 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 


Duration

4 Weeks or Fast Track 4 Days

MCSA: SQL Server 2012 Data Platform

£ 1,305 VAT inc.