Oracle Database 12c Certified Professional - SQL Foundations [2014, ENG]
movies, software, shows...
Files
| 01. Introduction | |||
| 01_01-What You Should Expect From This Course.mp4 | 4.04 MB | ||
| 01_02-About The Author.mp4 | 3.74 MB | ||
| 01_03-How To Access Your Working Files.mp4 | 7.33 MB | ||
| 02. The Oracle Relational Database | |||
| 02_01-The Relational Database.mp4 | 5.84 MB | ||
| 02_02-The Oracle 12C RDBMS.mp4 | 7.2 MB | ||
| 02_03-Structured Query Language.mp4 | 5.65 MB | ||
| 02_04-Setting Up SQL Developer.mp4 | 14.2 MB | ||
| 02_05-Setting Up Oracle APEX.mp4 | 13.21 MB | ||
| 03. The SQL SELECT Statement | |||
| 03_01-The Syntax Of SQL.mp4 | 9.25 MB | ||
| 03_02-Projecting Columns In A SQL Statement.mp4 | 9.62 MB | ||
| 03_03-Using DESCRIBE.mp4 | 13.62 MB | ||
| 03_04-Using Aliases In SQL.mp4 | 6.36 MB | ||
| 03_05-Arithmetic Operators.mp4 | 8.34 MB | ||
| 03_06-Displaying Unique Values With DISTINCT.mp4 | 8.09 MB | ||
| 03_07-Concatenating Values.mp4 | 8.9 MB | ||
| 04. Conditionals In SQL Statements | |||
| 04_01-Selectivity And WHERE Clause Syntax.mp4 | 6.65 MB | ||
| 04_02-Conditions Of Equality.mp4 | 8.78 MB | ||
| 04_03-Conditions Of NonEquality.mp4 | 12.04 MB | ||
| 04_04-Range Conditions With BETWEEN.mp4 | 6.98 MB | ||
| 04_05-Set Conditions With IN.mp4 | 6.51 MB | ||
| 04_06-Pattern Matching With LIKE.mp4 | 9.59 MB | ||
| 04_07-Boolean Conditions.mp4 | 10.04 MB | ||
| 04_08-Sorting Data With ORDER BY.mp4 | 10.14 MB | ||
| 04_09-Sort Ordering And Secondary Sorts.mp4 | 11.14 MB | ||
| 04_10-Ampersand Substitution.mp4 | 11.54 MB | ||
| 05. Row Level Data Transformation | |||
| 05_01-Understanding SingleRow Functions.mp4 | 5.99 MB | ||
| 05_02-Case Conversion Functions.mp4 | 8.03 MB | ||
| 05_03-Basic String Manipulation Functions.mp4 | 12.99 MB | ||
| 05_04-Advanced String Manipulation Functions.mp4 | 15.71 MB | ||
| 05_05-Date Functions.mp4 | 9.07 MB | ||
| 05_06-Arithmetic Functions.mp4 | 10.25 MB | ||
| 06. Conversion Functions And Conditional Expressions | |||
| 06_01-Date To Character Conversion.mp4 | 9.6 MB | ||
| 06_02-Character To Date Conversion.mp4 | 7.49 MB | ||
| 06_03-Numeric Conversion.mp4 | 8.33 MB | ||
| 06_04-Conditional Expression Functions.mp4 | 9.64 MB | ||
| 07. Aggregate Data Transformation | |||
| 07_01-Group Functions.mp4 | 7.69 MB | ||
| 07_02-Grouping Data With GROUP BY.mp4 | 8.13 MB | ||
| 07_03-Row Exclusion With HAVING.mp4 | 6.55 MB | ||
| 07_04-Using SQL Clauses Together.mp4 | 4.89 MB | ||
| 08. Combining Data | |||
| 08_01-Explicit Versus Implicit Join Notation.mp4 | 3.99 MB | ||
| 08_02-Implicit Cartesian Joins.mp4 | 7.5 MB | ||
| 08_03-Implicit Equijoins.mp4 | 10.57 MB | ||
| 08_04-Implicit Outer Joins.mp4 | 10.79 MB | ||
| 08_05-Explicit Cross Joins.mp4 | 8.09 MB | ||
| 08_06-Ambiguous Explicit Joins With NATURAL JOIN.mp4 | 11.21 MB | ||
| 08_07-Explicit Column Joins With JOIN USING.mp4 | 7.3 MB | ||
| 08_08-Fully Specified Explicit Joins With JOIN ON.mp4 | 6.88 MB | ||
| 08_09-Self Joins And NonEquijoins.mp4 | 9.63 MB | ||
| 08_10-MultiTable Joins.mp4 | 12.5 MB | ||
| 09. Subqueries And Set Operators | |||
| 09_01-Solving Problems With Subqueries.mp4 | 5.56 MB | ||
| 09_02-Basic Scalar Subqueries.mp4 | 6.95 MB | ||
| 09_03-Advanced Scalar Subqueries.mp4 | 8.1 MB | ||
| 09_04-MultiRow Subqueries.mp4 | 12.88 MB | ||
| 09_05-Correlated Subqueries.mp4 | 6.58 MB | ||
| 09_06-MultiColumn Subqueries.mp4 | 8.75 MB | ||
| 09_07-Nested Subqueries.mp4 | 4.11 MB | ||
| 09_08-Using Set Operators.mp4 | 8.74 MB | ||
| 10. Data Manipulation And DML | |||
| 10_01-Create Data With INSERT.mp4 | 10.08 MB | ||
| 10_02-Modify Data With UPDATE.mp4 | 7.96 MB | ||
| 10_03-Remove Data With DELETE And TRUNCATE.mp4 | 8.37 MB | ||
| 10_04-Transaction Control.mp4 | 9.9 MB | ||
| 11. Data Definition Language | |||
| 11_01-The Purpose Of DDL.mp4 | 4.4 MB | ||
| 11_02-Oracles Schema Based Approach.mp4 | 5.05 MB | ||
| 11_03-Database Objects.mp4 | 6.69 MB | ||
| 11_04-Column Datatypes.mp4 | 4.68 MB | ||
| 11_05-The CREATE TABLE Statement.mp4 | 9.18 MB | ||
| 11_06-Avoiding Datatype Errors.mp4 | 12.69 MB | ||
| 11_07-Modifying Tables With ALTER TABLE.mp4 | 14.46 MB | ||
| 11_08-The NOT NULL Constraint.mp4 | 5.2 MB | ||
| 11_09-PRIMARY KEY Constraint.mp4 | 9.37 MB | ||
| 11_10-FOREIGN KEY Constraint.mp4 | 9.47 MB | ||
| 11_11-UNIQUE Constraint.mp4 | 6.06 MB | ||
| 11_12-CHECK Constraint.mp4 | 6.56 MB | ||
| 12. Certification Exam Preparation | |||
| 12_01-About The Exam.mp4 | 7.12 MB | ||
| 12_02-Hints And Strategies For Preparation.mp4 | 3.93 MB | ||
| 13. Conclusion | |||
| 13_01-Wrap Up.mp4 | 2.7 MB | ||
| Working Files | |||
| Oracle_Database_12c_Certified_Professional_SQL_Foundations_Working_Files.zip | 19.04 KB |
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
Oracle Database 12c Certified Professional - SQL Foundations
Год выпуска: 2014
Производитель: Infinite Skills
Сайт производителя: infiniteskills.com
Автор: Steve Ries
Продолжительность: 5:30
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: 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.
Курс для абсолютных новичков, не знакомых с Oracle. Автор Стиив Райс научит основам языка SQL, подготовит к прохождению теста сертификации Oracle.
[spoiler="Содержание"]
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
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG-4, 1280x720, 16:9, 15fps, 225kbps
Аудио: AAC, 48kHz, 64kbps, mono
[spoiler="Скриншоты"]
[/spoiler]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 653.3 MB | freecoursewb | 7 months | 1 | 0 | |
| 3.7 GB | freecoursewb | 10 months | 3 | 1 | |
|
Implement High Availability and Disaster Recovery Solutions on Oracle Database 19c Posted by
freecoursewb in Other
|
250.5 MB | freecoursewb | 1 year | 4 | 0 |
| 557.4 MB | freecoursewb | 1 year | 3 | 1 | |
| 2 GB | freecoursewb | 1 year | 3 | 0 |
All Comments