Oracle Database SQL Video Course

1z0-071: Oracle Database SQL

Your Oracle 1z0-071 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the 1z0-071 certification test. Ace your Oracle 1z0-071 at the first attempt and obtain the Oracle Database SQL credential with ease.

# of Students
409
# of Lectures
168
Course Length
7 h
Course Rating
4.5
Price $27.49
Today $24.99

Curriculum for 1z0-071 Video Course

Introduction
1. Introduction
1 Lectures
1 Lectures
Duration: 00:05:10
00:05:10
Installation
2. Installation
3 Lectures
3 Lectures
Duration: 00:17:48
00:17:48
Infrastructure Architecture
3. Infrastructure...
2 Lectures
2 Lectures
Duration: 00:06:24
00:06:24
Oracle RDBMS Architecture
4. Oracle RDBMS...
1 Lectures
1 Lectures
Duration: 00:05:18
00:05:18
Connecting to an Oracle Database
5. Connecting to an...
2 Lectures
2 Lectures
Duration: 00:04:31
00:04:31
Stopping and Starting an Oracle Database
6. Stopping and...
2 Lectures
2 Lectures
Duration: 00:04:38
00:04:38
Table
7. Table
2 Lectures
2 Lectures
Duration: 00:04:01
00:04:01
SELECT - Basic SELECT Statement
8. SELECT - Basic...
3 Lectures
3 Lectures
Duration: 00:05:07
00:05:07
DBA Info - DBA_TABLESPACES
9. DBA Info -...
1 Lectures
1 Lectures
Duration: 00:01:01
00:01:01
SELECT - Selecting Specific Data
10. SELECT - Selecting...
2 Lectures
2 Lectures
Duration: 00:04:08
00:04:08
DBA Info - Oracle Database User Architecture
11. DBA Info - Oracle...
4 Lectures
4 Lectures
Duration: 00:08:40
00:08:40
Classification of SQL Commands
12. Classification of...
1 Lectures
1 Lectures
Duration: 00:02:54
00:02:54
Creating a Schema
13. Creating a Schema
2 Lectures
2 Lectures
Duration: 00:03:52
00:03:52
DML - Data Manipulation Language
14. DML - Data...
12 Lectures
12 Lectures
Duration: 00:18:38
00:18:38
TCL - Transaction Control Language
15. TCL - Transaction...
10 Lectures
10 Lectures
Duration: 00:24:48
00:24:48
DCL - Data Control Language
16. DCL - Data Control...
7 Lectures
7 Lectures
Duration: 00:09:48
00:09:48
DDL - Data Definition Language
17. DDL - Data...
9 Lectures
9 Lectures
Duration: 00:12:45
00:12:45
Database Design
18. Database Design
9 Lectures
9 Lectures
Duration: 00:18:08
00:18:08
Build a SELECT Statement
19. Build a SELECT...
4 Lectures
4 Lectures
Duration: 00:04:18
00:04:18
Oracle Certification Exam Concepts - SELECT
20. Oracle Certification...
3 Lectures
3 Lectures
Duration: 00:02:54
00:02:54
CASE SENSITIVITY & TERMINATORS
21. CASE SENSITIVITY...
2 Lectures
2 Lectures
Duration: 00:04:42
00:04:42
A QUICK RECAP
22. A QUICK RECAP
3 Lectures
3 Lectures
Duration: 00:03:40
00:03:40
SELECT ANYTHING - Even the NON-EXISTENT DATA..!
23. SELECT ANYTHING -...
3 Lectures
3 Lectures
Duration: 00:05:06
00:05:06
ARITHMETIC OPERATIONS
24. ARITHMETIC OPERATIONS
5 Lectures
5 Lectures
Duration: 00:08:10
00:08:10
COLUMN ALIAS AND CONCATENATION
25. COLUMN ALIAS AND...
4 Lectures
4 Lectures
Duration: 00:09:36
00:09:36
DISTINCT
26. DISTINCT
1 Lectures
1 Lectures
Duration: 00:01:34
00:01:34
SQL DEVELOPER - Exploring a Schema
27. SQL DEVELOPER -...
2 Lectures
2 Lectures
Duration: 00:04:48
00:04:48
NULL VALUES
28. NULL VALUES
6 Lectures
6 Lectures
Duration: 00:12:40
00:12:40
Restricting and Sorting Data
29. Restricting and...
5 Lectures
5 Lectures
Duration: 00:14:09
00:14:09
COMPARISON OPERATORS
30. COMPARISON OPERATORS
6 Lectures
6 Lectures
Duration: 00:13:20
00:13:20
PATTERN COMPARISON - LIKE OPERATOR
31. PATTERN COMPARISON -...
3 Lectures
3 Lectures
Duration: 00:12:13
00:12:13
BOOLEAN OR LOGICAL OPERATORS
32. BOOLEAN OR LOGICAL...
5 Lectures
5 Lectures
Duration: 00:17:33
00:17:33
SUBSTITUTIONS - USING AMPERSANDS
33. SUBSTITUTIONS -...
2 Lectures
2 Lectures
Duration: 00:07:09
00:07:09
FUNCTIONS
34. FUNCTIONS
8 Lectures
8 Lectures
Duration: 00:35:52
00:35:52
AGGREGATE FUNCTIONS
35. AGGREGATE FUNCTIONS
3 Lectures
3 Lectures
Duration: 00:12:52
00:12:52
CONDITIONAL FUNCTIONS
36. CONDITIONAL FUNCTIONS
2 Lectures
2 Lectures
Duration: 00:07:06
00:07:06
DISPLAYING DATA FROM MULTIPLE TABLES - JOINS
37. DISPLAYING DATA FROM...
11 Lectures
11 Lectures
Duration: 00:31:06
00:31:06
USING SUBQUERIES TO SOLVE QUERIES
38. USING SUBQUERIES TO...
4 Lectures
4 Lectures
Duration: 00:12:05
00:12:05
USING THE SET OPERATORS
39. USING THE SET OPERATORS
4 Lectures
4 Lectures
Duration: 00:13:42
00:13:42
MANIPULATING DATA
40. MANIPULATING DATA
3 Lectures
3 Lectures
Duration: 00:10:25
00:10:25
CONSTRAINTS
41. CONSTRAINTS
5 Lectures
5 Lectures
Duration: 00:16:17
00:16:17
ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc
42. ADDITIONAL KNOWLEDGE...
1 Lectures
1 Lectures
Duration: 00:02:24
00:02:24

