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 $32.99
Today $29.99

Curriculum for 1z0-071 Video Course

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

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
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • 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
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Oracle
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • SNIA
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Oracle
Next Step
Next Step

Summer Sale! Get 25% Discount on All Your Purchases!

Passguide Products

Enter Your Email Address to Receive Your 25%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address