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
- 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
-
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
Course Enrollment Cost
-
Get started now
$499.00