FileMood

Download [pluralsight.com] Oracle PL_SQL. Transactions, Dynamic SQL & Debugging

Pluralsight com Oracle PL SQL Transactions Dynamic SQL Debugging

Name

[pluralsight.com] Oracle PL_SQL. Transactions, Dynamic SQL & Debugging

  DOWNLOAD Copy Link

Total Size

825.2 MB

Total Files

122

Hash

C53DC28595FFFC07F329B26DB294589C1BF8BEA3

/01 Introduction/

01 01 Overview.mp4

4.4 MB

01 02 Prerequisites.mp4

1.6 MB

01 03 Audience.mp4

1.5 MB

01 04 Tools.mp4

2.5 MB

/02 Transaction Management in PL_SQL/

02 01 Transaction Management in Oracle.mp4

18.1 MB

02 02 Transaction Names & Read Only Transactions.mp4

8.6 MB

02 03 Commits.mp4

8.6 MB

02 04 Rollbacks & Statement Level Atomicity.mp4

8.9 MB

02 05 Demo - Commit & Rollback.mp4

42.4 MB

02 06 Savepoints.mp4

14.7 MB

02 07 Demo - Savepoints.mp4

30.2 MB

02 08 Explicit Locks.mp4

9.1 MB

02 09 Summary.mp4

1.2 MB

/03 Autonomous Transactions/

03 01 What Are Autonomous Transactions.mp4

4.7 MB

03 02 How to Define Autonomous Transactions.mp4

8.5 MB

03 03 How Autonomous Transactions Work & Considerations.mp4

9.5 MB

03 04 Need for Autonomous Transactions.mp4

16.6 MB

03 05 Demo - Need for Autonomous Transactions.mp4

17.0 MB

03 06 Demo - Transaction Context With Autonomous Transactions.mp4

10.4 MB

03 07 Creating Atomic & Independent Work Units.mp4

5.0 MB

03 08 Demo -Creating Atomic & Independent Work Units.mp4

17.9 MB

03 09 Summary.mp4

1.6 MB

/04 Native Dynamic SQL/

04 01 What Is a Dynamic SQL.mp4

9.7 MB

04 02 Static vs. Dynamic SQL.mp4

5.1 MB

04 03 Common Usage Scenarios.mp4

5.2 MB

04 04 Native Dynamic SQL Syntax Advantages & Syntax.mp4

5.3 MB

04 05 DDL Operations.mp4

8.5 MB

04 06 Demo - Executing DDL Statements.mp4

12.9 MB

04 07 Executing Single Row & Multiple Row Selects.mp4

27.9 MB

04 08 Demo - Single Row & Multi-Row Select.mp4

18.4 MB

04 09 Executing DML Statements.mp4

13.4 MB

04 10 Executing Anonymous Blocks, Procedures & Functions.mp4

12.1 MB

04 11 Demo - Executing Procedures.mp4

31.0 MB

04 12 Hints, Session Control Statements & Invokers Right.mp4

7.2 MB

04 13 SQL Injection.mp4

8.6 MB

04 14 Demo - SQL Injection.mp4

11.8 MB

04 15 Summary.mp4

1.4 MB

/05 Dynamic SQL Using DBMS_SQL/

05 01 Introduction.mp4

4.0 MB

05 02 DBMS_SQL Workflow.mp4

5.9 MB

05 03 Executing DDL & Session Control Statements.mp4

12.4 MB

05 04 Demo - Executing DDL Statements.mp4

7.6 MB

05 05 Executing DML Statements.mp4

20.0 MB

05 06 Executing Anonymous Blocks & Subprograms.mp4

15.2 MB

05 07 Demo - Executing Anonymous Blocks & Subprograms.mp4

12.8 MB

05 08 Executing Select Statements.mp4

18.0 MB

05 09 Demo - Executing Select Statements.mp4

27.8 MB

05 10 Describing Columns.mp4

10.3 MB

05 11 Unknown Number of Select Statements.mp4

15.8 MB

05 12 Demo - Unknown.mp4

29.1 MB

05 13 Security.mp4

5.5 MB

05 14 Demo - Security.mp4

10.2 MB

05 15 DBMS_SQL & Native Dynamic SQL Interoperability.mp4

13.9 MB

05 16 Summary.mp4

1.4 MB

/06 Debugging PL_SQL Code/

06 01 Debugging Methods.mp4

3.9 MB

06 02 DBMS_OUTPUT.mp4

