MTA: Database Fundamentals
Prepare for the 98-364 exam with the MTA: Windows Database Fundamentals course and lab. The lab is cloud-based, device-enabled, and can be easily integrated with an LMS. This complete course covers the 98-364 exam objectives and provides the skills that are necessary to work with databases, including relational databases, such as Microsoft SQL Server.
Here's what you will get
The MTA: Database Fundamentals certification exam is a standalone certification from Microsoft with the exam code 98-364. The certification is for the candidates who want to prove their caliber in software development. The MTA certification provides an appropriate entry point to a future career in technology.
Lessons
6+
Quizzes
50+
Flashcards
76+
Glossary of terms
76+
Pre-assessment Questions
50+
Full Length Tests
2+
Post-Assessment Questions
54+
Performance lab
Learn the real world skills using Live Labs.
42+
Video tutorials
Get interactive learning videos with transcripts and voice-over.
42+
Minutes
Signify the duration of video tutorials in labs.
39+
Videos and How To..
uCertify course includes videos to help understand concepts. It also includes How Tos that help learners with how to accomplish certain tasks.
Videos
319+
Hours
06:03+
|
Exam FAQs
| |
|---|---|
| What is the exam registration fee? | USD 127 |
| Where do I take the exam? | Certiport or Pearson VUE |
| What is the format of the exam? | Active screens, Best answers, Build list, Case study, and so on. |
| How many questions are asked in the exam? | The exam contains 40-60 questions. |
| What is the duration of the exam? | 45 minutes |
| Where can I find more information about this exam? | To know more about the 98-364-2018, click here. |
| Which certification covers this exam? | |
| What are the career opportunities after passing this exam? |
|
Here's what you will learn
- Understand How Data is Stored in Tables
- Understand Relational Database Concepts
- Understand Data Manipulation Language (DML)
- Understand Data Definition Language (DDL)
- Summary
- Choose Data Types
- Understand Tables and How to Create them
- Create Views
- Create Stored Procedures and Functions
- Summary
- Select Data
- Insert Data
- Update Data
- Delete Data
- Transaction Controls
- Summary
- Understand Normalization
- Understand Primary, Foreign, and Composite keys
- Understand Indexes
- Summary
- Understand Database Security Concepts
- Understand Database Backups and Restore
- Summary
Hands on Activities (Labs)
- Creating a Database
- Deleting a Database
- Adding a Column to a Table
- Renaming a Table
- Modifying a Column in a Table
- Dropping a Column in a Table
- Using the SELECT Command
- Creating ER Diagram
- Using the CREATE Command
- Exceeding Data Type Limit
- Handling NULL Values
- Inserting Values into a Table using the Stored Procedure
- Creating an Inline Table-Valued Function
- Using the CREATE VIEW Syntax
- Using the ALTER VIEW Statement
- Creating a View WITH CHECK OPTION Clause
- Creating a Stored Procedure
- Altering a Stored Procedure
- Modifying Stored Proc Definitions
- Using the SELECT DISTINCT Statement
- Using the SELECT, FROM, and WHERE Clauses
- Using the ORDER BY Keyword
- Using the UNION Operator
- Using the INTERSECT Operator
- Using the EXCEPT Operator
- Using LEFT OUTER JOIN
- Using RIGHT OUTER JOIN
- Using FULL OUTER JOIN
- Using CROSS JOIN
- Using a Simple Inner Join
- Using a Complex Inner Join
- Using the INSERT statement
- Using the UPDATE Statement
- Using the DELETE Statement
- Using Transaction Controls
- Using Referential Integrity Constraints
- Creating a Function-Based Index
- Using a Function-Based Index
- Creating a Non-Clustered Index
- Adding a New Login
- Accessing the Database Roles
- Creating a Backup
98-364
uCertify provides Courses, Hands-on Labs, Test Prep for IT certifications including Microsoft, Oracle, Cisco, CompTIA, CIW, PMI, ISC2, Linux, Zend, IC3, Adobe, and many more.
© 2002-2019 uCertify.
All Rights Reserved
Know Us
- About us
- Careers
- Partners
- Sitemap
- Contact us
- Terms & Conditions
- Privacy Statement