MTA: Database Administration Fundamentals Full Cost

Part Time

Course Details

Click here

Course Code

QBSNT171/BCP0

Course Level

N/A

Where will this course lead?

The Microsoft Technology Associate (MTA) certification is a new, entry-level certification designed to help individuals take the first step toward a career as an IT professional or developer.

An MTA certification is based on 80 percent knowledge and 20 percent skills. The next step in the Microsoft certification path is Microsoft Technology Specialist (MCTS), which requires hands-on experience with the Microsoft technology platform.

Students who satisfy the minimum pass level, for the above vendor exam(s), as defined by Microsoft at the time of taking the online exam, will be awarded the following:-

Microsoft Certified Technology Associate (MTA)

What will I study?

After completing this course, you will be able to:

Understanding Core Database Concepts
Understand how data is stored in tables.
Understand relational database concepts.
Understand data manipulation language (DML).
Understand data definition language (DDL).
Creating Database Objects
Choose data types.
Understand tables and how to create them.
Create views.
Create stored procedures and functions.
Manipulating Data
Select data.
Insert data.
Update data.
Delete data.
Understanding Data Storage
Understand normalization.
Understand primary, foreign, and composite keys.
Understand indexes.
Administering a Database
Understand database security concepts.
Understand database backups and restore.

How will this course be delivered?

This course is one of the 'blended learning' series from the Microsoft IT Academy at Solihull College. Providing IT professional access to the latest Microsoft certification courses with high quality, flexible learning systems.

The 'blended learning' courses comprise of components to facilitate effective self directed learning, with flexible start and attendance date to meet your individual needs.

This course offers bookable hands-on practice labs in our Academy open access lab facility that assist students in becoming proficient in the skills needed to support the Microsoft technology.

The student kit includes relevant comprehensive Microsoft Official Curriculum workbook(s) and other necessary materials for this class.

Students will also receive 150 days access to Microsoft's internet e-learning system, with relevant e-learning course materials.

Access to MSDN AA to 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 one-one support and guidance from our qualified Microsoft Certified Trainer / mentors.

On-line exam preparation and assessment with MeasureUP test practice system.

This course is available to study in daytime or evening sessions.

What qualifications will I get?

Vocational study not leading to a recognised qualification, Information and Communication Technology (SSA 6)

How will I be assessed?

There is no formal examination required; however students may take the external Microsoft examination, typically three weeks from end of course.

98-364 MTA: Database Fundamentals

Examinations must be taken at our in-house Authorised Certiport testing centre at Specialist IT Training.

The course includes continual assessments.

How do I get a place on the course?

Places are offered by interview.

What are the entry requirements?

Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases such as Microsoft SQL Server. It is recommended that candidates be familiar with the concepts of and have hands-on experience with the technologies described here either by taking relevant training courses or by working with tutorials and samples available on MSDN and in Microsoft Visual Studio. Although minimal hands-on experience with the technologies is recommended, job experience is not assumed for these exams.

Candidates for this exam are in the process of expanding their knowledge and skills in the following areas:
?core database concepts
?relational database concepts
?security requirements for databases and the data stored in them
?database objects, such as tables and views
?graphical tools and T-SQL scripts
?database queries
?stored procedures

What else do I need to know?

Earning a Microsoft Certification helps validate your proven experience and knowledge in using Microsoft products and solutions. Designed to be relevant in today's rapidly changing IT marketplace, Microsoft Certifications help you utilize evolving technologies, fine-tune your troubleshooting skills, and improve your job satisfaction.

Whether you are new to technology, changing jobs, or a seasoned IT professional, becoming certified helps demonstrate to customers, peers, and employers that you are committed to advancing your skills and taking on greater challenges. In addition, certification provides you with access to exclusive Microsoft Certified Professional (MCP) resources and benefits, including opportunities to connect with a vast, global network of MCPs.

Course schedules, content, supporting materials and availability may be subject to change.

Solihull College offers full time and part time courses for businesses and residents in Birmingham, Walsall, Wolverhampton, Coventry Warwickshire and the whole of the West Midlands.

What can I do after this course?

This course is intended for individuals who are first step toward a career as an IT professional or developer.


The following courses are recommended for further study:-

QBSNT127/BCP0 BL: 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
QBSNT167/BCP0 BL TS: Microsoft SQL Server 2008, Database Development

Is there anything else I will have to pay for in order to do this course?

Study material fees are payable.
If required, vendor exam will be charged at current rates.
This course is not eligible for fee concession.

Contact

Blossomfield Campus

Solihull College
Blossomfield Road
Solihull
B91 1SB

Tel: 0121 678 7000
Minicom: 0121 628 7005
Email: enquiries@solihull.ac.uk
Internet: www.solihull.ac.uk

Have you got a question about this course?

Please contact Admissions on 0121 678 7000 with any queries.

Course Details