×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

Oracle Database Essentials

Track :

Computer Science

Lessons no : 99

For Free Certificate After Complete The Course

To Register in Course you have to watch at least 30 Second of any lesson

Join The Course Go To Community Download Course Content

What will you learn in this course?
  • Master SQL query writing, database design, and data modeling for Oracle databases using practical techniques and best practices
  • Implement Oracle database installation, configuration, and maintenance to ensure optimal performance and security
  • Apply backup, recovery, and disaster recovery strategies to protect Oracle databases against data loss and system failures
  • Optimize Oracle database performance through indexing, tuning, and resource management techniques
  • Manage user access, roles, and privileges to ensure secure and compliant database environments
  • Utilize Oracle tools and utilities for effective database administration and troubleshooting
  • Design and implement scalable, high-availability Oracle database architectures for enterprise applications
  • Analyze and interpret database performance metrics to identify and resolve bottlenecks efficiently
  • Develop and deploy PL/SQL procedures, functions, and triggers for automation and data integrity
  • Understand Oracle database architecture, including memory structures and storage management principles
  • Implement data security measures, including encryption and auditing, to safeguard sensitive information
  • Configure and manage Oracle Data Guard for disaster recovery and data replication scenarios
  • Perform database upgrades, patches, and migrations with minimal downtime and data integrity risks
  • Apply best practices for database normalization, denormalization, and schema design for efficiency
  • Utilize Oracle Enterprise Manager for comprehensive database monitoring, management, and reporting
  • Troubleshoot common Oracle database issues using diagnostic tools and logs for quick resolution

How to Get The Certificate

  • You must have an account Register
  • Watch All Lessons
  • Watch at least 50% of Lesson Duration
  • you can follow your course progress From Your Profile
  • You can Register With Any Course For Free
  • The Certificate is free !
Lessons | 99
CPT 0 Oracle Database Administration Workshop I Oracle Database Server Oracle Database Course
00:05:22

CPT 0 Oracle Database Administration Workshop I Oracle Database Server Oracle Database Course
CPT 1 What is Oracle Database Server What is Instance What is Oracle Database
00:07:09

CPT 1 What is Oracle Database Server What is Instance What is Oracle Database
CPT 2 What is 3 Tire Architecture || 3 Tire Architecture with Standalone vs RAC database
00:03:28

CPT 2 What is 3 Tire Architecture || 3 Tire Architecture with Standalone vs RAC database
CPT 3 Connecting to the Database Instance tnsnames ora Connection String What is tnsnames ora
00:09:31

CPT 3 Connecting to the Database Instance tnsnames ora Connection String What is tnsnames ora
CPT 4 Connecting to the Database Instance listener ora Client Connection What is listnere ora
00:07:40

CPT 4 Connecting to the Database Instance listener ora Client Connection What is listnere ora
CPT 5 Database Connection Client Connectivity Dedicated Server Process || Shared Server Process
00:05:24

CPT 5 Database Connection Client Connectivity Dedicated Server Process || Shared Server Process
CPT 6 Oracle Database Server Architecture Overview Oracle Database Basic Understanding
00:17:14

CPT 6 Oracle Database Server Architecture Overview Oracle Database Basic Understanding
CPT 7 Oracle Database Installation Types How to Install Oracle database GUI and Silent Mode
00:05:04

CPT 7 Oracle Database Installation Types How to Install Oracle database GUI and Silent Mode
CPT 8 Listener Dynamic Registration and Static Registration Why do we need local listener
00:15:23

CPT 8 Listener Dynamic Registration and Static Registration Why do we need local listener
CPT 9 Database Types in Oracle Standalone Oracle Restart RAC Onenode RAC || Database Basics
00:14:42

CPT 9 Database Types in Oracle Standalone Oracle Restart RAC Onenode RAC || Database Basics
CPT 10 Installation Changes in 11g 12c and 19c GI Home DB Home Installation Oracle Database
00:04:40

CPT 10 Installation Changes in 11g 12c and 19c GI Home DB Home Installation Oracle Database
11204 Oracle Home Installation in GUI Mode || OH Installation || Oracle Binaries Installation
00:20:37

11204 Oracle Home Installation in GUI Mode || OH Installation || Oracle Binaries Installation
11204 Database Creation in GUI Mode
00:24:30

11204 Database Creation in GUI Mode
11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 1
00:05:25

11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 1
11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 2
00:04:03

11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 2
11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 3
00:03:51

11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 3
11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 4
00:02:43

11 2 0 4 Standalone Grid Infrastructure GI Installation DB Home Database Creation Part 4
Oracle Database 19c installation and configuration || Container and PDB creation on Linux 7
00:29:02

Oracle Database 19c installation and configuration || Container and PDB creation on Linux 7
database delete using dbca || drop database in GUI mode
00:06:30

database delete using dbca || drop database in GUI mode
Drop Database Delete Database manual method or GUI mothod
00:10:26

Drop Database Delete Database manual method or GUI mothod
listener ora and tnsnames ora configuration using netca netmgr
00:12:25

listener ora and tnsnames ora configuration using netca netmgr
Archivelog mode and Noarchivelog mode in Oracle database || How to database modes
00:08:59

