Flylib.com
Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors:
Chris Newman
BUY ON AMAZON
Sams Teach Yourself MySQL in 10 Minutes
Table of Contents
Copyright
About the Author
Introduction
Part 1: MySQL Foundations
Lesson 1. Introducing MySQL
Database Basics
MySQL Components
Summary
Lesson 2. Using MySQL
The mysql Client
Executing SQL Statements
Creating the Sample Tables
Summary
Part 2: Getting Started with SQL
Lesson 3. Retrieving Data
The SELECT Statement
Summary
Lesson 4. Filtering and Sorting Data
The WHERE Clause
The ORDER BY Clause
Summary
Lesson 5. Advanced Data Filtering
Combining WHERE Clauses
Limiting the Number of Rows Returned
Summary
Lesson 6. Numeric Operators and Functions
Numeric Operators
Numeric Functions
Conditional Functions
Summary
Lesson 7. String Operators and Functions
Using Operators with Strings
String Functions
Summary
Lesson 8. Date Operators and Functions
Date Operators
Date Functions
Summary
Lesson 9. Summarizing Data
Aggregate Functions
Grouping Data
Filtering Summary Data
Summary
Part 3: Advance SQL
Lesson 10. Using Subqueries
Understanding Subqueries
Summary
Lesson 11. Joining Tables
Understanding Joins
Summary
Lesson 12. Creating Advanced Joins
The JOIN Keyword
Inner Joins
Joining Multiple Tables
Cross Joins
Self-Joins
Natural Joins
Outer Joins
Summary
Lesson 13. Combining Queries
Understanding Combined Queries
Other Compound Operations
Using Temporary Tables
Summary
Part 4: Creating a New Database
Lesson 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
Lesson 15. Working with Data
The INSERT Statement
The DELETE Statement
The UPDATE Statement
The REPLACE Statement
Loading Data from a File
Why Use Transactions?
Transactions in MySQL
Autocommit Mode
Rolling Back a Transaction
Summary
Lesson 16. Designing Your Database
Relationships
Normalization
Naming Tables and Columns
Data Types
CHAR and VARCHAR
Summary
Lesson 17. Keys and Indexes
Understanding Keys and Indexes
Using Indexes in MySQL
Summary
Lesson 18. Managing User Access
Understanding MySQL Authentication
User Management
Using Wildcards
Summary
Part 5: New Features in MySQL 5.0
Lesson 19. Views
Understanding Views
Summary
Lesson 20. Stored Routines
Understanding Stored Routines
Summary
Lesson 21. Triggers
Understanding Triggers
Using Triggers
Summary
Part 6: Interfacing with MySQL
Lesson 22. Using ODBC
Understanding ODBC
Connecting to MyODBC
Summary
Lesson 23. Using MySQL with C
The C Language API
Summary
Lesson 24. Using MySQL with PHP
Using the mysql API
Using the mysqli API
Summary
Lesson 25. Using MySQL with Perl
The Perl DBI
Using the MySQL DBD
Summary
Part 7: Appendix
Appendix A. Installing MySQL
Obtaining MySQL
LinuxUNIX Installation
Windows Installation
Appendix B. Sample Table Scripts
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors:
Chris Newman
BUY ON AMAZON
Project Management JumpStart
Breaking Down the Project Activities
Closing the Books
Appendix A Answers to Review Questions
Appendix B Sample Project Management Forms
Appendix C Sample Project Management Checklists
Absolute Beginner[ap]s Guide to Project Management
Defining a Project
Variance Responses
Best Practices
Principles of Managing Project Quality
Best Practices of Effective Project Communicators
WebLogic: The Definitive Guide
Using J2EE Services on the Object Tier
Creating an Identity Assertion Provider
Implementing Clients
SOAP Message Handlers
Monitor MBeans
MySQL Clustering
Testing Your Cluster
Common Errors While Importing Tables
Running MySQL in a Chrooted Environment
Performance Metrics
Common Setups
The Complete Cisco VPN Configuration Guide
Traffic Issues
IPsec Standards
Introduction to Accessing a Concentrator
Windows Software Client
IPsec Preparation
Digital Character Animation 3 (No. 3)
Surface Types
Conclusion
Animating Walks
Chapter Seven. Facial and Dialogue Animation
Four-Legged Mammals
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies