40364
Database Fundamentals
- Duration 3 days
- Price $1,557
- Test Level 100
- Certifications MTA: Database
- Exams 98-364
Course Overviewremove_circle_outline
Students who are beginning studies in technology need a strong foundation in the basics before moving on to more advanced technology courses and certification programs. The Microsoft Technology Associate (MTA) is an innovative certification track designed to provide a pathway for future success in technology courses and careers.
The MTA program curriculum helps teach and validate fundamental technology knowledge. Database Administration Fundamentals covers introductory knowledge and skills including: relational databases; core database concepts; relational database concepts; security requirements for databases and the data stored in them; database objects -- such as tables and views; graphical tools and T-SQL scripts; database queries; and stored procedures.
Course Outlineadd_circle_outline
Lesson 1: Understanding Core Database Concepts
- Objective Domain Matrix
- Key Terms
- 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
- Skill Summary
- Knowledge Assessment
- Competency Assessment
- Proficiency Assessment
Lesson 2: Creating Database Objects
- Objective Domain Matrix
- Key Terms
- 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
- Skill Summary
- Knowledge Assessment
- Competency Assessment
- Proficiency Assessment
Lesson 3: Manipulating Data
- Objective Domain Matrix
- Key Terms
- 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
- Skill Summary
- Knowledge Assessment
- Competency Assessment
- Proficiency Assessment
Lesson 4: Understanding Data Storage
- Objective Domain Matrix
- Key Terms
- 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
- Skill Summary
- Knowledge Assessment
- Competency Assessment
- Proficiency Assessment
Lesson 5: Administering a Database
- Objective Domain Matrix
- Key Terms
- 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
- Skill Summary
- Knowledge Assessment
- Competency Assessment
- Proficiency Assessment
Prerequisitesadd_circle_outline
N/A
-
UPCOMING CLASSES
-
Click below to see more class dates with course versions -
See More Dates