VTC - MySQL 5 Development - Part 2 of 2

seeders: 14
leechers: 5
Download torrent
Added on June 10, 2013 by qKoFZGin Other > Tutorials
Torrent verified.


VTC - MySQL 5 Development - Part 2 of 2 (Size: 1.7 GB)
 00.01. Welcome.flv10.3 MB
 00.02. What the Course Will Cover.flv8.53 MB
 00.03. System Requirements.flv6.14 MB
 00.04. Brief Review of Part 1.flv3.99 MB
 01.01. Startup Options.flv15.77 MB
 01.02. Configuration File.flv12.14 MB
 01.03. Important Configuration Options.flv11.78 MB
 02.01. Data Manipulation Basics.flv4.88 MB
 02.02. Warnings and Errors.flv12.94 MB
 02.03. SQL Modes.flv10.99 MB
 02.04. Changing Syntax Interpretation.flv8.99 MB
 02.05. Elevating Warnings to Errors.flv11.27 MB
 02.06. Interpreting Error Messages.flv9.56 MB
 02.07. Note Warnings.flv6.25 MB
 02.08. System Error Warnings.flv8.25 MB
 03.01. Inserting Data.flv9.71 MB
 03.02. Inserting Data (Archaic Syntax).flv6.12 MB
 03.03. INSERT demonstration.flv14.29 MB
 03.04. Default Values on Insert.flv8.9 MB
 03.05. AUTO_INCREMENT on insert.flv8.82 MB
 03.06. AUTO_INCREMENT issues.flv13.48 MB
 03.07. LAST_INSERT_ID function.flv12.02 MB
 03.08. Common INSERT Errors.flv9.54 MB
 04.01. Deleting data.flv9.14 MB
 04.02. DELETE with WHERE.flv10.21 MB
 04.03. DELETE with LIMIT.flv13.59 MB
 04.04. DELETE with ORDER BY.flv9.74 MB
 04.05. DELETE result messages.flv3.99 MB
 05.01. Updating Data.flv12.24 MB
 05.02. UPDATE with WHERE.flv8.71 MB
 05.03. UPDATE with LIMIT.flv11.49 MB
 05.03. UPDATE with ORDERY BY.flv6.08 MB
 05.04. UPDATE result messages.flv7.59 MB
 06.01. Replacing Command.flv7.92 MB
 06.02. REPLACE demonstration.flv9.63 MB
 06.03. ON DUPLICATE KEY UPDATE Option of INSERT.flv9.02 MB
 06.04. ON DUPLICATE KEY UPDATE demonstration.flv8.68 MB
 06.05. TRUNCATE TABLE Command.flv6.06 MB
 06.06. TRUNCATE TABLE Demonstration.flv11.48 MB
 06.07. Safe Updates Mode.flv13.59 MB
 07.01. Importing Data.flv11.37 MB
 07.02. Basic Import Demonstrations.flv11.34 MB
 07.03. Importing Non-Tab Formats.flv13.47 MB
 07.04. Skipping Header Lines on Import.flv5.92 MB
 07.05. Changing Import Column Order.flv11.95 MB
 07.06. Converting Data On Import pt.1.flv8.44 MB
 07.07. Converting Data On Import pt.2.flv7.62 MB
 07.08. Importing on the Shell Command Line.flv19.41 MB
 08.01. New Tables From Existing Tables.flv11.28 MB
 08.02. CREATE TABLE Using SELECT.flv11.89 MB
 08.03. Including Other Features.flv12.72 MB
 08.04. CREATE TABLE Using LIKE.flv6.83 MB
 08.05. Populating Derived Tables.flv4.4 MB
 08.06. Temporary Tables.flv12.43 MB
 08.07. Altering Derived Tables.flv7.8 MB
 09.01. Addressing Multiple Tables.flv13.41 MB
 09.02. Column Name Conflicts.flv5.11 MB
 09.03. Resolving Column Name Conflicts.flv6.37 MB
 09.04. Table Name Conflicts.flv7.36 MB
 09.05. Resolving Table Name Conflicts.flv10.2 MB
 10.01. Subquery Basics.flv10.45 MB
 10.02. Shape of The Result.flv12.41 MB
 10.03. Guaranteeing a Single Row Result.flv9.03 MB
 10.04. Scalar Subqueries.flv5.58 MB
 10.05. Table Subqueries.flv7.24 MB
 10.06. Columnar Subqueries.flv7.11 MB
 10.07. Row Subqueries.flv4.22 MB
 10.08. EXISTS Subqueries pt.1.flv3.37 MB
 10.09. EXISTS Subqueries pt.2.flv4.92 MB
 10.10. Correlated vs Non-Correlated Subqueries.flv7.09 MB
 11.01. The FROM Clause.flv6.41 MB
 11.02. Join Basics pt.1.flv13.02 MB
 11.03. Join Basics pt.2.flv10.55 MB
 11.04. Inner Join Syntax.flv11.24 MB
 11.05. Basic Inner Join Demos.flv9.94 MB
 11.06. Inner Join Aggregation.flv9.46 MB
 11.07. The ON Clause.flv7.86 MB
 11.08. The USING() function.flv8.24 MB
 11.09. Natural Joins.flv6.72 MB
 11.10. Outer Joins.flv7.37 MB
 12.01. What a View Is.flv7.75 MB
 12.02. Uses of Views.flv8.38 MB
 12.03. Basic Syntax of a View.flv8.87 MB
 12.04. View Column Names.flv9.37 MB
 12.05. Updatabale Views.flv7.91 MB
 12.06. Insertable Views.flv7.4 MB
 12.07. View Consistency.flv4.52 MB
 12.08. View Viability.flv5.2 MB
 12.09. Altering or Dropping Views.flv6.83 MB
 12.10. View Metadata.flv13.27 MB
 13.01. Multiple Table INSERT.flv11.23 MB
 13.02. Multiple Table UPDATE.flv9.27 MB
 13.03. Multiple Table DELETE.flv9.9 MB
 13.04. Advantages and Limitations to Multi-Table UPDATEs and DELETEs.flv12.42 MB
 14.12. Row Locking Demos.flv16.48 MB
 14.01. Transaction Basics.flv11.62 MB
 14.02. Transactions in MySQL.flv8.15 MB
 14.03. AUTOCOMMIT Mode.flv11.45 MB
 14.04. Transaction Commands.flv10.97 MB
 14.05. Savepoints.flv9.77 MB
 14.06. Isolation.flv10.55 MB
 14.07. Isolation Levels.flv12.94 MB
 14.08. Transaction Demos.flv10.79 MB
 14.09. Locking.flv11.29 MB
 15.01. Procedures and Functions.flv9.12 MB
 15.02. Why Use Stored Routines.flv12.57 MB
 15.03. Basic CREATE FUNCTION syntax.flv8.82 MB
 15.04. Invoking a Function.flv6.61 MB
 15.05. Basic CREATE PROCEDURE syntax.flv5.42 MB
 15.06. Invoking a Procedure.flv5.87 MB
 15.07. Database Association.flv7.43 MB
 15.08. Stored Routine Metadata.flv13.52 MB
 15.09. Where They Are Stored.flv11.21 MB
 15.10. Dropping Stored Routines.flv7 MB
 16.01. Compound Statements.flv11.22 MB
 16.02. Compound statements Demos.flv7.44 MB
 16.03. Procedure Parameter Types.flv10.28 MB
 16.04. IN Parameters.flv9.13 MB
 16.05. INOUT Parameters.flv5.71 MB
 16.06. OUT Parameters.flv6.76 MB
 16.07. Declaring Local variables.flv7.44 MB
 16.08. Assigning Values to Variables.flv8.28 MB
 16.09. Variable scope.flv11 MB
 16.10. Conditional Blocks.flv11.16 MB
 17.01. Trigger Basics.flv9.3 MB
 17.02. Uses for Triggers.flv9.99 MB
 17.03. Trigger Syntax.flv10.35 MB
 17.04. Trigger Examples.flv10.81 MB
 17.05. Exploring Triggers.flv10.78 MB
 17.06. Tigger Metadata.flv13.14 MB
 17.07. Dropping Triggers.flv13.47 MB
 17.08. User Accounts for Triggers.flv7.32 MB
 17.09. Trigger Limitations.flv13.93 MB
 18.01. Event Basics.flv11.83 MB
 18.02. Event Execution.flv11.57 MB
 18.03. Event Syntax.flv11.1 MB
 18.04. Schedule Types.flv10.87 MB
 18.05. User Accounts for Events.flv10.65 MB
 18.06. Event Metadata.flv13.26 MB
 18.07. Event Limitations.flv8.82 MB
 19.01. Index Basics.flv10.95 MB
 19.02. Defining Indexes for a Table.flv9.3 MB
 19.04. Dropping Indexes from a Table.flv3.89 MB
 19.05. Compound Indexes.flv5.49 MB
 19.06. Prefix Length Indexes.flv5.62 MB
 19.07. Covering Indexes.flv4.9 MB
 19.08. FULLTEXT Indexes pt.1.flv13.08 MB
 19.09. FULLTEXT Indexes pt.2.flv8.12 MB
 20.02. PROCEDURE ANALYSE function.flv21.95 MB
 20.01. Efficiency Checks.flv7.46 MB
 20.03. EXPLAIN command pt.1.flv9.17 MB
 20.04. EXPLAIN command pt.2.flv6.85 MB
 20.05. EXPLAIN command pt.3.flv7.63 MB
 21.01. What We Covered.flv7.24 MB
 21.02. Where To Go From Here.flv5.25 MB
 22.01. About This Author.flv10.38 MB
 mysql5dev2.zip26.74 KB
 VTC - MySQL 5 Development - Part 2.nfo7.18 KB

