MySQL 5 development (part 2) [electronic resource] / David Swain
Material type:
FilmPublication details: Virtual Training CoDescription: 1 streaming video file (17 hr., 28 min., 7 sec.) : digital, sd., col. ; 12 cm. + 1 CD VTC playerISBN: - MED0000013(Local)
| Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
|---|---|---|---|---|---|---|---|
CD and DVD
|
UMPLIB PEKAN | cd QA76.73.S67 S935 2011 (Browse shelf(Opens below)) | 1 | Not for loan | 0000096702 | ||
Accompanying Material
|
UMPLIB PEKAN | CD 10050 | cd QA76.73.S67 S935 2011 (Browse shelf(Opens below)) | 1 | Available | 0000096703 |
Title from screen
Date of publication taken from resource description page
This MySQL 5 Development Part 2 course continues the introduction to MySQL we began with Part 1. But in Part 2, we now begin working with commands that are used to change the contents of the tables in our database. We also explore various ways of building more complex queries, including command options that allow us to address more than one table in a single command. While this is still an introductory course, we are now exploring tools that let us handle more complex operations and build more sophistication into our MySQL database systems. The topics we cover in Part 2 include inserting/updating/deleting data, subqueries, joins, transactions, table and row locking, stored procedures and functions, triggers and events, indexes, and more. We have tried to keep the examples in the lessons as simple as possible to illustrate them most effectively, but the further study exercises are more realistic as to how these tools are used in practice. To begin learning today, simply click on the movie links.