Course details
This MTA Database Administration Fundamentals course introduces and defines the terminology, concepts, and skills you need to understand database objects, security requirements, graphical tools, T-SQL scripts, and writing database queries, in addition to executing stored procedures. The course is designed for individuals seeking to learn the fundamentals of relational databases, database management systems, and database components.
On Completion of this course learners will:
- Understand Core Database Concepts
- Create Database Objects
- Manipulate Data
- Understand Data Storage
- Administer a Database
Entry Requirements
Learner Profile
The Microsoft Technology Associate (MTA) is Microsoft’s newest suite of technology certification exams that validate fundamental knowledge needed to begin building a career using Microsoft technologies. This program provides an appropriate entry point to a future career in technology and assumes some hands-on experience or training but does not assume on-the-job experience.
Microsoft Technology Associate (MTA) is a recommended entry point into IT certification and job preparation. If you are just starting your IT career path or are looking to enhance your understanding of IT fundamentals, MTA certification can validate your core knowledge and as an industry-recognised credential, it can also enhance your credibility.
Unit 1: Understanding Core Database Concepts
Unit 2: Creating Database Objects
Unit 3: Manipulating Data
Unit 4: Understanding Data Storage
Unit 5: Administering a Database
Microsoft Certification can take you from the start of your career to its pinnacle. Certification can increase your visibility, differentiate you from your peers, and bring you recognition for your knowledge and skills.
This course will provide the introductory knowledge and skills including: relational databases; 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; and stored procedures.
Assessment
- Learners take the Database Administration Fundamentals: MTA Exam 98-364. Assessment of this valuable qualification is carried out Online. On Completion of the Course the learner will have the requisite knowledge to sit the Professional Examination at any PearsonVue testing center or for Local learners at: 7 Belvedere Place, Dublin 1.
Award
- MTA: Database Administration Fundamentals Certificate
Course Location
About Dorset College
Dorset College has been an established provider of Academic, Professional and Career focused cThierses for over 30 years. They have a long standing reputation for excellence in Education, based on over thirty years experience providing programmes with clearly defined career paths and excellent academic progression. Thier graduates work in many of the leading industries in Ireland and abroad.
At Dorset College They offer a student centred learning experience and take pride in the successes of Thier Graduates. They offer a wide range of full and part-time programmes to meet the needs of learners at all stages in their lives and career. They are committed to ensuring that Thier learners are afforded the opportunity to develop their full potential in a professional and supportive environment.
“They provide you with the opportunity to build yThier qualifications through a career path that meets yThier interests and aspirations in yThier chosen profession”
Programmes are delivered in a dynamic environment by a highly qualified and experienced team of professionals. They have a strong focus on the provision of industry accredited programmes with good career and job prospects as Theyll as offering the ideal platform for academic progression. They provide excellent facilities and support to learners to enable them to achieve their goals. They focus on small class sizes and quality of education.
They constantly consult with Industry experts to ensure Thier cThierses meet and exceed market requirements, giving Thier learners the edge in today’s competitive job market. They regularly invite industry leader guest speakers to give talks in Thier cThierses so that Thier learners get to meet the best of their profession.
If you require further information, please do not hesitate to contact us or drop in and They will be very pleased to discuss the various options available to you. They look forward to meeting and Theylcoming you to Dorset College.
See all Dorset College courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- EUR 259
EUR 517Duration: Upto 125 Hours - EUR 18Duration: Upto 5 Hours
