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

Книга "Learn PL/SQL in 1 Day" читать, скачать PDF

Автор:  Krishna Rungta
Издательство: 

Год: November 23, 2016
Страниц: 209
Язык: английский
Формат: PDF
ISBN: 

 
Аннотация:

  •  PL/SQL is an extension of SQL for the Oracle Database.
  • Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development.
  • The book contains tons of examples that prepare you for real-world development project.
  • This book is considered the best Oracle PL/SQL programming guide by the Oracle community.
  • The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code.
  • Here is what you will learn (книга научит Вас следующему)

Chapter 1: Introduction

  • What Is PL/SQL?
  • Architecture of PL/SQL
  • Advantage of Using PL/SQL
  • Basic Difference between SQL and PL/SQL

Chapter 2: Blocks

  • What is PL/SQL block?
  • Block Structure
  • Types of PL/SQL block

Chapter 3: First Program: Hello World

  • SQL Plus
  • Connecting to Database
  • How to write a simple program using PL/SQL
  • Declaring and usage of variables in program
  • Commenting Codes

Chapter 4: Data Types

  • CHARACTER
  • NUMBER
  • BOOLEAN
  • DATE
  • LOB

Chapter 5: Complex Data Types

  • Record Type
  • Collection
  • Constructor and Initialization Concept in Collections
  • Collection Methods

Chapter 6: Decision Making Statements

  • Introduction to Decision Making Statements
  • IF-THEN Statement
  • IF-THEN-ELSE Statement
  • IF-THEN-ELSIF Statement
  • NESTED-IF Statement
  • CASE Statement
  • SEARCHED CASE Statement

Chapter 7: Loops

  • Introduction to Loops Concept
  • Loop Control Statements
  • Types of Loop in PL/SQL
  • Nested Loops
  • Labelling of Loops

Chapter 8: Subprograms: Procedures and Functions

  • Terminologies in PL/SQL Subprograms
  • Procedure
  • Function
  • Similarities between Procedure and Function
  • Difference between Procedure and Function
  • Built-in Functions in PL/SQL

Chapter 9: Exception Handling

  • Exception-Handling
  • Predefined Exceptions
  • User-defined Exception
  • Raising an Exception
  • Important points to note in Exception

Chapter 10: SQL

  • DML Transactions in PL/SQL
  • CURSOR Concept in PL/SQL
  • Cursor Attributes
  • FOR Loop Cursor statement
  • BULK COLLECT in PL/SQL
  • TCL Statements in PL/SQL
  • Autonomous Transaction

Chapter 11: Packages

  • Components of Packages
  • Package Initialization
  • Forward Declarations
  • Overloading
  • Package Information
  • UTL FILE – An Overview

Chapter 12: Triggers

  • Benefits of Triggers
  • Trigger Classification
  • Trigger Creation
  • :NEW and :OLD Clause
  • INSTEAD OF Trigger
  • Compound Trigger

Chapter 13: Object Types

  • Components of Object Types
  • Creation of Objects
  • Declaration Initialization of Object Type
  • Constructors
  • Inheritance in Object Type
  • Equality of PL/SQL Objects

Chapter 14: Dynamic SQL

  • Ways to write dynamic SQL
  • NDS
  • DBMS_SQL for Dynamic SQL

Chapter 15: Nested Blocks

  • Nested Block Structure
  • Scopes in Nested Block

Chapter 16: Identifiers

  • Properties of Identifiers
  • Naming Conventions of Identifiers
  • Variables – An Identifier
  • Declaration of Variables
  • Data storing in Variables

 

СКАЧАТЬ КНИГУ ИЗ ИНТЕРНЕТА:

скачать книгу

Вас заинтересует / Intresting for you:

MySQL Explained: Your Step By ...
MySQL Explained: Your Step By ... 1361 просмотров Алексей Вятский Sun, 04 Aug 2019, 11:57:44
SQL для чайников
SQL для чайников 6413 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
MySQL Crash Course
MySQL Crash Course 1741 просмотров Алексей Вятский Thu, 17 Sep 2020, 13:20:13
MySQL introduction
MySQL introduction 1292 просмотров Алексей Вятский Sun, 04 Aug 2019, 11:57:44
Войдите чтобы комментировать

admin аватар
admin ответил в теме #10161 01 окт 2021 13:38
Удалено по просьба правообладателя...
ildergun аватар
ildergun ответил в теме #10160 01 окт 2021 13:33
А по ссылке только кусок книги. Где все остальное?))
1dz аватар
1dz ответил в теме #8518 12 июнь 2017 11:26
Вот и мне интересно. Кто по каким учебникам / книгам / видеокурсам учился программировать на языке PL/SQL и как Вам именно эта книга? Ну и ссылку дайте, конечно!
OraDevel аватар
OraDevel ответил в теме #8251 14 март 2017 10:20
Наверное самые основы-основы по PL/SQL, судя по количеству страниц. Читал кто-то сей эпос? :-)