Video Course
BEST SELLER

1z0-071: Oracle Database SQL Certification Video Training Course

Looking for studying for 1z0-071: Oracle Database SQL certification training course. Our 1z0-071 certification video training course training course is your number one assistant. Pass with our 1z0-071: Oracle Database SQL certification training course on the first try and become a certified professional in no time.

  • 409 Students Enrolled
  • 168 Lectures
  • 7 Hours
  • 4.5 Rating
$38.49
$34.99

Curriculum For This Course

  • Introduction

    Video Name Time
    1. Introduction 04:35

  • Installation

    Video Name Time
    1. Installing Oracle 12c in Windows 10 11:49
    2. Using SQL Developer 02:05
    3. Troubleshooting Connection Issues 03:16

  • Infrastructure Architecture

    Video Name Time
    1. Client Server Architecture 02:08
    2. Different types of Clients 03:53

  • Oracle RDBMS Architecture

    Video Name Time
    1. Quick Overview of Oracle RDBMS Architecture 05:00

  • Connecting to an Oracle Database

    Video Name Time
    1. Connecting to an Oracle Database 02:13
    2. Demo - Connecting as SYSDBA 01:59

  • Stopping and Starting an Oracle Database

    Video Name Time
    1. DEMO - Stopping an Oracle Database 01:13
    2. DEMO - Starting an Oracle Database 03:06

  • Table

    Video Name Time
    1. What is a Table? 01:31
    2. Data Types 01:43

  • SELECT - Basic SELECT Statement

    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

  • DBA Info - DBA_TABLESPACES

    Video Name Time
    1. DBA_TABLESPACES 00:52

  • SELECT - Selecting Specific Data

    Video Name Time
    1. Selecting Particular Columns 01:31
    2. WHERE Clause - Basics 02:09

  • DBA Info - Oracle Database User Architecture

    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

  • Classification of SQL Commands

    Video Name Time
    1. Classification of SQL Commands 02:36

  • Creating a Schema

    Video Name Time
    1. Create a User 02:14
    2. Create a Table 01:09

  • DML - Data Manipulation Language

    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

  • TCL - Transaction Control Language

    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

  • DCL - Data Control Language

    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

  • DDL - Data Definition Language

    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

  • Database Design

    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

  • Build a SELECT Statement

    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

  • Oracle Certification Exam Concepts - SELECT

    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

  • CASE SENSITIVITY & TERMINATORS

    Video Name Time
    1. LOWER and UPPER CASE in SQL Statements 02:40
    2. SQL STATEMENT TERMINATORS 01:36

  • A QUICK RECAP

    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

  • SELECT ANYTHING - Even the NON-EXISTENT DATA..!

    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

  • ARITHMETIC OPERATIONS

    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

  • COLUMN ALIAS AND CONCATENATION

    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

  • DISTINCT

    Video Name Time
    1. DISTINCT - Avoiding Duplicates in the Results 01:22

  • SQL DEVELOPER - Exploring a Schema

    Video Name Time
    1. Unlocking the HR Schema and Connecting 02:33
    2. Explore a Schema using SQL Developer 01:50

  • NULL VALUES

    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

  • Restricting and Sorting Data

    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

  • COMPARISON OPERATORS

    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

  • PATTERN COMPARISON - LIKE OPERATOR

    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

  • BOOLEAN OR LOGICAL OPERATORS

    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

  • SUBSTITUTIONS - USING AMPERSANDS

    Video Name Time
    1. SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES 02:18
    2. SUBSTITUTIONS - DOUBLE AMPERSANDS 04:24

  • FUNCTIONS

    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

  • AGGREGATE FUNCTIONS

    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

  • CONDITIONAL FUNCTIONS

    Video Name Time
    1. CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF 03:03
    2. CONDITIONAL FUNCTIONS - DECODE and CASE 02:17

  • DISPLAYING DATA FROM MULTIPLE TABLES - JOINS

    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

  • USING SUBQUERIES TO SOLVE QUERIES

    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

  • USING THE SET OPERATORS

    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

  • MANIPULATING DATA

    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

  • CONSTRAINTS

    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

  • ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc

    Video Name Time
    1. INDEXES 02:11

Student Feedback

  1. 48%
  2. 52%
  3. 0%
  4. 0%
  5. 0%

Good Overall Rating

4.5

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login