SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK SQL IN 24 HOURS, SAMS TEACH YOURSELF, 6TH EDITION
SUMMARY
-
Items Found: 279
- Part I: An SQL Concepts Overview
- HOUR 1 Welcome to the World of SQL
- Part II: Building Your Database
- HOUR 2 Defining Data Structures
- 3 Managing Database Objects
- 4 The Normalization Process
- 5 Manipulating Data
- 6 Managing Database Transactions
- Part III: Getting Effective Results from Queries
- HOUR 7 Introduction to Database Queries
- 8 Using Operators to Categorize Data
- 9 Summarizing Data Results from a Query
- 10 Sorting and Grouping Data
- 11 Restructuring the Appearance of Data
- 12 Understanding Dates and Times
- Part IV: Building Sophisticated Database Queries
- HOUR 13 Joining Tables in Queries
- 14 Using Subqueries to Define Unknown Data
- 15 Combining Multiple Queries into One
- Part V: SQL Performance Tuning
- HOUR 16 Using Indexes to Improve Performance
- 17 Improving Database Performance
- Part VI: Using SQL to Manage Users and Security
- HOUR 18 Managing Database Users
- 19 Managing Database Security
- Part VII: Summarized Data Structures
- HOUR 20 Creating and Using Views and Synonyms
- 21 Working with the System Catalog
- HOUR 22 Advanced SQL Topics
- 23 Extending SQL to the Enterprise, the Internet, and the Intranet
- 24 Extensions to Standard SQL
- Part IX: Appendixes
- APPENDIX A Common SQL Commands
- B Installing Oracle and Microsoft SQL
- C Answers to Quizzes and Exercises
- D Bonus Exercises
- E Glossary
- Index
- Part I: An SQL Concepts Overview
- HOUR 1: Welcome to the World of SQL
- SQL Definition and History
- SQL Sessions
- Types of SQL Commands
- Canary Airlines: The Database Used in This Book
- Summary
- Q&A
- Workshop
- Part II: Building Your Database
- HOUR 2: Defining Data Structures
- What Is Data?
- Basic Data Types
- Summary
- Q&A
- Workshop
- HOUR 3: Managing Database Objects
- Database Objects and Schema
- Tables: The Primary Storage for Data
- Integrity Constraints
- Summary
- Q&A
- Workshop
- HOUR 4: The Normalization Process
- Normalizing a Database
- Denormalizing 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?
- Controlling Transactions
- Poor Transactional Control
- Summary
- Q&A
- Workshop
- Part III: Getting Effective Results from Queries
- HOUR 7: Introduction to Database Queries
- The SELECT Statement
- Case-Sensitivity
- Fundamentals of Query Writing
- Summary
- Q&A
- Workshop
- HOUR 8: Using Operators to Categorize Data
- What Is an Operator in SQL?
- Comparison Operators
- Logical Operators
- Conjunctive Operators
- Negative Operators
- Arithmetic Operators
- Summary
- Q&A
- Workshop
- HOUR 9: Summarizing Data Results from a Query
- Aggregate Functions
- Summary
- Q&A
- Workshop
- HOUR 10: Sorting and Grouping Data
- Why Group Data?
- The GROUP BY Clause
- GROUP BY Versus ORDER BY
- CUBE and ROLLUP Expressions
- The HAVING Clause
- Summary
- Q&A
- Workshop
- HOUR 11: Restructuring the Appearance of Data
- ANSI Character Functions
- Common Character Functions
- Miscellaneous Character Functions
- Mathematical Functions
- Conversion Functions
- 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
- Part IV: Building Sophisticated Database Queries
- HOUR 13: Joining Tables in Queries
- Selecting Data from Multiple Tables
- Understanding Joins
- Join Considerations
- Summary
- Q&A
- Workshop
- HOUR 14: Using Subqueries to Define Unknown Data
- What Is a Subquery?
- Embedded Subqueries
- Correlated Subqueries
- Subquery Performance
- Summary
- Q&A
- Workshop
- HOUR 15: Combining Multiple Queries into One
- Single Queries Versus Compound Queries
- Compound Query Operators
- Using ORDER BY with a Compound Query
- Using GROUP BY with a Compound Query
- Retrieving Accurate Data
- Summary
- Q&A
- 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?
- Altering an Index
- Dropping an Index
- Summary
- Q&A
- Workshop
- HOUR 17: Improving Database Performance
- What Is SQL Statement Tuning?
- Database Tuning Versus SQL Statement Tuning
- Formatting Your SQL Statement
- Full Table Scans
- Other Performance Considerations
- Cost-Based Optimization
- Summary
- Q&A
- Workshop
- Part VI: Using SQL to Manage Users and Security
- HOUR 18: Managing Database Users
- User Management in the Database
- The Management Process
- Tools Utilized by Database Users
- Summary
- Q&A
- Workshop
- HOUR 19: Managing Database Security
- What Is Database Security?
- What Are Privileges?
- Controlling User Access
- Controlling Privileges Through Roles
- Summary
- Q&A
- Workshop
- Part VII: Summarized Data Structures
- HOUR 20: Creating and Using Views and Synonyms
- What Is a View?
- Creating Views
- Updating Data Through a View
- Dropping a View
- Performance Impact of Nested Views
- 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?
- System Catalog Tables by Implementation
- Querying the System Catalog
- Updating System Catalog Objects
- Summary
- Q&A
- Workshop
- HOUR 22: Advanced SQL Topics
- Cursors
- Stored Procedures and Functions
- Triggers
- Dynamic SQL
- Call-Level Interface
- Using SQL to Generate SQL
- Direct Versus Embedded SQL
- Windowed Table Functions
- Working with XML
- Summary
- Q&A
- Workshop
- HOUR 23: Extending SQL to the Enterprise, the Internet, and the Intranet
- SQL and the Enterprise
- Accessing a Remote Database
- SQL and the Internet
- SQL and the Intranet
- Summary
- Q&A
- Workshop
- HOUR 24: Extensions to Standard SQL
- Various Implementations
- Example Extensions
- Interactive SQL Statements
- Summary
- Q&A
- Workshop
- Part IX: Appendixes
- APPENDIX A: Common SQL Commands
- SQL Statements
- SQL Clauses
- APPENDIX B: Installing Oracle and Microsoft SQL
- Windows Installation Instructions for Oracle
- Windows Installation Instructions for Microsoft SQL Server
- 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 Queries”
- 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 Times”
- 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: Bonus Exercises
- APPENDIX E: Glossary
- Index
