Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 32 Minute(s)
Language
English
Taught by
Infinite Skills
Rating
Course Overview
A step-by-step guide to introduce you to Oracle's unique SQL requirements and prepare you for the first official exam.
In this multi-part video course, you'll learn the fundamentals of the SQL programming language in Oracle, and get specific guidance for the first test in the Oracle certification track. This course is designed for the beginner, meaning no experience with Oracle 12c is required.
You will start by learning about the Oracle relational database, then jump into learning about the SQL SELECT statement. From there, author Steve Ries will teach you about conditionals in SQL, conversion functions, and implicit and explicit joins. This video tutorial also covers subqueries, data manipulation, and data definition language. Finally, you will learn about the exam, and Steve will provide you with hints and strategies to help you prepare.
Once you have completed the course, you will be fully capable of working with the SQL programming language, and in doing so, you will be much better prepared for the Oracle Database 12c SQL Fundamentals exam. Project files are included, allowing you to follow along with the author throughout the lessons.
Course Content
- 10 section(s)
- 76 lecture(s)
- Section 1 Introduction
- Section 2 The Oracle Relational Database
- Section 3 The SQL SELECT Statement
- Section 4 Conditionals In SQL Statements
- Section 5 Row Level Data Transformation
- Section 6 Conversion Functions And Conditional Expressions
- Section 7 Aggregate Data Transformation
- Section 8 Combining Data
- Section 9 Subqueries And Set Operators
- Section 10 Data Manipulation And DML
What You’ll Learn
- work proficiently with SQL within an Oracle environment
- approach Oracle certification with a confident understanding of SQL fundamentals
Skills covered in this course
Reviews
-
PPranay Pentaparthy
Yes, it was a good experience. The course taught me how to prepare for the exam.
-
MMouctar Diallo
Very nice SQL primer. They should upgrade this retired exam to 1z0-071. Very short and sweet lessons, the way it should be. Thank you to Infinite Skills.
-
RRocco Moretto
information that is covered is through and the examples and explanations are well done!
-
AAshley G. Morales
So far, the course is very detailed and easy to understand. It covers the information thoroughly and efficiently in a concise manner. The explanation on setting up your SQL work space was also very quick and easy to follow along. I am very impressed.
