Other Computer Certification, SQL, SQL (Programming Language)
Log in to track your reading progress.
Overview
In This Book You'll Learn How To:· Retrieve data using the SELECT statement
· Filter rows with the WHERE clause
· Sort data with the ORDER BY clause
· Use operators, conditions, pseudocolumns expressions, and single row functions
· Group and summarize with the GROUP BY clause
· Construct subqueries and other specialized queries
· Format with SQL *Plus
· Change data using DML INSERT, UPDATE, and DELETE commands
· Use DDL commands for creating and maintaining tables, their datatypes, and constraints
· Use DDL commands for creating and maintaining views, indexes, sequences, and synonyms
· Implement Oracle database security
· Filter rows with the WHERE clause
· Sort data with the ORDER BY clause
· Use operators, conditions, pseudocolumns expressions, and single row functions
· Group and summarize with the GROUP BY clause
· Construct subqueries and other specialized queries
· Format with SQL *Plus
· Change data using DML INSERT, UPDATE, and DELETE commands
· Use DDL commands for creating and maintaining tables, their datatypes, and constraints
· Use DDL commands for creating and maintaining views, indexes, sequences, and synonyms
· Implement Oracle database security
Book Details
Published
September 29, 2004
Publisher
Pearson IT Certification
Pages
414
Format
Paperback
ISBN
9780789732484