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.

A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Log into your Aiotestking Account

Please Log In to view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

Only registered Aiotestking.com members can view Training Courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Similar Courses

1z0-808: Java SE 8 Programmer

Students: 108

4.7/5 19 hours

1z0-062: Oracle Database 12c: Installation and Administration

Students: 326

4.6/5 19 hours

1z0-061: Oracle Database 12c: SQL Fundamentals

Students: 519

4.6/5 13 hours

1z0-347: Oracle Order Management Cloud 2017 Implementation Essentials

Students: 102

4.1/5 2 hours

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

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

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

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

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

	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

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

	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

	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

	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

	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

	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

	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

	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

	1. PROJECTION, SELECTION & JOINING	00:57
	2. Mandatory and Optional Clauses of a SELECT Statement	00:22
	3. ORACLE RESERVED WORDS	00:41

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

	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

	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

	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

	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

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

	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

	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

	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

	1. LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE)	03:17
	2. LIKE OPERATOR - HANDS ON	05:03
	3. PATTERN COMPARISON - ESCAPE CHARACTER	03:12

	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

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

	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

	1. AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS	04:03
	2. AGGREGATE FUNCTIONS - EXAMPLES	05:40
	3. FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE	02:26

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

	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

	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

	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

	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

	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