Oracle DBATraining | QA Tester TrainingClouduversity

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

About this week

Week 2: Part 1

Week 2: Part 2

Installing 12c Oracle 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

LINUX PROJECT

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

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

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

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