| MySQL 5 Development (Part 1) Tutorials Online |
 |
|
Description MySQL 5 Development (Part 1)
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! |
| Sample - Preview the First 3 chapters of MySQL 5 Development (Part 1) video free. Free learning MySQL 5 Development (Part 1) online. |
01 Introduction
0101 Welcome
0102 What This Course Will Cover
0103 System Requirements
0104 A Brief History of MySQL
0105 Help on the MySQL Web Site
0106 Online Manual Demonstration pt. 1
0107 Online Manual Demonstration pt. 2
02 Database Basics
0201 Definitions
0202 Client/Server Systems
0203 Tables/Columns/Rows
0204 Database Design in a Nutshell
0205 Indexes
0206 Databases in MySQL
03 Installation
0301 Installation Basics
0302 Windows
0303 Mac OS X
0304 Linux
0305 What We Installed
0306 Starting and Stopping MySQL
04 Configuration
0401 MySQL Server Configuration
0402 Server Startup Options
0403 MySQL Configuration File
0404 Important Configuration Options
05 Client Programs
0501 Command Line Operations
0502 Using a Command Line Client
0503 Command Line Client Help File
0504 MySQL Client Batch Mode
0505 MySQL Client Interactive Mode pt. 1
0506 MySQL Client Interactive Mode pt. 2
0507 MySQL Client Interactive Mode pt. 3
0508 Executing Scripts
0509 Exploring Databases and Tables
06 SELECT Statement Basics
0601 SELECT Arithmetic
0602 Selecting More Than One Column
0603 Operators and Functions
0604 Column Aliases
0605 NULL
0606 Data Type Basics
07 Variables
0701 What is a Variable?
0702 User Variables
0703 Assignment Operator
0704 SET Statement
0705 System Variables
0706 Variable Scope
08 Calculations and Expressions
0801 New Values From Old
0802 Operators and Operands
0803 Arithmetic Operators
0804 String Operators
0805 Comparison Operators
0806 Logical Operators
0807 Order of Precedence
0808 Functions and Parameters
0809 Useful Numeric Functions
0810 Useful Character String Functions
0811 Temporal Operations
0812 Useful Temporal Functions
0813 Decision-Making Functions
0814 NULL-Related Functions
0815 Useful System Functions
09 Querying SQL Data
0901 Using a Database
0902 Selecting FROM a Table
0903 Targeting Rows Using WHERE
0904 Complex WHERE Criteria
0905 Sorting Results Using ORDER BY
0906 Going to Extremes Using LIMIT
0907 Avoiding Duplicates Using DISTINCT
0908 Aggregation Queries
0909 Subtotals Using GROUP BY
0910 Filter Derived Columns with HAVING
0911 Multilevel Sums Using WITH ROLLUP
0912 Summarizing SELECT Clauses
0913 Some Clauses Cannot Coexist
10 Databases and Tables
1001 Databases in MySQL
1002 Creating a Database
1003 Aspects of a Table
1004 Creating a Table
1005 Table Options
1006 Column Options
1007 Auto-Incrementation
1008 Altering a Table
1009 Adding and Dropping Columns
1010 Altering a Column
1011 Dropping a Table
1012 Dropping a Database
11 Data Type Details
1101 Data Type Categories
1102 Integer Numbers
1103 Floating Point Numbers
1104 Fixed Decimal Numbers
1105 BIT Data Type
1106 Strings
1107 Basic Character Strings
1108 ENUM Character Strings
1109 SET Character Strings
1110 Character Sets
1111 Collations
1112 Fonts and Keystroke Mapping
1113 Binary Strings
1114 Temporal Data
1115 Timestamp and Time Types
12 Storage Engines
1201 Storage Engine Basics
1202 Discovering Storage Engines
1203 MyISAM
1204 InnoDB
1205 Memory
1206 Example
1207 CSV
1208 Archive
1209 Federated
1210 Blackhole
1211 Third Party Engines
13 Exporting Data
1301 Basic Export Concepts
1302 Exporting Using SQL Commands pt. 1
1303 Exporting Using SQL Commands pt. 2
1304 Exporting on the Shell Command Line
1305 Using MySQLDUMP for Scripts
1306 Using MySQLDUMP for Exporting
14 Prepared Statements
1401 Prepared Statement Basics
1402 Prepared Statement Demonstration
1403 Commands That Can Be Prepared
1404 When to Use Them
15 Server Information
1501 Metadata
1502 SHOW Commands
1503 DESCRIBE Command
1504 MySQLSHOW Command Line Client
1505 Information_Schema Database pt. 1
1506 Information_Schema Database pt. 2
16 Conclusion
1601 What We Covered
1602 Where to Go from Here
17 Credits
1701 About the Author
sku |
|
