News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Live Instructor-Led Training

The Power to Boost Productivity!


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Oracle Boot Camp

Course Code: OracleBootMH
Length: 10 Days
Tuition: $3,995.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

Prerequisites

Course Outline:

Oracle SQL Fundamentals
Unit 1:  Overview:  RELATIONAL DATABASES & SQL and CHOOSING A SQL & PL/SQL INTERFACE
Unit 2:     BUILDING A SELECT STATEMENT and RESTRICTING DATA WITH THE WHERE CLAUSE
Unit 3:     SORTING DATA WITH THE ORDER BY CLAUSE
Unit 4:     PSEUDO COLUMNS & FUNCTIONS
Unit 5:     JOINING TABLES
Unit 6:     USING THE SET OPERATORS
Unit 7:    USING SUB-QUERIES
Oracle Administration Level 1
Unit 1:     CONFIGURING THE SERVER FOR INSTALLATION
Unit 2:    VERIFY THE INSTALLATION
Unit 3:    UPGRADE, DEINSTALLATION & PATCHING
Unit 4:    MANUALLY STARTING & STOPPING DATABASE SERVICES
Unit 5:    EXPLORING THE ORACLE DATABASE ARCHITECTURE: General
Unit 6:    EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE MEMORY
Unit 7:    EXPLORING THE ORACLE DATABASE ARCHITECTURE: INSTANCE PROCESSES
Unit 8:    CREATING AN ORACLE DATABASE
Unit 9:    MANAGE DATABASE STORAGE STRUCTURES: TABLESPACES
Unit 10:     MANAGE DATABASE STORAGE STRUCTURES: ADVANCED TABLESPACES
Unit 11:    MANAGE DATABASE STORAGE STRUCTURES: DATA FILES & TEMP FILES
Unit 12:    MANAGING UNDO DATA
Unit 13:    NETWORK ENVIRONMENT: ORACLE NET SERVICES
Unit 14:    NETWORK ENVIRONMENT: ORACLE SHARED SERVERS
Unit 15:    SECURITY: IMPLEMENTING DATABASE SECURITY
Unit 16:    SECURITY: ADMINISTERING USER SECURITY
Unit 17:    MANAGING CONCURRENCY & LOCKS
ORACLE Boot Camp Week 2:  
SQL Fundamentals 2

SQL Fundamentals Level 2
Unit 1:     DATABASE OBJECTS: RELATIONAL VIEWS
Unit 2:    DATABASE OBJECTS: DATA DICTIONARY STORAGE
Unit 3:    DATABASE OBJECTS: INDEXES
Unit 4:    DATABASE OBJECTS: OTHER OBJECTS
Unit 5:    DATABASE OBJECTS: SECURITY
Unit 6:    DATA INTEGRITY USING CONSTRAINTS
Unit 7:    MANAGING CONSTRAINT DEFINITIONS
Oracle Administration Level 2
Unit 1:     MANAGING MEMORY
Unit 2:    MANAGING STORAGE & THE SEGMENT ADVISOR
Unit 3:    DIAGNOSING DATABASE PROBLEMS
Unit 4:    RECOVERY CONCEPTS
Unit 5:    ORACLE FLASHBACK TECHNOLOGY
Unit 6:    FLASHBACK DATABASE & FLASHBACK DATA ARCHIVE
Unit 7:    MANAGING RESOURCES
Unit 8:    AUTOMATING TASKS WITH THE SCHEDULER
Unit 9:    MANAGING DATABASE PERFORMANCE
Unit 10:     INSTANCE RECOVERY
Unit 11:    CONFIGURING RMAN
Unit 12:    BACKUP WITH RMAN
Unit 13:    RECOVERY WITH RMAN
Unit 14:    USING THE RMAN RECOVERY CATALOG
Unit 15:    DATABASE DUPLICATION & CLONING
Unit 16:    ADVANCED RMAN CAPABILITIES
Unit 17:    TRANSPORTING TABLESPACES
Unit 18:    RECOVERING FROM CORRUPTION WITH DATA RECOVERY ADVISOR

back to top