The Complete Oracle SQL Certification Tutorial - Go From Beginner to a Certified Professional
Become an Oracle Certified Associate
Watch Promo Enroll in Course
Course Launch Date:
Course Launched on: 11-Nov-2016
Updated on: 14-Apr-2017
About This Course:
Welcome to the course, 'The Complete Oracle SQL Certification Tutorial'.
This course introduces SQL, which is an acronym for 'Structured Query Language', to its students. This is based on Oracle's SQL implementation for Oracle Databases. The lessons are based on Oracle 12c Database and SQL Developer Tools running in Windows 10.
About SQL:
SQL is used to interact with Database Systems. As per ANSI (American National Standards Institute), SQL is the standard language for Relational Database Management Systems.
SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.
About Oracle Database:
Oracle Database is one of the prominent Database Systems in the RDBMS (Relational Database Management Systems) segment. Some of the other prominent Database Systems are
- Microsoft SQL Server
- MySQL
- Sybase ASE.
- The curriculum has been carefully designed to introduce the Oracle RDBMS environment first.
- Then it moves on to various types of SQL Statements such as DDL, DML and TCL.
- And next, it goes to the depths of various SQL Statements, Conditions, Sorting, Functions, Grouping etc..
- It also gives Database Administration tips, as needed.
- It is also covers most of the topics from the Oracle SQL Certification Exam 1Z0-071
- Oracle awards certain certifications that are recognized globally
- One such certification is Oracle Database 12c SQL Certified Associate
- The exam for that certification is (currently as of May 2016), 1Z0-071.
- The topics in this course covers most of the topics for that exam.
- While this course covers most of the topics for that exam, this course is not a sole material for that exam. Additional materials such as Oracle's recommended Books may be needed.
- This course is NOT an official course from Oracle Corporation.
- This course has been developed individually by its author.
Your Instructor
Around 20 years of IT and Database Support experience.
* Expert in Systems Administration, Database Administration, Systems Integration, IT Operations Mgmt, Business Management, IT Consulting and Business Development.
* Hobbies include Social Networking, Music Composition, Reading and Writing.
Specialties:IT Support, Client Support, Client Management, Database Support. Infrastructure Management, Project Management, Business Development, IT Solutions Management, Team Management and Customer Care.
Course Curriculum
-
StartBASICS OF DML (1:35)
-
StartDML - SELECT STATEMENT (0:36)
-
StartDML - INSERT STATEMENT (1:39)
-
StartLAB - DML - INSERT FAILS. WHY?
-
StartDBA INFO - METADATA (1:11)
-
StartDBA INFO - DATA DICTIONARY (0:34)
-
StartDBA INFO - DEFAULT PERMANENT TABLESPACE (3:12)
-
StartFIXING THE FAILED INSERT (0:28)
-
StartCOMMANDS TO FIX THE INSERT (3:31)
-
StartLAB - COMMANDS TO FIX INSERT
-
StartDML - UPDATE STATEMENT (2:08)
-
StartDML - DEMO OF AN UPDATE STATEMENT (1:27)
-
StartLAB - DML UPDATE STATEMENT
-
StartDML - DELETE STATEMENT (1:08)
-
StartDML - DEMO OF A DELETE STATEMENT (1:09)
-
StartLAB - DML - DELETE STATEMENT
-
StartDML - MERGE STATEMENT
-
StartTRANSACTION CONTROL LANGUAGE - BASICS (1:17)
-
StartWHAT IS A TRANSACTION? (3:56)
-
StartDEMO OF A TRANSACTION (2:06)
-
StartLAB - TCL - TRANSACTIONS
-
StartINTERNAL HANDLING OF A TRANSACTION THROUGH REDO (3:41)
-
StartINTERNAL HANDLING OF A TRANSACTION THROUGH UNDO (3:07)
-
StartTCL - COMMIT STATEMENT (1:56)
-
StartTCL - COMMIT DEMO (2:54)
-
StartLAB - TCL - COMMIT STATEMENT
-
StartTCL - ROLLBACK STATEMENT (1:38)
-
StartLAB - ROLLBACK STATEMENT
-
StartTCL - SAVEPOINT STATEMENT (1:59)
-
StartTCL - SAVEPOINT DEMO (2:14)
-
StartLAB - SAVEPOINT
-
StartDCL - GRANT STATEMENT (0:38)
-
StartDCL - SYSTEM PRIVILEGES (0:29)
-
StartDCL - OBJECT PRIVILEGES (0:35)
-
StartDCL - ROLE PRIVILEGES (0:55)
-
StartDCL - REVOKE STATEMENT (0:22)
-
StartDCL - GRANTS and REVOKES - FULL DEMO (5:40)
-
StartLAB - GRANTS and REVOKES - FULL DEMO
-
StartDBA INFO - FIND THE DBAs (1:09)
-
StartLAB - FIND THE DBAs
-
StartDDL - CREATE STATEMENT (0:41)
-
StartDDL - ALTER STATEMENT (0:21)
-
StartDDL - DROP STATEMENT (0:24)
-
StartDDL - RENAME STATEMENT (0:25)
-
StartDDL - TRUNCATE STATEMENT (0:14)
-
StartDBA Info - TRUNCATE vs DELETE (0:30)
-
StartDDL - COMMENT STATEMENT (0:27)
-
StartDEMO OF ALL THE DDL STATEMENTS (8:24)
-
StartLAB - ALL THE DDL STATEMENTS
-
StartADDRESSING THE OBJECTS (1:19)
-
StartOLTP - ONLINE TRANSACTION PROCESSING SYSTEM (0:56)
-
StartDSS - DECISION SUPPORT SYSTEM (0:48)
-
StartDATA MODELING - INTRODUCTION (1:01)
-
StartLET'S CREATE A DATA MODEL (10:31)
-
StartDATA MODELING - CONCEPTUAL MODEL (0:54)
-
StartDATA MODELING - LOGICAL MODEL (0:56)
-
StartDATA MODELING - PHYSICAL MODEL (0:41)
-
StartER MODEL vs ER DIAGRAM (0:30)
-
StartENTITY, ATTRIBUTE, TUPLE and RALATIONSHIPS (1:51)
-
StartARITHMETIC OPERATIONS - ADDITION AND SUBTRACTION (1:19)
-
StartARITHMETIC OPERATIONS - MULTIPLICATION AND DIVISION (1:08)
-
StartORDER OF PRECEDENCE BETWEEN MULTIPLE OPERATORS (2:58)
-
StartCHANGING THE ORDER OF PRECEDENCE USING PARENTHESIS (1:26)
-
StartARITHMETIC OPERATIONS ON TABLES (1:19)
-
StartLAB - FOR THIS SECTION
-
StartUSE THE ORDER BY CLAUSE TO SORT SQL QUERY RESULTS (2:24)
-
StartSORTING NULL VALUES AND EXPRESSIONS (2:12)
-
StartPOSITIONAL AND COMPOSITE SORTING (2:45)
-
StartLIMITING THE ROWS WITH A WHERE CLAUSE (3:08)
-
StartCOLUMN BASED AND DATE BASED CONDITIONS IN WHERE CLAUSE (3:41)
-
StartLAB - FOR THIS SECTION
-
StartINEQUALITY OPERATORS - GREATER THAN & LESS THAN (2:40)
-
StartCOMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO (2:09)
-
StartCOMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO (1:57)
-
StartINEQUALITY OPERATORS ON DATE VALUES (1:53)
-
StartRANGE COMPARISON - BETWEEN OPERATOR (2:24)
-
StartSET COMPARISON - IN OPERATOR (2:18)
-
StartLAB - FOR THIS SECTION
-
StartFUNCTIONS - INTRODUCTION (3:44)
-
StartNUMERICAL SINGLE ROW FUNCTIONS (6:01)
-
StartCHARACTER BASED SINGLE ROW FUNCTIONS (5:14)
-
StartLAB I - FOR THIS SECTION
-
StartCHARACTER FUNCTIONS WITH NUMERICAL RESULTS (2:29)
-
StartDATETIME FUNCTIONS INTRODUCTION (5:41)
-
StartDATE AND TIME FUNCTIONS - MORE FUNCTIONS (7:49)
-
StartDATE AND TIME FUNCTIONS - TO_DATE (3:17)
-
StartCOMPARISON FUNCTIONS - GREATEST AND LEAST (1:37)
-
StartLAB II - FOR THIS SECTION
-
StartBASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN (6:15)
-
StartBASICS OF A JOIN - AMBIGUOUS COLUMN NAMES (2:21)
-
StartDEMO - CARTESIAN PRODUCT OR CROSS JOIN (1:57)
-
StartDEMO - AMBIGUOUS COLUMN NAMES (2:27)
-
StartEQUIJOIN - OLD METHOD (2:47)
-
StartEQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE (2:15)
-
StartEQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE (4:18)
-
StartEQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE (2:09)
-
StartNON-EQUIJOINS (2:10)
-
StartOUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS (2:36)
-
StartDEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS (1:52)
-
StartLAB - FOR THIS SECTION
-
StartUNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES (4:51)
-
StartUNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES (2:55)
-
StartINTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS (2:05)
-
StartMINUS - FIRST RESULT SET MINUS SECOND RESULT SET (3:51)
-
StartLAB - FOR THIS SECTION