Oracle 11G | 18C : Database Administration,Data Analysis

Learn Oracle SQL, Database Administration , Data Analysis, Oracle web application development

What you'll learn
Installing Oracle Database 11g & 18c
Installing TOAD & Oracle Developer
Unlock Sample Schema
Perform CRUD Operations
Data Analysis & Manipulation
Monitoring Oracle Database
Oracle Database Accounts & Security
Oracle Database Backup & Recovery
Oracle Database Server Management
Build Web Apps using Oracle Apex
Data Analysis with Oracle SQL Analytic Functions
Data Analysis with Oracle SQL SET Operators
Data Analysis with Oracle SQL Logical Operators
Data Analysis with Oracle SQL Aggregate Functions
Practical Real World Oracle SQL Examples
Requirements
Computer and internet access required
Description
Oracle Database Administrator's are in constant demand in the IT industry.The  rapid growth of data has fueled the demand for database administrator's in general.  We are more than before reliant on data in our everyday life either through the use of social media with applications like Facebook,Instagram Whatsapp ,Twitter and may more data rich applications.This course is designed for beginners who are considering a career as a database administrator. It will guide you through some of the tasks that an Oracle database administrator has to perform.Oracle DBA Responsibilities includes:Installing new versions of the Oracle database and its toolsInstalling tools  required to access the Oracle database. Shutting down and Starting the databaseBacking up and Recovering DataExporting and Importing DataManaging UsersManaging security of the databaseMonitoring the databaseCreating database objects like databases, tables and viewsCreate new database users as required.Upgrading the databasePlans and implements backup and recovery of the Oracle database.Assists with impact analysis of any changes made to the database objects.Provides technical support to application development teamsEnforces and maintains database constraints to ensure integrity of the database.Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Troubleshooting  problems regarding the databases, applications and development tools.What is Oracle APEX?Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps, with world-class features, that can be deployed anywhere.Using APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. You won't need to be an expert in a vast array of technologies to deliver sophisticated solutions. Focus on solving the problem and let APEX take care of the rest.SQL is everywhere, and I'm not saying that because I want you to use it. It's just a fact. I bet you have some in your pocket right now. All Android Phones and iPhones.  SQL for several years and currently is the most in demand IT Skill requested by recruiters and employers. It is used anywhere there is a database present.  It runs banks, hospitals, universities, governments, small businesses, large ones, just about every computer and every person on the planet eventually touches something running SQL. SQL is an incredibly successful and solid technology that has been around for years and will be here for a long time to come.By learning SQL, you actually will learn important theoretical and practical concepts that apply to nearly every data storage system past and present .SQL Skills will greatly improve your job prospects either as a contractor or full time employment. It is a useful skill that is always in demand due to its usefulness. It’s everywhere there is a database. The skills you learn on this course will be enough to confidently work as an SQL professional.The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. To be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL . This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle.

Overview

Section 1: Introduction

Lecture 1 Course Introduction

Lecture 2 What is Oracle database

Lecture 3 What is Oracle 18c

Lecture 4 What is SQL

Lecture 5 What is database administration

Lecture 6 Oracle DBA Responsibilities

Lecture 7 Oracle Database Developer Responsibilities

Section 2: Oracle Database Server Setup

Lecture 8 Oracle Database Hardware Preinstallation

Lecture 9 Oracle Database Software Preinstallation

Lecture 10 Oracle Database Download Link

Lecture 11 Download Oracle 11g

Lecture 12 Install Oracle 11g

Lecture 13 Unlock sample schema for Oracle 11g

Lecture 14 Install Oracle 18c

Lecture 15 What is SQLPlus

Lecture 16 Unlock sample schema for Oracle 18c

Lecture 17 Install Oracle Developer

Lecture 18 Connect to Oracle Database with SQL Developer

Lecture 19 Install TOAD

Lecture 20 Connect to Oracle Database with TOAD

Section 3: Oracle SQL Sub Languages

Lecture 21 Introduction

Lecture 22 What is CRUD

Lecture 23 DDL : CREATE : Part 1

Lecture 24 DDL : CREATE : Part 2

Lecture 25 Oracle SQL INSERT Statement

Lecture 26 DML SELECT

Lecture 27 DML UPDATE & DELETE

Lecture 28 DDL ALTER | TRUNCATE | DROP

Section 4: ORACLE SQL Data Analysis & Manipulation

Lecture 29 Oracle Data Types & Constraints

Lecture 30 Using the FROM Clause

Lecture 31 Using the WHERE clause

Lecture 32 Using ORDER BY Clause

Lecture 33 Limiting & sorting data

Lecture 34 Using ALiases

Lecture 35 Excluding duplicate records

Lecture 36 Null Values

Lecture 37 Analyse data using LIKE Operator

Lecture 38 Grouping Data

Section 5: Monitoring Oracle Database

Lecture 39 Introduction

