SQL Bible
- 11h 14m
- Alex Kriegel, Boris M. Trukhnov
- John Wiley & Sons (US)
- 2003
Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.
- Understand the definition and characteristics of relational databases and SQL’s role within RDBMS
- Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server
- Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL)
- Comprehend Data Manipulation Language (DML) from different vendors’ perspectives
- Master single-table select statements and multitable queries from the ground up
- Explore in-depth SQL functions, operators, and data types for major RDBMS implementations
- Discover new SQL developments including XML, OLAP, Web services, and object-oriented features
About the Authors
Alex Kriegel, MCP/MCSD, has worked for Pope & Talbot, Inc., in Portland, Oregon, since 2001 as Senior Programmer/Analyst; prior to that, he worked for Psion Teklogix International, Inc., in the same capacity. He received his B.S. in Physics of Metals from Polytechnic Institute of Belarus in 1988, discovered PC programming in 1992, and has never looked back since. He is also the author of Microsoft SQL Server 2000 Weekend Crash Course (Wiley, 2001).
Boris M. Trukhnov, OCP, has been working as Senior Technical Analyst/Oracle DBA for Pope & Talbot, Inc., in Portland, Oregon, since 1998. His previous job titles include Senior Programmer Analyst, Senior Software Developer, and Senior Operations Analyst. He has been working with SQL and relational databases since 1994. Boris holds a B.S. in Computer Science from the University of Minnesota.
In this Book
-
SQL Bible
-
SQL and Relational Database Management Systems (RDBMS)
-
Fundamental SQL Concepts and Principles
-
SQL Data Types
-
Creating RDBMS Objects
-
Altering and Destroying RDBMS Objects
-
Data Manipulation Language (DML)
-
Sessions, Transactions, and Locks
-
Understanding SELECT Statement
-
Multitable Queries
-
SQL Functions
-
SQL Operators
-
SQL and RDBMS Security
-
The System Catalog and INFORMATION_SCHEMA
-
Stored Procedures, Triggers, and User-Defined Functions
-
Dynamic and Embedded SQL Overview
-
SQL API
-
New Developments—XML, OLAP, and Objects
