❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.

Updated in [July 18th, 2023]

This course, Oracle 11g 18c: Database Administration and Data Analysis, is designed for beginners who are considering a career as a database administrator. It will guide students through some of the tasks that an Oracle database administrator has to perform, such as installing new versions of the Oracle database and its tools, managing users, monitoring the database, creating database objects, and troubleshooting problems. Additionally, the course will cover Oracle Application Express (APEX), a low-code development platform that enables users to build scalable, secure enterprise apps. Finally, the course will teach students the basics of SQL, a language used to wrangle and extract data from relational databases. Upon completion of the course, students will have the skills necessary to confidently work as an SQL professional.

Course Syllabus

Introduction

Oracle Database Server Setup

Oracle SQL Sub Languages

ORACLE SQL Data Analysis & Manipulation

Monitoring Oracle Database

Oracle Database Accounts & Security

Database Backup & Recovery

Oracle Database Server Management

Managing UNDO Data

Building Web Apps with Oracle with APEX

Data Analysis with Oracle SQL Analytic Functions

Data Analysis with Oracle SQL Logical Operators

Data Analysis with Oracle SQL SET Operators

Analysing Data from multiple tables with Oracle SQL

Data Analysis with SQL Aggregate Functions

Practical Real World Oracle SQL Examples