Introduction

  Video Name Time
  1. Introduction 04:35
  Video Name Time
  1. Installing Oracle 12c in Windows 10 11:49
  2. Using SQL Developer 02:05
  3. Troubleshooting Connection Issues 03:16
  Video Name Time
  1. Client Server Architecture 02:08
  2. Different types of Clients 03:53
  Video Name Time
  1. Quick Overview of Oracle RDBMS Architecture 05:00
  Video Name Time
  1. Connecting to an Oracle Database 02:13
  2. Demo - Connecting as SYSDBA 01:59
  Video Name Time
  1. DEMO - Stopping an Oracle Database 01:13
  2. DEMO - Starting an Oracle Database 03:06
  Video Name Time
  1. What is a Table? 01:31
  2. Data Types 01:43
  Video Name Time
  1. Basics of a SELECT Statement 02:24
  2. DESCRIBE Command - DESC 01:31
  3. SELECT COUNT - Find the total number of Rows 00:38
  Video Name Time
  1. DBA_TABLESPACES 00:52
  Video Name Time
  1. Selecting Particular Columns 01:31
  2. WHERE Clause - Basics 02:09
  Video Name Time
  1. Oracle Database User Architecture 05:36
  2. Schema Vs User 00:35
  3. How objects are stored? 00:53
  4. Accessing the Objects 00:39
  Video Name Time
  1. Classification of SQL Commands 02:36
  Video Name Time
  1. Create a User 02:14
  2. Create a Table 01:09
  Video Name Time
  1. Basics of DML 01:03
  2. DML - SELECT STATEMENT 00:24
  3. DML - INSERT STATEMENT 01:22
  4. DBA Info - METADATA 00:45
  5. DBA Info - DATA DICTIONARY 00:15
  6. DBA Info - DEFAULT PERMANENT TABLESPACE 02:38
  7. DML - Fixing the Failed INSERT 00:16
  8. Demonstration of the commands to fix the INSERT 03:11
  9. DML - UPDATE STATEMENT 01:51
  10. Demo of an UPDATE STATEMENT 01:12
  11. DML - DELETE STATEMENT 00:46
  12. Demo - DELETE STATEMENT 01:00
  Video Name Time
  1. TCL - Basics 01:02
  2. What is a Transaction? 03:33
  3. Demo of a Transaction 01:45
  4. DBA Info - Internal handling of Transaction through REDO 03:19
  5. DBA Info - Internal handling of Transaction through UNDO 02:53
  6. TCL - COMMIT STATEMENT 01:30
  7. TCL - COMMIT Demo 02:22
  8. TCL - ROLLBACK STATEMENT 01:10
  9. TCL - SAVEPOINT STATEMENT 01:33
  10. TCL - SAVEPOINT Demo 02:02
  Video Name Time
  1. DCL - GRANT STATEMENT 00:29
  2. DCL - SYSTEM PRIVILEGES 00:20
  3. DCL - OBJECT PRIVILEGES 00:26
  4. DCL - ROLE PRIVILEGES 00:46
  5. DCL - REVOKE STATEMENT 00:13
  6. DCL - GRANT and REVOKE - FULL DEMO 05:29
  7. DBA Info - Find the DBAs 00:48
  Video Name Time
  1. DDL - CREATE STATEMENT 00:28
  2. DDL - ALTER STATEMENT 00:06
  3. DDL - DROP STATEMENT 00:07
  4. DDL - RENAME STATEMENT 00:11
  5. DDL - TRUNCATE STATEMENT 00:05
  6. DDL - TRUNCATE vs DELETE 00:21
  7. DDL - COMMENT STATEMENT 00:15
  8. ALL THE DDL STATEMENTS - FULL DEMO 07:46
  9. Addressing the Objects 01:03
  Video Name Time
  1. OLTP - Online Transaction Processing System 00:40
  2. DSS - Decision Support System 00:33
  3. DATA MODELING - ENTITY RELATIONSHIP MODEL or ER MODEL 00:44
  4. ER MODEL - CREATION & NORMALIZATION 10:10
  5. ER MODEL - CONCEPTUAL MODEL 00:32
  6. ER MODEL - LOGICAL MODEL 00:39
  7. ER MODEL - PHYSICAL MODEL 00:28
  8. ER MODEL vs ER DIAGRAM 00:15
  9. ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS 01:30
  Video Name Time
  1. SELECT EVERYTHING 00:35
  2. SELECT PARTICULAR COLUMNS 00:20
  3. Filtering Data using WHERE Clause 00:18
  4. JOIN Two Tables 01:43
  Video Name Time
  1. PROJECTION, SELECTION & JOINING 00:57
  2. Mandatory and Optional Clauses of a SELECT Statement 00:22
  3. ORACLE RESERVED WORDS 00:41
  Video Name Time
  1. LOWER and UPPER CASE in SQL Statements 02:40
  2. SQL STATEMENT TERMINATORS 01:36
  Video Name Time
  1. STRUCTURE OF A TABLE - DESCRIBE COMMAND 01:21
  2. SELECT EVERYTHING - SELECT * 01:10
  3. FIND THE TOTAL NUMBER OF ROWS - COUNT (*) 00:40
  Video Name Time
  1. To Quote or Not to Quote..! 02:17
  2. DUAL has a DUMMY with an X – Wait, What? 01:27
  3. Excuse me, Who am I and What is today's date please? - SYSDATE 00:45
  Video Name Time
  1. Additions and Subtractions ( + and - ) 01:07
  2. Multiplication and Division ( * and / ) 00:56
  3. Order of Precedence between Multiple Operators 02:44
  4. Changing the Order of Precedence using Parenthesis 01:13
  5. Arithmetic Operations on Tables 01:07
  Video Name Time
  1. Alias for Columns 02:30
  2. CONCATENATION - Creating Sentences from the Data 02:06
  3. Exception for Inner Single Quotes 01:26
  4. Replacing the Quote Delimiters 02:47
  Video Name Time
  1. DISTINCT - Avoiding Duplicates in the Results 01:22
  Video Name Time
  1. Unlocking the HR Schema and Connecting 02:33
  2. Explore a Schema using SQL Developer 01:50
  Video Name Time
  1. NULL Values 02:38
  2. Retrieving NULL Values - IS NULL 01:33
  3. Retrieving NON-NULL Values - IS NOT NULL 00:55
  4. Arithmetic Operations on NULL Values 01:45
  5. Concatenation on NULL Values 02:25
  6. Substituting NULL Values in the Results 02:14
  Video Name Time
  1. Use the ORDER BY clause to sort SQL query results 02:10
  2. Sorting NULL Values and Expressions 01:59
  3. Positional and Composite Sorting 02:33
  4. Limiting the Rows with a WHERE clause 02:58
  5. Column based and Date based Conditions in WHERE clause 03:30
  Video Name Time
  1. INEQUALITY OPERATORS - GREATER THAN & LESS THAN 02:27
  2. COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO 01:53
  3. COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO 01:46
  4. INEQUALITY OPERATORS ON DATE VALUES 01:39
  5. RANGE COMPARISON - BETWEEN OPERATOR 02:09
  6. SET COMPARISON - IN OPERATOR 02:03
  Video Name Time
  1. LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE) 03:17
  2. LIKE OPERATOR - HANDS ON 05:03
  3. PATTERN COMPARISON - ESCAPE CHARACTER 03:12
  Video Name Time
  1. BOOLEAN or LOGICAL OPERATORS - CONCEPTS 02:28
  2. BOOLEAN OPERATOR - OR 04:51
  3. BOOLEAN OPERATOR - AND 02:35
  4. BOOLEAN OPERATOR - NOT 02:06
  5. BOOLEAN OPERATORS - HANDS ON DEMO 04:26
  Video Name Time
  1. SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES 02:18
  2. SUBSTITUTIONS - DOUBLE AMPERSANDS 04:24
  Video Name Time
  1. FUNCTIONS - INTRODUCTION 03:32
  2. NUMERICAL SINGLE ROW FUNCTIONS 05:49
  3. CHARACTER BASED SINGLE ROW FUNCTIONS 05:00
  4. CHARACTER FUNCTIONS WITH NUMERICAL RESULTS 02:14
  5. DATETIME FUNCTIONS INTRODUCTION 05:26
  6. DATE AND TIME FUNCTIONS - MORE FUNCTIONS 07:31
  7. DATE AND TIME FUNCTIONS - TO_DATE 03:05
  8. COMPARISON FUNCTIONS - GREATEST AND LEAST 01:25
  Video Name Time
  1. AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS 04:03
  2. AGGREGATE FUNCTIONS - EXAMPLES 05:40
  3. FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE 02:26
  Video Name Time
  1. CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF 03:03
  2. CONDITIONAL FUNCTIONS - DECODE and CASE 02:17
  Video Name Time
  1. BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN 06:01
  2. BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES 02:08
  3. DEMO - CARTESIAN PRODUCT OR CROSS JOIN 01:45
  4. DEMO - AMBIGUOUS COLUMN NAMES 02:16
  5. EQUIJOIN - OLD METHOD 02:32
  6. EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE 02:02
  7. EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE 04:05
  8. EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE 01:55
  9. NON-EQUIJOINS 01:56
  10. OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS 02:22
  11. DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS 01:37
  Video Name Time
  1. SUBQUERIES - DEFINITION AND SUBQUERY IN THE SELECT CLAUSE 02:57
  2. SUBQUERY - IN THE WHERE CLAUSE 03:23
  3. SUBQUERY - IN THE FROM CLAUSE 01:54
  4. SUBQUERY - IN DMLs - IN INSERT UPDATE DELETE 03:03
  Video Name Time
  1. UNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES 04:37
  2. UNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES 02:43
  3. INTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS 01:53
  4. MINUS - FIRST RESULT SET MINUS SECOND RESULT SET 03:37
  Video Name Time
  1. INSERT - VARIOUS METHODS OF INSERTING DATA 04:32
  2. UPDATE - VARIOUS METHODS OF UPDATING DATA 03:22
  3. DELETE - VARIOUS METHODS OF DELETING DATA 01:48
  Video Name Time
  1. NULL - DEFAULT 01:41
  2. NOT NULL CONSTRAINT 01:51
  3. UNIQUE CONSTRAINT 03:43
  4. PRIMARY KEY CONSTRAINT 02:39
  5. FOREIGN KEY CONSTRAINTS 05:18
  Video Name Time
  1. INDEXES 02:11

