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

Homepage

https://www.udemy.com/course/oracle-11g-18c-database-administrationdata-analysis/