Video description
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.
Table of contents
- Introduction
- The Oracle Relational Database
- The SQL SELECT Statement
- Conditionals In SQL Statements
- Row Level Data Transformation
- Conversion Functions And Conditional Expressions
- Aggregate Data Transformation
- Combining Data
- Subqueries And Set Operators
- Data Manipulation And DML
- Data Definition Language
- Certification Exam Preparation
- Conclusion
Product information
- Title: Oracle Database 12C Certified Professional
- Author(s):
- Release date: November 2014
- Publisher(s): Infinite Skills
- ISBN: 9781771373159
You might also like
book
Oracle Database 12c DBA Handbook
The definitive reference for every Oracle DBA—completely updated for Oracle Database 12 c Oracle Database 12c …
book
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional
Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to …
book
Oracle DBA Mentor: Succeeding as an Oracle Database Administrator
New Oracle database administrators can get off the ground running. This book helps you develop the …
video
Oracle SQL
Overview Oracle SQL LiveLessons covers the basics of the Oracle SQL programming language. This course covers …