O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MySQL 5 Development (Part 1)

Video Description

As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of nondestructive, readonly techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and ""why"" those elements are written in a specific way. Further study exercises are provided for many of the handson lessons. Click the movie links below to get started now!

Table of Contents

  1. Introduction
    1. Welcome 00:04:34
    2. What This Course Will Cover 00:05:09
    3. System Requirements 00:02:56
    4. A Brief History of MySQL 00:06:07
    5. He|p on the MySQL Web Site 00:03:27
    6. Online Manual Demonstration pt. 1 00:05:56
    7. Online Manual Demonstration pt. 2 00:01:54
  2. Database Basics
    1. Definitions 00:04:28
    2. Client/Server Systems 00:06:04
    3. Tables/Columns/Rows 00:03:21
    4. Database Design in a Nutshell 00:06:21
    5. Indexes 00:03:45
    6. Databases in MySQL 00:05:43
  3. Installation
    1. Installation Basics 00:07:19
    2. Windows 00:07:16
    3. Mac OS X 00:02:58
    4. Linux 00:02:00
    5. What We Installed 00:05:27
    6. Starting and Stopping MySQL 00:02:19
  4. Configuration
    1. MySQL Server Configuration 00:02:18
    2. Server Startup Options 00:05:53
    3. MySQL Configuration File 00:05:25
    4. Important Configuration Options 00:06:00
  5. Client Programs
    1. Command Line Operations 00:05:48
    2. Using a Command Line Client 00:04:05
    3. Command Line Client He|p File 00:06:06
    4. MySQL Client Batch Mode 00:06:27
    5. MySQL Client Interactive Mode pt. 1 00:06:01
    6. MySQL Client Interactive Mode pt. 2 00:04:32
    7. MySQL Client Interactive Mode pt. 3 00:06:02
    8. Executing Scripts 00:06:49
    9. Exploring Databases and Tables 00:07:11
  6. SELECT Statement Basics
    1. SELECT Arithmetic 00:06:18
    2. Selecting More Than One Column 00:04:42
    3. Operators and Functions 00:05:03
    4. Column Aliases 00:05:50
    5. NULL 00:05:01
    6. Data Type Basics 00:05:24
  7. Variables
    1. What is a Variable? 00:03:55
    2. User Variables 00:01:42
    3. Assignment Operator 00:02:51
    4. SET Statement 00:05:53
    5. System Variables 00:04:36
    6. Variable Scope 00:07:12
  8. Calculations and Expressions
    1. New Values From Old 00:02:35
    2. Operators and Operands 00:03:45
    3. Arithmetic Operators 00:03:39
    4. String Operators 00:05:12
    5. Comparison Operators 00:05:28
    6. Logical Operators 00:06:22
    7. Order of Precedence 00:02:59
    8. Functions and Parameters 00:03:28
    9. Useful Numeric Functions 00:06:31
    10. Useful Character String Functions 00:07:10
    11. Temporal Operations 00:05:33
    12. Useful Temporal Functions 00:05:09
    13. Decision-Making Functions 00:07:27
    14. NULL-Related Functions 00:04:52
    15. Useful System Functions 00:02:41
  9. Querying SQL Data
    1. Using a Database 00:05:02
    2. Selecting FROM a Table 00:04:59
    3. Targeting Rows Using WHERE 00:05:08
    4. Complex WHERE Criteria 00:06:59
    5. Sorting Results Using ORDER BY 00:05:56
    6. Going to Extremes Using LIMIT 00:03:38
    7. Avoiding Duplicates Using DISTINCT 00:03:54
    8. Aggregation Queries 00:04:52
    9. Subtotals Using GROUP BY 00:06:10
    10. Filter Derived Columns with HAVING 00:02:43
    11. Multilevel Sums Using WITH ROLLUP 00:05:17
    12. Summarizing SELECT Clauses 00:06:44
    13. Some Clauses Cannot Coexist 00:03:07
  10. Databases and Tables
    1. Databases in MySQL 00:04:42
    2. Creating a Database 00:06:57
    3. Aspects of a Table 00:02:47
    4. Creating a Table 00:05:12
    5. Table Options 00:05:08
    6. Column Options 00:06:35
    7. Auto-Incrementation 00:05:29
    8. Altering a Table 00:04:54
    9. Adding and Dropping Columns 00:03:43
    10. Altering a Column 00:06:09
    11. Dropping a Table 00:04:27
    12. Dropping a Database 00:04:26
  11. Data Type Details
    1. Data Type Categories 00:02:23
    2. Integer Numbers 00:07:00
    3. Floating Point Numbers 00:07:36
    4. Fixed Decimal Numbers 00:04:49
    5. BIT Data Type 00:07:24
    6. Strings 00:03:13
    7. Basic Character Strings 00:05:45
    8. ENUM Character Strings 00:06:35
    9. SET Character Strings 00:06:08
    10. Character Sets 00:06:54
    11. Collations 00:06:51
    12. Fonts and Keystroke Mapping 00:07:00
    13. Binary Strings 00:05:21
    14. Temporal Data 00:05:43
    15. Timestamp and Time Types 00:06:16
  12. Storage Engines
    1. Storage Engine Basics 00:06:29
    2. Discovering Storage Engines 00:04:34
    3. MyISAM 00:06:20
    4. InnoDB 00:06:36
    5. Memory 00:05:31
    6. Example 00:01:54
    7. CSV 00:03:53
    8. Archive 00:02:38
    9. Federated 00:04:41
    10. Blackhole 00:02:27
    11. Third Party Engines 00:02:27
  13. Exporting Data
    1. Basic Export Concepts 00:02:57
    2. Exporting Using SQL Commands pt. 1 00:04:44
    3. Exporting Using SQL Commands pt. 2 00:05:06
    4. Exporting on the Shell Command Line 00:05:03
    5. Using MySQLDUMP for Scripts 00:07:02
    6. Using MySQLDUMP for Exporting 00:07:21
  14. Prepared Statements
    1. Prepared Statement Basics 00:07:53
    2. Prepared Statement Demonstration 00:07:00
    3. Commands That Can Be Prepared 00:03:32
    4. When to Use Them 00:03:26
  15. Server Information
    1. Metadata 00:07:07
    2. SHOW Commands 00:06:39
    3. DESCRIBE Command 00:03:07
    4. MySQLSHOW Command Line Client 00:06:58
    5. Information_Schema Database pt. 1 00:04:55
    6. Information_Schema Database pt. 2 00:06:40
  16. Conclusion
    1. What We Covered 00:03:00
    2. Where to Go from Here 00:03:08
  17. Credits
    1. About the Author 00:02:50