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.
Database Fundamentals
This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.
Profil uczestnika
Agenda
Understanding Core Database Concepts
- Understanding Database Concepts
- Understanding Flat-Type Databases
- Understanding Hierarchical Databases
- Understanding Relational Databases
- Understanding Database Fundamentals
- Understanding Relational Database Concepts
- Using the SQL Server Management Studio Interface
- Understanding Data Manipulation Language (DML)
- Understanding Data Definition Language (DDL)
- Using DDL Statements
Creating Database Objects
- Defining Data Types
- Using Built-in Data Types
- Using Exact Numeric Data Types
- Using Approximate Numeric Data Types
- Creating and Using Tables
- Creating Views
- Creating Stored Procedures
- Understanding SQL Injections
Manipulating Data
- Using Queries to Select Data
- Combining Conditions
- Using the BETWEEN Clause
- Using the NOT Clause
- Using the UNION Clause
- Using the EXCEPT and INTERSECT Clauses
- Using the JOIN Clause
- Using Queries to Insert Data
- Inserting Data
- Updating Data and Databases
- Using the UPDATE Statement
- Deleting Data
- Using the DELETE Statement
- Truncating a Table with TRUNCATE TABLE
- Deleting a Table with DROP TABLE
- Using Referential Integrity
Understanding Data Storage
- Using Queries to Select Data
- Normalizing a Database
- Understanding Normalization
- Understanding the First Normal Form
- Understanding the Second Normal Form
- Understanding the Third Normal Form
- Understanding the Fourth Normal Form
- Understanding the Fifth Normal Form
- Understanding Primary, Foreign, and Composite Keys
- Understanding Primary Keys
- Understanding Foreign Keys
- Understanding Composite Primary Keys
- Understanding Clustered and Non-clustered Indexes
- Understanding Clustered Indexes
- Understanding Non-clustered Indexes
- Creating a Non-clustered Table
Administering a Database
- Securing Databases
- Understanding Server-Level Security
- Understanding Database-Level Security
- Understanding Windows Security
- Understanding SQL Authentication
- Understanding Database Server Roles
- Granting Access to a Database
- Understanding Fixed Database Roles
- Understanding Object Permissions
- Managing Roles
- Understanding Ownership Chains
- Reviewing a Sample Security Model
- Backing Up and Restoring Databases
- Understanding Recovery Models
- Understanding Database Backups
- Understanding Backup Devices
- Understanding Database Restores
Korzyści
After completing this course, students will be able to:
- Understand Core Database Concepts
- Create Database Objects
- Manipulate Data
- Understand Data Storage
- Administer a Database
Zapisz się
