Book description
Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.
Table of contents
- Copyright
- What's New in the Latest Edition
- About the Authors
- Acknowledgments
- We Want to Hear from You!
- Introduction
-
At a Glance
- Getting Started with SQL
- Introducing the Query
- Expressions, Conditions, and Operators
-
Molding Data with Built-in Functions
- Using Aggregate Functions to Summarize Data
- Using Functions to Format Date and Time Values
- Using Functions for Arithmetic Operations
- Using Functions to Modify the Appearance of Character Values
- Conversion Functions
- Miscellaneous Functions
- Supplemental Examples of MySQL Character Functions
- Supplemental Examples of MySQL Date Functions
- Summary
- Q&A
- Workshop
- Clauses in SQL Queries
- Joining Tables
- Embedding Subqueries into Queries
- In Review
- At a Glance
-
At a Glance
- Creating Indexes on Tables to Improve Performance
-
Streamlining SQL Statements for Improved Performance
- Make Your SQL Statements Readable
- Avoiding the Full-Table Scan
- Adding a New Index
- Arranging Elements in a Query
- OLAP Versus OLTP
- Batch Loads Versus Transactional Processing
- Optimizing Data Loads by Dropping Indexes
- A Frequent COMMIT Keeps the DBA Away
- Rebuilding Tables and Indexes in a Dynamic Environment
- Tuning the Database
- Identifying Performance Obstacles
- Using Built-in Tuning Tools
- Summary
- Q&A
- Workshop
- Database Security
- Exploring the Data Dictionary (System Catalog)
- Stored Procedures, Triggers, and Embedded SQL
- New Objects in the Latest Standard: SQL3
-
Using SQL to Generate SQL Statements
- Understanding the Power of SQL Statement Generation
- Miscellaneous SQL*Plus Commands
- Counting the Rows in All Tables
- Granting System Privileges to Multiple Users
- Granting Privileges on Your Tables to Another User
- Disabling Table Constraints to Load Data
- Creating Numerous Synonyms in a Single Bound
- Creating Views on Your Tables
- Truncating All Tables in a Schema
- Using SQL to Generate Shell Scripts
- Reverse Engineering Tables and Indexes
- Applying SQL Generation and Other Concepts to the Real World
- Summary
- Q&A
- Workshop
- In Review
-
At a Glance
- Debugging Your SQL Statements
- Creating Complex SQL Queries
-
Using Oracle SQL*Plus to Satisfy Reporting Needs
- An Introduction to SQL*Plus
- The SQL*Plus Buffer
- Viewing Table Structure with the DESCRIBE Command
- Displaying Settings with the SHOW Command
- Manipulating Files with File Commands
- Customizing the Work Environment with SET Commands
- Using the LOGIN.SQL File
- Removing Settings with the CLEAR Command
- Formatting Your Output
- Creating Report and Group Summaries
- Using Variables in SQL*Plus
- Using the DUAL Table
- Exploring the DECODE Function
- DATE Conversions
- Running a Series of SQL Files
- Adding Comments to Your SQL Script
- Creating Advanced Reports
- Summary
- Q&A
- Workshop
- An Introduction to Oracle PL/SQL
- An Introduction to Transact-SQL
- Embedding SQL in Application Programming
- Using MySQL on a UNIX-based System
- In Review
- Answers
- Code Examples to Create Tables
- Code Examples to Populate Tables
- Using MySQL for Exercises
- Bonus Exercises
-
Glossary of Common SQL Commands
- *
- ALTER DATABASE
- ALTER USER
- BEGIN TRANSACTION
- CLOSE CURSOR
- COMMIT TRANSACTION
- CREATE DATABASE
- CREATE INDEX
- CREATE PROCEDURE
- CREATE TABLE
- CREATE TRIGGER
- CREATE USER
- CREATE VIEW
- DEALLOCATE CURSOR
- DECLARE CURSOR
- DROP DATABASE
- DROP INDEX
- DROP PROCEDURE
- DROP TABLE
- DROP TRIGGER
- DROP VIEW
- EXECUTE
- FETCH
- FROM
- GRANT
- GROUP BY
- HAVING
- INTERSECT
- ORDER BY
- REVOKE
- ROLLBACK TRANSACTION
- SELECT
- SET TRANSACTION
- UNION
- WHERE
- ASCII Table
- Resources
- Index
Product information
- Title: Sams Teach Yourself SQL in 21 Days, Fourth Edition
- Author(s):
- Release date: October 2002
- Publisher(s): Sams
- ISBN: 9780672324512
You might also like
book
SQL in 24 Hours, Sams Teach Yourself, 7th Edition
In just 24 lessons of one hour or less, Sams Teach Yourself SQL in 24 Hours …
book
Learn SQL Database Programming
Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide …
book
Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)
Whether you're studying for the Oracle 9i Fundamentals I exam or just need to take the …
book
Oracle Database Cloud Cookbook with Oracle Enterprise Manager 13c Cloud Control
This practical Oracle Press guide teaches cutting-edge techniques for building, configuring, and managing a secure private …