Cambridge Intercontinental University Career Certification ProgramRecommended training resource for Cambridge Certified Database Associate certification.Take CCDA Online Test here... More Free Certifications
Oracle Database Administration Fundamentals IThis is the second in a series of courses, aimed at preparing the user for Oracle Certification Exam # 1Z0-031. This course will teach Oracle database administration fundamentals; installing Oracle, creating databases, managing objects in the database and more. This course expands on the first course offered by VTC (Introduction to Oracle SQL and PL/SQL). Following courses will include: Oracle Database Administration Fundamentals II and Oracle Database Performance Tuning. To get started, click one of the movie topics below.
WelcomeWelcomePrerequisites for this Course About this Course Technet Database Administration Manuals Database AdministrationOracle Database Administration? pt. 1Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration ToolsWhat are the Tools?SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of OracleOracle Database ArchitectureMemory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a DatabaseThe Oracle Installer pt. 1The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a DatabaseConnecting to a DatabaseSTARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration ParametersWhat is the Parameter File?Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical DatabaseDDL and the Physical Database?The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical DatabaseWhat is the Logical Database?Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database ObjectsTables pt. 1Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database AdministrationTypes of UsersGrants and Revokes Create and Alter User Syntax Administration Users Database Auditing SchedulingThe DBMS_JOB PackageJob Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix UtilitiesExportImport SQL*Loader ORAPWD and ORADIM Built-In PackagesSupplied PackagesScripting for AutomationSome Example ScriptsCreditsAbout the Author | ||