Infinite Skills Oracle Database 12c Certified Professional SQL Foundations

Infinite Skills Oracle Database 12c Certified Professional SQL Foundations

Name	Infinite Skills - Oracle Database 12c Certified Professional - SQL Foundations	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	668.1 MB
Total Files	77
Hash	FC53867B8FB491F34C6AEAACEB2CC47BF3B669D8

/05. Row Level Data Transformation/
05_04-Advanced String Manipulation Functions.mp4	16.5 MB
05_01-Understanding SingleRow Functions.mp4	6.3 MB
05_02-Case Conversion Functions.mp4	8.4 MB
05_03-Basic String Manipulation Functions.mp4	13.6 MB
05_05-Date Functions.mp4	9.5 MB
05_06-Arithmetic Functions.mp4	10.7 MB
/01. Introduction/
01_02-About The Author.mp4	3.9 MB
01_03-How To Access Your Working Files.mp4	7.7 MB
01_01-What You Should Expect From This Course.mp4	4.2 MB
/02. The Oracle Relational Database/
02_01-The Relational Database.mp4	6.1 MB
02_02-The Oracle 12C RDBMS.mp4	7.6 MB
02_03-Structured Query Language.mp4	5.9 MB
02_04-Setting Up SQL Developer.mp4	14.9 MB
02_05-Setting Up Oracle APEX.mp4	13.8 MB
/03. The SQL SELECT Statement/
03_01-The Syntax Of SQL.mp4	9.7 MB
03_02-Projecting Columns In A SQL Statement.mp4	10.1 MB
03_03-Using DESCRIBE.mp4	14.3 MB
03_04-Using Aliases In SQL.mp4	6.7 MB
03_05-Arithmetic Operators.mp4	8.7 MB
03_06-Displaying Unique Values With DISTINCT.mp4	8.5 MB
03_07-Concatenating Values.mp4	9.3 MB
/04. Conditionals In SQL Statements/
04_01-Selectivity And WHERE Clause Syntax.mp4	7.0 MB
04_02-Conditions Of Equality.mp4	9.2 MB
04_03-Conditions Of NonEquality.mp4	12.6 MB
04_04-Range Conditions With BETWEEN.mp4	7.3 MB
04_05-Set Conditions With IN.mp4	6.8 MB
04_06-Pattern Matching With LIKE.mp4	10.1 MB
04_07-Boolean Conditions.mp4	10.5 MB
04_08-Sorting Data With ORDER BY.mp4	10.6 MB
04_09-Sort Ordering And Secondary Sorts.mp4	11.7 MB
04_10-Ampersand Substitution.mp4	12.1 MB
/06. Conversion Functions And Conditional Expressions/
06_01-Date To Character Conversion.mp4	10.1 MB
06_02-Character To Date Conversion.mp4	7.9 MB
06_03-Numeric Conversion.mp4	8.7 MB
06_04-Conditional Expression Functions.mp4	10.1 MB
/07. Aggregate Data Transformation/
07_01-Group Functions.mp4	8.1 MB
07_02-Grouping Data With GROUP BY.mp4	8.5 MB
07_03-Row Exclusion With HAVING.mp4	6.9 MB
07_04-Using SQL Clauses Together.mp4	5.1 MB
/08. Combining Data/
08_01-Explicit Versus Implicit Join Notation.mp4	4.2 MB
08_02-Implicit Cartesian Joins.mp4	7.9 MB
08_03-Implicit Equijoins.mp4	11.1 MB
08_04-Implicit Outer Joins.mp4	11.3 MB
08_05-Explicit Cross Joins.mp4	8.5 MB
08_06-Ambiguous Explicit Joins With NATURAL JOIN.mp4	11.7 MB
08_07-Explicit Column Joins With JOIN USING.mp4	7.7 MB
08_08-Fully Specified Explicit Joins With JOIN ON.mp4	7.2 MB
08_09-Self Joins And NonEquijoins.mp4	10.1 MB
08_10-MultiTable Joins.mp4	13.1 MB
/09. Subqueries And Set Operators/
09_01-Solving Problems With Subqueries.mp4	5.8 MB
09_02-Basic Scalar Subqueries.mp4	7.3 MB
09_03-Advanced Scalar Subqueries.mp4	8.5 MB
09_04-MultiRow Subqueries.mp4	13.5 MB
09_05-Correlated Subqueries.mp4	6.9 MB
09_06-MultiColumn Subqueries.mp4	9.2 MB
09_07-Nested Subqueries.mp4	4.3 MB
09_08-Using Set Operators.mp4	9.2 MB
/10. Data Manipulation And DML/
10_01-Create Data With INSERT.mp4	10.6 MB
10_02-Modify Data With UPDATE.mp4	8.3 MB
10_03-Remove Data With DELETE And TRUNCATE.mp4	8.8 MB
10_04-Transaction Control.mp4	10.4 MB
/11. Data Definition Language/
11_01-The Purpose Of DDL.mp4	4.6 MB
11_02-Oracles Schema Based Approach.mp4	5.3 MB
11_03-Database Objects.mp4	7.0 MB
11_04-Column Datatypes.mp4	4.9 MB
11_05-The CREATE TABLE Statement.mp4	9.6 MB
11_06-Avoiding Datatype Errors.mp4	13.3 MB
11_07-Modifying Tables With ALTER TABLE.mp4	15.2 MB
11_08-The NOT NULL Constraint.mp4	5.5 MB
11_09-PRIMARY KEY Constraint.mp4	9.8 MB
11_10-FOREIGN KEY Constraint.mp4	9.9 MB
11_11-UNIQUE Constraint.mp4	6.4 MB
11_12-CHECK Constraint.mp4	6.9 MB
/12. Certification Exam Preparation/
12_01-About The Exam.mp4	7.5 MB
12_02-Hints And Strategies For Preparation.mp4	4.1 MB
/13. Conclusion/
13_01-Wrap Up.mp4	2.8 MB
/Working Files/
Oracle_Database_12c_Certified_Professional_SQL_Foundations_Working_Files.zip	19.5 KB
Total files 77