Description

VTC - MySQL 5 Development - Part 2 of 2

Information

Course:MySQL 5 Development (Part 2)
Author:David Swain
SKU:34278
ISBN:978-1-61866-021-3
Release Date:2011-11-22
Duration:17.5 hrs / 184 tutorials
Subject: Databases


Description

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.


Table of Contents

Introduction
* Welcome (05:44)
* What the Course Will Cover (04:47)
* System Requirements (03:20)
* Brief Review of Part 1 (02:15)

Configuration
* Startup Options (06:02)
* Configuration File (05:30)
* Important Configuration Options (06:00)

Manipulating Data
* Data Manipulation Basics (03:16)
* Warnings and Errors (07:39)
* SQL Modes (06:40)
* Changing Syntax Interpretation (06:56)
* Elevating Warnings to Errors (07:02)
* Interpreting Error Messages (05:45)
* Note Warnings (04:23)
* System Error Warnings (05:24)

Inserting Data
* Inserting Data (06:19)
* Inserting Data Archaic Syntax (04:29)
* INSERT Demonstrations (07:39)
* Default Values on Insert (05:01)
* AUTO_INCREMENT on Insert (05:13)
* AUTO_INCREMENT Issues (06:06)
* LAST_INSERT_ID Function (07:04)
* Common INSERT Errors (04:47)