5.0 MB

06 03 DBMS_UTILITY.mp4

6.6 MB

06 04 Demo - DBMS_OUTPUT.mp4

32.6 MB

06 05 Compiling for Debug.mp4

2.2 MB

06 06 Demo - SQL Developer Debugger Setup.mp4

28.9 MB

06 07 Demo - Debugger Views, Navigation & Debugging Exceptions.mp4

45.7 MB

06 08 Demo - Navigating Execution Flow With Debugger.mp4

40.9 MB

06 09 Demo - What if Analysis & Conditional Breakpoints.mp4

24.3 MB

06 10 Summary.mp4

1.7 MB

/Exercise Files/

1-oracle-plsql-transactions-dynamic-sql-debugging-m1-slides.pdf

97.8 KB

2-oracle-plsql-transactions-dynamic-sql-debugging-m2-slides.pdf

204.7 KB

3-oracle-plsql-transactions-dynamic-sql-debugging-m3-slides.pdf

212.4 KB

4-oracle-plsql-transactions-dynamic-sql-debugging-m4-slides.pdf

265.4 KB

5-oracle-plsql-transactions-dynamic-sql-debugging-m5-slides.pdf

474.6 KB

6-oracle-plsql-transactions-dynamic-sql-debugging-m6-slides.pdf

161.3 KB

/.../2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/

.DS_Store

12.3 KB

oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1.txt

1.9 KB

oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demo1A.txt

3.6 KB

oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2.txt

1.5 KB

oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-demos2a.txt

1.9 KB

oracle-plsql-transactions-dynamic-sql-debugging-m2-transactions-drop.txt

0.2 KB

Setup.txt

0.3 KB

/.../2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/After/

.DS_Store

6.1 KB

drop.txt

0.2 KB

/.../2-oracle-plsql-transactions-dynamic-sql-debugging-m2-exercise-files/Demos/Before/

.DS_Store

6.1 KB

create.txt

1.9 KB

/.../3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/

.DS_Store

6.1 KB

oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1.sql

0.8 KB

oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1a.sql

0.9 KB

oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo1b.sql

0.5 KB

oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo2.sql

0.8 KB

oracle-plsql-transactions-dynamic-sql-debugging-m3-auto-demo3.sql

1.4 KB

Setup.txt

0.3 KB

/.../3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/After/

.DS_Store

6.1 KB

drop.txt

0.2 KB

/.../3-oracle-plsql-transactions-dynamic-sql-debugging-m3-exercise-files/Demos/Before/

.DS_Store

6.1 KB

create.txt

2.0 KB

/.../4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/

.DS_Store

6.1 KB

drop.txt

0.3 KB

oracle-plsql-fundamentals-m4-demo1-ddl.txt

0.8 KB

oracle-plsql-fundamentals-m4-demo2-record.txt

1.1 KB

oracle-plsql-fundamentals-m4-demo3-dmlproc.txt

1.5 KB

oracle-plsql-fundamentals-m4-demo4-sqlinjection.txt

1.0 KB

Setup.txt

0.3 KB

/.../4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/After/

.DS_Store

6.1 KB

drop.txt

0.3 KB

/.../4-oracle-plsql-transactions-dynamic-sql-debugging-m4-exercise-files/Demos/Before/

.DS_Store

6.1 KB

create.txt

3.6 KB

/.../5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/

.DS_Store

15.4 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo1.txt

0.5 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo2.txt

1.0 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo3.txt

1.1 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4a.txt

1.0 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4b.txt

1.9 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_demo4c.txt

2.7 KB

Setup.txt

0.3 KB

/.../5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/After/

.DS_Store

6.1 KB

drop.txt

0.2 KB

/.../5-oracle-plsql-transactions-dynamic-sql-debugging-m5-exercise-files/Demos/Before/

.DS_Store

6.1 KB

create.txt

2.7 KB

/.../6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/

.DS_Store

6.1 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_debugging_demo1.txt

1.6 KB

oracle-plsql-transactions-dynamic-sql-debugging-m5-dbms_sql_debugging_demo2.txt

2.1 KB

Setup.txt

0.3 KB

/.../6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/After/

.DS_Store

6.1 KB

drop.txt

0.1 KB

/.../6-oracle-plsql-transactions-dynamic-sql-debugging-m6-exercise-files/Demos/Before/

.DS_Store

6.1 KB

create.txt

2.0 KB
 

Total files 122

Copyright © 2024 FileMood.com