Pluralsight - Oracle PLSQL. Transactions, Dynamic SQL & Debugging - 2014

seeders: 18

leechers: 44

Download torrent

Added on January 21, 2015 by RocknBassin Other > Tutorials
Torrent verified.

Main

add to bookmarks

Pluralsight - Oracle PLSQL. Transactions, Dynamic SQL & Debugging - 2014 (Size: 787.02 MB)

		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 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 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 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
		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
		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
		.ds_store	6 KB
		DROP.txt	242 bytes
		.ds_store	6 KB
		create.txt	1.88 KB
		.ds_store	12 KB
		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 bytes
		setup.txt	338 bytes
		.ds_store	6 KB
		DROP.txt	158 bytes
		.ds_store	6 KB
		create.txt	1.95 KB
		.ds_store	6 KB
		oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1.sql	782 bytes
		oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1a.sql	871 bytes
		oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1b.sql	510 bytes
		oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo2.sql	807 bytes
		oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo3.sql	1.36 KB
		setup.txt	338 bytes
		.ds_store	6 KB
		DROP.txt	256 bytes
		.ds_store	6 KB
		create.txt	3.47 KB
		.ds_store	6 KB
		DROP.txt	256 bytes
		oracle-plsql-fundamentals-m4-demo1-ddl.txt	795 bytes
		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
		setup.txt	338 bytes
		.ds_store	6 KB
		DROP.txt	198 bytes
		.ds_store	6 KB
		create.txt	2.63 KB
		.ds_store	15 KB
		oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo1.txt	489 bytes
		oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo2.txt	959 bytes
		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 bytes
		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
		setup.txt	338 bytes
		.ds_store	6 KB
		DROP.txt	148 bytes
		.ds_store	6 KB
		create.txt	1.91 KB
		.ds_store	6 KB
		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
		setup.txt	338 bytes
		1-oracle-plsql-transactions-dynamic-sql-debugging-m1-slides.pdf	95.49 KB
		2-oracle-plsql-transactions-dynamic-sql-debugging-m2-slides.pdf	199.88 KB
		3-oracle-plsql-transactions-dynamic-sql-debugging-m3-slides.pdf	207.42 KB
		4-oracle-plsql-transactions-dynamic-sql-debugging-m4-slides.pdf	259.2 KB
		5-oracle-plsql-transactions-dynamic-sql-debugging-m5-slides.pdf	463.45 KB
		6-oracle-plsql-transactions-dynamic-sql-debugging-m6-slides.pdf	157.54 KB

Description

Year : 2014
Manufacturer : pluralsight
Author : Pankaj Jain
Duration : 4h 1m
Language : English
Format : MP4
Video : AVC, 1024x768, 4: 3, 15 fps, 572 Kbps
Audio : AAC, 128 Kbps, 2 channels, 44.1 KHz

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. In this course we will talk in detail about transaction management with Oracle. We consider in detail the dynamic SQL and debugging options in PL / SQL debugger and studied in detail SQL Developer.

Content:
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

Sharing Widget

Download torrent

787.02 MB

seeders:18

leechers:44

Pluralsight - Oracle PLSQL. Transactions, Dynamic SQL & Debugging - 2014