Oracle Tutorial
-
Oracle Tutorial / Course main topics:
ENTERPRISE EDITION INSTALLATION
• IDENTIFY SYSTEM REQUIREMENTS
• THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
• ORACLE_BASE
• ORACLE_HOME
• CONFIGURE THE INSTALLATION ENVIRONMENT
• ENTERPRISE EDITION INSTALLATION • DBCATHE ADMINISTRATOR INTERFACE
• ENTERPRISE MANAGER TOUR
• USING EM SQL WORKSHEET
• DUTIES OF A DATABASE ADMINISTRATOR
• EXPLORING THE ORACLE DATABASE ARCHITECTURE: GENERALTHE ORACLE ENTERPRISE ARCHITECTURE
EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
• WHAT IS AN ORACLE DATABASE INSTANCE?
• MORE ABOUT THE SYSTEM GLOBAL AREA (SGA)
• ABOUT THE PGA • MANAGING MEMORYEXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSESCREATING AN ORACLE DATABASE
• CREATE A NEW DATABASE
• CONFIGURE AN EXISTING DATABASE
• DROP A DATABASE
• MANAGE DBCA TEMPLATES
• MANUALLY CREATE A DATABASEMANAGING THE DATABASE INSTANCE
• CONFIGURING A LINUX ENVIRONMENT
• STARTING & STOPPING DATABASE CONTROL
• STARTING & STOPPING THE DATABASE LISTENER
• STARTING & STOPPING THE DATABASE INSTANCE
• MORE ABOUT THE DATABASE FILESMANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
• ABOUT TABLESPACES
• TABLESPACE MANAGEMENT
• DROP TABLESPACE
• ALTER TABLESPACEMANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
• MORE ABOUT TEMPORARY TABLESPACES
• ABOUT TEMPORARY TABLESPACE GROUPS
• MORE ABOUT PERMANENT TABLESPACES
• MORE ABOUT BIGFILE TABLESPACES
• MORE ABOUT THE SYSAUX TABLESPACEMANAGE DATABASE STORAGE STRUCTURES
• DATA FILES & TEMP FILES
• MANAGING DATA FILES
• MANAGING TEMP FILES
• ENABLE ORACLE-MANAGED FILES (OMF)MANAGING UNDO DATA
• ABOUT UNDO SPACE MANAGEMENT
• CONFIGURE AUTOMATIC UNDO MANAGEMENT
• UNDO_MANAGEMENT
• UNDO_TABLESPACE
• UNDO_RETENTION
• GUARANTEE UNDO RETENTION
• MONITOR UNDO SPACE
• USE THE UNDO ADVISORNETWORK ENVIRONMENT: ORACLE SHARED SERVERS
• SHARED SERVERS ARCHITECTURE
• CONFIGURE SHARED SERVERS
• MONITOR SHARED SERVERS
• V$SHARED_SERVER
• V$SHARED_SERVER_MONITOR
• V$SESSION
• V$CIRCUIT
• V$DISPATCHER & V$DISPATCHER_CONFIG
• V$QUEUESECURITY: IMPLEMENTING DATABASE SECURITY
• DATABASE SYSTEM PRIVILEGES
• DATABASE OBJECT PRIVILEGES
• ADMINISTRATOR AUDITING OF DATABASE ACTIVITY
• ENHANCED DEFAULT SECURITY SETTINGSSECURITY: ADMINISTERING USER SECURITY
• CREATE & MANAGE DATABASE ACCOUNTS
• GRANT & REVOKE DATABASE PRIVILEGES
• RESOURCE LIMITS VIA PROFILES
• ALTER PROFILE
• DROP PROFILE
• PASSWORD MANAGEMENT VIA PROFILES
• ABOUT ROLE-BASED SECURITY
• WITH ADMIN OPTION
• ALTER USER…DEFAULT ROLE
• SET ROLE
• ENHANCED DEFAULT SECURITY SETTINGSMOVING DATA: SQL LOADER
• LOADER CONCEPTS
• CONTROL FILE OPTIONS
• LOAD METHODS
• USING THE EM INTERFACEMOVING DATA: EXPORT & IMPORT
• MANAGE DIRECTORY OBJECTS
• ABOUT THE DATA PUMP ARCHITECTURE
• DATA PUMP EXPORT
• DATA PUMP IMPORT
• DATA PUMP DATA DICTIONARY VIEWS
• USING THE EM INTERFACEDATABASE MAINTENANCE & PERFORMANCE MANAGEMENT
• THE MANAGEMENT & ADVISORY FRAMEWORK
• MANAGE THE AUTOMATIC WORKLOAD REPOSITORY
• AUTOMATIC DATABASE DIAGNOSTIC MONITOR
• USE METRICS & ALERT THRESHOLDS
• AUTOMATIC MAINTENANCE TASKSMANAGING CONCURRENCY & LOCKS
• ABOUT LATCHES & LOCKS
• MANAGE & MONITOR LATCHES
• MANAGE & MONITOR LOCKS
• V$LOCK
• V$LOCKED_OBJECT
• V$SESSION
• V$SESSION_WAIT
• DBA_BLOCKERS & DBA_WAITERS
• DBA_DML_LOCKS & DBA_DDL_LOCKS
• DML_LOCKSBACKUP & RECOVERY CONCEPTS & CONFIGURATION
• ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
• MANAGING REDO DATA
• MANAGING ARCHIVAL DATA
• AUTOMATIC CRASH RECOVERY
• CREATING A BASIC BACKUP STRATEGY
Oracle Tutorial for beginners. This video tutorial helps to understand and learn Oracle in few minutes. Once you are done with this introduction tutorial you will get the basic understanding of Oracle and then you can goto detailed tab to become an Oracle expert.The following video gives the Oracle fundamentals. Simple fast easy Oracle learning.
-
Oracle tutorial detailed topic wise explanation videos.
1/5SCPT 1: What is Oracle Database ServerSCPT 2: Connecting To Database Instance In Dedicated Server ModeSCPT 4: Introduction to File Structures in DatabaseSCPT 21: Oracle Back Ground Processes ( CKPT, DBWR, LGWR, ARCH)SCPT 3: Connecting To Database Instance In Shared Server ModeSCPT 10: Introduction to Oracle Memory StructureSCPT 47: Oracle Storage Parameters: PCTFREE and PCTUSEDSCPT 20: Oracle Back Ground Processes (PMON,SMON,RECO)SCPT 23: Oracle Slave ProcessesSCPT 46:Oracle Storage Termininology: High Water Mark and Free ListsSCPT 8: Redo Log FilesWhat is Oracle? A Video TutorialSCPT 43: How Commit and Rollback Works in OraclePrivate videoSCPT 5: Parameter Files in Database1/5 -
PL/SQL Oracle tutorial, Oracle introduction, PL/SQL basics:
Codepen Oracle application example:
See the Pen Oracle instant search example demo by Shahansha shaik (@shahansha) on CodePen.
Top Oracle Interview Questions:
Oracle Quick reference pdf and guide:
Oracle references and useful links:
Oracle self learning tutorial – Click hereTopic link Learn Oracle in PDF Click here Oracle Official website : http://www.oracle.com/index.html Official Oracle tutorial: https://www.w3.org/ Self learning Oracle tutorials: http://www.oracle.com/technetwork/tutorials/index.html Oracle cheat Sheet: Click here