❗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