Deleting Data
* Deleting Data (06:08)
* DELETE with WHERE (06:25)
* DELETE with LIMIT (06:43)
* DELETE with ORDER BY (04:01)
* DELETE Result Messages (03:03)

Updating Data
* Updating Data (07:48)
* UPDATE with WHERE (05:02)
* UPDATE with LIMIT (07:09)
* UPDATE with ORDER BY (03:36)
* UPDATE Result Messages (05:25)

Other MySQL DML Commands
* REPLACE Command (05:02)
* REPLACE Demo (05:54)
* ON DUPLICATE KEY UPDATE Option (05:15)
* ON DUPLICATE KEY UPDATE Demo (05:22)
* TRUNCATE Command (03:48)
* TRUNCATE Demonstration (05:56)
* Safe Updates Mode (07:14)

Importing Data
* Importing Data (07:29)
* Basic Import Demonstrations (06:35)
* Importing Non-Tab Formats (06:58)
* Skipping Header Lines on Import (04:13)
* Changing Import Column Order (07:14)
* Converting Data on Import pt. 1 (04:35)
* Converting Data on Import pt. 2 (04:47)
* Importing on the Shell Command Line (06:33)

Deriving New Tables
* New Tables from Existing Tables (06:40)
* CREATE TABLE Using SELECT (06:09)
* Including Other Features (06:41)
* CREATE TABLE Using LIKE (04:12)
* Populating Derived Tables (03:24)
* Temporary Tables (06:48)
* Altering Derived Tables (05:54)

Multi-Table Queries
* Addressing Multiple Tables (08:04)
* Column Name Conflicts (04:35)
* Resolving Column Name Conflicts (04:13)
* Table Name Conflicts (05:03)
* Resolving Table Name Conflicts (06:31)

Subqueries
* Subquery Basics (06:16)
* Shape of the Result (07:49)
* Guaranteeing a Single Row (05:25)
* Scalar Subqueries (04:01)
* Table Subqueries (04:14)
* Columnar Subqueries (05:40)
* Row Subqueries (03:40)
* EXISTS Subqueries pt. 1 (03:24)
* EXISTS Subqueries pt. 2 (03:51)
* Correlated vs Non-Correlated (04:35)
* Nesting to Multiple Levels (02:57)
* Building Queries in Layers (05:03)
* Addressing the Same Table Twice (05:18)
* When to Use Subqueries (04:12)

