MySQL in 10 minutes /

Now at over 5 million downloads and widely used at all levels, MySQL continues to grow in popularity. Readers are hungry for a concise, easily accessible tutorial on MySQL basics that allows them to get up and running quickly. While there are many MySQL books on the market, there are no up-to-date b...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Newman, Chris
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Sams, ©2006.
Colección:Sams teach yourself.
Temas:
MySQL (Electronic resource)
SQL (Computer program language)
Database management.
SQL (Langage de programmation)
Bases de données > Gestion.
COMPUTERS > Data Processing.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • TOC36;Contents
  • Introduction
  • PART 1 MySQL Foundations
  • CH36;1 Introducing MySQL
  • Database Basics
  • About MySQL AB and mysql46;com
  • MySQL Components
  • Summary
  • CH36;2 Using MySQL
  • The mysql Client
  • Executing SQL Statements
  • Creating the Sample Tables
  • Summary
  • PART 2 Getting Started with SQL
  • CH36;3 Retrieving Data
  • The SELECT Statement
  • Retrieving Database Information
  • Summary
  • CH36;4 Filtering and Sorting Data
  • The WHERE Clause
  • The ORDER BY Clause
  • Summary
  • CH36;5 Advanced Data Filtering
  • Combining WHERE Clauses
  • Limiting the Number of Rows Returned
  • Summary
  • CH36;6 Numeric Operators and Functions
  • Numeric Operators
  • Numeric Functions
  • Conditional Functions
  • Summary
  • CH36;7 String Operators and Functions
  • Using Operators with Strings
  • String Functions
  • Summary
  • CH36;8 Date Operators and Functions
  • Date Operators
  • Date Functions
  • Summary
  • CH36;9 Summarizing Data
  • Aggregate Functions
  • Grouping Data
  • Filtering Summary Data
  • Summary
  • PART 3 Advanced SQL
  • CH36;10 Using Subqueries
  • Understanding Subqueries
  • Summary
  • CH36;11 Joining Tables
  • Understanding Joins
  • Summary
  • CH36;12 Creating Advanced Joins
  • The JOIN Keyword
  • Inner Joins
  • Joining Multiple Tables
  • Cross Joins
  • Self45;Joins
  • Natural Joins
  • Outer Joins
  • Summary
  • CH36;13 Combining Queries
  • Understanding Combined Queries
  • Other Compound Operations
  • Using Temporary Tables
  • Summary
  • PART 4 Creating a New Database
  • CH36;14 Creating and Modifying Tables
  • Creating a New Database
  • Character Sets and Collations
  • Altering a Database
  • Dropping a Database
  • Managing Tables
  • Temporary Tables
  • Using a Query to Create a Table
  • Storage Engines
  • Altering Tables
  • Dropping Tables
  • Summary
  • CH36;15 Working with Data
  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • The REPLACE Statement
  • Loading Data from a File
  • Why Use Transactions63;
  • Transactions in MySQL
  • Autocommit Mode
  • Rolling Back a Transaction
  • Summary
  • CH36;16 Designing Your Database
  • Relationships
  • Normalization
  • Naming Tables and Columns
  • Data Types
  • Summary
  • CH36;17 Keys and Indexes
  • Understanding Keys and Indexes
  • Using Indexes in MySQL
  • Summary
  • CH36;18 Managing User Access
  • Understanding MySQL Authentication
  • User Management
  • Using Wildcards
  • Summary
  • PART 5 New Features in MySQL 546;0
  • CH36;19 Views
  • Understanding Views
  • Summary
  • CH36;20 Stored Routines
  • Understanding Stored Routines
  • Summary
  • CH36;21 Triggers
  • Understanding Triggers
  • Summary
  • PART 6 Interfacing with MySQL
  • CH36;22 Using ODBC
  • Understanding ODBC
  • Connecting to MyODBC
  • Summary
  • CH36;23 Using MySQL with C
  • The C Language API
  • Summary
  • CH36;24 Using MySQL with PHP
  • Using the mysql API
  • Using the mysqli API
  • Summary
  • CH36;25 Using MySQL with Perl
  • The Perl DBI
  • Using the MySQL DBD
  • Summary
  • PART 7 Appendixes
  • T$848.

Ejemplares similares