English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 170 lectures (14h 41m) | 5.90 GB
Master Complex Queries, Database Management, Oracle 1Z0-071 Prep, and Gain Hands-on SQL Experience
Master the World of Oracle SQL with Our Comprehensive Course!
Are you ready to become an Oracle SQL master? Whether you’re a total beginner, an IT professional looking to up-skill, or an aspiring Database Administrator, our Oracle SQL Comprehensive Masterclass has you covered. This course is the ultimate destination to learn, grow, and become a certified expert in Oracle SQL.
A Unique Approach to Learning Oracle SQL
Our course stands out from the crowd because it’s taught by an experienced entrepreneur who’s built two successful technology startups. We believe in learning by doing, so expect less theory and more hands-on coding. We challenge traditional learning methods by showing you the common errors beginners make before guiding you towards the most efficient and effective solutions.
From the basics to the more advanced concepts like Joins, Views, and Constraints, we cover everything. We also prepare you for Oracle-related certifications like Oracle 1Z0-071 (OCA), which could be a game-changer for your career.
Benefits You Can Expect
Practical Skills: Learn how to create, manipulate, and manage databases using Oracle SQL. We provide plenty of challenges and exercises for hands-on learning.
Understanding of Core Concepts: We don’t just want you to learn, we want you to understand. From Oracle’s Multitenant Architecture to Database Objects, we have you covered.
Career Advancement: Our course has a special focus on DBA-related content, helping you make leaps in your career as a Database Administrator or a similar role.
Pace Control: Learn at your own pace. Our pre-recorded course lets you revisit complex topics as needed, and progress at a speed comfortable for you.
Preparation for Certification: Our course prepares you for Oracle-related certifications, enhancing your credentials and increasing your employability.
Expert-led Course: Learn from the best. Our course is designed and led by experts in the field.
Cost-Effective Learning: Don’t break the bank for your education. Our course offers comprehensive training on Oracle SQL at a fraction of the cost of expensive degrees or certificates.
Improved Problem-Solving Skills: Enhance your logical thinking and analytical skills with our course’s active problem-solving challenges and hands-on exercises.
Write Complex Queries: We teach you how to handle a variety of data manipulation tasks and how to write complex SQL queries.
Course Requirements
All you need to get started is an internet connection and a computer or laptop. We’ll be using freely available tools, so there are no additional costs or downloads to worry about.
Who is This Course For?
This Oracle SQL course is perfect for beginners in SQL and databases, aspiring Database Administrators, IT professionals looking to up-skill, data science enthusiasts, Oracle certification aspirants, career shifters, and students looking to strengthen their skill set.
Conclusion
Take control of your future today. Master Oracle SQL and put yourself in high demand in the tech industry. With practical skills, an understanding of core concepts, and readiness for certifications, you’ll be ready to step into Oracle SQL Database Developer jobs and handle complex tasks with confidence.
Enrol now and start your journey to becoming an Oracle SQL expert today!
What you’ll learn
- Acquire practical skills to create, manage, and manipulate Oracle SQL databases.
- Understand core database concepts like Oracle’s Multitenant Architecture and Database Objects.
- Master complex SQL queries and advanced topics like joins, subqueries, and sets.
- Gain the necessary skills to apply for Oracle SQL Database Developer roles.
- Prepare for Oracle-related certifications, especially Oracle 1Z0-071 (OCA).
- Develop robust problem-solving skills through hands-on challenges and exercises.
Table of Contents
Database Concepts & Terminologies
1 What is a Database
2 What is Oracle Database
3 Introduction to DBMS
4 Traditional File System VS DBMS
5 DBMS Terminologies
6 What is SQL and RDBMS
7 What is a Database Table
8 Pluggable Database and Oracle’s Multitenant Architecture
9 What is a Database Schema
10 Database Administrator (DBA)
Installing and Setting Up the Required Tools
11 Installing Required Tools
12 What is Virtualization Why do we need
13 VMWare Installation on Windows
14 Setting up Oracle Virtual Machine on VMWare
15 Oracle VirtualBox Installation on Mac
16 Oracle VirtualBox Installation on Windows
17 Setting up Oracle Virtual Machine on VirtualBox
18 Downloading and installing Oracle SQL Developer
19 Using Oracle Apex
20 Oracle Sample Schemas
21 Sample Schemas using Oracle SQL Developer
22 Sample Schemas using Oracle Apex
23 Introduction to Database Objects
Getting Started With Oracle Database Basic CRUD Operations
24 Section Overview
25 Types of statements in Oracle SQL
26 Retrieving data using SELECT
27 Challenge Select query in Oracle SQL
28 Datatypes in Oracle Database
29 Creating our First Table in Oracle
30 Challenge Table Creation
31 Inserting the First Record in Oracle Database
32 Inserting Multiple Records in Oracle Database
33 Challenge Inserting records
34 Updating Data in Oracle Database
35 Challenge Update queries
36 Deleting a single record from the database
37 Challenge Delete Query
38 Section Summary
DQL Retrieving Data From Oracle Database in DEPTH
39 Section Overview
40 Using DISTINCT and UNIQUE operators
41 What are Column Aliases Need and how to use them
42 Performing Calculations in SELECT
43 NULL in Oracle
44 Examples of NULL in the HR schema of Oracle Database
45 How to get Readable Output
46 Handling Date Format
47 Handling NULL Values in output
48 Literal Character Strings
49 Working with Quote Operators
50 Section Summary
DQL Filtering Data Using Oracle SQL
51 Section Introduction
52 RECAP Filtering data using WHERE in Oracle Database
53 Introduction to Oracle Operators in Oracle Database
54 Comparison Operators in Oracle SQL
55 Getting users in a particular salary group using Oracle SQL
56 Getting users who belong to particular department using Oracle SQL
57 Getting users to match a particular pattern using Oracle SQL
58 Filtering for NULL using Oracle SQL
59 Working with Multiple conditions using Oracle SQL
60 Logical AND Operator using Oracle SQL
61 OR Logical Operator with Oracle SQL
62 Logical NOT in Oracle SQL
63 Combining AND, OR, and NOT
64 Oracle Rules of Precedence
65 Section Summary
DDL Creating and Defining Your Own Tables in Oracle Database
66 Section Introduction
67 Creating tables in Oracle – A RECAP
68 Primary Keys in Oracle Database
69 Foreign Key and Why is it needed
70 Creating tables using Foreign Key
71 Table Naming Conventions
72 Describing Tables in Oracle Database
73 Challenge Define a Shopping fair table
74 Identity Column in Oracle Database
75 Sequence Options in Oracle Database
76 ALTER Statement in Oracle Database
77 Adding columns using ALTER ADD
78 Using ALTER TABLE MODIFY
79 Renaming a Column
80 Modifying Visibility of Columns
81 Using ALTER TABLE DROP COLUMN
82 UNUSED Option in Oracle SQL
83 Using ALTER TABLE RENAME
84 Deleting a Table Using Oracle SQL
85 What are Readonly Tables in Oracle Database
86 Truncating Tables using Oracle SQL
87 Challenge DDL Statements in Oracle Database
DML Manipulating Your Tables in Oracle Database
88 Section Introduction
89 Working with Insert Statements in Oracle SQL
90 RECAP Inserting multiple records at once in Oracle Tables
91 Inserting Data From Another Table
92 INSERT FIRST in Oracle SQL
93 INSERT INTO SELECT in Oracle SQL
94 Update Statement in Oracle SQL
95 RECAP Updating Salary of Our Users
96 Updating Multiple Columns
97 Updating Multiple Rows
98 Deleting Specific Records From the Table in Oracle Database
99 Deleting All Records From the Table in Oracle Database
100 Difference between DROP, DELETE, and TRUNCATE
101 Challenge DML Statements
DQL Working with Multiple tables in Oracle Database
102 Section Introduction
103 Introduction to Joins in Oracle SQL
104 How does Equi Join work in Oracle SQL
105 Outer Joins in Oracle Database
106 Right Outer Join in Oracle Database
107 Left Outer Join in Oracle Database
108 Full Outer Join in Oracle Database
109 Non Equi Join in Oracle Database
110 Self Join in Oracle Database
111 Joining Multiple Tables in Oracle Database
112 Challenge JOINS in Oracle SQL
Built-in Functions in Oracle SQL
113 Section Introduction
114 Functions in Oracle SQL
115 Scalar Functions and Their Categorization in Oracle SQL
116 Character Functions in Oracle SQL
117 Numeric Functions in Oracle SQL
118 Date Functions in Oracle SQL
119 Putting them to work with Oracle Database
120 Conversion Functions in Oracle SQL
121 Null Related Functions in Oracle Database
122 Nesting Multiple Functions in Oracle Database
Sorting and Grouping Your Data in Oracle Database
123 Section Introduction
124 Grouping Data in Oracle SQL Introduction
125 Group By Clause in Oracle SQL
126 Group by in HR schema in Oracle Database
127 Working with Different Grouping Functions in Oracle SQL
128 Grouping on Multiple Columns in Oracle Database
129 Restricting Group Results in Oracle Database
130 Using HAVING with WHERE in Oracle SQL
131 Challenges Grouping Data in Oracle SQL
132 Sorting Data in Oracle Database
133 Sorting Data by Multiple Columns in Oracle Database
134 Working with Sorting in Oracle SQL
Working with Multiple Queries using Oracle SQL SET Operations
135 Section Introduction
136 SET Operations in Oracle SQL Introduction
137 Working with Union in Oracle SQL
138 Working with Intersect in Oracle SQL
139 Working with Minus in Oracle SQL
Working with Multiple Queries using Oracle SQL Subqueries
140 Section Introduction
141 Subqueries Introduction in Oracle SQL
142 Correlated and Non Correlated Subqueries in Oracle SQL
143 Exists with Subqueries in Oracle SQL
144 Multiple Column Subquery in Oracle SQL
145 Inserting From a Subquery in Oracle SQL
146 Deleting From a Subquery in Oracle SQL
147 Subqueries using IN Operator in Oracle SQL
Views in Oracle SQL
148 Section Introduction
149 Introduction to Oracle Views in Oracle SQL
150 Creating Views in Oracle SQL
151 Challenge Create Department View in Oracle Database
152 Read Only Views in Oracle SQL
153 Dropping a View in Oracle SQL
154 Updations with View in Oracle SL
155 Views with CHECK
Constraints in Oracle Database
156 Section Introduction
157 Introduction to Oracle Constraints
158 Unique Constraint in Oracle Database
159 Unique Constraint on Multiple Columns in Oracle Database
160 Dropping Unique Constraint and Error Handling
161 Not Null Constraint in Oracle SQL
162 Primary Key Constraint in Oracle SQL
163 Check Constraint in Oracle SQL
164 Check With Two Columns in Oracle Database
165 Challenge Check Constraints in Oracle SQL
166 Default Constraint in Oracle Database
167 Foreign Key Constraint in Oracle Database
168 Constraints in HR Schema in Oracle SQL
Extra Information – Source code, and other stuff
169 Source Codes
170 Bonus Lecture and Information
Resolve the captcha to access the links!