This course helps you prepare and build an understanding of these course 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
Career benefit of this course
- After completing this course, students will be able to:• Understand Core Database Concepts
• Create Database Objects
• Manipulate Data
• Understand Data Storage
• Administer a Database
Course Modules for Database Administration Fundamentals
Module 1: Understanding Core Database Concepts
- Understanding Database Concepts
- Understanding Relational Databases
- Understanding Data Manipulation Language
- Understanding Data Definition Language (DDL)
Module 2: Creating Database Objects
- Defining Data Types
- Creating and Using Tables
- Creating Views
- Creating Sorted Procedures
Module 3: Manipulating Data
- Using Queries to Select Data
- Using Queries to Insert Data
- Updating Data and Databases
- Deleting Data
Module 4: Understanding Data Storage
- Normalizing a Database
- Understanding Primary, Foreign and Composites Key
- Understanding Clustered and Non-Clustered Indexes
Module 5: Administrating a Database
- Securing Databases
- Backing Up and Restoring Databases
The strength in your qualification
On successful completion of this programme, the learner will receive the Pine Valley Institute certificate in system Database Administration and we are also accredited by Micseta .We also assist the learner to seat for the ORACLE certify Database Administration exam which guarantee the learners to work in any reputable company
For Career Guidance or not sure what to study complete the form below and Pine Valley Institute professional career adviser will call you back within an hour
