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 Outline
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.
