Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 275
Pages: 275
- Main
- TOC
- Copyright
- About the Authors
- Acknowledgments
- Tell Us What You Think
- We Want to Hear from You
- Introduction
- Who Should Read This Book?
- What This Book Intends to Accomplish
- What We Added to This Edition
- What You Need
- Conventions Used in This Book
- ANSI SQL and Vendor Implementations
- Understanding the Examples and Exercises
- Part 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
- Summary
- QA
- Workshop
- Part II: Building Your Database
- Hour 2. Defining Data Structures
- What Is Data?
- Basic Data Types
- Summary
- QA
- Workshop
- Hour 3. Managing Database Objects
- What Are Database Objects?
- What Is a Schema?
- A Table: The Primary Storage for Data
- Integrity Constraints
- Summary
- QA
- Workshop
- Hour 4. The Normalization Process
- Normalizing a Database
- Summary
- QA
- Workshop
- Hour 5. Manipulating Data
- Overview of Data Manipulation
- Populating Tables with New Data
- Updating Existing Data
- Deleting Data from Tables
- Summary
- QA
- Workshop
- Hour 6. Managing Database Transactions
- What Is a Transaction?
- What Is Transactional Control?
- Transactional Control and Database Performance
- Summary
- QA
- Workshop
- Part 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
- QA
- 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
- QA
- Workshop
- Hour 9. Summarizing Data Results from a Query
- What Are Aggregate Functions?
- Summary
- QA
- Workshop
- Hour 10. Sorting and Grouping Data
- Why Group Data?
- The GROUP BY Clause
- GROUP BY Versus ORDER BY
- The HAVING Clause
- Summary
- QA
- 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
- QA
- Workshop
- Hour 12. Understanding Dates and Times
- How Is a Date Stored?
- Date Functions
- Date Conversions
- Summary
- QA
- Workshop
- Part IV: Building Sophisticated Database Queries
- Hour 13. Joining Tables in Queries
- Selecting Data from Multiple Tables
- Types of Joins
- Join Considerations
- Summary
- QA
- 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 GROUP BY with a Compound Query
- Retrieving Accurate Data
- Summary
- QA
- Workshop
- Part 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
- QA
- 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
- QA
- Workshop
- Part 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
- QA
- 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
- QA
- Workshop
- Part 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
- QA
- 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
- QA
- Workshop
- Part 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
- QA
- 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
- QA
- Workshop
- Hour 24. Extensions to Standard SQL
- Various Implementations
- Examples of Extensions from Some Implementations
- Interactive SQL Statements
- Summary
- QA
- Workshop
- Part IX: Appendixes
- Appendix A. Common SQL Commands
- SQL Statements
- SQL Clauses
- Appendix B. Using MySQL for Exercises
- Windows Installation Instructions
- Linux Installation Instructions
- 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
- Appendix G. Bonus Exercises
- INDEX
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 275
Pages: 275
- ERP Systems Impact on Organizations
- The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
- Context Management of ERP Processes in Virtual Communities
- Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
- Development of Interactive Web Sites to Enhance Police/Community Relations