Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners

Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners

<p>PL/SQL is an extension of SQL for the Oracle Database.</p><p>Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development.</p><p>The book contains tons of examples that prepare you for real-world development project.</p><p>This book is considered the best Oracle PL/SQL programming guide by the Oracle community.</p><p>The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code.</p><p>Here is what you will learn<br /></p><p>Chapter 1: Introduction</p><p><br /></p><p>What Is PL/SQL?</p><p>Architecture of PL/SQL</p><p>Advantage of Using PL/SQL</p><p>Basic Difference between SQL and PL/SQL</p><p>Chapter 2: Blocks</p><p><br /></p><p>What is PL/SQL block?</p><p>Block Structure</p><p>Types of PL/SQL block</p><p>Chapter 3: First Program: Hello World</p><p><br /></p><p>SQL Plus</p><p>Connecting to Database</p><p>How to write a simple program using PL/SQL</p><p>Declaring and usage of variables in program</p><p>Commenting Codes</p><p>Chapter 4: Data Types</p><p><br /></p><p>CHARACTER</p><p>NUMBER</p><p>BOOLEAN</p><p>DATE</p><p>LOB</p><p>Chapter 5: Complex Data Types</p><p><br /></p><p>Record Type</p><p>Collection</p><p>Constructor and Initialization Concept in Collections</p><p>Collection Methods</p><p>Chapter 6: Decision Making Statements</p><p><br /></p><p>Introduction to Decision Making Statements</p><p>IF-THEN Statement</p><p>IF-THEN-ELSE Statement</p><p>IF-THEN-ELSIF Statement</p><p>NESTED-IF Statement</p><p>CASE Statement</p><p>SEARCHED CASE Statement</p><p>Chapter 7: Loops</p><p><br /></p><p>Introduction to Loops Concept</p><p>Loop Control Statements</p><p>Types of Loop in PL/SQL</p><p>Nested Loops</p><p>Labelling of Loops</p><p>Chapter 8: Subprograms: Procedures and Functions</p><p><br /></p><p>Terminologies in PL/SQL Subprograms</p><p>Procedure</p><p>Function</p><p>Similarities between Procedure and Function</p><p>Difference between Procedure and Function</p><p>Built-in Functions in PL/SQL</p><p>Chapter 9: Exception Handling</p><p><br /></p><p>Exception-Handling</p><p>Predefined Exceptions</p><p>User-defined Exception</p><p>Raising an Exception</p><p>Important points to note in Exception</p><p>Chapter 10: SQL</p><p><br /></p><p>DML Transactions in PL/SQL</p><p>CURSOR Concept in PL/SQL</p><p>Cursor Attributes</p><p>FOR Loop Cursor statement</p><p>BULK COLLECT in PL/SQL</p><p>TCL Statements in PL/SQL</p><p>Autonomous Transaction</p><p>Chapter 11: Packages</p><p><br /></p><p>Components of Packages</p><p>Package Initialization</p><p>Forward Declarations</p><p>Overloading</p><p>Package Information</p><p>UTL FILE – An Overview</p><p>Chapter 12: Triggers</p><p><br /></p><p>Benefits of Triggers</p><p>Trigger Classification</p><p>Trigger Creation</p><p>:NEW and :OLD Clause</p><p>INSTEAD OF Trigger</p><p>Compound Trigger</p><p>Chapter 13: Object Types</p><p><br /></p><p>Components of Object Types</p><p>Creation of Objects</p><p>Declaration Initialization of Object Type</p><p>Constructors</p><p>Inheritance in Object Type</p><p>Equality of PL/SQL Objects</p><p>Chapter 14: Dynamic SQL</p><p><br /></p><p>Ways to write dynamic SQL</p><p>NDS</p><p>DBMS_SQL for Dynamic SQL</p><p>Chapter 15: Nested Blocks</p><p><br /></p><p>Nested Block Structure</p><p>Scopes in Nested Block</p><p>Chapter 16: Identifiers</p><p><br /></p><p>Properties of Identifiers</p><p>Naming Conventions of Identifiers</p><p>Variables – An Identifier</p><p>Declaration of Variables</p><p>Data storing in Variables<br /></p>