Joins
* The FROM Clause (03:38)
* Join Basics pt. 1 (07:55)
* Join Basics pt. 2 (06:11)
* Inner Join Syntax (07:03)
* Basic Inner Join Demos (05:59)
* Inner Join Aggregation (06:02)
* The ON Clause (05:09)
* The USING Option (05:51)
* Natural Joins (03:51)
* Outer Joins (04:51)
* Join Criteria Options (04:12)
* Multiple Table Joins (06:24)
* Self Joins (07:02)
* Problems Joins Cannot Solve (03:59)

Views
* What a View Is (04:13)
* Uses of Views (04:52)
* Basic Syntax of a View (06:05)
* View Column Names (05:41)
* Updatable Views (05:23)
* Insertable Views (05:22)
* View Consistency (03:19)
* View Viability (03:07)
* Altering or Dropping a View (05:08)
* View Metadata (07:46)

Multiple Table DML Operations
* Multiple Table INSERT (06:52)
* Multiple Table UPDATE (05:52)
* Multiple Table DELETE (05:48)
* Advantages and Limitations (06:40)

Transactions and Locking
* Transaction Basics (07:05)
* Transactions in MySQL (04:23)
* AUTOCOMMIT Mode (06:50)
* Transaction Commands (07:28)
* Savepoints (05:08)
* Isolation (06:41)
* Isolation Levels (08:06)
* Transaction Demos (05:43)
* Locking Basics (06:45)
* Locking in MySQL (06:26)
* Explicit Row Locking with InnoDB (07:20)
* Row Locking Demos (07:12)
* Explicit Table Locking (08:29)
* Table Locking Demos (06:08)
* Deadlock Resolution (04:51)
* Implicit Commits (07:11)

Stored Routine Basics
* Procedures and Functions (05:53)
* Why Use Stored Routines (07:27)
* Basic Create Function Syntax (06:40)
* Invoking a Function (04:23)
* Basic Create Procedure Syntax (04:50)
* Invoking a Procedure (04:09)
* Database Association (05:02)
* Stored Routine Metadata (07:47)
* Where They Are Stored (06:07)
* Dropping Stored Routines (05:28)

Stored Routine Programming
* Compound Statements (06:55)
* Compound Statement Demos (05:09)
* Procedure Parameter Types (06:08)
* IN Parameters (04:47)
* INOUT Parameters (04:29)
* OUT Parameters (06:48)
* Declaring Local Variables (04:38)
* Assigning Values to Variables (05:45)
* Variable Scope (07:05)
* Conditional Blocks (06:38)
* IF Block Demos (06:07)
* CASE Block Demos (06:54)
* Iterative Blocks (06:19)
* LOOP Block Demos (05:36)
* REPEAT Block Demos (07:15)
* WHILE Block Demos (03:47)
* The LEAVE Statement (06:41)
* The ITERATE Statement (08:03)
* More We Can DECLARE (07:48)
* Declaring Conditions (02:45)
* Declaring Error Handlers (06:08)
* Declaring Cursors (07:20)
* Limitations on Cursors (08:05)

Triggers
* Trigger Basics (05:31)
* Uses for Triggers (06:15)
* Trigger Syntax (06:01)
* Trigger Examples (06:39)
* Exploring Triggers (05:45)
* Trigger Metadata (06:02)
* Dropping Triggers (06:26)
* User Accounts for Triggers (04:35)
* Trigger Limitations (07:31)

Events
* Event Basics (07:01)
* Event Execution (06:26)
* Event Syntax (06:12)
* Schedule Types (07:32)
* User Accounts for Events (05:54)
* Event Metadata (06:48)
* Event Limitations (04:49)

Indexes
* Index Basics (06:36)
* Defining Indexes for a Table (05:44)
* Adding Indexes to a Table (05:59)
* Dropping Indexes from a Table (03:35)
* Compound Indexes (03:38)
* Prefix Length Indexes (04:17)
* Covering Indexes (04:03)
* FULLTEXT Indexes pt. 1 (06:15)
* FULLTEXT Indexes pt. 2 (05:01)

Efficiency Checks
* Efficiency Checks (04:42)
* PROCEDURE ANALYSE function (06:52)
* EXPLAIN Command pt. 1 (06:14)
* EXPLAIN Command pt. 2 (04:37)
* EXPLAIN Command pt. 3 (05:08)

Conclusion
* What We Covered (03:54)
* Where to Go from Here (03:14)

Credits
* About the Author (06:58)

Part 1 here Torrent: VTC - MySQL 5 Development - Part 1 of 2

Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
1.7 GB
seeders:14
leechers:5
VTC - MySQL 5 Development - Part 2 of 2

All Comments

sadokbe
Thanks
Danova
no its not, only slow..