Study Mode: Part Time
Course Level: N/A
This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the exam 70-462
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases
After completing this course, you will be able to:
- Plan and install SQL Server.
- Describes the system databases, the physical structure of databases and the most common configuration options related to them.
- Explain the concept of the transaction log and SQL Server recovery models and implement different backup strategies available with SQL Server.
- Create SQL Server Backups.
- Restore SQL Server databases.
- Use the import/export wizards and explain how they relate to SSIS.
- Work with SQL Server security models, logins and users.
- Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles.
- Work with permissions and the assignment of permissions.
- Work with SQL Server Audit.
- Work with SQL Server Agent, jobs and job history.
- Implement SQL Server agent security, proxy accounts and credentials.
- Configure database mail, alerts and notifications.
- Create database maintenance plans.
- Work with SQL Profiler and SQL Trace stored procedures.
- Introduce DMVs and the configuration of data collection.
- Work with Central Management Servers and Multi-Server queries, Virtualization of SQL Server and Data-Tier Applications.
- Troubleshoot SQL Server databases.
Please refer to the Microsoft exam preparation guide for details of objectives covered.
This 'Specialist' level course is part of the SQL Server 1012 'Database Certification Track' from the Professional IT Training series delivered by the Microsoft IT Academy at Solihull College.
Providing IT professional's access to the latest Microsoft certification courses with high quality, flexible learning systems.
The 'Professional IT Training' courses facilitate effective self-directed learning, with flexible start dates to meet your individual needs. This course is delivered in our Microsoft IT Academy workshop alongside students studying similar SQL database or BI courses.
This course includes hands-on practice labs in our Academy lab facility that assist students in becoming proficient in the skills needed to support the Microsoft technology.
The student resources include relevant comprehensive printed Microsoft Study Guide, and e- learning materials.
Microsoft Dreamspark (formally MSDN AA) enable students to download Microsoft operating systems and applications to create and develop their own practice lab environments, for your academic use only. Conditions and systems requirements apply.
Tailored individual learning plans, with support and guidance from our qualified Microsoft Certified Trainer / mentors.
Each Microsoft Official Academic Course is aligned to existing MCP exam objectives.
This course is available to study in the evening, over 15 sessions. Learners may re-enrol on course to extend their period of study.
Vocational study not leading to a recognised academic qualification.
Students may elect to take the relevant Microsoft MCP exam to gain the Microsoft Certified Professional in Administering Microsoft SQL Server 2012 Databases
Microsoft Certified Solutions Associate (MCSA): SQL Server 2012
Microsoft Certified Solutions Expert (MCSE): Data Platform
Microsoft Certified Solutions Expert (MCSE): Business Intelligence
Certification requirements are is subject to change at any time without prior notice and at the sole discretion of Microsoft. Please refer to Microsoft certification site for current details.
The course includes continual assessments throughout the course with both practical and quiz exercises and MeasureUp practice exams. Course certificates of completion are provided.
There is no formal examination required; however this course will prepare you for the following Microsoft MCP exam: 70-462: Administering Microsoft SQL Server 2012 Databases which may be taken at external Pearson VUE test centres.
Places are offered by interview, subject to meeting the entry requirements.
Learners must be over 19.
Before attending this course, learners must have completed the following courses, gained certification or have similar knowledge:
MCSA: 461 Querying Microsoft SQL Server 2012
Have basic knowledge of the Microsoft Windows operating system and its core functionality.
The number of job postings in the computing industry is growing so rapidly that there aren't enough qualified workers available to fill the positions. Get certified and be part of the solution.
Eighty-six percent of hiring managers indicate IT certifications are a high or medium priority during the candidate evaluation process. (CompTIA, Employer Perceptions of IT Training and Certification, January 2011)
Eight in ten HR execs verify certifications among job candidates. (CompTIA, Employer Perceptions of IT Training and Certification, January 2011)
Ninety-one percent of hiring managers consider certification as part of their hiring criteria. (Microsoft, Microsoft Certification Program Satisfaction Study, April 2012)
Sixty-four percent of IT hiring managers rate certifications as having extremely high or high value in validating the skills and expertise of job candidates. (CompTIA, Employer Perceptions of IT Training and Certification, January 2011)
How much will this course cost?
Tuition fee £ 450.00 ; Materials fee £ 85.00 ; Total £ 535.00
Is there anything else I will have to pay for in order to do this course?
Study material fees (£85) are payable on enrolment.
This course is not eligible for fee concession.
Learners may re-enrol on course to extend their period of study, tuition fee payable.
Have you got a question about this course?
Please contact the Microsoft IT Academy co-ordinator, Mr Robin Foster via the enquiries team.
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals. Further Microsoft IT certification courses are available on the 'Database Certification Track' including administering an SQL 2012 server, implementing data warehousing, data models and reports and BI courses.
Course Fee (p.a)