| 00. Welcome | |||
| 00.01. Welcome.flv | 5.2 MB | ||
| 00.02. What This Course Will Cover.flv | 5.34 MB | ||
| 00.03. System Requirements.flv | 3.1 MB | ||
| 00.04. A Brief History of MySQL.flv | 6.5 MB | ||
| 00.05. Help on the MySQL Web Site.flv | 3.57 MB | ||
| 00.06. Online Manual Demonstration pt- 1.flv | 13.55 MB | ||
| 00.07. Online Manual Demonstration pt- 2.flv | 3.12 MB | ||
| 01. Database Basics | |||
| 01.01. Definitions.flv | 4.52 MB | ||
| 01.02. ClientServer Systems.flv | 6.91 MB | ||
| 01.03. TablesColumnsRows.flv | 3.6 MB | ||
| 01.04. Database Design in a Nutshell.flv | 6.72 MB | ||
| 01.05. Indexes.flv | 4.23 MB | ||
| 01.06. Databases in MySQL.flv | 6.11 MB | ||
| 02. Installation | |||
| 02.01. Installation Basics.flv | 7.81 MB | ||
| 02.02. Windows.flv | 8.1 MB | ||
| 02.03. Mac OS X.flv | 2.88 MB | ||
| 02.04. Linux.flv | 1.91 MB | ||
| 02.05. What We Installed.flv | 5.81 MB | ||
| 02.06. Starting and Stopping MySQL.flv | 2.4 MB | ||
| 03. Configuration | |||
| 03.01. MySQL Server Configuration.flv | 2.38 MB | ||
| 03.02. Server Startup Options.flv | 10.15 MB | ||
| 03.03. MySQL Configuration File.flv | 7.64 MB | ||
| 03.04. Important Configuration Options.flv | 7.8 MB | ||
| 04. Client Programs | |||
| 04.01. Command Line Operations.flv | 5.26 MB | ||
| 04.02. Using a Command Line Client.flv | 5.07 MB | ||
| 04.03. Command Line Client Help File.flv | 13.8 MB | ||
| 04.04. MySQL Client Batch Mode.flv | 6.33 MB | ||
| 04.05. MySQL Client Interactive Mode pt. 1.flv | 6.33 MB | ||
| 04.06. MySQL Client Interactive Mode pt. 2.flv | 6.76 MB | ||
| 04.07. MySQL Client Interactive Mode pt. 3.flv | 9.84 MB | ||
| 04.08. Executing Scripts.flv | 6.62 MB | ||
| 04.09. Exploring Databases and Tables.flv | 10.27 MB | ||
| 05. SELECT statement Basics | |||
| 05.01. SELECT Arithmetic.flv | 6.2 MB | ||
| 05.02. Selecting More than One Column.flv | 5.11 MB | ||
| 05.03. Operators and Funtions.flv | 4.97 MB | ||
| 05.04. Column Aliases.flv | 6.35 MB | ||
| 05.05. NULL.flv | 5.48 MB | ||
| 05.06. Data Type Basics.flv | 6.28 MB | ||
| 06. Variables | |||
| 06.01. What is a Variable.flv | 4.17 MB | ||
| 06.02. User Variables.flv | 1.46 MB | ||
| 06.03. Assignment Operator.flv | 2.42 MB | ||
| 06.04. SET statement.flv | 5.31 MB | ||
| 06.05. System Variables.flv | 3.97 MB | ||
| 06.06. Variable Scope.flv | 7.03 MB | ||
| 07. Calculations and Expressions | |||
| 07.01. New Values From Old.flv | 2.83 MB | ||
| 07.02. Operators and Operands.flv | 3.15 MB | ||
| 07.03. Arithmetic Operators.flv | 3.17 MB | ||
| 07.04. String Operators.flv | 4.59 MB | ||
| 07.05. Comparison Operators.flv | 4.67 MB | ||
| 07.06. Logical Operators.flv | 6.24 MB | ||
| 07.07. Order of Precedence.flv | 3.71 MB | ||
| 07.08. Functions and Parameters.flv | 3.41 MB | ||
| 07.09. Useful Numeric Functions.flv | 6.28 MB | ||
| 07.10. Useful Character String Functions.flv | 6.6 MB | ||
| 07.11. Temporal Operations.flv | 7.2 MB | ||
| 07.12. Useful Temporal Functions.flv | 5.23 MB | ||
| 07.13. Decision-Making Functions.flv | 7.44 MB | ||
| 07.14. NULL-related Functions.flv | 4.53 MB | ||
| 07.15. Useful System Functions.flv | 2.38 MB | ||
| 08. Querying SQL Data | |||
| 08.01. Using a Database.flv | 5.29 MB | ||
| 08.02. Selecting FROM a Table.flv | 6.49 MB | ||
| 08.03. Targeting Rows Using WHERE.flv | 5.25 MB | ||
| 08.04. Complex WHERE Criteria.flv | 8.04 MB | ||
| 08.05. Sorting Results Using ORDER BY.flv | 6.69 MB | ||
| 08.06. Going to Extremes Using LIMIT.flv | 4.53 MB | ||
| 08.07. Avoiding Duplicates Using DISTINCT.flv | 4.08 MB | ||
| 08.08. Aggregation Queries.flv | 4.78 MB | ||
| 08.09. Subtotals Using GROUP BY.flv | 7.67 MB | ||
| 08.10. Filter Derived Columns with HAVING.flv | 2.91 MB | ||
| 08.11. Multilevl Sums Using WITH ROLLUP.flv | 8.35 MB | ||
| 08.12. Summarizing SELECT Clauses.flv | 7.18 MB | ||
| 08.13. Some Clauses Cannot Coexist.flv | 3.62 MB | ||
| 09. Databases and Tables | |||
| 09.01. Databases in MySQL.flv | 5.14 MB | ||
| 09.02. Creating a Database.flv | 7.01 MB | ||
| 09.03. Aspects of a Table.flv | 2.95 MB | ||
| 09.04. Creating a Table.flv | 7.39 MB | ||
| 09.05. Table Options.flv | 5.35 MB | ||
| 09.06. Column Options.flv | 7 MB | ||
| 09.07. Auto-Incrementation.flv | 5.65 MB | ||
| 09.08. Altering a Table.flv | 5.38 MB | ||
| 09.09. Adding and Dropping Columns.flv | 4.5 MB | ||
| 09.10. Altering a Column.flv | 7.53 MB | ||
| 09.11. Dropping a Table.flv | 4.34 MB | ||
| 09.12. Dropping a Database.flv | 4.28 MB | ||
| 10. Data Type Details | |||
| 10.01. Data Type Categories.flv | 2.37 MB | ||
| 10.02. Integer Numbers.flv | 7.12 MB | ||
| 10.03. Floating Point Numbers.flv | 7.86 MB | ||
| 10.04. Fixed Decimal Numbers.flv | 4.98 MB | ||
| 10.05. BIT Data Type.flv | 7.46 MB | ||
| 10.06. Strings.flv | 3.41 MB | ||
| 10.07. Basic Character Strings.flv | 6.53 MB | ||
| 10.08. ENUM Character Strings.flv | 6.98 MB | ||
| 10.09. SET Character Strings.flv | 6.27 MB | ||
| 10.10. Character Sets.flv | 7.82 MB | ||
| 10.11. Collations.flv | 8.04 MB | ||
| 10.12. Fonts and Keystroke Mapping.flv | 3.27 MB | ||
| 10.13. Binary Strings.flv | 2.5 MB | ||
| 10.14. Temporal Data.flv | 5.94 MB | ||
| 10.15. Timestamp and Time Types.flv | 6.84 MB | ||
| 11. Storage Engines | |||
| 11.01. Storage Engine Basics.flv | 7.19 MB | ||
| 11.02. Discovering Storage Engines.flv | 7.02 MB | ||
| 11.03. MyISAM.flv | 6.91 MB | ||
| 11.04. InnoDB.flv | 6.72 MB | ||
| 11.05. Memory.flv | 5.92 MB | ||
| 11.06. Example.flv | 1.97 MB | ||
| 11.07. CSV.flv | 4.09 MB | ||
| 11.08. Archive.flv | 2.79 MB | ||
| 11.09. Federated.flv | 4.69 MB | ||
| 11.10. Blackhole.flv | 2.26 MB | ||
| 11.11. Third Party Engines.flv | 2.75 MB | ||
| 12. Exporting Data | |||
| 12.01. Basic Export Concepts.flv | 3.15 MB | ||
| 12.02. Exporting Using SQL Commands pt. 1.flv | 6.35 MB | ||
| 12.03. Exporting Using SQL Commands pt. 2.flv | 5.76 MB | ||
| 12.04. Exporting on the Shell Command Line.flv | 6.25 MB | ||
| 12.05. Using MySQLDUMP for Scripts.flv | 14.21 MB | ||
| 12.06. Using MySQLDUMP for Exporting.flv | 12.26 MB | ||
| 13. Prepared Statements | |||
| 13.01. Prepared Statement Basics.flv | 7.91 MB | ||
| 13.02. Prepared Statement Demonstration.flv | 8.45 MB | ||
| 13.03. Commands That Can Be Prepared.flv | 3.72 MB | ||
| 13.04. When to Use Them.flv | 3.87 MB | ||
| 14. Server Information | |||
| 14.01. Metadata.flv | 6.98 MB | ||
| 14.02. SHOW Commands.flv | 8.25 MB | ||
| 14.03. DESCRIBE Command.flv | 3.35 MB | ||
| 14.04. MySQLSHOW Command Line Client.flv | 7.02 MB | ||
| 14.05. Information_Schema Database pt. 1.flv | 4.87 MB | ||
| 14.06. Information_Schema Database pt. 2.flv | 7.38 MB | ||
| 15. Conclusion | |||
| 15.01. What We Covered.flv | 3.16 MB | ||
| 15.02. Where to Go from Here.flv | 3.22 MB | ||
| 16. Credits | |||
| 16.01. About the Author.flv | 2.72 MB | ||
| VTC - MySQL 5 Development - Part 1.nfo | 5.22 KB | ||
| mysql5dev1.zip | 12.74 KB | ||
| ▲ 131 total files | |||
VTC - MySQL 5 Development - Part 1
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
Subject: Databases
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!
Table of Contents
Introduction
* Welcome (04:34)
* What This Course Will Cover (05:09)
* System Requirements (02:56)
* A Brief History of MySQL (06:07)
* Help on the MySQL Web Site (03:27)
* Online Manual Demonstration pt. 1 (05:56)
* Online Manual Demonstration pt. 2 (01:54)
Database Basics
* Definitions (04:28)
* Client/Server Systems (06:04)
* Tables/Columns/Rows (03:21)
* Database Design in a Nutshell (06:21)
* Indexes (03:45)
* Databases in MySQL (05:43)
Installation
* Installation Basics (07:19)
* Windows (07:16)
* Mac OS X (02:58)
* Linux (02:00)
* What We Installed (05:27)
* Starting and Stopping MySQL (02:19)
Configuration
* MySQL Server Configuration (02:18)
* Server Startup Options (05:53)
* MySQL Configuration File (05:25)
* Important Configuration Options (06:00)
Client Programs
* Command Line Operations (05:48)
* Using a Command Line Client (04:05)
* Command Line Client Help File (06:06)
* MySQL Client Batch Mode (06:27)
* MySQL Client Interactive Mode pt. 1 (06:01)
* MySQL Client Interactive Mode pt. 2 (04:32)
* MySQL Client Interactive Mode pt. 3 (06:02)
* Executing Scripts (06:49)
* Exploring Databases and ables (07:11)
SELECT Statement Basics
* SELECT Arithmetic (06:18)
* Selecting More Than One Column (04:42)
* Operators and Functions (05:03)
* Column Aliases (05:50)
* NULL (05:01)
* Data Type Basics (05:24)
Variables
* What is a Variable? (03:55)
* User Variables (01:42)
* Assignment Operator (02:50)
* SET Statement (05:53)
* System Variables (04:36)
* Variable Scope (07:12)
Calculations and Expressions
* New Values From Old (02:35)
* Operators and Operands (03:45)
* Arithmetic Operators (03:39)
* String Operators (05:12)
* Comparison Operators (05:28)
* Logical Operators (06:22)
* Order of Precedence (02:59)
* Functions and Parameters (03:28)
* Useful Numeric Functions (06:31)
* Useful Character String Functions (07:10)
* Temporal Operations (05:33)
* Useful Temporal Functions (05:09)
* Decision-Making Functions (07:27)
* NULL-Related Functions (04:52)
* Useful System Functions (02:41)
Querying SQL Data
* Using a Database (05:02)
* Selecting FROM a able (04:59)
* Targeting Rows Using WHERE (05:08)
* Complex WHERE Criteria (06:59)
* Sorting Results Using ORDER BY (05:56)
* Going to Extremes Using LIMIT (03:38)
* Avoiding Duplicates Using DISTINCT (03:54)
* Aggregation Queries (04:52)
* Subtotals Using GROUP BY (06:10)
* Filter Derived Columns with HAVING (02:43)
* Multilevel Sums Using WITH ROLLUP (05:17)
* Summarizing SELECT Clauses (06:44)
* Some Clauses Cannot Coexist (03:07)
Databases and Tables
* Databases in MySQL (04:42)
* Creating a Database (06:57)
* Aspects of a Table (02:47)
* Creating a Table (05:12)
* Table Options (05:08)
* Column Options (06:35)
* Auto-Incrementation (05:29)
* Altering a Table (04:54)
* Adding and Dropping Columns (03:43)
* Altering a Column (06:09)
* Dropping a Table (04:27)
* Dropping a Database (04:26)
Data Type Details
* Dataype Categories (02:23)
* Integer Numbers (07:00)
* Floating Point Numbers (07:36)
* Fixed Decimal Numbers (04:49)
* BIT Data Type (07:24)
* Strings (03:13)
* Basic Character Strings (05:45)
* ENUM Character Strings (06:35)
* SET Character Strings (06:08)
* Character Sets (06:54)
* Collations (06:51)
* Fonts and Keystroke Mapping (07:00)
* Binary Strings (05:21)
* Temporal Data (05:43)
* Timestamp and Time Types (06:16)
Storage Engines
* Storage Engine Basics (06:29)
* Discovering Storage Engines (04:34)
* MyISAM (06:20)
* InnoDB (06:36)
* Memory (05:31)
* Example (01:54)
* CSV (03:53)
* Archive (02:38)
* Federated (04:41)
* Blackhole (02:27)
* Third Party Engines (02:27)
Exporting Data
* Basic Export Concepts (02:57)
* Exporting Using SQL Commands pt. 1 (04:44)
* Exporting Using SQL Commands pt. 2 (05:06)
* Exporting on the Shell Command Line (05:03)
* Using MySQLDUMP for Scripts (07:02)
* Using MySQLDUMP for Exporting (07:21)
Prepared Statements
* Prepared Statement Basics (07:53)
* Prepared Statement Demonstration (07:00)
* Commands That Can Be Prepared (03:32)
* When to Use Them (03:26)
Server Information
* Metadata (07:07)
* SHOW Commands (06:39)
* DESCRIBE Command (03:07)
* MySQLSHOW Command Line Client (06:58)
* Information_Schema Database pt. 1 (04:55)
* Information_Schema Database pt. 2 (06:40)
Conclusion
* What We Covered (03:00)
* Where to Go from Here (03:08)
Credits
* About the Author
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.7 GB | yTSa6 | 13 years | 1 | 0 |
All Comments