Oracle SQL, Analytical SQL and PL/SQL
%25
2,37 USD
3,16 USD
Stock code
9786059129374
Number of pages
344
The aspect
16,5 / 24 cm
Isbn
9786059129374
Publisher
Abaküs
Author
Fahrettin Ateş, Orhan Eripek, Özgür Umut Vurgun
Warranty Period
24 Month
Price
3,16 USD
The first chapter of the first SQL, Analytical SQL and PL/SQL book written in Turkish, written by Orhan Eripek, Özgür Umut Vurgun and Fahrettin Ateş, gives information about the SQL language as well as detailed information about the configuration of the programs required to test the examples. Starting with simple SQL statements to the next sections, topics such as functions, joins, DML statements and user management are covered in the SQL language. At the same time, the authors, who deal with many different examples of database objects such as table, synonym, view, index and sequence, talk about different reporting methods that many people do not know in the "Reporting with SQL language" section, which is rarely seen in many books but is widely used in daily life.
Part II, which is about the PL/SQL programming language, which is the main part of the book, consists of different subsections and covers very extensive information about this language. In the first chapter, the authors give extensive information about the structure of the PL/SQL language, and in the next chapters, the authors cover each topic with different examples from simple to difficult, giving extensive information about correct data types, loops, triggers, cursors and exceptions.
SQL DML (Data Manipulation Language)
User Management
Analytical Functions
Hierarchical Queries
Regular Expression
PL/SQL
PL/SQL Data Types and Variables
Trigger Usage
Cursor
Exception Handling
Part II, which is about the PL/SQL programming language, which is the main part of the book, consists of different subsections and covers very extensive information about this language. In the first chapter, the authors give extensive information about the structure of the PL/SQL language, and in the next chapters, the authors cover each topic with different examples from simple to difficult, giving extensive information about correct data types, loops, triggers, cursors and exceptions.
In the last section, the analytical functions, which even many expert developers have difficulty in understanding, are discussed. Throughout the chapter, hierarchical queries and regular expressions are examined and the operation of such queries and expressions is explained with different examples.
INGREDIENTS
What is SQL?
Functions in SQLSQL DML (Data Manipulation Language)
User Management
Analytical Functions
Hierarchical Queries
Regular Expression
PL/SQL
PL/SQL Data Types and Variables
Trigger Usage
Cursor
Exception Handling
Be the first to review this product!
RECOMMENDED PRODUCTS