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 Oracle Software FREE PREVIEW
- 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
- LINUX PROJECT 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 FREE PREVIEW
- 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- Datafile Relocation 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
- 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
- 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
-
9
WEEK 9
- FINAL EXAM
-
10
ORACLE 12C ADMINISTRATION
- How To Uninstall The Oracle Software Completely From Your Server
- 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
- 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
- Backing-Up-CDB-Database
- Backing-Up-CDB-Database
- Backing-Up-PDB-Database
- Backing-Up-PDB-Database-AS-PDBADmin
- Backing-Up-PDB-Tablespace-Database
- Create-Common-User-For-Backups
- FlashbackCDB-With-Restorepoint
- FlashbackPDB-With-Restorepoint-Error
- PDB-TablespaceLoss-recovery
- 12C PROJECT
-
11
WEEK 11- AWS SOLUTIONS ARCHITECT- BUCKET MGMT
- Logging Into AWS Console
- Signing Up For A New AWS Console
- Getting Familiar With AWS Console
- Identify Access Management Initial Setup
- Creating Billing Alarms
- Creating AWS Organizations
- Grant Access To Users In A Different Account
- Cross Region Replication
- Creating An S3 Bucket
- Steps To Deleting An S3 Bucket
- Steps To Uploading Files Into An S3 Bucket
- Granting Permission on S3 Bucket Objects
- Granting Permission on S3 Bucket Objects Part 2
- Granting Permission on S3 Bucket Objects Part 3
- Creating Lifecycle Rules
- Understanding Bucket Versioning
- Enabling Bucket Versioning
- Suspending Bucket Versioning
- Understanding the Unique ID for Bucket Versioning
- Bucket Versioning- Delete A File and Updating Storage Class
- Encrypting Your Bucket and Files
-
12
WEEK 11 - AWS SOLUTIONS ARCHITECT- USER MGMT
- Creating Users In The AWS Console
- Delete An IAM User Via AWS Console
- How To Download The csv file After Creating Users
- How To Log In As A New IAM User
- How to Email A New User Account Credentials
-
13
WEEK 11 - AWS SOLUTIONS ARCHITECT- CLI MGMT
- Installing AWS Command Line Interface
- Configuring and Completing AWI CLI
- Setting Up Environmental Variables
- AWS CLI Man Page Basics
- AWS CLI Command Basics - Using Different Text Outputs
- AWS CLI Command Basics - Using the Help Command
- Creating and Using a Key Pair
- Creating and Launching a New Instance
- Creating a New Key Pair Using AWS CLI
- Deleting an EC2 Instance Using AWS CLI
- Creating an S3 Bucket Using AWS CLI
- Creating an S3 Bucket In A Different Region Using AWS CLI
-
14
WEEK 11 - AWS SOLUTIONS ARCHITECT- S3 MGMT
- Copying a File Into an S3 Bucket
- Moving a File Into an S3 Bucket
- Moving a File From an S3 Bucket To Local Storage
- Synchronizing a File From a Local Storage To S3 Bucket
- Synchronizing a File From a Local Storage To A Subfolder In an S3 Bucket
- S3 Transfer Acceleration
- Creating Cloud Front Distribution
- Creating A Static Website
- Removing a File From an S3 Bucket Using AWS CLI
- Creating A Lifecycle Policy For Objects In a Bucket
- Creating A Lifecycle Policy to Permanently Delete Objects in A Bucket
- Creating Pre-Signed URLs
- Creating Pre-signed URLs With 60 Sec Expiration
- Creating A Group
- Creating A User And Assigning User To A Group
- Logging In Via CLI With an IAM User Credentials
- How To Replicate A Bucket From One Region To Another
- How To Create A Bucket Policy
- How To Test A Bucket Policy
- How To Delete A Bucket Policy
- Configuring MFA Delete For S3 Buckets
- Configuring MFA Delete For S3 Buckets part 2
- Understanding IAM User Roles
- Creating Restrictive Policies
- Creating A Role
- Attaching A Role To An Instance
- Connecting To An Instance Via SSH
-
15
WEEK 12 - AWS SOLUTIONS ARCHITECT- VPC MGMT
- Creating A Custom VPC
- Creating Custom Subnets
- Creating Custom Route Tables
- Creating Custom Internet Gateways
- Connecting Internet Gateways To Subnet Automatically
- Creating Instances Inside Subnets
- Connecting To Public EC2s
- Attempting To Connect To Private EC2s
- Connecting To Private EC2s Via Public Ec2
- Connecting To An EC2 Instance Remotely Part 2
- Creating A NAT Gateway
- Connecting NAT Gateway To Private EC2 Instance
- Creating Network ACL's
- Creating An EC2 Instance And Apache Web Page
- Navigating Your EC2 Instance
- Terminating Your EC2 Instance
- Creating EBS Volumes
- Creating New Snapshots and AMI's From An EBS Block Storage
- Encrypting An EC2 Instance After Creation
- Configuring EC2 Hybernation
- Configuring CloudWatch For More Frequent Updates
- AWS CLI - Launching An EC2 Instance From Scratch
- AWS CLI - Creating New Tags For An EC2 Instance
- AWS CLI - Searching For Instances By Instance Type
- AWS CLI - Searching For Instances By AMI Type
- AWS CLI - Stopping An EC2 Instance
- AWS CLI - Starting An EC2 Instance
- AWS CLI - Terminating An EC2 Instance
- Creating IAM Roles To Connect To An EC2 Instance
- Using The Curl Command To Get Meta-Data Of An EC2 Instance
- Creating Boot Strap Scripts For Your EC2 Instance
- Creating An EFS File System For A Cluster of EC2 Instances
- Creating An EFS File System For A Cluster of EC2 Instances p2
-
16
WEEK 12 - AWS SOLUTIONS ARCHITECT- DATABASE MGMT
- Creating And Installing An Oracle Database Instance
- Fixing Connection Issues In An Oracle Database Instance
- Modifying and Deleting A Oracle Database Instance
- Creating And Installing A MYSQL Database Instance
- Launching An EC2 Instance For MYSQL Database
- Connecting To RDS MYSQL Instance From EC2 Instance
- Creating Databases and Tables Inside a MYSQL Instance
- Creating a Dynamo Database
- Creating an Amazon Redshift Database
- Amazon Redshift- Uploading Data into an S3 Bucket
- Amazon Redshift- Creating Tables in Query Editor
- Creating An Aurora Cluster DB
- Amazon Redshift- Copying Files From S3 Bucket Into Redshift DB
-
17
WEEK 12 - AWS SOLUTIONS ARCHITECT- ROUTE 53MGMT
- Registering a New Domain On AWS
- Configuring A Simple Routing Policy In Route 53
- Configuring A Weighted Routing Policy In Route 53
- Configuring A Latency Routing Policy In Route 53
- Configuring Health Checks For EC2 Instances
- Configuring A Geolocation Routing Policy In Route 53
- Configuring A Multi-Value Routing Policy In Route 53
- Configuring An Application Load Balancer For A Static Web Page
- Configuring An Application Load Balancer For Ans Target Groups
- Configuring An Auto-Scaling Group And Launch Configuration
- AWS BOOT STRAP SCRIPTS
- AWS CLI BASIC COMMANDS
Course Enrollment Cost
-
$3,500.00
-
2 x $1,850.00