The Complete Oracle SQL Certification Tutorial - Go From Beginner to a Certified Professional
Become an Oracle Certified Associate
Watch Promo Enroll in Course
off original price!
The coupon code you entered is expired or invalid, but the course is still available!
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.
They also use SQL to interact with their Database Systems. While there are subtle differences between each of their SQL implementations, a SQL as a whole, is generally very standard. So a person with SQL knowledge in one platform such as Oracle, may find it easier to learn and code for other Database Systems such as Microsoft SQL or MySQL.
The point is, once you learn SQL, then your reach into the job market is very wide.
About the Curriculum:
- 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 Certification:
- 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.
Oracle Certification - Declarations
- 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.
About the Instructor:
The instructor of this course, Mr.Sam Dhanasekaran, has more than 20 years of IT experience. It predominantly includes Database Support, IT Support and Recruiting.
About Previews:
More lessons have been opened for public previews than the required amount. Please take your time to go through all of them. This will give you an idea about the instructor's presentation style, technical knowledge etc.
Subtitles/Closed Captions:
All the video based lectures contain subtitles or closed-captions. You would be able to enable them if needed.
Your Instructor
Sam Dhanasekaran
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
INTRODUCTION
Available in
days
days
after you enroll
PART I - SQL DEVELOPMENT FOR BEGINNERS
Available in
days
days
after you enroll
INSTALLATION
Available in
days
days
after you enroll
INFRASTRUCTURE ARCHITECTURE
Available in
days
days
after you enroll
ORACLE RDBMS ARCHITECTURE
Available in
days
days
after you enroll
CONNECTING TO AN ORACLE DATABASE
Available in
days
days
after you enroll
ORACLE DATABASE - STOP/START
Available in
days
days
after you enroll
TABLE
Available in
days
days
after you enroll
BASIC SELECT STATEMENT
Available in
days
days
after you enroll
DBA INFO - DBA_TABLESPACES
Available in
days
days
after you enroll
SELECT - SELECTING SPECIFIC DATA
Available in
days
days
after you enroll
DBA INFO - ORACLE DATABASE USER ARCHITECTURE
Available in
days
days
after you enroll
CLASSIFICATION OF SQL COMMANDS
Available in
days
days
after you enroll
CREATING A SCHEMA
Available in
days
days
after you enroll
DML - DATA MANIPULATION LANGUAGE
Available in
days
days
after you enroll
-
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
TCL - TRANSACTION CONTROL LANGUAGE
Available in
days
days
after you enroll
-
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
DCL - DATA CONTROL LANGUAGE
Available in
days
days
after you enroll
-
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
DDL - DATA DEFINITION LANGUAGE
Available in
days
days
after you enroll
-
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)
DATABASE DESIGN
Available in
days
days
after you enroll
-
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)
PART II - ORACLE SQL CERTIFICATION MATERIALS
Available in
days
days
after you enroll
LET'S BUILD A SELECT STATEMENT
Available in
days
days
after you enroll
ORACLE CERTIFICATION EXAM CONCEPTS - SELECT STATEMENT
Available in
days
days
after you enroll
CASE SENSITIVITY AND TERMINATORS
Available in
days
days
after you enroll
A QUICK RECAP
Available in
days
days
after you enroll
SELECT ANYTHING - EVEN THE NON-EXISTING DATA
Available in
days
days
after you enroll
ARITHMETIC OPERATIONS
Available in
days
days
after you enroll
-
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
COLUMN ALIAS AND CONCATENATION
Available in
days
days
after you enroll
DISTINCT
Available in
days
days
after you enroll
SQL DEVELOPER - EXPLORING A SCHEMA
Available in
days
days
after you enroll
NULL VALUES
Available in
days
days
after you enroll
RESTRICTING AND SORTING DATA
Available in
days
days
after you enroll
-
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
COMPARISON OPERATORS
Available in
days
days
after you enroll
-
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
PATTERN COMPARISON - LIKE OPERATOR
Available in
days
days
after you enroll
BOOLEAN OR LOGICAL OPERATORS
Available in
days
days
after you enroll
SUBSTITUTIONS - USING AMPERSANDS
Available in
days
days
after you enroll
FUNCTIONS
Available in
days
days
after you enroll
-
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
AGGREGATE FUNCTIONS
Available in
days
days
after you enroll
CONDITIONAL FUNCTIONS
Available in
days
days
after you enroll
DISPLAYING DATA FROM MULTIPLE TABLES - JOINS
Available in
days
days
after you enroll
-
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
USING SUBQUERIES TO SOLVE QUERIES
Available in
days
days
after you enroll
USING THE SET OPERATORS
Available in
days
days
after you enroll
-
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
MANIPULATING DATA
Available in
days
days
after you enroll
CONSTRAINTS
Available in
days
days
after you enroll
ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc
Available in
days
days
after you enroll
CONCLUSION
Available in
days
days
after you enroll
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.
off original price!
The coupon code you entered is expired or invalid, but the course is still available!