What's Your Why?

  • Boost Your Career

    Potential to change careers in as little as 8-12 weeks, qualifying to interview for six figure paying jobs. You'll learn new marketable skills employers are looking for in this fierce economy.

  • Refresh & Recertify

    Are you behind on your certifications? Career hit a low? This course will help you refresh your IT skills and get re-certified.

  • Family

    Need a more flexible career where by you can work from home and still generate substantial income? Need to generate more money for your family? This career field offers opportunities to work from home while still getting paid.

Course curriculum

  • 1
    Week 1: Linux Fundamentals
    • Linux Fundamentals I
    • Linux Fundamentals II
    • Linux Fundamentals III
    • Linux Fundamentals IV
    • Linux Fundamentals V
    • Differences Between Windows And Linux
    • What Is A Linux Operating System Prompt
    • How To Check System Requirements
    • Linux Commands: How To Move Forward In Linux
    • Linux Commands: How To Move Backwards In Linux
    • Linux Commands: What Is A Mount Point
    • Linux Commands: How To Create A Directory In Linux
    • Linux Commands: How To Create A File In Linux
    • Linux Commands:How To Copy A File Or Directory In Linux
    • Linux Commands: How To Move A File Or Directory In Linux
    • Linux Quizes
    • Linux Commands: How To Delete A File Or Directory In Linux
    • Linux Commands: How To List Directories In Linux
    • Linux Commands: How To Switch Users In Linux
    • Linux Commands: How To Change Permissions On A File In Linux
    • Linux Commands: How To Change Ownership In Linux
    • Linux Commands: How To Shutdown Your Server In Linux
    • Notes: Basic Unix Commands
    • Project 1
    • How To Turn In Your Homework Assignment
  • 2
    Week 2: SQL Language| Data Manipulation Language
    • About this week
    • Week 2: Part 1
    • Week 2: Part 2
    • Installing 12c Database Software
    • Creating A 12c Database With Sample Schema
    • How To Connect To An Oracle Database
    • How To Startup And Shutdown An Oracle Database
    • Select Statement- What Is A Server Parameter File
    • What Is A Controlfile
    • What Is A Datafile And Redolog File
    • Select Statements: Explaining Data Manipulation,Data Definition,Data Control Languages
    • Select Statement- Rules Of Select Statements| Select Statement Basics
    • Select Statement- Aliases| Select Statement Basics
    • Select Statement- Arithmetic Functions|Select Statement Basics
    • Select Statement- Case Functions|Select Statement Basics
    • SQL QUIZ PART 1
    • Select Statement- Concatenation|Select Statement Basics
    • Select Statement- Group By Clause|Select Statement Basics
    • Select Statement- Length Clause|Select Statement Basics
    • Select Statement- Replace Clause|Select Statement Basics
    • Select Statement- Left Pad And Right Pad|Select Statement Basics
    • Select Statement- NVL|Select Statement Basics
    • Select Statement- Instr|Select Statement Basics
    • Select Statement- Substr|Select Statement Basics
    • Select Statement-To-Char|Select Statement Basics
    • Select Statement- Where Clause Pt 1|Select Statement Basics
    • Select Statement-Where To + And Clause|Select Statement Basics
    • Select Statement- OR clause|Select Statement Basics
    • Select Statement- And Clause|Select Statement Basics
    • Select Statements- Where Clause contd|Select Statement Basics
    • Select Statement-Between clause|Select Statement Basics
    • Select Statement- Between Clause Contd|Select Statement Basics
    • SQL QUIZ PART 2
    • Select Statement-In clause|Select Statement Basics
    • Select Statement- Like|Select Statement Basics
    • Select Statement-Null Clause|Select Statement Basics
    • Select Statement- Putting It All Together|Select Statement Basics
    • Project 2
    • SQL CLASS NOTES
    • PROJECT 1 SOLUTIONS
  • 3
    Week 3: SQL Language II
    • Week 3: Part 1
    • Week 3: Part 2
    • Select Statement- Group by Clause|Select Statement Basics
    • Select Statement-GroupBY Clause Part2|Select Statement Basics
    • Select Statement-Group BY Clause Part 3|Select Statement Basics
    • Select Statement- How To Perform A Subquery|Select Statement Basics
    • Select Statement- How To Perform A Subquery Part 2|Select Statement Basics
    • Select Statement- How To Perform A Subquery Part 3|Select Statement Basics
    • Select Statement- What Is An Equijoin| Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 2 | Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 3| Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 4| Select from Multiple Tables
    • Select Statement- What Is An Equijoin Part 5| Select from Multiple Tables
    • Select Statement- What Is A Leftjoin| Select from Multiple Tables
    • Select Statement- What Is A Rightjoin| Select from Multiple Tables
    • Select Statement- Minus Clause| Select from Multiple Tables
    • Select Statement- Intersect Clause| Select from Multiple Tables
    • Select Statement- Union Clause| Select from Multiple Tables
    • SQL QUIZ PART 3
    • Select Statement- Union Clause| Select from Multiple Tables
    • Select Statement-Putting IT All Together| Selecting From Multiple tables
    • Project 3
    • SQL CLASS NOTES
    • PROJECT 2 SOLUTIONS
  • 4
    Week 4
    • About This Week
    • Week 4: Part 1
    • Week 4: Part 2
    • Data Definition Language- How To Connect To A New Schema
    • Data Definition Language- How to Create A Duplicate Table
    • Data Definition Language- Understanding Oracle Database Tables Datatypes
    • Data Definition Language- Table Column Level Constraints
    • Data Definition Language- Adding A Primary Key Constraint
    • Data Definition Language- Adding A Not Null Constraint
    • Data Definition Language- Adding Unique Constraint
    • Data Definition Language- Adding A Check Constraint
    • Data Definition Language-Adding A Foreign Key Constraint
    • Alter Statement- Adding A Table Constraint After Table Creation| Data Definition Language
    • Alter Statement- Disable Column Level Constraint After Table Creation|Data Definition Language
    • Alter Statement- Enabling A ColumnConstraint After Table Creation|Data Definition Language
    • Alter Statement- Dropping A Column Level Constraint After Table Creation|Data Definition Language
    • Alter Statement-Renaming A Column In A Table|Data Definition Language
    • Alter Statement- Renaming A Table|Data Definition Language
    • Alter Statement- Modify A Table Column|Data Definition Language
    • Alter Statement- Drop A Table Column|Data Definition Language
    • Alter Statement- Adding A Column To A Table|Data Definition Language
    • Insert Statement- Inserting Data Into A Table Column|Data Manipulation Language
    • Update Statement- Update Data In A Table Column|Data Manipulation Language
    • Deleting Data In A Table Column|Data Manipulation Language
    • Delete, Drop, Truncate In SQL
    • Data Definition Language-Creating A View
    • SQL QUIZ 4
    • Data Definition Language- Create A Sequence
    • Data Definition Language- Create A Sequence
    • Data Definition Language- Create An Index
    • Data Definition Language- Create A Synonym
    • Project 4
    • SQL CLASS NOTES
    • PROJECT 3 SOLUTIONS
  • 5
    Week 5
    • About This Week
    • Week 5: Part 1
    • Week 5: Part 2
    • Notes: Database Creation
    • Notes: Managing Oracle Instance
    • Notes: Oracle Database Architecture
    • Notes: User Management
    • How To Create An Oracle Database
    • Oracle Database Administration- Understanding The Oratab File|
    • Oracle Database Administration- Editing The Bash Profile
    • Oracle Database Administration- Understanding Spfile Part 2
    • Oracle Database Administration- Understanding The Export Command
    • Oracle Database Administration- Understanding The Echo Command
    • Oracle Database Administration- Understanding The Physical Structure Of An Oracle Database
    • Oracle Database Administration- Understanding The Logical Structure Of An Oracle Database
    • Oracle Database Administration- Difference The Between SPfile And Pfile
    • Oracle Database Administration-How To Create An Spfile And Pfile
    • Oracle Database Administration- Editing The Pfile
    • Oracle Database Administration- How To Start Oracle Database With The Pfile
    • Oracle Database Administration- How To View Spfile Parameters
    • Oracle Database Administration- Understanding Spfile Scopes
    • Oracle Database Administration- Understanding The Controlfile
    • Oracle Database Administration- Understanding Datafile
    • Oracle Database Administration- Understanding Redolog files
    • Oracle Database Administration- Understanding Archived Redologfiles
    • Oracle Database Administration- Understanding Dynamic Performance Views
    • Oracle Database Administration- Understanding How To Create A Tablespace And Datafiles
    • Oracle Database Administration- Understanding The 5 Default Tablespaces
    • Oracle Database Administration- Understanding Oracle Managed Files (OMF)
    • Oracle Database Administration- Understanding Tablespace Creation
    • Oracle Database Administration- Understanding How To Create Users In A Database
    • Oracle Database Administration- Understanding System Privileges
    • Oracle Database Administration- Understanding How To Create Roles
    • Oracle Database Administration- Understanding How To Create User Profiles
    • Oracle Database Administration- Understanding Enterprise Manager In 11g
    • Project 5
    • ORACLE ADMIN QUIZ 1
    • PROJECT 4 SOLUTIONS
  • 6
    Week 6
    • About This Week
    • Week 6: Part 1
    • Week 6: Part 2
    • Notes: Database Maintenance
    • Notes: Oracle_Network
    • Notes: Auditing
    • Project 6
    • Oracle Database Administration- Understanding Standard Auditing
    • Oracle Database Administration- Understanding Standard Auditing Part 2
    • Oracle Database Administration- Understanding How To Set Up Standard Audits
    • Oracle Database Administration- Understanding Setting Up Fine Grain Auditing
    • Oracle Database Administration- Understanding How To Set Up Finegrain Auditing contd
    • Oracle Database Administration- Understanding How To Disable Finegrain Audit Policies
    • Oracle Database Administration- Understanding How To Configure Oracle Listener
    • Oracle Database Administration- Explaining How To Control The Oracle Database Listener
    • Oracle Database Administration- Undestanding How To Configure The TNS Names.ora File
    • Oracle Database Administration- How to Register The Database A Listener Via Net Manager
    • Oracle Database Administration- Understanding How To Resolve Common Listener Issues
    • Oracle Database Administration- Understanding How Configure The Archivelog
    • Oracle Database Administration- Understanding How To Configure Fast Recovery Area
    • Oracle Database Administration- Understanding The Undo Tablespace
    • Oracle Database Administration- Understanding How To Configure The Undo Tablespace
    • Oracle Database Administration- Listener Definition
    • Oracle Database Administration- Listener Creation
    • Oracle Database Administration- Listener Modification
    • Oracle Database Administration- Understanding TNS Names.ora file
    • Oracle Database Administration-TNS Names Creation
    • Oracle Database Administration- Database Registration
    • Oracle Database Administration- Understanding Automatic Workload Repository (AWR)
    • Oracle Database Administration- Undestanding Automatic Workload Repository(AWR) Contd
    • Oracle Database Administration- Running An AWR Report
    • Oracle Database Administration- Running An ADDM Report
    • Oracle Database Administration- Identifying Blocking Sessions
    • Oracle Database Administration- Understanding The Optimizer
    • Oracle Database Administration- Optimizer Statistic Gathering
    • ORACLE ADMIN QUIZ 2
    • PROJECT 5 SOLUTIONS
  • 7
    Week 7
    • About This Week
    • Week 7: Part 1
    • Week 7: Part 2
    • Notes: Backup Concepts
    • Notes: Datapump
    • Notes: Flashback
    • Notes: Locks
    • Notes: Restore and Recovery
    • Notes: RMAN Backup
    • Project 7
    • Oracle Database Administration II- Connecting To Recovery Manager
    • Oracle Database Administration II- Setting Up RMAN Parameters
    • Oracle Database Administration II- Setting Up RMAN Contd
    • Oracle Database Administration II- Backing Up The Database Via Recovery Manager
    • Oracle Database Administration II- How To Recover From A SPfile Loss
    • Oracle Database Administration II- How To Recover From A Controlfile Loss
    • Oracle Database Administration II- How To Recover From A Datafile Loss
    • Oracle Database Administration II- How To Recover From A Redo Log File Loss
    • Oracle Database Administration II- How To Recover From A Loss Of All Physical Files
    • Oracle Database Adminsitration II- Backing Up The Controlfile To A Trace File
    • Oracle Database Administration II- Datapump Part 1
    • ORACLE ADMIN QUIZ 3
    • Oracle Database Administration II- Datapump Backup Part 2|
    • Oracle Database Administration II- Flashback Database
    • Oracle Database Administration II- Flashback Drop
    • Oracle Database Administration II- Flashback Table
    • Oracle Database Administration II- Resetting Sys Password File
    • ORACLE ADMIN QUIZ 4
    • Oracle Database Administration II- SQL LOADER Best Practices
    • RMAN Settings
    • PROJECT 6 SOLUTIONS
  • 8
    Week 8
    • About This Week
    • Week 8: Part 1
    • Week 8: Part 2
    • How To uninstall Oracle 12c Software From A Server
    • Oracle Upgrade Explained
    • Oracle Database Administration II- Upgrade 11.2.0.1 to 11.2.0.2
    • Oracle Database Administration II- Upgrade 11.2.0.1 to 11.2.0.2 Part 2
    • Upgrade From 11.2.0.4 To Oracle 12c
    • Upgrade From 11.2.0.4 To Oracle 12c Part 2
    • Upgrade From 11.2.0.4 To Oracle 12c Part 3
    • Oracle Database Administration II- Datafile Relocation Explained
    • Oracle Database Administration II- Critical Patch Update
    • Oracle Database Administration II- Sqldeveloper Basics
    • ORACLE ADMIN QUIZ 4
    • Oracle Database Administration II- Sqldeveloper New Connection
    • Oracle Database Administration II- Duplicating A Database Via Rman
    • Cloning A Database Via Recovery Manager Script
    • Project 8
    • Oracle Software
    • PROJECT 7 SOLUTIONS
  • 9
    WEEK 9 - FINAL EXAM
    • FINAL EXAM
  • 10
    ORACLE 12C ADMINISTRATION
    • How To Create A Container Database
    • How To Create A Pluggable Database From DBCA
    • How To Create A Pluggable Database From Seed
    • Registering The Container And PDB Databases With The TNS Names And Listener.ora Files
    • Registering The Container And PDB Databases With The TNS Names And Listener.ora Files Part 2
    • How To Move From One PDB To Another PDB Database
    • How To Put PDB Database In Archive Redo Log Mode
    • How To Save The State Of A Pluggable Database
    • How To Change Initialization Parameters In A Pluggable Database
    • Backing-Up-CDB-Database
    • Backing Up A Pluggable Database
    • Backing Up A Pluggable Database As PDB Admin
    • Backing Up A Tablespace In A Pluggable Database
    • Create-Common-User-For-Backups
    • Flashback CDB With Restore Point
    • FlashbackPDB-With-Restorepoint-Error
    • PDB-Tablespace-Loss-Recovery
    • Creating A Common User
    • Creating A Common User Locally
    • Creating A Common Role
    • Granting A Common Role To A Common User
    • Revoking A Common Role
    • 12C PROJECT

Course Enrollment Cost