Description
About this Course
In this course, students will be introduced to database design and administration. Students will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database.
What You'll Learn
- Data types
- Data manipulation language
- Database queries
- Primary keys
- Database backups.
Who Needs to Attend
Business or IT professionals who need to understand core database concepts and how databases can be used to store, manipulate, and analyze data
Course Outline
- Core Database Concepts
- Database Concepts
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Creating Database Objects
- Key Terms
- Data Types
- Creating and Using Tables
- Creating Views
- Creating Stored Procedures
- Manipulating Data
- Using Queries to Select Data
- Using Queries to Insert Data
- Updating Data and Databases
- Deleting Data
- Data Storage
- Normalizing a Database
- Primary, Foreign, and Composite Keys
- Clustered and Non-Clustered Indexes
- Administering a Database
- Securing Databases
- Backing Up and Restoring Databases
For more details on this module, kindly visit the official Microsoft page by following this link.
Certification
Certification Name: MTA Database Fundamentals
Exam Number: 98-364
Duration: 50 Minutes
Number of Questions: 30 - 50 Questions
Course Details
MODE OF STUDY
Part-Time
DELIVERY METHOD
Lectures & Hands-On Practice
ENTRY REQUIREMENTS
Good Knowledge of English
DURATION
25 Hours (10 Sessions of 2.5 Hours)
DAY(S)
TBA
TIME
TBA
WHAT'S INCLUDED
Training by an official Microsoft Certified Trainer
Official Microsoft Courseware (Format: Paperback)
Official Microsoft Practice Assesment
In this course, students will be introduced to database design and administration. Students will gain an understanding of core database concepts, creation of database objects, manipulation of data, data storage, and administration of a database.
What You'll Learn
- Data types
- Data manipulation language
- Database queries
- Primary keys
- Database backups.
Who Needs to Attend
Business or IT professionals who need to understand core database concepts and how databases can be used to store, manipulate, and analyze data
- Core Database Concepts
- Database Concepts
- Data Manipulation Language (DML)
- Data Definition Language (DDL)
- Creating Database Objects
- Key Terms
- Data Types
- Creating and Using Tables
- Creating Views
- Creating Stored Procedures
- Manipulating Data
- Using Queries to Select Data
- Using Queries to Insert Data
- Updating Data and Databases
- Deleting Data
- Data Storage
- Normalizing a Database
- Primary, Foreign, and Composite Keys
- Clustered and Non-Clustered Indexes
- Administering a Database
- Securing Databases
- Backing Up and Restoring Databases
For more details on this module, kindly visit the official Microsoft page by following this link.
Certification Name: MTA Database Fundamentals
Exam Number: 98-364
Duration: 50 Minutes
Number of Questions: 30 - 50 Questions
MODE OF STUDY
Part-Time
DELIVERY METHOD
Lectures & Hands-On Practice
ENTRY REQUIREMENTS
Good Knowledge of English
DURATION
25 Hours (10 Sessions of 2.5 Hours)
DAY(S)
TBA
TIME
TBA
WHAT'S INCLUDED
Training by an official Microsoft Certified Trainer
Official Microsoft Courseware (Format: Paperback)
Official Microsoft Practice Assesment