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


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

Год: November 23, 2016
Страниц: 209
Язык: английский
Формат:
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 Crash Course
MySQL Crash Course 1347 просмотров Алексей Вятский Thu, 17 Sep 2020, 13:20:13
Jump Start MySQL
Jump Start MySQL 866 просмотров Алексей Вятский Thu, 17 Sep 2020, 13:11:06
SQL для чайников
SQL для чайников 4718 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
T-SQL Fundamentals - 3rd Editi...
T-SQL Fundamentals - 3rd Editi... 1487 просмотров Алексей Вятский Mon, 05 Aug 2019, 05:39:41

Войдите чтобы комментировать

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