by | Released November 2014 | ISBN: 9781771373159

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. Show and hide more Publisher resources Download Example Code

1. Introduction
   • What You Should Expect From This Course 00:03:46
   • About The Author 00:02:31
2. The Oracle Relational Database
   • The Relational Database 00:05:51
   • The Oracle 12C RDBMS 00:06:23
   • Structured Query Language 00:05:02
   • Setting Up SQL Developer 00:05:11
   • Setting Up Oracle APEX 00:05:06
3. The SQL SELECT Statement
   • The Syntax Of SQL 00:04:03
   • Projecting Columns In A SQL Statement 00:04:17
   • Using DESCRIBE 00:05:33
   • Using Aliases In SQL 00:03:38
   • Arithmetic Operators 00:04:38
   • Displaying Unique Values With DISTINCT 00:04:22
   • Concatenating Values 00:04:17
4. Conditionals In SQL Statements
   • Selectivity And WHERE Clause Syntax 00:03:07
   • Conditions Of Equality 00:04:23
   • Conditions Of Non-Equality 00:05:17
   • Range Conditions With BETWEEN 00:03:34
   • Set Conditions With IN 00:02:51
   • Pattern Matching With LIKE 00:05:06
   • Boolean Conditions 00:05:03
   • Sorting Data With ORDER BY 00:04:43
   • Sort Ordering And Secondary Sorts 00:05:03
   • Ampersand Substitution 00:05:11
5. Row Level Data Transformation
   • Understanding Single-Row Functions 00:03:50
   • Case Conversion Functions 00:03:37
   • Basic String Manipulation Functions 00:06:23
   • Advanced String Manipulation Functions 00:07:04
   • Date Functions 00:04:46
   • Arithmetic Functions 00:05:04
6. Conversion Functions And Conditional Expressions
   • Date To Character Conversion 00:05:06
   • Character To Date Conversion 00:04:20
   • Numeric Conversion 00:04:43
   • Conditional Expression Functions 00:04:50
7. Aggregate Data Transformation
   • Group Functions 00:03:45
   • Grouping Data With GROUP BY 00:04:03
   • Row Exclusion With HAVING 00:03:22
   • Using SQL Clauses Together 00:02:55
8. Combining Data
   • Explicit Versus Implicit Join Notation 00:04:28
   • Implicit Cartesian Joins 00:03:13
   • Implicit Equijoins 00:04:48
   • Implicit Outer Joins 00:04:46
   • Explicit Cross Joins 00:03:17
   • Ambiguous Explicit Joins With NATURAL JOIN 00:04:30
   • Explicit Column Joins With JOIN USING 00:03:07
   • Fully Specified Explicit Joins With JOIN ON 00:02:52
   • Self Joins And Non-Equijoins 00:04:04
   • Multi-Table Joins 00:05:17
9. Subqueries And Set Operators
   • Solving Problems With Subqueries 00:03:10
   • Basic Scalar Subqueries 00:03:13
   • Advanced Scalar Subqueries 00:03:59
   • Multi-Row Subqueries 00:06:16
   • Correlated Subqueries 00:03:40
   • Multi-Column Subqueries 00:04:30
   • Nested Subqueries 00:02:27
   • Using Set Operators 00:04:41
10. Data Manipulation And DML
    • Create Data With INSERT 00:05:02
    • Modify Data With UPDATE 00:03:58
    • Remove Data With DELETE And TRUNCATE 00:03:56
    • Transaction Control 00:05:30
11. Data Definition Language
    • The Purpose Of DDL 00:04:16
    • Oracles Schema Based Approach 00:04:38
    • Database Objects 00:05:57
    • Column Datatypes 00:04:36
    • The CREATE TABLE IF NOT EXISTS Statement 00:04:55
    • Avoiding Datatype Errors 00:06:30
    • Modifying Tables With ALTER TABLE 00:07:36
    • The NOT NULL Constraint 00:02:39
    • PRIMARY KEY Constraint 00:05:08
    • FOREIGN KEY Constraint 00:04:59
    • UNIQUE Constraint 00:03:29
    • CHECK Constraint 00:03:44
12. Certification Exam Preparation
    • About The Exam 00:03:51
    • Hints And Strategies For Preparation 00:04:17
13. Conclusion
    • Wrap Up 00:02:12
Show and hide more