The 98-364-r1 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2016. By completing the lab tasks you will improve your practical skills in Relational Database Concepts, Data Manipulation Statements, Data Definition Language, Tables, Data types, Views, Stored Procedures, Select statements, Modifying data, Data storage, Securing databases and Backing up / Restoring Databases. These same tasks will help you understand the objectives and competencies required by the MTA: 98-364 Database Fundamentals certification exam.
Once you feel confident to take the Microsoft certification exam, you will need to follow the process below to register and pay for your exam. The exam can be taken online or in a test centre near you.
Go to Certifications and select the certification you would like to write, click register for exam
Select “Schedule with Pearson VUE” when choosing an exam delivery partner
Sign into your Microsoft account, or create a certification profile
Complete the required information
Follow the on-screen steps to select a proctoring method (if available), schedule your exam appointment, and complete payment (if applicable).
Run a systems check if taking the exam online
Once registered, your appointment should appear in the Certification Dashboard. You can also cancel or reschedule your appointment here if you need. If you are taking an online exam, you will start your exam from here as well.
MODULE 1 | Core Database Concepts
MODULE 2 | Working with tables
MODULE 3 | Choose Data Types
MODULE 4 | Working With Views
MODULE 5 | Create Stored Procedures
MODULE 6 | Extracting Data using Statements
MODULE 7 | Modify Data
MODULE 8 | Normalization, Primary, Foreign and Composite Keys
MODULE 9 | Administering Databases
NEED MORE INFORMATION ABOUT THIS COURSE?
Complete the fields below to receive the course information pack. *Required fields
By providing us with your contact details, you agree to the use of your data as described in our terms and conditions to receive communications. You may opt out of receiving communications at any time.
DAMELIN HET – Damelin (Pty) Ltd is registered with the Department of Higher Education and Training as a Private Higher Education Institution under the Higher Education Act No. 101 of 1997 and its higher education programmes are accredited by the Council on Higher Education (CHE). Registration Number: 2001/HE07/009. DAMELIN FET – Damelin (Pty) Ltd is provisionally registered with the Department of Higher Education and Training as a private college under the Continuing Education and Training Act No. 16 of 2006. Registration Certificate No: 2008/FE07/089. Damelin (Pty) Ltd is also provisionally accredited by Umalusi, the Quality Council for General and Further Education and Training. Damelin (Pty) Ltd is further accredited by the Quality Council for Trades and Occupations (QCTO)