The 98-364 Practice-Lab will provide you with the necessary platform to gain hands on skills in Microsoft SQL Server 2008 R2. 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 Database. 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 | Understanding 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 | Select Data
MODULE 7 | Modify Data
MODULE 8 | Understand Data Storage
MODULE 9 | Administering Databases
Related Products
Practice Lab
MD-100
MD-100 Windows 10
Practice Lab
77-729
77-729 PowerPoint 2016 - Core Presentation Design and Delivery Skills
Exam Prep
77-884
77-884 Outlook 2010
Practice Lab
98-366
98-366 Networking Fundamentals
Practice Lab
MO-100
MO-100 Microsoft Word 2019
Practice Lab
77-725
77-725 Microsoft Office – Word 2016
Practice Lab
MO-200
MO-200 Microsoft Excel 2019
Practice Lab
MD-101
MD-101 Managing Modern Desktops
Practice Lab
98-382
98-382 Introduction to Programming Using JavaScript
Practice Lab
98-383
98-383 Introduction to Programming Using HTML and CSS
Practice Lab
98-375
98-375 HTML5 Application Development Fundamentals
Exam Prep
77-727
77-727 Excel 2016 - Core Data Analysis, Manipulation and Presentation
Exam Prep
77-882
77-882 Excel 2010
Practice Lab
98-364-r1
98-364-r1 Database Fundamentals - SQL Server 2016 Update
Practice Lab
ORACLE-1Z0-062
ORACLE-1Z0-062 Oracle Database 12c - Installation and Administration
Exam Prep
1Z0-051
1Z0-051 Database 11g SQL Fundamentals 1
Practice Lab
SY0-601
SY0-601 CompTIA Security+
Practice Lab
N10-008
N10-008 CompTIA Network+
Practice Lab
N10-007
N10-007 CompTIA Network+
Practice Lab
XK0-004
XK0-004 CompTIA Linux+
Practice Lab
FC0-U61
FC0-U61 CompTIA IT Fundamentals+
Practice Lab
CS0-002
CS0-002 CompTIA Cybersecurity Analyst (CySA+)
PLAB-SERVER-2016-SANDBOX
PLAB-SERVER-2016-SANDBOX Practice Labs Server 2016 Sandbox
PLAB-SERVER-2012-R2-SANDBOX
PLAB-SERVER-2012-R2-SANDBOX Practice Labs Server 2012R2 Sandbox
PLAB-WS01
PLAB-WS01 Practice Labs Introduction to Wireshark
PLAB-CEH-v10
PLAB-CEH-v10 Practice Labs - Ethical Hacker v10
PLAB-WS-NMAP
PLAB-WS-NMAP Introduction to Network Security Tools
IC3-GS5 IC3
IC3-GS5 IC3 Digital Literacy Certification - Global Standard 5
Practice Lab
PLAB-DIG-LIT
PLAB-DIG-LIT Digital Literacy
Practice Lab
PLAB-CS-FUND
PLAB-CS-FUND Cyber Security Fundamentals
Practice Lab
PLABS-DFORENSIC
PLABS-DFORENSIC Computer Forensics and Investigations
