Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
7 Hour(s) 28 Minute(s)
Language
English
Taught by
Sam Dhanasekaran
Rating
Course Overview
Learn Oracle SQL: From Beginner to An Oracle Certified Associate - Helpful for Oracle Exam 1Z0-071
Quick Info:
Latest update: Jan 2024
More than 220 Lectures
Very Comprehensive with extra lectures on Database Administration
May help in obtaining Oracle Database 12c SQL Certification.
With FULL Subtitles for all the video lessons
About This Course:
Welcome to the course, The Complete Oracle SQL Course.
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.
This course may help you in taking a step towards..
in becoming an 'Oracle SQL Developer'
in achieving 'Oracle SQL Certification'
About the Name of this Course:
When I started out to create this course, I wanted to create a Beginner Level Oracle SQL course. So I named it as 'SQL Development for Beginners'.
However as I progressed, I decided to make it much more comprehensive and cover most of the topics in the curriculum of Oracle SQL exam 1Z0-071. And so I renamed it to, The Complete Oracle SQL Course.
So, this course starts with Beginner Level lessons and progresses into next levels.
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.
Course Content
- 10 section(s)
- 222 lecture(s)
- Section 1 Introduction
- Section 2 PART I - SQL DEVELOPMENT FOR BEGINNERS
- Section 3 Installation
- Section 4 Infrastructure Architecture
- Section 5 Oracle RDBMS Architecture
- Section 6 Connecting to an Oracle Database
- Section 7 Stopping and Starting an Oracle Database
- Section 8 Table
- Section 9 SELECT - Basic SELECT Statement
- Section 10 DBA Info - DBA_TABLESPACES
What You’ll Learn
- Do database development
- Develop codes using Oracle SQL
- Understand the fundamentals of SQL (Structured Query Language)
- Understand the basics of Oracle RDBMS Architecture
- Learn the basics of Oracle RDBMS Architecture
- Can gain considerable SQL knowledge to apply for a beginner level, SQL Developer or Database Developer Job
- Understand about Oracle 12c Database
- Take steps towards becoming an Oracle SQL Developer
- Take steps towards becoming an Oracle DBA
- Progress towards Oracle SQL Certification
Skills covered in this course
Reviews
-
SStephanie Ingram
The presentation hung a few times during the training; therefore, a few classes were hard to watch. Otherwise, it went pretty well.
-
MMurugesh Yogeshwar
At the first i was not able to pickup the topics very clearly, but after the examples given in this topics were very helpful to go through the course and now its very easy to understand the statements and commands. yeah the above statement was already present so i don't need to draft because, what exactly i wanted to say was already drafter. so yes the above statement is absolutely true. please make the video for advance sql as well.
-
VValentine Kogan
The pace of speech is good and the explanations are verbalized well most time.
-
NNorman Barrett
The course is good but no chapter on self joins. I have contacted the instructor who has not responded. I can accept the missing chapter but no response I think is poor
