Artikel und Links: Datenbanken / MySQL

Database Fundamentals with MySQL

  1. Database Journal:
    1. Just SQL Part IV - Joining Tables
    2. MySQL Subqueries
    3. Date and Time in MySQL 5
    4. MySQL and Character Sets
  2. Developer.com: Secrets of the MySQL Client Command Line
  3. Devshed.com:
    1. Beginning SQL
    2. Beginning SQL the SEQUEL: Working with Advanced SQL Statement
    3. More Advanced SQL Statements
    4. Date Arithmetic with MySQL
    5. Introduction to SQL
    6. Understanding SQL Joins
    7. Using Subqueries In MySQL 4.1 (2 parts)
    8. Using Transactions In MySQL (Part 1 | Part 2)
    9. Database Design Using Key-Value Tables
    10. Optimizing Queries with Operators, Branching and Functions
    11. Optimizing Queries with Operators, Branching and Functions continued
    12. Optimizing Queries with Operators for Date, Time and Other Functions
    13. Null and Empty Strings
    14. Designing a MySQL Database: Tips and Techniques
  4. Devshed.com: MySQL Versions (Features)
    1. Taking a Look at MySQL 4.1
    2. Examining MySQL 5.0
    3. Delving Deeper into MySQL 5.0
    4. Planned Improvements in MySQL 5.1
  5. Devshed.com: Full Text Searches
    1. Performing Full-text and Boolean Searches
    2. Using Relevance Rankings for Full Text and Boolean Searches
    3. Using Boolean Operators for Full Text and Boolean Searches
  6. Devshed.com / Sams Publishing - MySQL Security
    1. Security Issues with MySQL
    2. Security and More in MySQL Databases
    3. Working with the MySQL Access Privilege System
    4. Disaster Prevention and Recovery with the MySQL Database
    5. Administering MySQL: International Usage and Log File
    6. Advanced MySQL Database Administration
    7. MySQL User Account Management
    8. Client Access Control with MySQL
    9. Optimizing for Query Speed
    10. Analyzing Queries for Speed with EXPLAIN
    11. Enhancing MySQL Query Efficiency
    12. Optimizing the Logical Database Structure
  7. Digitalweb.com: Introduction to Databases
  8. PHPBuilder.com: MySQL, today's contender (covers 5.1 and 5.2)
  9. Mysql.com:
    1. Database Migration from FileMaker to MySQL
    2. New Features of MySQL 5.0
    3. Using Transactions with InnoDB Tables
  10. Networkcomputing: Database Engines compared
  11. O'Reilly Media: MySQL Stored Procedure Programming
    1. Error Handling
    2. Error Handling Examples
    3. Using the SIGNAL Statement for Error Handling

SQL - general language features

  1. Devshed.com: All About SQL Functions
    1. SQL: Functioning in the Real World
    2. All About SQL Functions
  2. O'Reilly Media: SQL Hacks
    1. Date Handling
    2. SQL Date Handling and Data Trends
    3. Creating SQL Reports Based on Date Criteria
    4. Generating Reports with SQL Date Handling
  3. O'Reilly Media: The Art of SQL
    1. A Close Look at the SQL Query
    2. Complex SQL Queries
    3. Focusing SQL Queries

SQLite

  1. Developer.com: SQLite - The Sensible Database Solution