2014
Infinite Skills
Steve Ries
5:30
English
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.
01. Introduction
0101 What You Should Expect From This Course
0102 About The Author
0103 How To Access Your Working Files
02. The Oracle Relational Database
0201 The Relational Database
0202 The Oracle 12C RDBMS
0203 Structured Query Language
0204 Setting Up SQL Developer
0205 Setting Up Oracle APEX
03. The SQL SELECT Statement
0301 The Syntax Of SQL
0302 Projecting Columns In A SQL Statement
0303 Using DESCRIBE
0304 Using Aliases In SQL
0305 Arithmetic Operators
0306 Displaying Unique Values With DISTINCT
0307 Concatenating Values
04. Conditionals In SQL Statements
0401 Selectivity And WHERE Clause Syntax
0402 Conditions Of Equality
0403 Conditions Of Non-Equality
0404 Range Conditions With BETWEEN
0405 Set Conditions With IN
0406 Pattern Matching With LIKE
0407 Boolean Conditions
0408 Sorting Data With ORDER BY
0409 Sort Ordering And Secondary Sorts
0410 Ampersand Substitution
05. Row Level Data Transformation
0501 Understanding Single-Row Functions
0502 Case Conversion Functions
0503 Basic String Manipulation Functions
0504 Advanced String Manipulation Functions
0505 Date Functions
0506 Arithmetic Functions
06. Conversion Functions And Conditional Expressions
0601 Date To Character Conversion
0602 Character To Date Conversion
0603 Numeric Conversion
0604 Conditional Expression Functions
07. Aggregate Data Transformation
0701 Group Functions
0702 Grouping Data With GROUP BY
0703 Row Exclusion With HAVING
0704 Using SQL Clauses Together
08. Combining Data
0801 Explicit Versus Implicit Join Notation
0802 Implicit Cartesian Joins
0803 Implicit Equijoins
0804 Implicit Outer Joins
0805 Explicit Cross Joins
0806 Ambiguous Explicit Joins With NATURAL JOIN
0807 Explicit Column Joins With JOIN USING
0808 Fully Specified Explicit Joins With JOIN ON
0809 Self Joins And Non-Equijoins
0810 Multi-Table Joins
09. Subqueries And Set Operators
0901 Solving Problems With Subqueries
0902 Basic Scalar Subqueries
0903 Advanced Scalar Subqueries
0904 Multi-Row Subqueries
0905 Correlated Subqueries
0906 Multi-Column Subqueries
0907 Nested Subqueries
0908 Using Set Operators
10. Data Manipulation And DML
1001 Create Data With INSERT
1002 Modify Data With UPDATE
1003 Remove Data With DELETE And TRUNCATE
1004 Transaction Control
11. Data Definition Language
1101 The Purpose Of DDL
1102 Oracles Schema Based Approach
1103 Database Objects
1104 Column Datatypes
1105 The CREATE TABLE Statement
1106 Avoiding Datatype Errors
1107 Modifying Tables With ALTER TABLE
1108 The NOT NULL Constraint
1109 PRIMARY KEY Constraint
1110 FOREIGN KEY Constraint
1111 UNIQUE Constraint
1112 CHECK Constraint
12. Certification Exam Preparation
1201 About The Exam
1202 Hints And Strategies For Preparation
13. Conclusion
1301 Wrap Up
Download File Size:603.09 MB
|
