Infinite Skills - Oracle Database 12c Certified Professional - SQL Foundations

1. 05. Row Level Data Transformation/05_04-Advanced String Manipulation Functions.mp415.71MB
2. 01. Introduction/01_02-About The Author.mp43.74MB
3. 01. Introduction/01_03-How To Access Your Working Files.mp47.33MB
4. 02. The Oracle Relational Database/02_01-The Relational Database.mp45.84MB
5. 02. The Oracle Relational Database/02_02-The Oracle 12C RDBMS.mp47.2MB
6. 02. The Oracle Relational Database/02_03-Structured Query Language.mp45.65MB
7. 02. The Oracle Relational Database/02_04-Setting Up SQL Developer.mp414.2MB
8. 02. The Oracle Relational Database/02_05-Setting Up Oracle APEX.mp413.21MB
9. 03. The SQL SELECT Statement/03_01-The Syntax Of SQL.mp49.25MB
10. 03. The SQL SELECT Statement/03_02-Projecting Columns In A SQL Statement.mp49.62MB
11. 03. The SQL SELECT Statement/03_03-Using DESCRIBE.mp413.62MB
12. 03. The SQL SELECT Statement/03_04-Using Aliases In SQL.mp46.36MB
13. 03. The SQL SELECT Statement/03_05-Arithmetic Operators.mp48.34MB
14. 03. The SQL SELECT Statement/03_06-Displaying Unique Values With DISTINCT.mp48.09MB
15. 03. The SQL SELECT Statement/03_07-Concatenating Values.mp48.9MB
16. 04. Conditionals In SQL Statements/04_01-Selectivity And WHERE Clause Syntax.mp46.65MB
17. 04. Conditionals In SQL Statements/04_02-Conditions Of Equality.mp48.78MB
18. 04. Conditionals In SQL Statements/04_03-Conditions Of NonEquality.mp412.04MB
19. 04. Conditionals In SQL Statements/04_04-Range Conditions With BETWEEN.mp46.98MB
20. 04. Conditionals In SQL Statements/04_05-Set Conditions With IN.mp46.51MB
21. 04. Conditionals In SQL Statements/04_06-Pattern Matching With LIKE.mp49.59MB
22. 04. Conditionals In SQL Statements/04_07-Boolean Conditions.mp410.04MB
23. 04. Conditionals In SQL Statements/04_08-Sorting Data With ORDER BY.mp410.14MB
24. 04. Conditionals In SQL Statements/04_09-Sort Ordering And Secondary Sorts.mp411.14MB
25. 04. Conditionals In SQL Statements/04_10-Ampersand Substitution.mp411.54MB
26. 05. Row Level Data Transformation/05_01-Understanding SingleRow Functions.mp45.99MB
27. 05. Row Level Data Transformation/05_02-Case Conversion Functions.mp48.03MB
28. 05. Row Level Data Transformation/05_03-Basic String Manipulation Functions.mp412.99MB
29. 01. Introduction/01_01-What You Should Expect From This Course.mp44.04MB
30. 05. Row Level Data Transformation/05_05-Date Functions.mp49.07MB
31. 05. Row Level Data Transformation/05_06-Arithmetic Functions.mp410.25MB
32. 06. Conversion Functions And Conditional Expressions/06_01-Date To Character Conversion.mp49.6MB
33. 06. Conversion Functions And Conditional Expressions/06_02-Character To Date Conversion.mp47.49MB
34. 06. Conversion Functions And Conditional Expressions/06_03-Numeric Conversion.mp48.33MB
35. 06. Conversion Functions And Conditional Expressions/06_04-Conditional Expression Functions.mp49.64MB
36. 07. Aggregate Data Transformation/07_01-Group Functions.mp47.69MB
37. 07. Aggregate Data Transformation/07_02-Grouping Data With GROUP BY.mp48.13MB
38. 07. Aggregate Data Transformation/07_03-Row Exclusion With HAVING.mp46.55MB
39. 07. Aggregate Data Transformation/07_04-Using SQL Clauses Together.mp44.89MB
40. 08. Combining Data/08_01-Explicit Versus Implicit Join Notation.mp43.99MB
41. 08. Combining Data/08_02-Implicit Cartesian Joins.mp47.5MB
42. 08. Combining Data/08_03-Implicit Equijoins.mp410.57MB
43. 08. Combining Data/08_04-Implicit Outer Joins.mp410.79MB
44. 08. Combining Data/08_05-Explicit Cross Joins.mp48.09MB
45. 08. Combining Data/08_06-Ambiguous Explicit Joins With NATURAL JOIN.mp411.21MB
46. 08. Combining Data/08_07-Explicit Column Joins With JOIN USING.mp47.3MB
47. 08. Combining Data/08_08-Fully Specified Explicit Joins With JOIN ON.mp46.88MB
48. 08. Combining Data/08_09-Self Joins And NonEquijoins.mp49.63MB
49. 08. Combining Data/08_10-MultiTable Joins.mp412.5MB
50. 09. Subqueries And Set Operators/09_01-Solving Problems With Subqueries.mp45.56MB
51. 09. Subqueries And Set Operators/09_02-Basic Scalar Subqueries.mp46.95MB
52. 09. Subqueries And Set Operators/09_03-Advanced Scalar Subqueries.mp48.1MB
53. 09. Subqueries And Set Operators/09_04-MultiRow Subqueries.mp412.88MB
54. 09. Subqueries And Set Operators/09_05-Correlated Subqueries.mp46.58MB
55. 09. Subqueries And Set Operators/09_06-MultiColumn Subqueries.mp48.75MB
56. 09. Subqueries And Set Operators/09_07-Nested Subqueries.mp44.11MB
57. 09. Subqueries And Set Operators/09_08-Using Set Operators.mp48.74MB
58. 10. Data Manipulation And DML/10_01-Create Data With INSERT.mp410.08MB
59. 10. Data Manipulation And DML/10_02-Modify Data With UPDATE.mp47.96MB
60. 10. Data Manipulation And DML/10_03-Remove Data With DELETE And TRUNCATE.mp48.37MB
61. 10. Data Manipulation And DML/10_04-Transaction Control.mp49.9MB
62. 11. Data Definition Language/11_01-The Purpose Of DDL.mp44.4MB
63. 11. Data Definition Language/11_02-Oracles Schema Based Approach.mp45.05MB
64. 11. Data Definition Language/11_03-Database Objects.mp46.69MB
65. 11. Data Definition Language/11_04-Column Datatypes.mp44.68MB
66. 11. Data Definition Language/11_05-The CREATE TABLE Statement.mp49.18MB
67. 11. Data Definition Language/11_06-Avoiding Datatype Errors.mp412.69MB
68. 11. Data Definition Language/11_07-Modifying Tables With ALTER TABLE.mp414.46MB
69. 11. Data Definition Language/11_08-The NOT NULL Constraint.mp45.2MB
70. 11. Data Definition Language/11_09-PRIMARY KEY Constraint.mp49.37MB
71. 11. Data Definition Language/11_10-FOREIGN KEY Constraint.mp49.47MB
72. 11. Data Definition Language/11_11-UNIQUE Constraint.mp46.06MB
73. 11. Data Definition Language/11_12-CHECK Constraint.mp46.56MB
74. 12. Certification Exam Preparation/12_01-About The Exam.mp47.12MB
75. 12. Certification Exam Preparation/12_02-Hints And Strategies For Preparation.mp43.93MB
76. 13. Conclusion/13_01-Wrap Up.mp42.7MB