MCSA: SQL Server 2012 Course + Exam
MCSA: SQL Server 2012 Certification
Microsoft SQL Server 2012 is the cutting-edge Microsoft database server offering in the IT world. The MCSA SQL 2012 certification displays the IT professional has a deep understanding of installing and configuring the Microsoft SQL Server 2012 product. We offer high quality, low cost MCSA SQL Server 2012 training in Sydney and Melbourne.
The Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 certification proves the certification holder possesses main SQL Server 2012 skills across diverse areas.
-
Course 20461 (Exam Microsoft 70-461)
In this course, you will learn about Querying Microsoft SQL Server 2012.
Course Outline:
-
Create and alter tables using T-SQL syntax (simple statements)
-
Create and alter views (simple statements)
-
Design views
-
Create and modify constraints (simple statements)
-
Create and alter DML triggers
-
Query data by using SELECT statements
-
Implement sub-queries
-
Implement data types
-
Implement aggregate queries
-
Query and manage XML data
-
Create and alter stored procedures (simple statements)
-
Modify data by using INSERT, UPDATE and DELETE statements
-
Combine datasets
-
Work with functions
-
Optimise queries
-
Manage transactions
-
Evaluate the use of row-based operations vs. set-based operations
-
Implement error handling
-
Course 20462 (Exam Microsoft 70-462)
In this course, you will learn about Administering Microsoft SQL Server Databases.
Course Outline:
-
Plan installation
-
Install SQL Server and related services
-
Implement a migration strategy
-
Configure additional SQL Server components
-
Manage SQL Server Agent
-
Manage and configure databases
-
Configure SQL Server instances
-
Implement an SQL Server clustered instance
-
Manage SQL Server instances
-
Identify and resolve concurrency problems
-
Collect and analyse troubleshooting data
-
Audit SQL Server instances
-
Configure and maintain a backup strategy
-
Restore databases
-
Course 20463 (Exam Microsoft 70-463)
In this course, you will learn about Implementing a Data warehouse with Microsoft SQL Server.
Course Outline:
-
Implement and maintain indexes
-
Import and export data
-
Manage logins and server roles
-
Manage database permissions
-
Manage users and database roles
-
Troubleshoot security
-
Implement AlwaysOn
-
Implement database mirroring
-
Design and implement dimensions
-
Design and implement fact tables
-
Define connection managers
-
Design data flow
-
Implement data flow
-
Manage SSIS package execution
-
Implement script tasks in SSIS
-
Design control flow
-
Implement package logic by using SSIS variables and parameters
-
Implement control flow
-
Implement data load options
-
Implement script components in SSIS
-
Troubleshoot data integration issues
-
Install and maintain SSIS components
-
Implement auditing, logging and event handling
-
Deploy SSIS solutions
-
Configure SSIS security settings
-
Install and maintain data quality services
-
Implement master data management solutions
-
Create a data quality project to clean data
- Updated Training: SQL Server 2012
- More hands-on: trial software included
- Receive a certificate of course attendance
- 3 x Certification exams worth $618 included
- Expert trainers: imparting real world experience
- Small class size: increased instructor interaction
- Authorised test centre: exams taken at our premises
Exposure to Microsoft Server technologies
Candidates can achieve this certification by passing the following exam(s).
- Microsoft 70-461
- Microsoft 70-462
- Microsoft 70-463
The certification exam can be registered and attempted within 3 months of course/module completion at Logitrain training centre on weekdays during normal business hours (excludes public holidays)
- Querying Microsoft SQL Server 2012
- Administering Microsoft SQL Server 2012 Databases
- Implementing a Data Warehouse with Microsoft SQL Server 2012
(Logitrain Course material provided)
- Create database objects
- Work with data
- Modify Data
- Troubleshoot and optimise
- Install and Configure SQL Server
- Maintain instances and databases
- Optimise and troubleshoot
- Manage data
- Implement security
- Implement high availability
- Design and implement a data warehouse
- Extract and transform data
- Load data
- Configure an deploy SSIS solutions
- Build data quality solutions
This course is likely to add to the employment related skills of the participants. The skills developed are likely to be used in the course of being an employee or working in a business.
- Database Developers
- Database Analysts
- Database support staff
- Individuals seeking MCSA certification
- Create and alter tables using T-SQL syntax (simple statements)
- Create and alter views (simple statements)
- Design views
- Create and modify constraints (simple statements)
- Create and alter DML triggers
- Query data by using SELECT statements
- Implement sub-queries
- Implement data types
- Implement aggregate queries
- Query and manage XML data
- Create and alter stored procedures (simple statements)
- Modify data by using INSERT, UPDATE and DELETE statements
- Combine datasets
- Work with functions
- Optimise queries
- Manage transactions
- Evaluate the use of row-based operations vs. set-based operations
- Implement error handling
- Plan installation
- Install SQL Server and related services
- Implement a migration strategy
- Configure additional SQL Server components
- Manage SQL Server Agent
- Manage and configure databases
- Configure SQL Server instances
- Implement an SQL Server clustered instance
- Manage SQL Server instances
- Identify and resolve concurrency problems
- Collect and analyse troubleshooting data
- Audit SQL Server instances
- Configure and maintain a backup strategy
- Restore databases
- Implement and maintain indexes
- Import and export data
- Manage logins and server roles
- Manage database permissions
- Manage users and database roles
- Troubleshoot security
- Implement AlwaysOn
- Implement database mirroring
- Design and implement dimensions
- Design and implement fact tables
- Define connection managers
- Design data flow
- Implement data flow
- Manage SSIS package execution
- Implement script tasks in SSIS
- Design control flow
- Implement package logic by using SSIS variables and parameters
- Implement control flow
- Implement data load options
- Implement script components in SSIS
- Troubleshoot data integration issues
- Install and maintain SSIS components
- Implement auditing, logging and event handling
- Deploy SSIS solutions
- Configure SSIS security settings
- Install and maintain data quality services
- Implement master data management solutions
- Create a data quality project to clean data
Take the certification exam within 3 months of each module completion
Take the official vendor certification exam at the Logitrain training center
Course material in hardcopy is included. Full-time classroom courses include meals
Mock tests included in full-time courses for 3 months from course completion
Our trainers are highly skilled with expertise and extensive hands-on experience
Relax, we will beat competitor’s advertised price. Our course has no extra costs
| Location | Type | Duration | Price | Dates | |
|---|---|---|---|---|---|
| Location | Type | Duration | Price | Dates |
Find out why we are the leading choice to help boost your career
Prepare to get IT job ready in 8 weeks
Trained 8000+ professionals and counting
Experienced Provider: Operating Since 2004
Trained staff from 1000+ Australian Businesses
| Approachable and knowledgeable; comfortable surroundings. Logitrain does make IT training easier |
Paul Sinclair Service Desk Analyst 4.8/5 Rating - - 4.8/5 Rating -
I recently followed the ITIL Foundation course at Logitrain. The training, materials and facilities were excellent and I would not hesitate to train with Logitrain again.
Rob Stockey - Senior Engineer - 4.8/5 Rating -
Justin Blackford - Systems Administrator - 4.8/5 Rating -
Thanks for a great week! Really enjoyed and feel I picked up a lot. Great Trainer! Will definitely look at further studies here.
Steven Bell - Senior Service Centre Analyst - 4.8/5 Rating -
Well-presented and able to convey immense knowledge to class. All queries were responded to promptly.
Ivan Ocampo - Senior Network Engineer - 4.8/5 Rating -
Excellent teaching method, easy to understand.
Rajan Anandasivam - Technical Specialist - 4.8/5 Rating -
Logitrain provided a valuable insight into ITIL and enabled me to excel and advance my knowledge through a simple and well organised series of sessions.
Adam Centorrino - Managing Director - 4.8/5 Rating -
Great place to study for certification, knowledgeable persons, excellent customer service. Ready to answer queries on the spot, very helpful.
Ankit Sobti - Network and Systems Administrator - 4.8/5 Rating -
The trainer was very patient and gave everybody the opportunity to participate.
Tim Symonds - Solutions Architect at MSC Mobility Solutions - 4.8/5 Rating -
The trainer explained everything very well. Logitrain was very helpful for me in getting a better overall understanding of CCNA. I previously had studied it 2 years earlier but required revision
Felice Amenta - Senior Service Management Officer at Optus 4.8/5 Rating - 4.8/5 Rating -
Over 1000 organisations have relied on Logitrain to be their trusted training partner.
Dont’ Wait. Fill the form for a free no-obligation information session with our course specialists.