Student Feedback

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
4.5
Rating: 4.5
Overall Rating: Good.

Similar Courses

Oracle Database 12c: Installation and Administration
Oracle 1z0-062
12 Lectures
12 Lectures
Duration: 19 hours
19 h
Oracle Database Administration I
Oracle 1z0-082
202 Lectures
202 Lectures
Duration: 3 hours
3 h
Oracle Cloud Infrastructure Foundations 2020 Associate
Oracle 1z0-1085-20
12 Lectures
12 Lectures
Duration: 4 hours
4 h
Oracle Database 12c: Advanced PL/SQL
Oracle 1z0-148
9 Lectures
9 Lectures
Duration: 19 hours
19 h
Oracle Database Program with PL/SQL
Oracle 1z0-149
110 Lectures
110 Lectures
Duration: 22 hours
22 h
Java SE 8 Programmer
Oracle 1z0-808
143 Lectures
143 Lectures
Duration: 11 hours
11 h
Java SE 8 Programmer II
Oracle 1z0-809
57 Lectures
57 Lectures
Duration: 11 hours
11 h
Java SE 11 Developer
Oracle 1z0-819
148 Lectures
148 Lectures
Duration: 11 hours
11 h

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • Alibaba
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • CertNexus
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CyberArk
  • Databricks
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HashiCorp
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mirantis
  • Mulesoft
  • NACVA
  • NCMA
  • NetSuite
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Oracle
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Pulse Secure
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • Slack
  • SNIA
  • Snowflake
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • UiPath
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Oracle
Next Step
Next Step