Microsoft Certified Solutions Associate (MCSA) SQL Server 2012

Course Information:

Course Microsoft Certified Solutions Associate (MCSA) – SQL Server 2012
 Programme TypeProfessional Industry Partner Programme
 Award TypeMicrosoft Certificate: Microsoft Certified Solution Associate: SQL Server 2012
 Award Issued ByMicrosoft
 Accredited By Not Applicable
 Course Duration12 Months
 Entrance Criteria
  • A+ Certification OR N+ Certification OR S+ Certification OR Any Microsoft Technology Associate (MTA) Certification
  • Learners must be 16 years or older
  • The ability to read and write in english
  • Access to a computer
  • Computer Literacy
  • Exam fees are not included in your course fees

What is Included in your Course Fee?

 

All your study material, textbooks and study notes

All the study notes and textbooks you need to pass your course is included in your course fees. There is no list of books to buy at a bookstore. No extra hidden costs for textbooks. The price we give you includes everything you will need to complete your course.
When there are external costs like institute membership or exam fees, we will warn you about that before you register. So you are able to budget your monthly study costs.

Courier Fees

The courier fees are included in your course fees. No waiting on the Post Office. You don’t spend weeks waiting on your next package with study materials. On average we deliver in a week or less.

 

All your Tutorial Services

We have a dedicated team of tutors and administrators to help you with each and every query you might have on your course.

 

Online Study Group with Together We Pass

Skills Academy students get free access to the Together We Pass (TWP) online study groups. The study groups are facilitated by your own Skills Academy lecturers and tutors. This is where you get the best help with your studies! And when YOU have the answer, you can even help your classmates!

 

Limitless access to your Lecturers and Tutors (in Office Hours)

Together We Pass, in association with Skills Academy, offers free online study groups for all of their students.  That means that within two days of signing up you will be registered in your online study group and you can start engaging with your classmates and your lecturers.

This is key to the Skills Academy strategy of high contact, supported learning so all students are encouraged to use the study groups as much as possible.

Students should also remember that these study groups are facilitated by their own Skills Academy lecturers, which means they can answer any question you might have.  We hope you find the study groups useful in your studies!

 

What is NOT Included in your Course Fee?

  • Writing materials
  • Envelopes to send assignments to us

In fact, you can upload your assignments here through our Learner Portal, and cut out the price of envelopes out as well!

 

How Will My Study Material Look?

Once you have successfully enrolled with us, we will send you a package within the first 1-2 working days. In this package, you will receive a Skills Academy Welcome Pack as well as the first set of study material for the Microsoft Certificate in Microsoft Certified Solution Associate: SQL Server 2012 course. Look at the image below to see what you can expect from us.

Child Day Care Certificate

 

Our Tutors Will Make Sure You Pass!

Here at Skills Academy, we want to make sure you pass on your first try. That’s why we have a team of smart and helpful tutors that will assist you every step of the way. You can call them during the day for any assistance or Whatsapp them in a group if you need a quick answer to a tough question.

Subjects

 

1. Introduction to Business English

2. Querying Microsoft SQL Server 2012 (Exam number 461)

3. Administering Microsoft SQL Server 2012 Databases (Exam number 462)

4. Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 463)

 

1. Introduction to Business English

  • Introduction to communication
  • Non-verbal communication
  • Business writing
  • Speaking, listening and reading skills
  • Meetings
  • Presentations
  • Work readiness

2. Querying Microsoft SQL Server 2012 (Exam number 461)

  • 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
  • Optimize queries
  • Manage transactions
  • Evaluate the use of row-based operations vs. set-based operations
  • Implement error handling

3. Administering Microsoft SQL Server 2012 Databases (Exam number 462)

  • 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 a SQL Server clustered instance
  • Manage SQL Server instances
  • Identify and resolve concurrency problems
  • Collect and analyze troubleshooting data
  • Audit SQL Server instances
  • Configure and maintain a back-up strategy
  • Restore databases
  • Implement and maintain indexes
  • Manage logins and server roles
  • Manage database security
  • Manage users and database roles
  • Troubleshoot security
  • Implement AlwaysOn
  • Implement AlwaysOn availability groups; implement AlwaysOn failover clustering
  • Implement replication
  • Import and export data

4. Implementing a Data Warehouse with Microsoft SQL Server 2012 (Exam 463)

  • Design/implement star vs. snowflake schemas, fact tables, dimensions, keys
  • Create/apply project level connection managers, slowly changing dimensions, fuzzy lookups
  • Execute SSIS packages with SSMS, DTEXEC, SQL Server Agent
  • Create, assign, read variables and parameters
  • Plan and implement full and incremental loads for data warehouses
  • Implement solutions with Data Quality Services

 

Assessments & Awards

You will need to write 3 Computer-Based Assessment at a Prometric Testing Centre:

  • Exam 461
  • Exam 462
  • Exam 463

Once you have successfully completed the exams, your Prometric Testing Centre will provide you with a report.  You will then receive the  Microsoft certification: Microsoft Certified Solutions Associate: SQL Server 2012.

Once you have passed your exam, you will be given access to the Microsoft Certification member site.  You will be able to download your certificate on the member site.  You will also be able to order a printed copy of your certificate.

Your first assignment will be on Goal Setting, which will arrive with your Welcome Pack.

Accreditation

This course is a Accredited by Microsoft Official.

Can I trust This College? Check Out Our Reputation!

How do you know you are making the right choice? You have to investigate the reputation of the college you are looking at. That means you look us on on Facebook and Google.

When Can I Start?

You can start right now! Click Here to fill in an application form and a friendly Student Consultant will contact you to ensure this is the right course for you.

 

Last Updated: September 14, 2018

We Will Call You

  • We shall call you back as soon as we have a line available.

  • This field is for validation purposes and should be left unchanged.