United States MySQL 5 Development (Part 1) Tutorials
Online Contents For This Course
We have made some of the video tutorials for
MySQL 5 Development (Part 1)
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course 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 non-destructive, read-only 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 hands-on lessons. Click the movie links below to get started now!
Choose your media type:
|
Introduction
|
|||
| Welcome | (04:34) | T | |
| What This Course Will Cover | (05:09) | T | |
| System Requirements | (02:56) | T | |
| A Brief History of MySQL | (06:07) | T | |
| Help on the MySQL Web Site | (03:27) | T | |
| Online Manual Demonstration pt. 1 | (05:56) | T | |
| Online Manual Demonstration pt. 2 | (01:54) | T | |
|
Database Basics
|
|||
| Definitions | (04:28) | T | |
| Client/Server Systems | (06:04) | T | |
| Tables/Columns/Rows | (03:21) | T | |
| Database Design in a Nutshell | (06:21) | T | |
| Indexes | (03:45) | T | |
| Databases in MySQL | (05:43) | T | |
|
Installation
|
|||
| Installation Basics | (07:19) | T | |
| Windows | (07:16) | T | |
| Mac OS X | (02:58) | T | |
| Linux | (02:00) | T | |
| What We Installed | (05:27) | T | |
| Starting and Stopping MySQL | (02:19) | T | |
|
Configuration
|
|||
| MySQL Server Configuration | (02:18) | T | |
| Server Startup Options | (05:53) | T | |
| MySQL Configuration File | (05:25) | T | |
| Important Configuration Options | (06:00) | T | |
|
Client Programs
|
|||
| Command Line Operations | (05:48) | T | |
| Using a Command Line Client | (04:05) | T | |
| Command Line Client Help File | (06:06) | T | |
| MySQL Client Batch Mode | (06:27) | T | |
| MySQL Client Interactive Mode pt. 1 | (06:01) | T | |
| MySQL Client Interactive Mode pt. 2 | (04:32) | T | |
| MySQL Client Interactive Mode pt. 3 | (06:02) | T | |
| Executing Scripts | (06:49) | T | |
| Exploring Databases and Tables | (07:11) | T | |
|
SELECT Statement Basics
|
|||
| SELECT Arithmetic | (06:18) | T | |
| Selecting More Than One Column | (04:42) | T | |
| Operators and Functions | (05:03) | T | |
| Column Aliases | (05:50) | T | |
| NULL | (05:01) | T | |
| Data Type Basics | (05:24) | T | |
|
Variables
|
|||
| What is a Variable? | (03:55) | T | |
| User Variables | (01:42) | T | |
| Assignment Operator | (02:50) | T | |
| SET Statement | (05:53) | T | |
| System Variables | (04:36) | T | |
| Variable Scope | (07:12) | T | |
|
Calculations and Expressions
|
|||
| New Values From Old | (02:35) | T | |
| Operators and Operands | (03:45) | T | |
| Arithmetic Operators | (03:39) | T | |
| String Operators | (05:12) | T | |
| Comparison Operators | (05:28) | T | |
| Logical Operators | (06:22) | T | |
| Order of Precedence | (02:59) | T | |
| Functions and Parameters | (03:28) | T | |
| Useful Numeric Functions | (06:31) | T | |
| Useful Character String Functions | (07:10) | T | |
| Temporal Operations | (05:33) | T | |
| Useful Temporal Functions | (05:09) | T | |
| Decision-Making Functions | (07:27) | T | |
| NULL-Related Functions | (04:52) | T | |
| Useful System Functions | (02:41) | T | |
|
Querying SQL Data
|
|||
| Using a Database | (05:02) | T | |
| Selecting FROM a Table | (04:59) | T | |
| Targeting Rows Using WHERE | (05:08) | T | |
| Complex WHERE Criteria | (06:59) | T | |
| Sorting Results Using ORDER BY | (05:56) | T | |
| Going to Extremes Using LIMIT | (03:38) | T | |
| Avoiding Duplicates Using DISTINCT | (03:54) | T | |
| Aggregation Queries | (04:52) | T | |
| Subtotals Using GROUP BY | (06:10) | T | |
| Filter Derived Columns with HAVING | (02:43) | T | |
| Multilevel Sums Using WITH ROLLUP | (05:17) | T | |
| Summarizing SELECT Clauses | (06:44) | T | |
| Some Clauses Cannot Coexist | (03:07) | T | |
|
Databases and Tables
|
|||
| Databases in MySQL | (04:42) | T | |
| Creating a Database | (06:57) | T | |
| Aspects of a Table | (02:47) | T | |
| Creating a Table | (05:12) | T | |
| Table Options | (05:08) | T | |
| Column Options | (06:35) | T | |
| Auto-Incrementation | (05:29) | T | |
| Altering a Table | (04:54) | T | |
| Adding and Dropping Columns | (03:43) | T | |
| Altering a Column | (06:09) | T | |
| Dropping a Table | (04:27) | T | |
| Dropping a Database | (04:26) | T | |
|
Data Type Details
|
|||
| Data Type Categories | (02:23) | T | |
| Integer Numbers | (07:00) | T | |
| Floating Point Numbers | (07:36) | T | |
| Fixed Decimal Numbers | (04:49) | T | |
| BIT Data Type | (07:24) | T | |
| Strings | (03:13) | T | |
| Basic Character Strings | (05:45) | T | |
| ENUM Character Strings | (06:35) | T | |
| SET Character Strings | (06:08) | T | |
| Character Sets | (06:54) | T | |
| Collations | (06:51) | T | |
| Fonts and Keystroke Mapping | (07:00) | T | |
| Binary Strings | (05:21) | T | |
| Temporal Data | (05:43) | T | |
| Timestamp and Time Types | (06:16) | T | |
|
Storage Engines
|
|||
| Storage Engine Basics | (06:29) | T | |
| Discovering Storage Engines | (04:34) | T | |
| MyISAM | (06:20) | T | |
| InnoDB | (06:36) | T | |
| Memory | (05:31) | T | |
| Example | (01:54) | T | |
| CSV | (03:53) | T | |
| Archive | (02:38) | T | |
| Federated | (04:41) | T | |
| Blackhole | (02:27) | T | |
| Third Party Engines | (02:27) | T | |
|
Exporting Data
|
|||
| Basic Export Concepts | (02:57) | T | |
| Exporting Using SQL Commands pt. 1 | (04:44) | T | |
| Exporting Using SQL Commands pt. 2 | (05:06) | T | |
| Exporting on the Shell Command Line | (05:03) | T | |
| Using MySQLDUMP for Scripts | (07:02) | T | |
| Using MySQLDUMP for Exporting | (07:21) | T | |
|
Prepared Statements
|
|||
| Prepared Statement Basics | (07:53) | T | |
| Prepared Statement Demonstration | (07:00) | T | |
| Commands That Can Be Prepared | (03:32) | T | |
| When to Use Them | (03:26) | T | |
|
Server Information
|
|||
| Metadata | (07:07) | T | |
| SHOW Commands | (06:39) | T | |
| DESCRIBE Command | (03:07) | T | |
| MySQLSHOW Command Line Client | (06:58) | T | |
| Information_Schema Database pt. 1 | (04:55) | T | |
| Information_Schema Database pt. 2 | (06:40) | T | |
|
Conclusion
|
|||
| What We Covered | (03:00) | T | |
| Where to Go from Here | (03:08) | T | |
|
Credits
|
|||
| About the Author | (02:50) | T | |
Email this Page 
Send us FeedbackCourse Information
| Course: | MySQL 5 Development (Part 1) |
| Author: | David Swain |
| SKU: | 34225 |
| ISBN: | 1-936334-93-3 |
| Release Date: | 2011-05-27 |
| Duration: | 11 hrs / 129 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Search within Captions
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com's entire library of video tutorials.
If you are already a member, please login here.