Oracle SQL by example

Alice Rischert - Collection The prentice hall ptr oracle series

932 pages, parution le 22/07/2004 (3^eme édition)

Ajouter à une liste

Indisponible

Résumé

Crafted for hands-on learning and tested in classrooms worldwide, this book illuminates in-depth every Oracle SQL technique you'll need. From the simplest query fundamentals through the newest regular expression database enhancements, you will focus on the tasks that matter most. Hundreds of guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL Along the way, you will acquire an arsenal of useful Oracle SQL knowledge and techniques: an extraordinary library of solutions for your real-world challenges with Oracle SQL.

Creating and using tables, views, indexes, and sequences
Working in SQL*Plus and /SQL*Plus environments
Oracle functions in depth-especially number, character, date, timestamp, interval, time zone, aggregate, and analytical functions
All types of joins, including equijoins, outer joins, self joins, and ANSI join syntax options
Every type of subquery, including correlated and scalar subqueries, set operators, hierarchical queries, flashback queries, data dictionary, regular expressions, and more
Common pitfalls to avoid and solutions for common mistakes
Practical performance, security, and architectural solutions
Insights, tips, and tricks-of-the-trade from an experienced Oracle professional
For every database developer, administrator, designer, or architect, regardless of experience!

Sommaire

SQL and data
SQL: the basics
Character, number, and miscellaneous functions
Date and conversion functions
Aggregate functions, group by, and having
Equijoins
Subqueries
Set operators
Complex joins
Insert, update, and delete
Create, alter, and drop tables
Views, indexes, and sequences
The data dictionary and advanced SQL*plus commands
Security
Regular expressions and hierarchical queries
Exploring data warehousing features
SQL optimization

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	Alice Rischert
Collection	The prentice hall ptr oracle series
Parution	22/07/2004
Édition	3^eme édition
Nb. de pages	932
Format	18 x 23,5
Couverture	Broché
Poids	1230g
Intérieur	Noir et Blanc
EAN13	9780131451315
ISBN13	978-0-13-145131-5