Lynda - MySQL Essential Training (2014)

seeders: 38
leechers: 17
Added on May 20, 2014 by Zilch01in Other > Tutorials
Torrent verified.



Lynda - MySQL Essential Training (2014) (Size: 623.63 MB)
 02_04-Setting up MySQL users.mp434.83 MB
 02_06-Installing SID on the Mac.mp422.04 MB
 02_07-Installing time zone support in MySQL on Windows.mp420.73 MB
 02_03-Installing XAMPP on the Mac.mp419.62 MB
 02_05-Installing SID on Windows.mp418 MB
 02_02-Installing XAMPP on Windows.mp416.67 MB
 02_01-Installation overview.mp45.41 MB
 03_07-Filtering results with regular expressions.mp417.46 MB
 03_02-Selecting rows.mp410.97 MB
 03_04-Sorting results with ORDER BY.mp410.58 MB
 03_05-Filtering results with WHERE.mp410.16 MB
 03_06-Filtering results with LIKE and IN.mp48.3 MB
 03_03-Selecting columns.mp46.77 MB
 03_08-Inserting rows.mp46.33 MB
 03_01-The SELECT statement.mp44.89 MB
 03_11-Literal strings.mp44.63 MB
 03_12-Understanding NULL.mp44.1 MB
 04_06-Using foreign key constraints.mp421.72 MB
 04_05-Creating an ID column.mp418.76 MB
 04_03-Creating indexes.mp414.35 MB
 04_02-Creating a table.mp412.5 MB
 04_01-Creating a database.mp410.12 MB
 04_04-Controlling column behavior with constraints.mp49.67 MB
 04_07-Altering a table.mp47.08 MB
 05_04-Date and time types.mp413.58 MB
 05_07-Enumeration types.mp49.59 MB
 05_02-Numeric types.mp49.06 MB
 05_01-What are data types.mp46.37 MB
 05_03-String types.mp44.59 MB
 05_06-Boolean values.mp44.27 MB
 05_05-Bit type.mp43.79 MB
 06_01-String functions.mp419.66 MB
 06_04-Time zones in MySQL.mp414.38 MB
 06_06-Aggregate functions.mp412.11 MB
 06_02-Numeric functions.mp48.99 MB
 06_03-Date and time functions.mp46.35 MB
 06_07-Flow control with CASE.mp46.2 MB
 06_05-Formatting dates.mp43.52 MB
 07_01-Maintaining database integrity with transactions.mp49.91 MB
 07_02-Using transactions for performance.mp43.96 MB
 08_02-Preventing automatic updates with a trigger.mp419.03 MB
 08_03-Logging transactions with a trigger.mp412.52 MB
 08_01-Updating a table with a trigger.mp412.18 MB
 09_03-Creating a view.mp410.87 MB
 09_04-Creating a joined view.mp410.68 MB
 09_02-Searching within a result set.mp48.31 MB
 09_01-Creating a simple subselect.mp47.05 MB
 10_03-Creating a stored procedure.mp413.17 MB
 10_02-Creating a stored function.mp412.15 MB
 10_01-Understanding MySQL stored routines.mp43.31 MB
 11_01-The multi-platform PDO interface.mp412.39 MB
 11_04-Using a stored funciton.mp411.25 MB
 11_02-Executing the SQL.mp49.74 MB
 11_03-Implementing auto-increment IDs.mp44.89 MB
 12_01-goodbye.mp41.83 MB
 Ex_Files_MySQL_EssT.zip126.94 KB
 01_01-Welcome.mp49.38 MB
 01_03-What is MySQL.mp42.72 MB
 01_02-Using the exercise files.mp42.27 MB


Description

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.
Topics include:

Writing queries
Creating and updating databases and tables
Using MySQL built-in functions
Sorting and filtering data
Updating tables with triggers
Working with subselects and views
Creating and using a stored function

Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
623.63 MB
seeders:38
leechers:17
Lynda - MySQL Essential Training (2014)

All Comments

thanks :)