|
Free ebooks
 Free database ebooks Oracle Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Database
|
 Chapter 1: Introduction - In this chapter, you’ll learn about relational databases, be introduced to SQL, see a few simple queries, use SQL*Plus and SQL Developer to execute queries, and briefly see PL/SQL.Chapter 2: Retrieving Information from Database Tables - You’ll explore how to retrieve information from one or more database tables using SELECT statements, use arithmetic expressions to perform calculations, filter rows using a WHERE clause, and sort the rows retrieved from a table. Chapter 3: Using SQL*Plus - In this chapter, you’ll use SQL*Plus to view a table’s structure, edit a SQL statement, save and run scripts, format column output, define and use variables, and create reports. Chapter 4: Using Simple Functions - In this chapter, you’ll learn about some of the Oracle database’s built-in functions. A function can accept input parameters and returns an output parameter. Chapter 5: Storing and Processing Dates and Times - You’ll learn how the Oracle database processes and stores dates and times, collectively known as datetimes. Chapter 6: Subqueries - You’ll learn how to place a SELECT statement within an outer SQL statement. The inner SELECT statement is known as a subquery. You’ll learn about the different types of subqueries and see how subqueries allow you to build up very complex statements from simple components. Chapter 7: Advanced Queries - In this chapter, you’ll learn how to perform queries containing advanced operators and functions. Chapter 8: Changing Table Contents - You’ll learn how to add, modify, and remove rows using the INSERT, UPDATE, and DELETE statements, and how to make the results of your transactions permanent using the COMMIT statement or undo their results entirely using the ROLLBACK statement. Chapter 9: Users, Privileges, and Roles - In this chapter, you’ll learn about database users and see how privileges and roles are used to enable users to perform specific tasks in the database. Chapter 10: Creating Tables, Sequences, Indexes, and Views - You’ll learn about tables and sequences, which generate a series of numbers, and indexes, which act like an index in a ebook and allow you quick access to rows. Chapter 11: Introducing PL/SQL Programming - In this chapter, you’ll explore PL/SQL, which is built on top of SQL and enables you to write stored programs in the database that contain SQL statements. PL/SQL contains standard programming constructs. Chapter 12: Database Objects - You’ll learn how to create database object types, which may contain attributes and methods. Chapter 13: Collections - In this chapter, you’ll learn how to create collection types, which may contain multiple elements. You’ll use collection types to define columns in tables. Chapter 14: Large Objects - You’ll learn about large objects, which can be used to store up to 128 terabytes of character and binary data or point to an external file. Chapter 15: Running SQL Using Java - In this chapter, you’ll learn the basics of running SQL using Java through the Java Database Connectivity (JDBC) applications programming interface, which is the glue that allows a Java program to access a database. Chapter 16: SQL Tuning - You’ll see SQL tuning tips that you can use to shorten the length of time your queries take to execute. You’ll also learn about the Oracle optimizer and examine how to pass hints to the optimizer. Chapter 17: XML and the Oracle Database - The Extensible Markup Language (XML) is a general-purpose markup language. XML enables you to share structured data across the Internet, and can be used to encode data and other documents. Download free Oracle ebooks: Oracle Database 11g SQL: Master SQL and PL/SQL in the Oracle Database
|
