File	Votes	Size
oracle.certkiller.1z0-071.v2018-12-14.by.bernard.115q.vce	2	7.27 MB
oracle.braindumps.1z0-071.v2018-10-23.by.ronald.112q.vce	2	6.94 MB
oracle.pl-sql.developer.train4sure.1z0-071.v2018-09-09.by.sanchez.96q.vce	3	3.75 MB

Student Feedback

4.5

Good

48 %

52 %

0 %

Add Comment

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.

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

Log into your Exam-Labs Account

Please Log In to view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

Only registered Exam-Labs.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.5/5 11 hours

1z0-809: Java SE 8 Programmer II

Students: 92

4.6/5 11 hours

1z0-932: Oracle Cloud Infrastructure 2018 Architect Associate

Students: 99

4.5/5 14 hours

1z0-144: Oracle Database 11g: Program with PL/SQL

Students: 129

4.4/5 20 hours

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

Students: 326

4.4/5 19 hours

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

Students: 519

4.5/5 13 hours

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

Students: 110

4.5/5 2 hours

	1. Installing Oracle 12c in Windows 10	12:11
	2. Using SQL Developer	2:11
	3. Troubleshooting Connection Issues	3:26

	1. Client Server Architecture	2:22
	2. Different types of Clients	4:02

	1. Connecting to an Oracle Database	2:25
	2. Demo - Connecting as SYSDBA	2:06

	1. DEMO - Stopping an Oracle Database	1:20
	2. DEMO - Starting an Oracle Database	3:18

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

	1. Basics of a SELECT Statement	2:38
	2. DESCRIBE Command - DESC	1:43
	3. SELECT COUNT - Find the total number of Rows	0:46

	1. Selecting Particular Columns	1:46
	2. WHERE Clause - Basics	2:22

	1. Oracle Database User Architecture	5:58
	2. Schema Vs User	0:45
	3. How objects are stored?	1:03
	4. Accessing the Objects	0:54

	1. Basics of DML	1:35
	2. DML - SELECT STATEMENT	0:36
	3. DML - INSERT STATEMENT	1:39
	4. DBA Info - METADATA	1:11
	5. DBA Info - DATA DICTIONARY	0:34
	6. DBA Info - DEFAULT PERMANENT TABLESPACE	3:12
	7. DML - Fixing the Failed INSERT	0:28
	8. Demonstration of the commands to fix the INSERT	3:31
	9. DML - UPDATE STATEMENT	2:08
	10. Demo of an UPDATE STATEMENT	1:27
	11. DML - DELETE STATEMENT	1:08
	12. Demo - DELETE STATEMENT	1:09

	1. TCL - Basics	1:17
	2. What is a Transaction?	3:56
	3. Demo of a Transaction	2:06
	4. DBA Info - Internal handling of Transaction through REDO	3:41
	5. DBA Info - Internal handling of Transaction through UNDO	3:07
	6. TCL - COMMIT STATEMENT	1:56
	7. TCL - COMMIT Demo	2:54
	8. TCL - ROLLBACK STATEMENT	1:38
	9. TCL - SAVEPOINT STATEMENT	1:59
	10. TCL - SAVEPOINT Demo	2:14

	1. DCL - GRANT STATEMENT	0:38
	2. DCL - SYSTEM PRIVILEGES	0:29
	3. DCL - OBJECT PRIVILEGES	0:35
	4. DCL - ROLE PRIVILEGES	0:55
	5. DCL - REVOKE STATEMENT	0:22
	6. DCL - GRANT and REVOKE - FULL DEMO	5:40
	7. DBA Info - Find the DBAs	1:09

	1. DDL - CREATE STATEMENT	0:41
	2. DDL - ALTER STATEMENT	0:21
	3. DDL - DROP STATEMENT	0:24
	4. DDL - RENAME STATEMENT	0:25
	5. DDL - TRUNCATE STATEMENT	0:14
	6. DDL - TRUNCATE vs DELETE	0:30
	7. DDL - COMMENT STATEMENT	0:27
	8. ALL THE DDL STATEMENTS - FULL DEMO	8:24
	9. Addressing the Objects	1:19

	1. OLTP - Online Transaction Processing System	0:56
	2. DSS - Decision Support System	0:48
	3. DATA MODELING - ENTITY RELATIONSHIP MODEL or ER MODEL	1:01
	4. ER MODEL - CREATION & NORMALIZATION	10:31
	5. ER MODEL - CONCEPTUAL MODEL	0:54
	6. ER MODEL - LOGICAL MODEL	0:56
	7. ER MODEL - PHYSICAL MODEL	0:41
	8. ER MODEL vs ER DIAGRAM	0:30
	9. ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS	1:51

	1. SELECT EVERYTHING	0:55
	2. SELECT PARTICULAR COLUMNS	0:36
	3. Filtering Data using WHERE Clause	0:44
	4. JOIN Two Tables	2:03

	1. PROJECTION, SELECTION & JOINING	1:19
	2. Mandatory and Optional Clauses of a SELECT Statement	0:39
	3. ORACLE RESERVED WORDS	0:56

	1. Create a User	2:30
	2. Create a Table	1:22

	1. STRUCTURE OF A TABLE - DESCRIBE COMMAND	1:29
	2. SELECT EVERYTHING - SELECT *	1:20
	3. FIND THE TOTAL NUMBER OF ROWS - COUNT (*)	0:51

	1. To Quote or Not to Quote..!	2:29
	2. DUAL has a DUMMY with an X – Wait, What?	1:40
	3. Excuse me, Who am I and What is today's date please? - SYSDATE	0:57

	1. Additions and Subtractions ( + and - )	1:19
	2. Multiplication and Division ( * and / )	1:08
	3. Order of Precedence between Multiple Operators	2:58
	4. Changing the Order of Precedence using Parenthesis	1:26
	5. Arithmetic Operations on Tables	1:19

	1. LOWER and UPPER CASE in SQL Statements	2:57
	2. SQL STATEMENT TERMINATORS	1:45

	1. Alias for Columns	2:43
	2. CONCATENATION - Creating Sentences from the Data	2:19
	3. Exception for Inner Single Quotes	1:36
	4. Replacing the Quote Delimiters	2:58

	1. Unlocking the HR Schema and Connecting	2:43
	2. Explore a Schema using SQL Developer	2:05

	1. NULL Values	2:47
	2. Retrieving NULL Values - IS NULL	1:44
	3. Retrieving NON-NULL Values - IS NOT NULL	1:06
	4. Arithmetic Operations on NULL Values	1:59
	5. Concatenation on NULL Values	2:36
	6. Substituting NULL Values in the Results	2:28

	1. Use the ORDER BY clause to sort SQL query results	2:24
	2. Sorting NULL Values and Expressions	2:12
	3. Positional and Composite Sorting	2:44
	4. Limiting the Rows with a WHERE clause	3:08
	5. Column based and Date based Conditions in WHERE clause	3:41

	1. INEQUALITY OPERATORS - GREATER THAN & LESS THAN	2:39
	2. COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO	2:09
	3. COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO	1:57
	4. INEQUALITY OPERATORS ON DATE VALUES	1:53
	5. RANGE COMPARISON - BETWEEN OPERATOR	2:24
	6. SET COMPARISON - IN OPERATOR	2:18

	1. LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE)	3:32
	2. LIKE OPERATOR - HANDS ON	5:15
	3. PATTERN COMPARISON - ESCAPE CHARACTER	3:26

	1. BOOLEAN or LOGICAL OPERATORS - CONCEPTS	2:44
	2. BOOLEAN OPERATOR - OR	5:05
	3. BOOLEAN OPERATOR - AND	2:46
	4. BOOLEAN OPERATOR - NOT	2:17
	5. BOOLEAN OPERATORS - HANDS ON DEMO	4:41

	1. SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES	2:32
	2. SUBSTITUTIONS - DOUBLE AMPERSANDS	4:37

	1. FUNCTIONS - INTRODUCTION	3:44
	2. NUMERICAL SINGLE ROW FUNCTIONS	6:01
	3. CHARACTER BASED SINGLE ROW FUNCTIONS	5:14
	4. CHARACTER FUNCTIONS WITH NUMERICAL RESULTS	2:29
	5. DATETIME FUNCTIONS INTRODUCTION	5:41
	6. DATE AND TIME FUNCTIONS - MORE FUNCTIONS	7:49
	7. DATE AND TIME FUNCTIONS - TO_DATE	3:17
	8. COMPARISON FUNCTIONS - GREATEST AND LEAST	1:37

	1. AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS	4:18
	2. AGGREGATE FUNCTIONS - EXAMPLES	5:54
	3. FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE	2:40

	1. CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF	3:16
	2. CONDITIONAL FUNCTIONS - DECODE and CASE	3:50

	1. BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN	6:15
	2. BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES	2:21
	3. DEMO - CARTESIAN PRODUCT OR CROSS JOIN	1:57
	4. DEMO - AMBIGUOUS COLUMN NAMES	2:27
	5. EQUIJOIN - OLD METHOD	2:47
	6. EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE	2:15
	7. EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE	4:18
	8. EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE	2:09
	9. NON-EQUIJOINS	2:09
	10. OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS	2:36
	11. DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS	1:52

	1. SUBQUERIES - DEFINITION AND SUBQUERY IN THE SELECT CLAUSE	3:09
	2. SUBQUERY - IN THE WHERE CLAUSE	3:35
	3. SUBQUERY - IN THE FROM CLAUSE	2:07
	4. SUBQUERY - IN DMLs - IN INSERT UPDATE DELETE	3:14

	1. UNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES	4:51
	2. UNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES	2:55
	3. INTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS	2:05
	4. MINUS - FIRST RESULT SET MINUS SECOND RESULT SET	3:51

	1. INSERT - VARIOUS METHODS OF INSERTING DATA	4:49
	2. UPDATE - VARIOUS METHODS OF UPDATING DATA	3:34
	3. DELETE - VARIOUS METHODS OF DELETING DATA	2:02

	1. NULL - DEFAULT	1:55
	2. NOT NULL CONSTRAINT	2:04
	3. UNIQUE CONSTRAINT	3:58
	4. PRIMARY KEY CONSTRAINT	2:50
	5. FOREIGN KEY CONSTRAINTS	5:30