A new edition of this title is available, ISBN-10: 0672330180 ISBN-13: 9780672330186
Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
(NOTE: Each chapter concludes with a Summary, Q&A and Workshop.).
I. A SQL CONCEPTS OVERVIEW.Hour 1. Welcome to the World of SQL.
SQL Definition and History. SQL Sessions. Types of SQL Commands. An Introduction to the Database Used in This Book.
II. BUILDING YOUR DATABASE.Hour 2. Defining Data Structures.
What Is Data? Basic Data Types.Hour 3. Managing Database Objects.
What Are Database Objects? What Is a Schema? A Table: The Primary Storage for Data. Integrity Constraints.Hour 4. The Normalization Process.
Normalizing a Database.Hour 5. Manipulating Data.
Overview of Data Manipulation. Populating Tables with New Data. Updating Existing Data. Deleting Data from Tables.Hour 6. Managing Database Transactions.
What Is a Transaction? What Is Transactional Control? Transactional Control and Database Performance.
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.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.Hour 9. Summarizing Data Results from a Query.
What Are Aggregate Functions?Hour 10. Sorting and Grouping Data.
Why Group Data? The GROUP BY Clause. GROUP BY Versus ORDER BY. The HAVING Clause.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.Hour 12. Understanding Dates and Times.
How Is a Date Stored? Date Functions. Date Conversions.
IV. BUILDING SOPHISTICATED DATABASE QUERIES.Hour 13. Joining Tables in Queries.
Selecting Data from Multiple Tables. Types of Joins. Join Considerations.Hour 14. Using Subqueries to Define Unknown Data.
What Is a Subquery? Embedding a Subquery Within a Subquery..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 GROUP BY with a Compound Query. Retrieving Accurate Data.