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

Product Information

  • Title: MySQL 5 Development (Part 1)
  • Author(s): David Swain
  • Release date: May 2011
  • Publisher(s): Virtual Training Company, Inc.
  • ISBN: 1936334933