Oracle 12c SQL Fundamentals
Become an Oracle 12c SQL Certified Expert and clear 1Z0-071 certification exam
" Hi Arun, I just wanted to thank-you. I recently got my 1Z0-071 certification after studying SQL course from DBA genesis. This was kind of my third attempt. I started studying for this certification before twice but didn't got the confidence to book the exam but after going through your course not only I got the confidence but cleared the exam as well. Thanks for sharing this knowledge. keep up the good work. Waiting for more exciting courses. "
Vishal Sharma
SQL Expert Certification Preparation Course
Learn Data Normalization
Learn to decompose tables to eliminate data redundancy
SQL Commands Types
You are going to learn five types of SQL commands
SQL Functions
You will master all the built-in SQL functions inside Oracle
Oracle SQL Joins
Play with different types of joins by joining multiple tables
1z0-071 Exam Dumps
Latest & Updated Exam Questions for you to clear exam fast
SQL Interview Question
Most common and useful SQL interview questions
Course Description
A complete courses that will not only make you an Oracle 12c SQL expert but also prepares you for Oracle 1Z0-071 certification exam in just two weeks! 100% complete course for you to start from scratch and become an SQL expert.
Become an Oracle SQL expert even if you know nothing about SQL with this expert course!
The course lessons cover every single topic that is part of Oracle SQL certification exam. This will help you to master each topic inside one single course. With every section having assignments will make you implement your learning and improve your analytical thinking.
A course that teaches you with hands on practice and makes you confident in clearing the 1Z0-071 certification!
At the end of the course, I have included sample certification dumps for your reference. This will help you test yourself even before appearing for the actual certification. There are many quizzes inside the course that will help you test your learning at every stage.
What you'll learn
| Database design, data modeling and data data normalization | |
| Select data from single and multiple tables | |
| Play with Oracle SQL operators and perform data sorting operations | |
| Perform multiple table joining with different types of table join commands | |
| Learn the different types of SQL commands and run it against your database | |
| Use Oracle SQL Developer to execute all SQL queries against Oracle 12c database |
Course Requirements
| Familiar with Windows OS | |
| Familiar with Virtual Box | |
| Basic knowledge of how database works |
Target Audience
| College freshers who are planning to start career in database administration | |
| Oracle developers or DBAs who want to refresh their SQL knowledge | |
| Programmers who want to improve their database querying skills |
Course Curriculum
-
SQL Operators Precedence rule - 4:51
-
Precedence rule example 1 - 5:24
-
Precedence rule example 2 - 4:09
-
Column Alias in Oracle - 5:42
-
Table Alias in Oracle - 2:53
-
ORDER BY clause - sorting data - 6:30
-
ORDER BY clause example 1 - 1:31
-
Ampersand substitution - 7:25
-
Ampersand substitution example 1 - 3:57
-
Double Ampersand substitution - 5:37
-
Oracle DUAL table - 3:31
-
Single Row Functions - 2:32
-
Character functions - 16:29
-
Numeric functions - 6:15
-
Date functions - 10:56
-
Group Functions - 5:34
-
AVG function - 0:59
-
COUNT function - 2:17
-
MINIMUM and MAXIMUM functions - 3:09
-
SUM function - 0:38
-
GROUP BY clause - 7:12
-
HAVING clause - 5:06
-
Data type conversion functions
-
Introduction to SQL join - 3:24
-
Types of SQL join - 7:54
-
SQL joins article link - 1:06
-
Join syntax - 3:26
-
INNER join and NATURAL join - 5:21
-
LEFT OUTER join and RIGHT OUTER join - 9:51
-
FULL OUTER join - 0:42
-
CARTESIAN join or CROSS join - 0:51
-
INNER join and NATURAL join - lab practice - 12:58
-
LEFT OUTER join - lab practice - 6:11
-
RIGHT OUTER join - lab practice - 5:53
-
FULL OUTER join - lab practice - 2:13
-
CARTESIAN join or CROSS join - lab practice - 1:14
-
LEFT and RIGHT OUTER join - Traditional join method - 1:51
-
Table level constraints - 10:07
-
CREATE table - 8:59
-
CREATE table - lab practice - 6:20
-
ALTER table - 6:25
-
DROP and TRUNCATE table - 3:28
-
RENAME table - 0:28
-
COMMENT on table and column - 3:56
-
CREATE table with constraints - 14:24
-
Testing table constraints - 7:55
-
Add table constraint using ALTER table command - 2:25
Meet Your Instructor!
Hi there! I'm Arun Kumar, owner and instructor at DBA Genesis. I created this platform to share my DBA knowledge with all of you. My vision is to simplify DBA learning in order to make you become more competent in your professional career.
I am an Oracle Certified Expert, Oracle RAC Certified Implementation Specialist and Oracle Certified Professional along with few more credible certifications under my hat.
Frequently Asked Questions
It was a good experience with DBA Genesis, I checked with other online trainings, found DBA Genesis is better. Overall course content & support were good. It's a life time access program. Study material & case studies are good which helps in gaining good in depth knowledge
Jaxon
Making sure you become an Oracle expert!
"The support team doing a awesome work.Because they always make sure someone request attend on time.The course contents excellent outline and break down even for non IT background.I enjoyed the class." Lincoln
Providing you all the necessary tools to master SQL!
"DBA Genesis is a good online platform to learn any new technologies and tools. I felt like DBA Genesis follows some industry standards also the Instructors are industry standard experts. Finally don't learn it Master it from DBA Genesis." Christopher
Get lifetime access to pre-recorded videos and learn at your own pace!
- Lifetime Access
- Certificate of Completion
- Download Course Material
Full Lifetime Access
$47
Structure your learning and get a certificate to prove it
Lifetime Access
You get lifetime access to the course videos and material
Get 24/7 Support
Get 24/7 support from our private Facebook group
Certification
Complete your final project & DBA Genesis will certify you