2014
Lynda
Bill Weinman
4:24
English
MySQL is by far the most popular database management system for small- to medium-sized web projects. In this course, Bill Weinman provides clear, concise tutorials that guide you through creating and maintaining a MySQL database of your own. Bill explores the basic syntax, using SQL statements to create, insert, update, and delete data from your tables. He also covers creating a new database from scratch, as well as data types, transactions, subselects, views, and stored routines. Plus, learn about the multi-platform PHP PDO interface that will help you connect your database to web applications.
Introduction
Welcome
Using the exercise files
What is MySQL?
1. Installing and Configuring the Test Environment
Installation overview
Installing XAMPP on Windows
Installing XAMPP on the Mac
Setting up MySQL users
Installing SID on Windows
Installing SID on the Mac
Installing time zone support in MySQL on Windows
2. Basic Syntax
The SELECT statement
Selecting rows
Selecting columns
Sorting results with ORDER BY
Filtering results with WHERE
Filtering results with LIKE and IN
Filtering results with regular expressions
Inserting rows
Updating rows
Deleting rows
Literal strings
Understanding NULL
3. Creating a Database
Creating a database
Creating a table
Creating indexes
Controlling column behavior with constraints
Creating an ID column
Using foreign key constraints
Altering a table
4. MySQL Data Types
What are data types?
Numeric types
String types
Date and time types
Bit type
Boolean values
Enumeration types
5. MySQL Functions
String functions
Numeric functions
Date and time functions
Time zones in MySQL
Formatting dates
Aggregate functions
Flow control with CASE
6. Transactions
Maintaining database integrity with transactions
Using transactions for performance
7. Triggers
Updating a table with a trigger
Preventing automatic updates with a trigger
Logging transactions with a trigger
8. Subselects and Views
Creating a simple subselect
Searching within a result set
Creating a view
Creating a joined view
9. Stored Routines
Understanding MySQL stored routines
Creating a stored function
Creating a stored procedure
10. PHP's PDO Interface with MySQL
The multi-platform PDO interface
Executing the SQL
Implementing auto-increment IDs
Using a stored funciton
Conclusion
Goodbye
Download File Size:590.11 MB