Sams Teach Yourself SQL in 24 Hours
2nd Edition
Published on 17. April 2000
Book
Paperback/Softback
464 pages
978-0-672-31899-3 (ISBN)
Description
Written by college instructors, Sams Teach Yourself SQL in 24 Hours quickly teaches beginning- to intermediate-level SQL users how to create, store, access and manipulate data using a proven step-by-step format that teaches SQL by example. This book contains a thorough explanation of database concepts, SQL procedures, and low-level programming, enabling readers to gain an understanding of the whys as well as the hows behind SQL.
This book presents complete code listings and output, followed with analysis that explains exactly what the listings are doing. These practical code examples can be incorporated easily by the reader into other projects. Coverage includes SQL, as well as SQL in an enterprise setting and on the Web and Intranet.
Authors Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each.
This book presents complete code listings and output, followed with analysis that explains exactly what the listings are doing. These practical code examples can be incorporated easily by the reader into other projects. Coverage includes SQL, as well as SQL in an enterprise setting and on the Web and Intranet.
Authors Ryan Stephens and Ronald Plew are President and Vice President of Perpetual Technologies, Inc., where their duties include Oracle database administration and consulting and Oracle, SQL, and UNIX training. They have both been teaching at the collegiate level for over three years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals, having specialized in Oracle and UNIX for more than 10 years each.
More details
Edition
2nd edition
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Width: 230 mm
Thickness: 26 mm
Weight
753 gr
ISBN-13
978-0-672-31899-3 (9780672318993)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Ryan Stephens | Ron Plew
Sams Teach Yourself SQL in 24 Hours
Book
08/2002
3rd Edition
Sams Publishing
€22.27
Article exhausted; check for reprint
Persons
Ronald R. Plew is vice president and CIO for Perpetual Technologies, Inc., in Indianapolis, Indiana. Ron is a Certified Oracle Professional, and his duties include Oracle database consulting and training. Ron is an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL and various database courses. He holds a Bachelor of Science degree in Business Management/Administration from Indiana Institute of Technology, Fort Wayne, Indiana. Ron also serves in the Indiana Army National Guard, where he is the programmer/analyst for the 433rd Personnel Detachment. Ron's hobbies include golf, chess, and collecting Indianapolis 500 racing memorabilia. He shares ownership of Plew's Indy 500 Museum with is brothers, Mark and Dennis; his sister Arleen; and mother, Betty. Ron lives in Indianapolis with his wife Linda. Ron and Linda have four children and nine grandchildren.
Ryan K. Stephens is president and CEO for Perpetual Technologies, Inc., an Oracle training and consulting firm in Indianapolis, Indiana, that is partnered with Oracle Corporation. He has specialized in Oracle database and SQL for over 10 years, working as an Oracle programmer/analyst and Oracle Database Administrator. Ryan is a Certified Oracle Professional and is also an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL, PL/SQL, UNIX, Oracle Designer, Oracle Forms, and Oracle database administration. Ryan resides in Indianapolis with his wife Tina and their son Daniel.
Ryan K. Stephens is president and CEO for Perpetual Technologies, Inc., an Oracle training and consulting firm in Indianapolis, Indiana, that is partnered with Oracle Corporation. He has specialized in Oracle database and SQL for over 10 years, working as an Oracle programmer/analyst and Oracle Database Administrator. Ryan is a Certified Oracle Professional and is also an adjunct professor at Indiana University-Purdue University in Indianapolis and Indiana University at Kokomo, where he teaches SQL, PL/SQL, UNIX, Oracle Designer, Oracle Forms, and Oracle database administration. Ryan resides in Indianapolis with his wife Tina and their son Daniel.
Content
Introduction.
I. A SQL CONCEPTS OVERVIEW.
Hour 1. Welcome to the World of SQL.
SQL Definition and History.SQL Sessions. DISCONNECT. Types of SQL Commands. An Introduction to the Database Used in This Book. Summary. Q&A. Workshop.
II. A SQL CONCEPTS OVERVIEW.
Hour 2. Defining Data Structures.
What Is Data? Basic Data Types. Summary. Q&A. Workshop.
Hour 3. Managing Database Objects.
What Are Database Objects? What Is a Schema? A Table: The Primary Storage for Data. Integrity Constraints. Summary. Q&A. Workshop.
Hour 4. The Normalization Process.
Normalizing a Database. Summary. Q&A. Workshop.
Hour 5. Manipulating Data.
Overview of Data Manipulation. Populating Tables with New Data. Updating Existing Data. Deleting Data from Tables. Summary. Q&A. Workshop.
Hour 6. Managing Database Transactions.
What Is a Transaction? What Is Transactional Control? Transactional Control and Database Performance. Summary. Q&A. Workshop.
III. GETTING EFFECTIVE RESULTS FROM QUERIES.
Hour 7. Introduction to the Database Query.
What Is a Query? Introduction to the SELECT Statement. Examples of Simple Queries. Summary. Q&A. Workshop.
Hour 8. Using Operators to Categorize Data.
What Is an Operator in SQL? Comparison Operators. Logical Operators. Conjunctive Operators. Negating Conditions with the NOT Operator. Arithmetic Operators. Summary. Q&A. Workshop.
Hour 9. Summarizing Data Results from a Query.
What Are Aggregate Functions? Summary. Q&A. Workshop.
Hour 10. Sorting and Grouping Data.
Why Group Data? The GROUP BY Clause. GROUP BY Versus ORDER BY. The HAVING Clause. Summary. Q&A. Workshop.
Hour 11. Restructuring the Appearance of Data.
The Concepts of ANSI Character Functions. Various Common Character Functions. Miscellaneous Character Functions. Mathematical Functions. Conversion Functions. The Concept of Combining Character Functions. Summary. Q&A. Workshop.
Hour 12. Understanding Dates and Times.
How Is a Date Stored? Date Functions. Date Conversions. Summary. Q&A. Workshop.
IV. BUILDING SOPHISTICATED DATABASE QUERIES.
Hour 13. Joining Tables in Queries.
Selecting Data from Multiple Tables. Types of Joins. Join Considerations. Summary. Q&A. Workshop.
Hour 14. Using Subqueries to Define Unknown Data.
What Is a Subquery? Embedding a Subquery Within a Subquery. Summary. Workshop.
Hour 15. Combining Multiple Queries into One.
Single Queries Versus Compound Queries. Why Would I Ever Want to Use a Compound Query? Compound Query Operators. Using an ORDER BY with a Compound Query. Using a GROUP BY with a Compound Query. Retrieving Accurate Data. Summary. Q&A. Workshop.
V. SQL PERFORMANCE TUNING.
Hour 16. Using Indexes to Improve Performance.
What Is an Index? How Do Indexes Work? The CREATE INDEX Command. Types of Indexes. When Should Indexes Be Considered? When Should Indexes Be Avoided? Summary. Q&A. Workshop.
Hour 17. Improving Database Performance.
What Is SQL Statement Tuning? Database Tuning Versus SQL Tuning. Formatting Your SQL Statement. Full Table Scans. Other Performance Considerations. Performance Tools. Summary. Q&A. Workshop.
VI. USING SQL TO MANAGE USERS AND SECURITY.
Hour 18. Managing Database Users.
Users Are the Reason. The Management Process. Tools Utilized by Database Users. Summary. Q&A. Workshop.
Hour 19. Managing Database Security.
What Is Database Security? How Does Security Differ from User Management? What Are Privileges? Controlling User Access. Controlling Privileges Through Roles. Summary. Q&A. Workshop.
VII. SUMMARIZED DATA STRUCTURES.
Hour 20. Creating and Using Views and Synonyms.
What Is a View? Creating Views. Dropping a View. What Is a Synonym? Summary. Q&A. Workshop.
Hour 21. Working with the System Catalog.
What Is the System Catalog? How Is the System Catalog Created? What Is Contained in the System Catalog? Examples of System Catalog Tables by Implementation. Querying the System Catalog. Updating System Catalog Objects. Summary. Q&A. Workshop.
VIII. APPLYING SQL FUNDAMENTALS IN TODAY'S WORLD.
Hour 22. Advanced SQL Topics.
Advanced Topics. Cursors. Stored Procedures and Functions. Triggers. Dynamic SQL. Call-Level Interface. Using SQL to Generate SQL. Direct Versus Embedded SQL. Summary. Q&A. Workshop.
Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet.
SQL and the Enterprise. Accessing a Remote Database. Accessing a Remote Database Through a Web Interface. SQL and the Internet. SQL and the Intranet. Summary. Q&A. Workshop.
Hour 24. Extensions to Standard SQL.
Various Implementations. Examples of Extensions from Some Implementations. Interactive SQL Statements. Summary. Q&A. Workshop.
VIII. APPLYING SQL FUNDAMENTALS IN TODAY'S WORLD.
Appendix A. Common SQL Commands.
SQL Statements. SQL Clauses.
Appendix B. ASCII Table.
Appendix C. Answers to Quizzes and Exercises.
Hour 1, "Welcome to the World of SQL". Hour 2, "Defining Data Structures". Hour 3, "Managing Database Objects". Hour 4, "The Normalization Process". Hour 5, "Manipulating Data". Hour 6, "Managing Database Transactions". Hour 7, "Introduction to the Database Query". Hour 8, "Using Operators to Categorize Data". Hour 9, "Summarizing Data Results from a Query". Hour 10, "Sorting and Grouping Data". Hour 11, "Restructuring the Appearance of Data". Hour 12, "Understanding Dates and Time". Hour 13, "Joining Tables in Queries". Hour 14, "Using Subqueries to Define Unknown Data". Hour 15, "Combining Multiple Queries into One". Hour 16, "Using Indexes to Improve Performance". Hour 17, "Improving Database Performance". Hour 18, "Managing Database Users". Hour 19, "Managing Database Security". Hour 20, "Creating and Using Views and Synonyms". Hour 21, "Working with the System Catalog". Hour 22, "Advanced SQL Topics". Hour 23, "Extending SQL to the Enterprise, the Internet, and the. Intranet". Hour 24, "Extensions to Standard SQL".
Appendix D. CREATE TABLE Statements for Book Examples.
EMPLOYEE_TBL. EMPLOYEE_PAY_TBL. CUSTOMER_TBL. ORDERS_TBL. PRODUCTS_TBL.
Appendix E. INSERT Statements for Data in Book Examples.
INSERT Statements.
Appendix F. Glossary.
Index
I. A SQL CONCEPTS OVERVIEW.
Hour 1. Welcome to the World of SQL.
SQL Definition and History.SQL Sessions. DISCONNECT. Types of SQL Commands. An Introduction to the Database Used in This Book. Summary. Q&A. Workshop.
II. A SQL CONCEPTS OVERVIEW.
Hour 2. Defining Data Structures.
What Is Data? Basic Data Types. Summary. Q&A. Workshop.
Hour 3. Managing Database Objects.
What Are Database Objects? What Is a Schema? A Table: The Primary Storage for Data. Integrity Constraints. Summary. Q&A. Workshop.
Hour 4. The Normalization Process.
Normalizing a Database. Summary. Q&A. Workshop.
Hour 5. Manipulating Data.
Overview of Data Manipulation. Populating Tables with New Data. Updating Existing Data. Deleting Data from Tables. Summary. Q&A. Workshop.
Hour 6. Managing Database Transactions.
What Is a Transaction? What Is Transactional Control? Transactional Control and Database Performance. Summary. Q&A. Workshop.
III. GETTING EFFECTIVE RESULTS FROM QUERIES.
Hour 7. Introduction to the Database Query.
What Is a Query? Introduction to the SELECT Statement. Examples of Simple Queries. Summary. Q&A. Workshop.
Hour 8. Using Operators to Categorize Data.
What Is an Operator in SQL? Comparison Operators. Logical Operators. Conjunctive Operators. Negating Conditions with the NOT Operator. Arithmetic Operators. Summary. Q&A. Workshop.
Hour 9. Summarizing Data Results from a Query.
What Are Aggregate Functions? Summary. Q&A. Workshop.
Hour 10. Sorting and Grouping Data.
Why Group Data? The GROUP BY Clause. GROUP BY Versus ORDER BY. The HAVING Clause. Summary. Q&A. Workshop.
Hour 11. Restructuring the Appearance of Data.
The Concepts of ANSI Character Functions. Various Common Character Functions. Miscellaneous Character Functions. Mathematical Functions. Conversion Functions. The Concept of Combining Character Functions. Summary. Q&A. Workshop.
Hour 12. Understanding Dates and Times.
How Is a Date Stored? Date Functions. Date Conversions. Summary. Q&A. Workshop.
IV. BUILDING SOPHISTICATED DATABASE QUERIES.
Hour 13. Joining Tables in Queries.
Selecting Data from Multiple Tables. Types of Joins. Join Considerations. Summary. Q&A. Workshop.
Hour 14. Using Subqueries to Define Unknown Data.
What Is a Subquery? Embedding a Subquery Within a Subquery. Summary. Workshop.
Hour 15. Combining Multiple Queries into One.
Single Queries Versus Compound Queries. Why Would I Ever Want to Use a Compound Query? Compound Query Operators. Using an ORDER BY with a Compound Query. Using a GROUP BY with a Compound Query. Retrieving Accurate Data. Summary. Q&A. Workshop.
V. SQL PERFORMANCE TUNING.
Hour 16. Using Indexes to Improve Performance.
What Is an Index? How Do Indexes Work? The CREATE INDEX Command. Types of Indexes. When Should Indexes Be Considered? When Should Indexes Be Avoided? Summary. Q&A. Workshop.
Hour 17. Improving Database Performance.
What Is SQL Statement Tuning? Database Tuning Versus SQL Tuning. Formatting Your SQL Statement. Full Table Scans. Other Performance Considerations. Performance Tools. Summary. Q&A. Workshop.
VI. USING SQL TO MANAGE USERS AND SECURITY.
Hour 18. Managing Database Users.
Users Are the Reason. The Management Process. Tools Utilized by Database Users. Summary. Q&A. Workshop.
Hour 19. Managing Database Security.
What Is Database Security? How Does Security Differ from User Management? What Are Privileges? Controlling User Access. Controlling Privileges Through Roles. Summary. Q&A. Workshop.
VII. SUMMARIZED DATA STRUCTURES.
Hour 20. Creating and Using Views and Synonyms.
What Is a View? Creating Views. Dropping a View. What Is a Synonym? Summary. Q&A. Workshop.
Hour 21. Working with the System Catalog.
What Is the System Catalog? How Is the System Catalog Created? What Is Contained in the System Catalog? Examples of System Catalog Tables by Implementation. Querying the System Catalog. Updating System Catalog Objects. Summary. Q&A. Workshop.
VIII. APPLYING SQL FUNDAMENTALS IN TODAY'S WORLD.
Hour 22. Advanced SQL Topics.
Advanced Topics. Cursors. Stored Procedures and Functions. Triggers. Dynamic SQL. Call-Level Interface. Using SQL to Generate SQL. Direct Versus Embedded SQL. Summary. Q&A. Workshop.
Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet.
SQL and the Enterprise. Accessing a Remote Database. Accessing a Remote Database Through a Web Interface. SQL and the Internet. SQL and the Intranet. Summary. Q&A. Workshop.
Hour 24. Extensions to Standard SQL.
Various Implementations. Examples of Extensions from Some Implementations. Interactive SQL Statements. Summary. Q&A. Workshop.
VIII. APPLYING SQL FUNDAMENTALS IN TODAY'S WORLD.
Appendix A. Common SQL Commands.
SQL Statements. SQL Clauses.
Appendix B. ASCII Table.
Appendix C. Answers to Quizzes and Exercises.
Hour 1, "Welcome to the World of SQL". Hour 2, "Defining Data Structures". Hour 3, "Managing Database Objects". Hour 4, "The Normalization Process". Hour 5, "Manipulating Data". Hour 6, "Managing Database Transactions". Hour 7, "Introduction to the Database Query". Hour 8, "Using Operators to Categorize Data". Hour 9, "Summarizing Data Results from a Query". Hour 10, "Sorting and Grouping Data". Hour 11, "Restructuring the Appearance of Data". Hour 12, "Understanding Dates and Time". Hour 13, "Joining Tables in Queries". Hour 14, "Using Subqueries to Define Unknown Data". Hour 15, "Combining Multiple Queries into One". Hour 16, "Using Indexes to Improve Performance". Hour 17, "Improving Database Performance". Hour 18, "Managing Database Users". Hour 19, "Managing Database Security". Hour 20, "Creating and Using Views and Synonyms". Hour 21, "Working with the System Catalog". Hour 22, "Advanced SQL Topics". Hour 23, "Extending SQL to the Enterprise, the Internet, and the. Intranet". Hour 24, "Extensions to Standard SQL".
Appendix D. CREATE TABLE Statements for Book Examples.
EMPLOYEE_TBL. EMPLOYEE_PAY_TBL. CUSTOMER_TBL. ORDERS_TBL. PRODUCTS_TBL.
Appendix E. INSERT Statements for Data in Book Examples.
INSERT Statements.
Appendix F. Glossary.
Index