Archivelog mode and Noarchivelog mode in Oracle database || How to database modes
orapwd utility || Password File management in Oracle database
00:17:44

orapwd utility || Password File management in Oracle database
How to identify any parameter as static or dynamic using v aparameter || ISSYS MODIFIABLE
00:14:22

How to identify any parameter as static or dynamic using v aparameter || ISSYS MODIFIABLE
Manual Oracle Home Cloning || 11g Release 2 11 2 0 4
00:16:34

Manual Oracle Home Cloning || 11g Release 2 11 2 0 4
Inventory Concepts in Oracle Database Central Inventory and Local Inventory || Database Patching
00:20:27

Inventory Concepts in Oracle Database Central Inventory and Local Inventory || Database Patching
Oracle Patching Demo || PSU Patching || 11g Release 2 11 2 0 4 || OPatch
00:30:41

Oracle Patching Demo || PSU Patching || 11g Release 2 11 2 0 4 || OPatch
Create ASM RECO diskgroup using ASMCA || Database administration ASMCMD
00:12:31

Create ASM RECO diskgroup using ASMCA || Database administration ASMCMD
Oracle Database Release Numbers and Support lifetime Primer Support and Extended Support
00:15:07

Oracle Database Release Numbers and Support lifetime Primer Support and Extended Support
Network tnsping Network Ping and Host Ping listener ora and tnsname ora configuration netmgr
00:16:30

Network tnsping Network Ping and Host Ping listener ora and tnsname ora configuration netmgr
Database Startup and Shutdown Sequence in Standalone and RAC What are database startup phases
00:24:48

Database Startup and Shutdown Sequence in Standalone and RAC What are database startup phases
DBA Basic Checks || Database Daily Health Check || Database health Check Automation Shell Script
00:19:08

DBA Basic Checks || Database Daily Health Check || Database health Check Automation Shell Script
Database Health Check Automation Using Shell Script || Oracle DBA Checklist
00:11:43

Database Health Check Automation Using Shell Script || Oracle DBA Checklist
19c Oracle DBA Training Announcement || Course Details || Course Starting on 1 Jun 2021
00:47:57

19c Oracle DBA Training Announcement || Course Details || Course Starting on 1 Jun 2021
Oracle OEL 7 9 Installation Configuration VirtualBox || Post Installation Steps || YUM repo
00:26:46

Oracle OEL 7 9 Installation Configuration VirtualBox || Post Installation Steps || YUM repo
Database Migration or Switching to Different Oracle Home || Oracle Home Cloning || Standalone DB
00:12:12

Database Migration or Switching to Different Oracle Home || Oracle Home Cloning || Standalone DB
Drop Database Manual or Drop Database Using dbca GUI and Deinstall Oracle Home || DB OH Cleanup
00:12:21

Drop Database Manual or Drop Database Using dbca GUI and Deinstall Oracle Home || DB OH Cleanup
nid DBNEWID Changing DBID and Changing DBNAME in Oracle || NID Utility in Oracle
00:40:14

nid DBNEWID Changing DBID and Changing DBNAME in Oracle || NID Utility in Oracle
Cleanup Old GI and DB homes || Deinstall Old GI DB Homes After GI and DB upgradation || Inventory
00:14:03

Cleanup Old GI and DB homes || Deinstall Old GI DB Homes After GI and DB upgradation || Inventory
DROP ASM Instance || servctl remove asm || How to Delete ASM from Clusterware || GI Home Cleanup
00:28:58

DROP ASM Instance || servctl remove asm || How to Delete ASM from Clusterware || GI Home Cleanup
Show More Lessons


We Appreciate Your Feedback

Be the First One Review This Course

Excellent
0 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
0
0 Reviews

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

Related Courses

Linear Algebra for Computer Scientists
7 Lessons

Linear Algebra for Computer Scientists

Insertion Sort
3 Lessons

Insertion Sort

Bubble Sort
4 Lessons

Bubble Sort

GCSE Computer Science
18 Lessons

GCSE Computer Science

Random Access Memory
7 Lessons

Random Access Memory

Binary Trees
4 Lessons

Binary Trees

Bitwise Operators
4 Lessons

Bitwise Operators

Introduction to Stacks Data Structures
17 Lessons

Introduction to Stacks Data Structures

Organization Theory Structure and Design
41 Lessons

Organization Theory Structure and Design

Handling Large Scale Unit Level Data
41 Lessons

Handling Large Scale Unit Level Data

Introduction to Machine Learning
19 Lessons

Introduction to Machine Learning

Applied Linear Algebra Vectors Matrices
54 Lessons

Applied Linear Algebra Vectors Matrices

Artificial Intelligence beginners
1 Lessons

Artificial Intelligence beginners

Machine Learning Autumn 2018
1 Lessons

Machine Learning Autumn 2018

Robotics and Autonomous Systems
15 Lessons

Robotics and Autonomous Systems

Natural Language Understanding
15 Lessons

Natural Language Understanding

Oracle Database Essentials course, in this course Explore the core concepts and principles that form the foundation of Oracle Database management in this essential course.