Lecture 40 Monitor & view database sessions

Lecture 41 Monitor Top SQL Statements

Lecture 42 Monitor Long Operations

Section 6: Oracle Database Accounts & Security

Lecture 43 Types of Oracle Database Users

Lecture 44 How to create new user with DBA Access

Lecture 45 Predefined administrative accounts

Lecture 46 SysDBA Vs SysOPER

Lecture 47 Establishing database security policy

Lecture 48 Priviledges and Roles

Lecture 49 Managing Oracle Database Users

Lecture 50 Creating a new database user

Lecture 51 Auditing Database Activities

Lecture 52 Predefined Oracle Database Accounts

Section 7: Database Backup & Recovery

Lecture 53 Introduction

Lecture 54 Enable ARCHIVELOG Mode

Lecture 55 Backup Database

Lecture 56 Restore and Recover Database

Lecture 57 View and restore historical data

Lecture 58 Recover Dropped (Deleted) Tables

Section 8: Oracle Database Server Management

Lecture 59 How to shutdown oracle database server

Lecture 60 How to start Oracle database server

Lecture 61 Database Schema

Lecture 62 What is a Tablespace

Lecture 63 How to create a Tablespace: Part 1

Lecture 64 How to create a Tablespace: Part 2

Section 9: Managing UNDO Data

Lecture 65 What is UNDO Data

Lecture 66 UNDO Tablespace

Lecture 67 UNDO Retention

Lecture 68 Configure UNDO Retention

Lecture 69 What is a Transaction

Lecture 70 REDO Log Files

Lecture 71 UNDO vs REDO Data

Section 10: Building Web Apps with Oracle with APEX

Lecture 72 What is APEX

Lecture 73 Apps built with APEX

Lecture 74 How to login to APEX

Lecture 75 How to display Schema Objects

Lecture 76 Creating APEX Workspace

Lecture 77 What we will build

Lecture 78 Creating the CRUD App

Lecture 79 Modify the app view

Lecture 80 Create APEX User

Lecture 81 Publish App to end users

Lecture 82 Performing CRUD Operations

Section 11: Data Analysis with Oracle SQL Analytic Functions

Lecture 83 What are Analytic Functions

Lecture 84 Analytic Functions Syntax

Lecture 85 Partition By Clause

Lecture 86 Order By Clause

Lecture 87 Introduction to Windowing Clause

Lecture 88 Working with a default windowing clause

Lecture 89 Using Rows and a Windowing clause

Lecture 90 Using a Range with a windowing clause

Lecture 91 Using Between And in windowing clause

Lecture 92 Multiple windows into your data

Lecture 93 Row Number Functions

Lecture 94 Rank Functions

Lecture 95 Dense Rank Function

Lecture 96 LEAD Function

Lecture 97 Lag Function

Lecture 98 First and Last Functions

Lecture 99 ListAgg Function

Section 12: Data Analysis with Oracle SQL Logical Operators

Lecture 100 What are Logical Operators

Lecture 101 Data Analysis with ALL Operator

Lecture 102 Data Analysis with ANY Operator

Lecture 103 Data Analysis with IN Operator

Lecture 104 Data Analysis with AND Operator

Lecture 105 Data Analysis with OR Operator

Lecture 106 Data Analysis with IS NULL Operator

Lecture 107 Data Analysis with NOT Operator

Section 13: Data Analysis with Oracle SQL SET Operators

Lecture 108 What are SET Operators

Lecture 109 Data Analysis with INTERSECT SET Operators

Lecture 110 Data Analysis with UNION SET Operator

Lecture 111 Data Analysis with MINUS SET Operator

Section 14: Analysing Data from multiple tables with Oracle SQL

Lecture 112 Introduction to Table Joins

Lecture 113 Analysing data with SELF Joins

Lecture 114 Analysing data with OUTER Joins

Lecture 115 Analysing data with CARTESIAN Join

Lecture 116 Analysing dat with EQUI Join

Lecture 117 Analysing data with NON EQUI Join

Section 15: Data Analysis with SQL Aggregate Functions

Lecture 118 What are Aggregate Functions

Lecture 119 Analysing data with AVG Aggregate Functions

Lecture 120 Analysing data with COUNT Aggregate Functions

Lecture 121 Analysing data with MIN Aggregate Functions

Lecture 122 Analysing data with MAX Aggregate Functions

Lecture 123 Analysing data with SUM Aggregate Functions

Section 16: Practical Real World Oracle SQL Examples

Lecture 124 Determine total employees with SQL

Lecture 125 Update employees salaries with SQL

Lecture 126 Create employee salary report with SQL

Lecture 127 Add new record into database with SQL

Lecture 128 Create s new table with SQL

Lecture 129 Delete record from database

Lecture 130 Produce a report of hire date for employees

Beginner Database Administrator,Beginner Data Analyst,Beginner Data Scientist,Beginner Data Engineer