Znajdź zawartość

Oracle PL/SQL Programming Fundamentals LiveLessons English | 2015 | .FLV | h264, yuv420p, 1280x720, 30.00 fps® | aac, 44100 Hz, stereo | 4.95 GB Genre: E-learning Oracle PL/SQL Programming Fundamentals LiveLessons covers the basics of Oracle's language extension for SQL and the Oracle relational database. The focus is to give students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and packages using the PL/SQL language. In this LiveLessons course, Oracle ACE Director Dan Hotka will teach you how to work with existing code and create new programs. Along the way, you will learn both conditional and looping syntax and techniques, error handling and error processing, plus how to work with script files, procedures, functions and packages (a collection of procedures and functions). This hands-on course also covers how to use the PL/SQL Debugger and the PL/SQL profiler and how to apply PL/SQL performance tips. Contents Lesson 1: PL/SQL Course Overview Learning objectives 1.1 Understand the course pre-requisites 1.2 Learn the Oracle database objects to be used in this course 1.3 Review the command-line SQL*Plus tool 1.4 Review SQL Developer tool 1.5 Review TOAD tool Put it all together Lesson 2: Oracle PL/SQL Overview Learning objectives 2.1. Review Oracle architecture 2.2. Review PL/SQL overview Put it all together Lesson 3: PL/SQL Basics and Variables Learning objectives 3.1 Explore PL/SQL basics 3.2 Use PL/SQL variables Put it all together Lesson 4: Logic Flow Learning objectives 4.1 Understand IF/THEN/ELSE logic 4.2 Explore the CASE statement 4.3 Utilize looping syntax Put it all together Lesson 5: PL/SQL Cursors Learning objectives 5.1 Introduce PL/SQL cursors and the implicit cursor 5.2 Explore explicit cursors Put it all together Lesson 6: PL/SQL Exception Handling Learning objectives 6.1 Introduce PL/SQL exceptions 6.2 Explore PL/SQL exception basic syntax 6.3 Discover implicit vs explicit exceptions 6.4 Work with SQLCODE and SQLERRM features 6.5 Understand user defined exceptions 6.6 Use application defined exceptions Put it all together Lesson 7: PL/SQL Procedures and Functions Learning objectives 7.1 Introduce PL/SQL procedures and functions 7.2 Explore PL/SQL procedures 7.3 Understand PL/SQL functions 7.4 Work with parameter passing Put it all together Lesson 8: PL/SQL Packages Learning objectives 8.1 Introduce PL/SQL packages 8.2 Explore the package syntax 8.3 Review executing code in packages Put it all together Lesson 9: PL/SQL Triggers Learning objectives 9.1 Introduce PL/SQL triggers 9.2 Explore the trigger syntax 9.3 Review the order of trigger processing and other restrictions 9.4 Work with useful examples Put it all together Lesson 10: PL/SQL New Features Learning objectives 10.1 Introduce PL/SQL new features 10.2 Explore the new features with tips and techniques Put it all together Lesson 11: PL/SQL Collections Learning objectives 11.1 Introduce PL/SQL collections 11.2 Explore the collection syntax 11.3 Review code examples 11.4 Explore bulk binding techniques Put it all together Lesson 12: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips Learning objectives 12.1 Introduce PL/SQL debugging, PL/SQL profiling, PL/SQL coding tips 12.2 Explore the TOAD debugger 12.3 Explore the SQL developer debugger 12.4 Review the PL/SQL profiler 12.5 Use the PL/SQL profiler with SQL*Plus 12.6 Use the TOAD PL/SQL profiler 12.7 Review PL/SQL coding tips Put it all together Summary Buy Premium Account To Get Resumable Support & Max Speed http://www.nitroflare.com/view/555A6E4F323A5F4/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part01.rar http://www.nitroflare.com/view/31DA7404179C9AF/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part02.rar http://www.nitroflare.com/view/B99DA27FBFC5478/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part03.rar http://www.nitroflare.com/view/E47725B2F973711/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part04.rar http://www.nitroflare.com/view/E8A29AA076A686A/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part05.rar http://www.nitroflare.com/view/AEFAFAFE1B101D6/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part06.rar http://www.nitroflare.com/view/1D2A4D85E2EC3E7/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part07.rar http://www.nitroflare.com/view/AEC1336EC0CF5AC/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part08.rar http://www.nitroflare.com/view/AF659E30B0CD8CF/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part09.rar http://www.nitroflare.com/view/EE31A265EB8D717/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part10.rar http://www.nitroflare.com/view/FB19E90E2C4F3CC/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part11.rar http://www.nitroflare.com/view/69F13C63EB18F5E/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part12.rar http://www.nitroflare.com/view/B8E37FDBACAC0CF/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part13.rar http://rapidgator.net/file/0a716fe84f5aff6e50cc16df8b27af91/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part01.rar.html http://rapidgator.net/file/2f407fa95a12debe7f8f6ecca15fdd0b/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part02.rar.html http://rapidgator.net/file/d8510e6f4a533fa163ed28ece52e60a6/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part03.rar.html http://rapidgator.net/file/9ca797e680fcd27515163c1d674139ab/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part04.rar.html http://rapidgator.net/file/5118e978f1b2541077dd7dc5813759ef/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part05.rar.html http://rapidgator.net/file/aa611500da8525235f4615e80a82c832/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part06.rar.html http://rapidgator.net/file/0d22283ea92c6324808a6b3e789e0840/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part07.rar.html http://rapidgator.net/file/8d83cd8989d57881bab0dc1e16f3f636/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part08.rar.html http://rapidgator.net/file/114eca25c9e829033f61a7fb97c05bba/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part09.rar.html http://rapidgator.net/file/58a4cb59355400e0e79aa48c3286dc22/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part10.rar.html http://rapidgator.net/file/3d36dcf411cab0e1b11d36329f078b1f/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part11.rar.html http://rapidgator.net/file/4be361ed72b0a935d166d36f00a3e33d/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part12.rar.html http://rapidgator.net/file/4ceb159afc70845a82e58df1f36d843a/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part13.rar.html http://www.uploadable.ch/file/32cWugdnRUc8/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part01.rar http://www.uploadable.ch/file/fxz9qVmrCfJ2/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part02.rar http://www.uploadable.ch/file/ywEjHrzEwhpx/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part03.rar http://www.uploadable.ch/file/4f2EqR7qTJGE/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part04.rar http://www.uploadable.ch/file/yA7J2QgGNHFz/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part05.rar http://www.uploadable.ch/file/HYrzmjXyPMrw/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part06.rar http://www.uploadable.ch/file/ztZXfTq8r9DP/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part07.rar http://www.uploadable.ch/file/n4rVCe6hHC5v/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part08.rar http://www.uploadable.ch/file/RS2TxhNJzeEq/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part09.rar http://www.uploadable.ch/file/bP9AuKk3Pbxg/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part10.rar http://www.uploadable.ch/file/YAKbpFzBPaRb/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part11.rar http://www.uploadable.ch/file/QYvEMmDdP33j/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part12.rar http://www.uploadable.ch/file/MmPyzkE5py6s/y9wfq.Oracle.PLSQL.Programming.Fundamentals.LiveLessons.part13.rar Links are Interchangeable - No Password

