The Diploma in Database Administration and database App development course enables participants to enhance their skills in Oracle Development by building applications and reports, Database Administration through learning the architect and management of a database and System Administration using the Red Hat Enterprise Linux which equips learners with essential skills to manage systems that may be hosting the database.
12 months
- Before you apply for this course, all you need is a passion to learn about Database Management and a minimum of Certificate in Database administration and database app development from our institution
- IT Certificate holders/ Diploma holders or Degree holders who want to learn and specialize in Oracle Database Administration.
- This course is also recommended for individuals who are preparing for certifications in Oracle (OCA and OCP certification)
- This course is also recommended for individuals who are preparing for certifications in Red Hat Enterprise Linux (RHCSA)
Semester 1
- Data modelling and relational Database designs –
Designing a database is much like designing anything else: a building, a car, a roadway through a city, or a book such as this. Much care must be taken to plan a design. If time is not taken to carefully plan the design of an object, the quality of the end product will suffer. Many approaches can be taken to explain database design. It can be debated indefinitely what to include, what not to include, and in what order to present the material. This module takes an approach to database design that focuses mainly on the logical methods involved in deriving a database structure. We explain the thought process involved in converting an organization’s data storage needs into a relational database
- Red Hat Linux 8: System Administration 1 –
Red Hat System Administration I equips you with Linux administration survival skills by focusing on foundational Linux concepts and core tasks. You will learn how to apply command-line concepts and enterprise-level tools, starting you on your journey toward becoming a full-time Linux system administrator.
- Oracle Database: Fundamentals of SQL I –
SQL is a database computer language designed for the retrieval and management of data in a relational database. SQL stands for Structured Query Language. This module will give you a quick start to SQL. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.
- Oracle Database: Fundamentals of SQL II –
This module continues to build up the fundamental of sql I by introducing more concepts that which gives learners an in-depth knowledge on the dynamic language of sql
- Oracle Database: programming with PL/SQL –
PL/SQL is a combination of SQL along with the procedural features of programming languages. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This module will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.
Semester 2
- Oracle Database 19c: Administration –
Oracle database is one of the most commonly used Database Management System that supports multiple data models against one integrated backend. Organizations which are into the business of maintaining Data Warehouses or running OLTP transactions, prefer Oracle database the most, due to its variety of features which supports high performance, security and scalability with an ease of use. This module will equip you with the knowledge necessary to understand the architecture of oracle and learn why it is the market leader in DBMS and what makes it stand out among other DBMS
- Backup and Recovery Workshop –
Backup and recovery show you how to perform Oracle Database backup and recovery operations by using Oracle Recovery Manager (RMAN). After completing this module, you should be familiar with the basic concepts of Oracle Database backup and recovery operations, know how to implement a disk-based backup strategy, and use Oracle Flashback features.
- System Analysis and Design 2 –
System analysis and design 2 deal with planning the development of information systems through understanding and specifying in detail what a system should do and how the components of the system should be implemented and work together. System analysts solve business problems through analysing the requirements of information systems and designing such systems by applying analysis and design techniques. This module deals with the concepts, skills, methodologies, techniques, tools, and perspectives essential for systems analysts
- Oracle Forms Developer: Building Internet Apps –
Oracle Forms Developer, business application developers quickly build, in a declarative RAD environment, comprehensive Java client applications that are optimized for the Internet without writing any Java code, and that meet (and exceed) the requirements of professional user communities. These applications are rich, Web-deployed applications available on demand for rapid processing of large amounts of data and rapid completion of complex calculations, analysis, and transactions
- Oracle Reports Developer: Build Reports –
Oracle Reports is Oracle’s award-winning, high-fidelity enterprise reporting tool. It enables businesses to give immediate access to information to all levels within and outside of the organization in an unrivalled scalable and secure environment. This module will give you the necessary knowledge on how to deploy and build report
Red Hat Linux 8: System Administration II –
Red Hat System Administration II serves as the second part of training track for IT professionals who have taken Red Hat System Administration I. The course goes deeper into core Linux system administration skills in storage configuration and management, installation and deployment of Red Hat Enterprise Linux, management of security features such as SELinux, control of recurring system tasks, management of the boot process and troubleshooting, basic system tuning, and command-line automation and productivity.
What to learn next?
