Sams teach yourself SQL in one hour a day
"In just one hour a day, you'll have all the skills you need to begin creating effective SQL queries, reports, and database applications. With this complete tutorial, you'll quickly master the basics and then move on to more advanced features and concepts"--Resource description p...
| Otros Autores: | , , , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Place of publication not identified]
Sams
2009
|
| Edición: | 5th ed |
| Colección: | Sams Teach Yourself
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628865906719 |
Tabla de Contenidos:
- Cover
- Table of Contents
- Introduction
- PART I: Introducing SQL
- LESSON 1: Getting Started with SQL
- A Brief History of SQL
- A Brief History of Databases
- Today's Database Landscape
- A Cross-Product Language
- An Overview of SQL
- Popular SQL Implementations
- Open Database Connectivity
- Embedding SQL in Application Programming
- LESSON 2: Introducing the Query
- Exploring SQL's Background
- Learning Basic Query Syntax
- The Building Blocks of Data Retrieval: SELECT and FROM
- Applying Query Concepts
- Writing Your First Query
- Selecting Distinct Values
- LESSON 3: Expressions, Conditions, and Operators
- Working with Query Expressions
- Placing Conditions on Queries
- Learning How to Use Operators
- LESSON 4: Clauses in SQL Queries
- Specifying Criteria with the WHERE Clause
- Order from Chaos: The ORDER BY Clause
- The GROUP BY Clause
- The HAVING Clause
- Combining Clauses
- LESSON 5: Joining Tables
- Joining Multiple Tables in a Single SELECT Statement
- Joining Tables Based on Equality
- Joining Tables Based on Nonequality
- OUTER JOINs Versus INNER JOINs
- Joining a Table to Itself: The Self Join
- LESSON 6: Embedding Subqueries into Queries
- Building a Subquery
- Using Aggregate Functions with Subqueries
- Nesting Subqueries
- Referencing Outside with Correlated Subqueries
- Using EXISTS, ANY, and ALL
- LESSON 7: Molding Data with Built-in Functions
- Using Aggregate Functions to Summarize Data
- Using Functions to Format Date and Time Values
- Using Functions for Arithmetic Operations
- Using Functions to Modify the Appearance of Character Values
- Conversion Functions
- Miscellaneous Functions
- Supplemental Examples of MySQL Character Functions
- Supplemental Examples of MySQL Date Functions
- PART II: Database Design
- LESSON 8: Database Normalization.
- Normalizing a Database
- Understanding the Normal Forms
- Making Normalization Work
- Benefits of Normalization
- Drawbacks of Normalization
- Denormalizing a Database
- LESSON 9: Creating and Maintaining Tables
- Beginning with the CREATE DATABASE Statement
- Defining Tables with the CREATE TABLE Statement
- Modifying Table Structures with the ALTER TABLE Statement
- The DROP TABLE Statement
- The DROP DATABASE Statement
- LESSON 10: Controlling Data Integrity
- Introducing Constraints
- Exploring Types of Constraints
- Managing Constraints
- PART III: Data Manipulation
- LESSON 11: Manipulating Data
- Introducing Data-Manipulation Statements
- Entering Data with the INSERT Statement
- Modifying Existing Data with the UPDATE Statement
- Removing Information with the DELETE Statement
- Importing and Exporting Data from Foreign Sources
- LESSON 12: Dates and Time in SQL
- How Are Date and Time Values Stored?
- Applying Date Functions to the Query
- Converting Date Formats
- LESSON 13: Creating Views
- Introducing Views
- Using Views
- LESSON 14: Controlling Transactions
- Transaction Management
- The Banking Application
- Beginning a Transaction
- Finishing a Transaction
- Canceling the Transaction
- Using Transaction Savepoints
- PART IV: Database Administration
- LESSON 15: Creating Indexes on Tables to Improve Performance
- What Are Indexes?
- Using the UNIQUE Keyword with CREATE INDEX
- Indexes and Joins
- Using Clustered Indexes
- LESSON 16: Streamlining SQL Statements for Improved Performance
- Making Your SQL Statements Readable
- Avoiding the Full-Table Scan
- Adding a New Index
- Arranging Elements in a Query
- OLAP Versus OLTP
- Batch Loads Versus Transactional Processing
- Optimizing Data Loads by Dropping Indexes
- COMMIT Statement
- Rebuilding Tables and Indexes in a Dynamic Environment.
- Tuning the Database
- Identifying Performance Obstacles
- Using Built-in Tuning Tools
- LESSON 17: Database Security
- Security's Role in Database Administration
- Popular Database Products and Security
- Oracle Express and MySQL Security
- LESSON 18: Exploring the Data Dictionary (System Catalog)
- An Introduction to the Data Dictionary
- Identifying Data Dictionary Users
- Exploring the Contents of the Data Dictionary
- A Look Inside Oracle's Data Dictionary
- A Look Inside MySQL's Data Dictionary
- PART V: More SQL Objects
- LESSON 19: Temporary Tables, Stored Procedures, Triggers, and Cursors
- Creating Temporary Tables
- Using Cursors
- Creating and Using Stored Procedures
- Designing and Using Triggers
- Using Embedded SQL
- LESSON 20: New Objects in the Latest Standard
- Exploring the CREATE ROLE Statement
- Creating Triggers
- Using the CREATE TYPE Statement
- Regular Expressions
- Working with BLOB Data Types
- A Short XML Example
- PART VI: Advanced SQL Programming
- LESSON 21: Using SQL to Generate SQL Statements
- Understanding the Power of SQL Statement Generation
- Miscellaneous SQL*Plus Commands
- Counting the Rows in All Tables
- Granting System Privileges to Multiple Users
- Granting Privileges on Your Tables to Another User
- Disabling Table Constraints to Load Data
- Creating Numerous Synonyms in a Single Bound
- Creating Views on Your Tables
- Truncating All Tables in a Schema
- Using SQL to Generate Shell Scripts
- Applying SQL Generation and Other Concepts to the Real World
- LESSON 22: Creating Complex SQL Queries
- CREATE TABLE statements
- Examples of Complex Queries
- Tips for Building Complex Queries
- LESSON 23: Debugging Your SQL Statements
- Exploring Common SQL Errors
- Exploring Common Logical Mistakes
- Preventing Problems with Your Data.
- LESSON 24: Embedding SQL in Application Programming
- A Quick Trip Through Some Application Development Tools
- Creating the Database
- Using Java and SQL
- Using .NET and SQL
- PART VII: SQL in Various Database Implementations
- LESSON 25: Using Oracle SQL*Plus to Satisfy Reporting Needs
- An Introduction to SQL*Plus
- The SQL*Plus Buffer
- Viewing Table Structure with the DESCRIBE Command
- Displaying Settings with the SHOW Command
- Manipulating Files with File Commands
- Customizing the Work Environment with SET Commands
- Removing Settings with the CLEAR Command
- Formatting Your Output
- Creating Report and Group Summaries
- Using Variables in SQL*Plus
- Using the DUAL Table
- Exploring the DECODE Function
- DATE Conversions
- Running a Series of SQL Files
- Adding Comments to Your SQL Script
- Creating Advanced Reports
- LESSON 26: An Introduction to Oracle PL/SQL
- Introducing PL/SQL
- The Structure of a PL/SQL Block
- Transactional Control in PL/SQL
- Putting Everything Together
- Using Stored Procedures, Packages, and Triggers
- LESSON 27: An Introduction to Transact-SQL
- An Overview of Transact-SQL
- Extensions to ANSI QL
- Data Types
- Accessing the Database with Transact-SQL
- Establishing Flow Control
- Using Transact-SQL Wildcard Operators
- Date Conversions
- SQL Server Diagnostic Tools-SET Commands
- LESSON 28: Using MySQL on a UNIX-based System
- MySQL Administration
- The MySQL Terminal Monitor
- MySQL Utilities
- PART VIII: Appendices
- APPENDIX A: Answers
- APPENDIX B: Code Examples to Create Tables
- APPENDIX C: Code Examples to Populate Tables
- APPENDIX D: Using MySQL for Exercises
- Index
- Online Appendixes
- APPENDIX E: Glossary of Common SQL Commands.
- APPENDIX F: Glossary of Common SQL Functions.