Working with Collections in Oracle PL/SQL With Pankaj Jain 766MB | Duration: 4h 52m | Video: AVC (.mp4) 1024x768 15fps | Audio: AAC 48KHz 2ch Genre: eLearning | Level: Intermediate | Language: English Oracle's relational databases are used by thousands of companies around the globe. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL which allows us to procedurally tie SQL statements to effectively define business logic. In this course, we will talk about collection types available in PL/SQL. Collections Types are an extremely important part of any programming language. The collection types, along with providing a mechanism to conveniently handle sets of data, can also boost performance. Oracle offers a rich set of collection types in Associative Arrays, Varrays, and Nested Tables. We will take an in-depth look at these powerful datatypes and get familiar with the Oracle bulk fetch and collect features which greatly enhance the performance of our PL/SQL code. Download From NitroFlare http://www.nitroflare.com/view/BF2B417F0811E6C/workcollectns0racl_pl-sql.part1.rar http://www.nitroflare.com/view/2F2203B3CB2486F/workcollectns0racl_pl-sql.part2.rar http://www.nitroflare.com/view/F15869A3C502B67/workcollectns0racl_pl-sql.part3.rar http://www.nitroflare.com/view/520B8E2ECB4A71B/workcollectns0racl_pl-sql.part4.rar Download From Keep2share http://k2s.cc/file/0d68d4d293ee9/workcollectns0racl_pl-sql.part1.rar http://k2s.cc/file/104fede04028b/workcollectns0racl_pl-sql.part2.rar http://k2s.cc/file/f7e7eaf8a4aa6/workcollectns0racl_pl-sql.part3.rar http://k2s.cc/file/93f54a55bed8c/workcollectns0racl_pl-sql.part4.rar