Oracle PL\SQL. Transactions, Dynamic SQL & Debugging [2014, ENG]
movies, software, shows...
Files
| 01 Introduction | |||
| 01 01 Overview.mp4 | 4.23 MB | ||
| 01 02 Prerequisites.mp4 | 1.54 MB | ||
| 01 03 Audience.mp4 | 1.4 MB | ||
| 01 04 Tools.mp4 | 2.37 MB | ||
| 02 Transaction Management in PL_SQL | |||
| 02 01 Transaction Management in Oracle.mp4 | 17.22 MB | ||
| 02 02 Transaction Names & Read Only Transactions.mp4 | 8.24 MB | ||
| 02 03 Commits.mp4 | 8.21 MB | ||
| 02 04 Rollbacks & Statement Level Atomicity.mp4 | 8.47 MB | ||
| 02 05 Demo - Commit & Rollback.mp4 | 40.45 MB | ||
| 02 06 Savepoints.mp4 | 14.05 MB | ||
| 02 07 Demo - Savepoints.mp4 | 28.83 MB | ||
| 02 08 Explicit Locks.mp4 | 8.7 MB | ||
| 02 09 Summary.mp4 | 1.18 MB | ||
| 03 Autonomous Transactions | |||
| 03 01 What Are Autonomous Transactions.mp4 | 4.46 MB | ||
| 03 02 How to Define Autonomous Transactions.mp4 | 8.1 MB | ||
| 03 03 How Autonomous Transactions Work & Considerations.mp4 | 9.09 MB | ||
| 03 04 Need for Autonomous Transactions.mp4 | 15.87 MB | ||
| 03 05 Demo - Need for Autonomous Transactions.mp4 | 16.23 MB | ||
| 03 06 Demo - Transaction Context With Autonomous Transactions.mp4 | 9.91 MB | ||
| 03 07 Creating Atomic & Independent Work Units.mp4 | 4.81 MB | ||
| 03 08 Demo -Creating Atomic & Independent Work Units.mp4 | 17.08 MB | ||
| 03 09 Summary.mp4 | 1.51 MB | ||
| 04 Native Dynamic SQL | |||
| 04 01 What Is a Dynamic SQL.mp4 | 9.2 MB | ||
| 04 02 Static vs. Dynamic SQL.mp4 | 4.87 MB | ||
| 04 03 Common Usage Scenarios.mp4 | 4.95 MB | ||
| 04 04 Native Dynamic SQL Syntax Advantages & Syntax.mp4 | 5.09 MB | ||
| 04 05 DDL Operations.mp4 | 8.11 MB | ||
| 04 06 Demo - Executing DDL Statements.mp4 | 12.32 MB | ||
| 04 07 Executing Single Row & Multiple Row Selects.mp4 | 26.65 MB | ||
| 04 08 Demo - Single Row & Multi-Row Select.mp4 | 17.58 MB | ||
| 04 09 Executing DML Statements.mp4 | 12.83 MB | ||
| 04 10 Executing Anonymous Blocks, Procedures & Functions.mp4 | 11.55 MB | ||
| 04 11 Demo - Executing Procedures.mp4 | 29.55 MB | ||
| 04 12 Hints, Session Control Statements & Invokers Right.mp4 | 6.85 MB | ||
| 04 13 SQL Injection.mp4 | 8.21 MB | ||
| 04 14 Demo - SQL Injection.mp4 | 11.25 MB | ||
| 04 15 Summary.mp4 | 1.35 MB | ||
| 05 Dynamic SQL Using DBMS_SQL | |||
| 05 01 Introduction.mp4 | 3.77 MB | ||
| 05 02 DBMS_SQL Workflow.mp4 | 5.6 MB | ||
| 05 03 Executing DDL & Session Control Statements.mp4 | 11.79 MB | ||
| 05 04 Demo - Executing DDL Statements.mp4 | 7.27 MB | ||
| 05 05 Executing DML Statements.mp4 | 19.12 MB | ||
| 05 06 Executing Anonymous Blocks & Subprograms.mp4 | 14.48 MB | ||
| 05 07 Demo - Executing Anonymous Blocks & Subprograms.mp4 | 12.25 MB | ||
| 05 08 Executing Select Statements.mp4 | 17.13 MB | ||
| 05 09 Demo - Executing Select Statements.mp4 | 26.51 MB | ||
| 05 10 Describing Columns.mp4 | 9.8 MB | ||
| 05 11 Unknown Number of Select Statements.mp4 | 15.1 MB | ||
| 05 12 Demo - Unknown.mp4 | 27.75 MB | ||
| 05 13 Security.mp4 | 5.29 MB | ||
| 05 14 Demo - Security.mp4 | 9.77 MB | ||
| 05 15 DBMS_SQL & Native Dynamic SQL Interoperability.mp4 | 13.27 MB | ||
| 05 16 Summary.mp4 | 1.35 MB | ||
| 06 Debugging PL_SQL Code | |||
| 06 01 Debugging Methods.mp4 | 3.71 MB | ||
| 06 02 DBMS_OUTPUT.mp4 | 4.75 MB | ||
| 06 03 DBMS_UTILITY.mp4 | 6.31 MB | ||
| 06 04 Demo - DBMS_OUTPUT.mp4 | 31.08 MB | ||
| 06 05 Compiling for Debug.mp4 | 2.09 MB | ||
| 06 06 Demo - SQL Developer Debugger Setup.mp4 | 27.6 MB | ||
| 06 07 Demo - Debugger Views, Navigation & Debugging Exceptions.mp4 | 43.62 MB | ||
| 06 08 Demo - Navigating Execution Flow With Debugger.mp4 | 39.05 MB | ||
| 06 09 Demo - What if Analysis & Conditional Breakpoints.mp4 | 23.13 MB | ||
| 06 10 Summary.mp4 | 1.63 MB | ||
| Exercise Files | |||
| 1-oracle-plsql-transactions-dynamic-sql-debugging-m1-slides.pdf | 95.49 KB | ||
| 2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files | |||
| Demos | |||
| .DS_Store | 12 KB | ||
| After | |||
| .DS_Store | 6 KB | ||
| drop.txt | 242 B | ||
| Before | |||
| .DS_Store | 6 KB | ||
| create.txt | 1.88 KB | ||
| Setup.txt | 338 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1.txt | 1.84 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1A.txt | 3.49 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2.txt | 1.47 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2a.txt | 1.85 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-drop.txt | 242 B | ||
| 2-oracle-plsql-transactions-dynamic-sql-debugging-m2-slides.pdf | 199.88 KB | ||
| 3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files | |||
| Demos | |||
| .DS_Store | 6 KB | ||
| After | |||
| .DS_Store | 6 KB | ||
| drop.txt | 158 B | ||
| Before | |||
| .DS_Store | 6 KB | ||
| create.txt | 1.95 KB | ||
| Setup.txt | 338 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1.sql | 782 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1a.sql | 871 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1b.sql | 510 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo2.sql | 807 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo3.sql | 1.36 KB | ||
| 3-oracle-plsql-transactions-dynamic-sql-debugging-m3-slides.pdf | 207.42 KB | ||
| 4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files | |||
| Demos | |||
| .DS_Store | 6 KB | ||
| After | |||
| .DS_Store | 6 KB | ||
| drop.txt | 256 B | ||
| Before | |||
| .DS_Store | 6 KB | ||
| create.txt | 3.47 KB | ||
| Setup.txt | 338 B | ||
| drop.txt | 256 B | ||
| oracle-plsql-fundamentals-m4-demo1-ddl.txt | 795 B | ||
| oracle-plsql-fundamentals-m4-demo2-record.txt | 1.11 KB | ||
| oracle-plsql-fundamentals-m4-demo3-dmlproc.txt | 1.45 KB | ||
| oracle-plsql-fundamentals-m4-demo4-sqlinjection.txt | 1.02 KB | ||
| 4-oracle-plsql-transactions-dynamic-sql-debugging-m4-slides.pdf | 259.2 KB | ||
| 5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files | |||
| Demos | |||
| .DS_Store | 15 KB | ||
| After | |||
| .DS_Store | 6 KB | ||
| drop.txt | 198 B | ||
| Before | |||
| .DS_Store | 6 KB | ||
| create.txt | 2.63 KB | ||
| Setup.txt | 338 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo1.txt | 489 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo2.txt | 959 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo3.txt | 1.09 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4a.txt | 968 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4b.txt | 1.84 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4c.txt | 2.61 KB | ||
| 5-oracle-plsql-transactions-dynamic-sql-debugging-m5-slides.pdf | 463.45 KB | ||
| 6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files | |||
| Demos | |||
| .DS_Store | 6 KB | ||
| After | |||
| .DS_Store | 6 KB | ||
| drop.txt | 148 B | ||
| Before | |||
| .DS_Store | 6 KB | ||
| create.txt | 1.91 KB | ||
| Setup.txt | 338 B | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_debugging_demo1.txt | 1.61 KB | ||
| oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_debugging_demo2.txt | 2.06 KB | ||
| 6-oracle-plsql-transactions-dynamic-sql-debugging-m6-slides.pdf | 157.54 KB |
Description
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
Oracle PL\SQL. Transactions, Dynamic SQL & Debugging
Год выпуска: 2014
Производитель: pluralsight
Сайт производителя: pluralsight.com
Автор: Pankaj Jain
Продолжительность: 4h 1m
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: In this course, we will talk in detail about transaction management in Oracle. We will take an in-depth look at dynamic SQL and debugging options in PL/SQL, and explore in detail the SQL Developer Debugger.
В этом курсе мы будем говорить подробно об управлении транзакциями в Oracle. Мы подробно рассмотрим динамический SQL и параметры отладки в PL/SQL и подробно изучим отладчик SQL Developer.
[spoiler="Содержание"]
01. Introduction 6:30
Overview 2:54
Prerequisites 1:03
Audience 1:05
Tools 1:27
02. Transaction Management in PL/SQL 50:09
Transaction Management in Oracle 8:22
Transaction Names & Read Only Transactions 4:41
Commits 4:18
Rollbacks & Statement Level Atomicity 3:52
Demo: Commit & Rollback 9:40
Savepoints 6:08
Demo: Savepoints 7:05
Explicit Locks 5:07
Summary 0:54
03. Autonomous Transactions 27:36
What Are Autonomous Transactions? 2:50
How to Define Autonomous Transactions 3:27
How Autonomous Transactions Work & Considerations 3:43
Need for Autonomous Transactions 4:56
Demo: Need for Autonomous Transactions 3:51
Demo: Transaction Context With Autonomous Transactions 2:29
Creating Atomic & Independent Work Units 1:29
Demo:Creating Atomic & Independent Work Units 3:37
Summary 1:10
04. Native Dynamic SQL 58:47
What Is a Dynamic SQL? 4:02
Static vs. Dynamic SQL 2:30
Common Usage Scenarios 3:21
Native Dynamic SQL Syntax Advantages & Syntax 3:09
DDL Operations 3:39
Demo: Executing DDL Statements 2:26
Executing Single Row & Multiple Row Selects 9:53
Demo: Single Row & Multi-Row Select 3:31
Executing DML Statements 5:54
Executing Anonymous Blocks, Procedures & Functions 5:33
Demo: Executing Procedures 4:17
Hints, Session Control Statements & Invokers Right 3:14
SQL Injection 3:36
Demo: SQL Injection 2:33
Summary 1:03
05. Dynamic SQL Using DBMS_SQL 1:01:12
Introduction 2:12
DBMS_SQL Workflow 3:22
Executing DDL & Session Control Statements 5:02
Demo: Executing DDL Statements 1:50
Executing DML Statements 6:03
Executing Anonymous Blocks & Subprograms 4:07
Demo: Executing Anonymous Blocks & Subprograms 1:57
Executing Select Statements 6:37
Demo: Executing Select Statements 4:20
Describing Columns 5:04
Unknown Number of Select Statements 4:23
Demo: Unknown 5:41
Security 2:18
Demo: Security 1:55
DBMS_SQL & Native Dynamic SQL Interoperability 5:11
Summary 1:04
06. Debugging PL/SQL Code 37:22
Debugging Methods 2:13
DBMS_OUTPUT 2:57
DBMS_UTILITY 2:37
Demo: DBMS_OUTPUT 6:10
Compiling for Debug 1:21
Demo: SQL Developer Debugger Setup 4:32
Demo: Debugger Views, Navigation & Debugging Exceptions 6:47
Demo: Navigating Execution Flow With Debugger 6:02
Demo: What if Analysis & Conditional Breakpoints 3:22
Summary 1:19
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1024x768, 4:3, 15 fps, 572 Kbps
Аудио: AAC, 128 Kbps, 2 channels, 44.1 KHz
[spoiler="Скриншоты"]
[/spoiler]
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.4 GB | freecoursewb | 2 years | 0 | 0 | |
|
Udemy - Oracle Apex 19 - Sql, Pl - Sql To Web Application Development Posted by
freecoursewb in Other
|
2.4 GB | freecoursewb | 4 years | 0 | 0 |
| 773.6 MB | freecoursewb | 4 years | 0 | 1 | |
| 2.7 GB | freecoursewb | 4 years | 0 | 1 | |
| 256.9 MB | freecoursewb | 5 years | 0 | 0 |
All Comments