
MySQL 5 Development (Part 1)
by David Swain
Start the free chapterAs 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!
Course content
Introduction7 lessons
Database Basics6 lessons
Installation6 lessons
Configuration4 lessons
Client Programs9 lessons
- Command Line Operations5:481 credit or ad
- Using a Command Line Client4:051 credit or ad
- Command Line Client Help File6:061 credit or ad
- MySQL Client Batch Mode6:271 credit or ad
- MySQL Client Interactive Mode pt. 16:011 credit or ad
- MySQL Client Interactive Mode pt. 24:321 credit or ad
- MySQL Client Interactive Mode pt. 36:021 credit or ad
- Executing Scripts6:491 credit or ad
- Exploring Databases and Tables7:111 credit or ad
SELECT Statement Basics6 lessons
Variables6 lessons
Calculations and Expressions15 lessons
- New Values From Old2:351 credit or ad
- Operators and Operands3:451 credit or ad
- Arithmetic Operators3:391 credit or ad
- String Operators5:121 credit or ad
- Comparison Operators5:281 credit or ad
- Logical Operators6:221 credit or ad
- Order of Precedence2:591 credit or ad
- Functions and Parameters3:281 credit or ad
- Useful Numeric Functions6:311 credit or ad
- Useful Character String Functions7:101 credit or ad
- Temporal Operations5:331 credit or ad
- Useful Temporal Functions5:091 credit or ad
- Decision-Making Functions7:271 credit or ad
- NULL-Related Functions4:521 credit or ad
- Useful System Functions2:411 credit or ad
Querying SQL Data13 lessons
- Using a Database5:021 credit or ad
- Selecting FROM a Table4:591 credit or ad
- Targeting Rows Using WHERE5:081 credit or ad
- Complex WHERE Criteria6:591 credit or ad
- Sorting Results Using ORDER BY5:561 credit or ad
- Going to Extremes Using LIMIT3:381 credit or ad
- Avoiding Duplicates Using DISTINCT3:541 credit or ad
- Aggregation Queries4:521 credit or ad
- Subtotals Using GROUP BY6:101 credit or ad
- Filter Derived Columns with HAVING2:431 credit or ad
- Multilevel Sums Using WITH ROLLUP5:171 credit or ad
- Summarizing SELECT Clauses6:441 credit or ad
- Some Clauses Cannot Coexist3:071 credit or ad
Databases and Tables12 lessons
- Databases in MySQL4:421 credit or ad
- Creating a Database6:571 credit or ad
- Aspects of a Table2:471 credit or ad
- Creating a Table5:121 credit or ad
- Table Options5:081 credit or ad
- Column Options6:351 credit or ad
- Auto-Incrementation5:291 credit or ad
- Altering a Table4:541 credit or ad
- Adding and Dropping Columns3:431 credit or ad
- Altering a Column6:091 credit or ad
- Dropping a Table4:271 credit or ad
- Dropping a Database4:261 credit or ad
Data Type Details15 lessons
- Data Type Categories2:231 credit or ad
- Integer Numbers7:001 credit or ad
- Floating Point Numbers7:361 credit or ad
- Fixed Decimal Numbers4:491 credit or ad
- BIT Data Type7:241 credit or ad
- Strings3:131 credit or ad
- Basic Character Strings5:451 credit or ad
- ENUM Character Strings6:351 credit or ad
- SET Character Strings6:081 credit or ad
- Character Sets6:541 credit or ad
- Collations6:511 credit or ad
- Fonts and Keystroke Mapping7:001 credit or ad
- Binary Strings5:211 credit or ad
- Temporal Data5:431 credit or ad
- Timestamp and Time Types6:161 credit or ad
Storage Engines11 lessons
- Storage Engine Basics6:291 credit or ad
- Discovering Storage Engines4:341 credit or ad
- MyISAM6:201 credit or ad
- InnoDB6:361 credit or ad
- Memory5:311 credit or ad
- Example1:541 credit or ad
- CSV3:531 credit or ad
- Archive2:381 credit or ad
- Federated4:411 credit or ad
- Blackhole2:271 credit or ad
- Third Party Engines2:271 credit or ad