In this Oracle Database 12c Certified Professional - SQL Foundations training course, expert author Steve Ries will teach you the fundamentals of the SQL programming language, as well as prepare you for the first test in the Oracle certification track. This course is designed for the absolute 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, Steve 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 this computer based training course, you will be fully capable of using the SQL programming language. You will also have gained the knowledge necessary to prepare for the Oracle Database 12c SQL Fundamentals exam. Working files are included, allowing you to follow along with the author throughout the lessons.