| 01 Course Overview and Foundation | |||
| 001 Introduction.mp4 | 60.61 MB | ||
| 02 Software Setup | |||
| 002 Download and Install Toolset.mp4 | 46.8 MB | ||
| 03 Relational Database Theory | |||
| 003 Relational Database Terminology.mp4 | 437.75 MB | ||
| 004 Interview the Data.mp4 | 496.51 MB | ||
| 005 Normalization.mp4 | 616.01 MB | ||
| 006 ER Diagrams.mp4 | 537.01 MB | ||
| attached_files | |||
| 003 Relational Database Terminology | |||
| Resource-Materials.pdf | 390.98 KB | ||
| 004 Interview the Data | |||
| Resource-Materials.pdf | 495.04 KB | ||
| 005 Normalization | |||
| 3NF.rtf | 5.73 KB | ||
| resource-materials.pdf | 466.61 KB | ||
| 006 ER Diagrams | |||
| Resource-Materials.pdf | 305.59 KB | ||
| quizzes | |||
| 001 Relational Database Terminology Quiz.html | 4.21 KB | ||
| 002 Interview the Data Quiz.html | 3.78 KB | ||
| 003 Normalization Quiz.html | 4.99 KB | ||
| 004 ER Diagram Quiz.html | 3.86 KB | ||
| 04 Schema Creation | |||
| 007 Schema Creation Part 1.mp4 | 466.78 MB | ||
| 008 Schema Creation Part 2.mp4 | 639.02 MB | ||
| 009 Schema Creation Part 3.mp4 | 636.58 MB | ||
| 010 Schema Modification.mp4 | 72.08 MB | ||
| attached_files | |||
| 007 Schema Creation Part 1 | |||
| My-Store.txt | 9.24 KB | ||
| Resource-Material.pdf | 663.21 KB | ||
| 008 Schema Creation Part 2 | |||
| resource-materials.pdf | 565.2 KB | ||
| 009 Schema Creation Part 3 | |||
| Resource-Materials.pdf | 603.58 KB | ||
| 010 Schema Modification | |||
| My-Store-Modifications.txt | 7.25 KB | ||
| resource-materials.pdf | 1.06 MB | ||
| quizzes | |||
| 005 Schema Creation Part 1 Quiz.html | 4.51 KB | ||
| 006 Schema Creation Part 2 Quiz.html | 3.86 KB | ||
| 007 Schema Creation Part 3 Quiz.html | 3.74 KB | ||
| 008 Schema Modification Quiz.html | 3.66 KB | ||
| 05 Data Manipulation Language | |||
| 011 Data Manipulation Language.mp4 | 714.66 MB | ||
| attached_files | |||
| 011 Data Manipulation Language | |||
| My-Store-Data.txt | 14.53 KB | ||
| Resource-Materials.pdf | 543.48 KB | ||
| quizzes | |||
| 009 DML Quiz.html | 4.24 KB | ||
| 06 Queries | |||
| 012 Single Table Selects Part 1.mp4 | 419.47 MB | ||
| 013 Single Table Selects Part 2.mp4 | 616.82 MB | ||
| 014 Multi-table Queries.mp4 | 52.13 MB | ||
| 015 Subqueries.mp4 | 57.76 MB | ||
| 016 Set Operators Translate and Replace.mp4 | 28.9 MB | ||
| 017 Advanced Queries.mp4 | 50.72 MB | ||
| attached_files | |||
| 012 Single Table Selects Part 1 | |||
| lecture-12-selects.txt | 1.42 KB | ||
| resource-materials.pdf | 412.21 KB | ||
| 013 Single Table Selects Part 2 | |||
| Lecture-13-selects.txt | 1.85 KB | ||
| Where-Clause-Operators-2.pdf | 111.62 KB | ||
| resource-materials.pdf | 380.31 KB | ||
| 014 Multi-table Queries | |||
| lecture-14-selects.txt | 2.79 KB | ||
| resource-materials.pdf | 390.28 KB | ||
| 015 Subqueries | |||
| lecture-15-selects.txt | 2.4 KB | ||
| resource-materials.pdf | 588.87 KB | ||
| 016 Set Operators Translate and Replace | |||
| Resource-Materials.pdf | 625.93 KB | ||
| lecture-16-selects.txt | 2.88 KB | ||
| 017 Advanced Queries | |||
| lecture-17-selects.txt | 3.66 KB | ||
| resource-materials.pdf | 743.26 KB | ||
| quizzes | |||
| 010 Single Table Select Part 1 Quiz.html | 3.51 KB | ||
| 011 Single Table Queries Part 2 Quiz.html | 3.46 KB | ||
| 012 Joins Quiz.html | 3.73 KB | ||
| 013 Subqueries Quiz.html | 4.61 KB | ||
| 014 Set Operators Translate and Replace Quiz.html | 3.99 KB | ||
| 015 Advanced Queries.html | 3.52 KB | ||
| 07 PLSQL | |||
| 018 PLSQL Procedures.mp4 | 42.47 MB | ||
| 019 PLSQL Functions.mp4 | 37.97 MB | ||
| 020 PLSQL Triggers and Packages.mp4 | 60.65 MB | ||
| attached_files | |||
| 018 PLSQL Procedures | |||
| lecture-18-scripts.txt | 1.94 KB | ||
| resource-materials.pdf | 466.94 KB | ||
| 019 PLSQL Functions | |||
| lecture-19-scripts.txt | 5.67 KB | ||
| resource-materials.pdf | 813.42 KB | ||
| 020 PLSQL Triggers and Packages | |||
| lecture-20-script.txt | 5.3 KB | ||
| resource-materials.pdf | 623.83 KB | ||
| quizzes | |||
| 016 PLSQL Procedures Quiz.html | 3.45 KB | ||
| 017 PLSQL Functions Quiz.html | 3.91 KB | ||
| 018 PLSQL Triggers and Packages Quiz.html | 4 KB | ||
| 08 Less Frequently Used Oracle Constructs | |||
| 021 User-Defined Types.mp4 | 44.76 MB | ||
| 022 Collections.mp4 | 43.2 MB | ||
| 023 LOBs.mp4 | 41.95 MB | ||
| 024 XML.mp4 | 55.42 MB | ||
| 025 Performance Part 1.mp4 | 54.32 MB | ||
| 026 Performance Part 2.mp4 | 44.44 MB | ||
| attached_files | |||
| 021 User-Defined Types | |||
| lecture-21-scripts.txt | 5.88 KB | ||
| resource-materials.pdf | 954.38 KB | ||
| 022 Collections | |||
| lecture-22-script.txt | 3.16 KB | ||
| resource-materials.pdf | 587.07 KB | ||
| 023 LOBs | |||
| lecture-23-script.txt | 3.72 KB | ||
| resource-materials.pdf | 640.68 KB | ||
| 024 XML | |||
| lecture-24-XML.txt | 706 B | ||
| lecture-24-script.txt | 6.64 KB | ||
| resource-materials.pdf | 1.09 MB | ||
| 025 Performance Part 1 | |||
| lecture-25-script.txt | 2.35 KB | ||
| resource-materials.pdf | 378.17 KB | ||
| 026 Performance Part 2 | |||
| lecture-26-script.txt | 570 B | ||
| resource-materials.pdf | 258.88 KB | ||
| quizzes | |||
| 019 User-Defined Types Quiz.html | 4.3 KB | ||
| 020 Collections Quiz.html | 4.67 KB | ||
| 021 LOBs Quiz.html | 3.46 KB | ||
| 022 XML Quiz.html | 3.94 KB | ||
| 023 Performance Quiz.html | 4.02 KB | ||
| 09 Summary and Conclusion | |||
| 027 Wrap up.mp4 | 66.15 MB |
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
Oracle SQL - From Beginner to Pro
Год выпуска: 2017
Производитель: Udemy
Сайт производителя: udemy.com/oracle-sql-from-beginner-to-pro
Автор: Dr. Rick Phillips
Продолжительность: 6h 40m
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: This course introduces the learner to all facets of Oracle SQL programming. The course begins with a section on relational database theory, moves onto cover the data definition components of SQL, the data manipulation components of SQL and then does a deep dive on queries. The course culminates with a overview of user-defined objects, collections, XML, large objects and performance.
The course is fast paced and targeted toward aggressive learners. Each of Dr. Phillips' examples, as well his lecture scripts, are provided as resource materials. Dr. Phillips shares many valuable experiences from both his academic and real-world careers.
This course is highly recommended for anyone seeking to advance their career by adding Oracle SQL programming to their technical toolbox as well as those seeking Oracle certification.
Этот курс знакомит учащегося со всеми аспектами программирования Oracle SQL. Курс начинается с раздела по теории реляционных баз данных, перемещается на покрытие компонентов определения данных SQL, компонентов обработки данных SQL и затем совершает глубокое погружение по запросам. Курс завершается обзором пользовательских объектов, коллекций, XML, больших объектов и производительности.
[spoiler="Содержание"]
Course Overview and Foundation
Software Setup
Relational Database Theory
Schema Creation
Data Manipulation Language
Queries
PL/SQL
Less Frequently Used Oracle Constructs
Summary and Conclusion
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG-4 1280x720 16:9 29.9 fps 564 kbps
Аудио: AAC 48000 Hz 192 kbps Стерео
[spoiler="Скриншоты"]
![]()
[/spoiler]
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 918 MB | freecoursewb | 7 months | 4 | 5 | |
| 13.2 GB | DeadlySin | 8 months | 11 | 0 | |
| 1.7 GB | freecoursewb | 1 year | 3 | 0 | |
| 1.4 GB | freecoursewb | 2 years | 0 | 0 | |
| 970.9 MB | freecoursewb | 2 years | 2 | 0 |
All Comments