Description

Type

Course
Methodology

Online

Start date

Different dates available

Course Description
The course provides students with the technical skills required to perform installation, maintenance, and configuration tasks in Microsoft SQL Server 2012. It also teaches them how to set up database systems, make sure the systems operate efficiently, and regularly store, back up, and secure data from unauthorized access.
This course will help current and aspiring data professionals to prepare for the Microsoft 70-462 exam, known as Administering Microsoft SQL Server 2012 Databases.
Entry Requirement
The MCSA: Administering Microsoft SQL 2012 Course is intended for SQL Administrators who administer and maintain SQL Server databases are best suited for this certification training. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.The course has been designed to give you real-world knowledge that you can put to use from day one. It's highly flexible, so you can set your own timetable and study at your own pace. You can start learning right away with an initial payment of £21.67 by using our 9 month interest-free payment plan

Facilities

Online

Start date

Different dates availableEnrolment now open

About this course

Requirements

Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Qualification

Certification Details
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!

Questions & Answers

Add your question

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

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

Access
Server
Database
SQL
Database training
MCSA training
MCSA
Systems

Course programme

Course Syllabus

Module 1

Introduction to SQL Server 2012
SQL Instances
Editions and Licensing
SQL Server Objects
System Databases
SQL Server Data Tools
Object Explorer
Object Scripting
Template Explorer
Query Tabs
Projects and Solutions
Customizing SSDT
Debugging T-SQL
SQLCMD
Exam Scenarios
Module Review

Module 2

T-SQL Overview
T-SQL Elements
Batch Separators
Line Terminator
Variables
Control Flow
Expressions
Functions
Predicates and Operators
SELECT
Column Aliasing
SELECT Execution
Exam Scenarios
Module Review

Module 3

SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module Review

Module 4

Filtering
WHERE Syntax
BETWEEN
WHERE Syntax IN
Filtering NULL Values
LIKE
Data Type Comparison
Filtering Data with WHERE
TOP
OFFSET-FETCH
Exam Scenarios
Module Review

Module 5

Join and Set Operators
Using Joins
Categories of Joins
INNER JOIN
OUTER JOIN
JOIN Demo
Set Operators
Set Operators Demo
Exam Scenarios
Module Review

Module 6

Subqueries and Table Expressions
Subqueries
Self Contained Subquery
Correlated Subquery
Subquery Demo
EXISTS
Common Table Expressions
Temporary Tables
Table Variables
Table Demo
Exam Scenarios

See related categories

Contact us

MCSA: Administering Microsoft Sql 2012 (Exam 70-462)

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

MCSA: Administering Microsoft Sql 2012 (Exam 70-462)

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.