Database Administration is an IT sector which consists of everything required to manage a database and make it available as needed. The database administrator (DBA) is the person who manages, backs up and ensures the availability of the data produced and consumed by today’s organizations via their IT systems.
For our Database Administration course, our students are thought how to use SQL Fundamentals, MySQL, DB Management System, Oracle Database.
Most companies, schools, and institutions who deal with a lot of data today are in need of professional Database Administrators who will help them protect and manage their files. This is a very lucrative field and it is for this reason that professionals are put at the disposal of our students to teach them all they need.
WHAT YOU WILL LEARN
With PhpMyAdmin / MySQL
- Understand what are databases and why they are used.
- Database project management.
- Learn how to create database using SQL commands.
- Understanding what a datatype is.
- Learn how to create tables using SQL commands.
- Learn how to alter and drop existing tables using SQL commands.
- SQL queries to insert, update and delete data from the database.
- SQL queries to manipulate data.
- How to write complex SQL queries to obtain useful information from the
database. - SQL operators to write complex SQL queries.
- How to perform different types of join operations.
- Different SQL functions and constraints.
- Administering user accounts in the Database.
- Learn how to perform Backup and Recovery as needed.
- MySQL views and how to manipulate views effectively.
Oracle Database
- Database Architecture, which will help you to perform your DBA duties with better understanding.
- How to Install the necessary Oracle Software/Database.
- Administering User accounts in the Database.
- Managing Table space’s to provide required space for the data.
- Managing Tables, views.
- You would be able to read, insert, update and delete data from the database.
- You would create/alter/drop functions and constraints.
- How perform Backup and Recovery as needed.
- You would learn how to diagnose the problems and if required will be able to work with Oracle Support.
- How to configure the Listeners for users to communicate.
DB Management System
- Understanding the Importance of Information & Data Management in Business
- How to translate business requirements into database diagrams
- How to Install, configure and deploy different databases
- How to elaborate on data storage and indexing options, and perform query optimization
- Understanding the life cycle of the relational database
- How to build your own Business Critical Database
- Writing SQL codes based on Queries standards to build and maintain database structures and data
- Discuss the physical database design process of producing an efficient and tuned database transform an E-R diagram into a relational model, and use normalization to create a database relational schema
COURSE OUTLINE
| Week1 | – What is database? – What is database administration (DBA)? – What is a database administrator? – What is a relational database? – What is a Database management system (DBMS)? – What is a relational Database management system (RDBMS)? – What is SQL? – Relational Model in DBMS – Data Modeling • Conceptual data model • Logical data model • Physical data model – Popular Relational Database Management Systems – Database Administrator Responsibilities – Database project management |
| Week2 | – Installing the required tool (PhpMyAdmin) – Managing databases Create/Rename/drop a Database – MySQL data types • Character datatypes • Numeric datatypes • Date datatypes – Working with tables • CREATE TABLE • DROP TABLE Student assignments (Using PhpMyAdmin) |
| Week3 | – Working with tables • ALTER TABLE – Modifying data in MySQL • How to insert data into tables using MySQL statements. • How to read data from tables using MySQL statements and operators. • How to update data in tables using MySQL statements. • How to delete data from tables using MySQL statements. Student assignments and projects (Using PhpMyAdmin) |
| Week4 | – MySQL constraints • Add/Alter/drop NOT NULL constraint • Add/Alter/drop UNIQUE constraint • Add/Alter/drop DEFAULT constraint • Add/Alter/drop CHECK constraint • Add/Alter/drop PRIMARY KEY constraint • How to use an AUTO_INCREMENT column to generate unique numbers automatically for the primary key • Add/Alter/drop FOREIGN KEY constraint Student assignments and presentations (Using PhpMyAdmin) |
| Week 5 | – Joining tables • Reading data from 2 tables • Reading data from 3 tables and more – MySQL Stored Procedures and functions • MySQL Aggregate Functions • CREATE/ALTER/DROP functions • CREATE/ALTER/DROP Stored procedures – Backup and Restore Data |
| Week 6 | – MySQL Views – Users, Roles and Privileges • Secure the admin account with a password • Create/rename/drop users • Grant privileges • Revoke privileges • Manage roles • Change password Student projects and presentations (Using PhpMyAdmin) |
| Week 7 | – Installing Oracle 12c – What is Oracle 12c? – Oracle Architecture – Creation of pluggable databases – Connect To Oracle Database |
| Week 8 | – Oracle data types • Character datatypes • Numeric datatypes • Date datatypes • Etc. – Working with tables • CREATE TABLE • DROP TABLE Student assignments (Using Oracle 12c) |
| Week 9 | – Working with tables • ALTER TABLE – Modifying data • How to insert data into tables. • How to read data from tables. • How to update data in tables. • How to delete data from tables Student assignments and projects (Using Oracle 12c) |
| Week 10 | – Oracle constraints • Add/Alter/drop NOT NULL constraint • Add/Alter/drop UNIQUE constraint • Add/Alter/drop DEFAULT constraint • Add/Alter/drop CHECK constraint • Add/Alter/drop PRIMARY KEY constraint • How to use GENERATED BY DEFAULT AS IDENTITY to generate unique numbers automatically for the primary key • Add/Alter/drop FOREIGN KEY constraint Student assignments and presentations (Using Oracle 12c) |
| Week 11 | – Joining tables • Reading data from 2 tables • Reading data from 3 tables and more – Oracle Stored Procedures and functions • Oracle Aggregate Functions • CREATE/ALTER/DROP functions • CREATE/ALTER/DROP Stored procedures – Backup and Restore Data |
| Week 12 | – Tablespace management • How data is stored in a Database? • Tablespace Concepts • Online and Offline Tablespaces • Let’s create a Tablespace… • Let’s add more space to the Database • Tablespaces with different block sizes • Temporary Tablespace Management • Temporary Tablespace Groups – UNDO and REDO management – User management • User Management Concepts • User Creation Exercise • Grant Privileges • Revoking User Privileges • Revoking System Privileges • Revoking Object Privileges • Role Management Concepts • User Profiles • Managing Passwords using Profiles |
| Week 13 | – Oracle networking • Networking Concepts • Listener Configuration • TNSNAMES Configuration • Database Link Concepts • Public Database Link • Private Database Link |
| Week 14 | Project’s presentation. |
Course Benefits
- Lab Project
- Take Home Exercises
- FREE Driving Lessons
- Internship Opportunity
- Certificate of Completion
Who is the target audience?
- Anyone who works and want to work with data and information industries!
- Those who work in organizations where the company typically uses database, software and apps.
- Secondary School Students
- Those who want to boast their CV or Advance their Career.
- Graduate Trainee
Job Outlook
- Career prospects for people with similar training include Web Developer, IT Officer, Application Developer, Software developer, Software tester, Data Analyst, Sales Analyst, DB Administrator.
- The median salary for entry level for Database jobs in Cameroon is 500,000 FCFA per Month.