VTC MySQL 5 Development Part 2 of 2.torrent
2013.06.16 17:30
VTC MySQL 5 Development Part 2 of 2.torrent
VTC MySQL 5 Development Part 2 of 2.torrent
Torrent Contents
| VTC - MySQL 5 Development - Part 2 | |
| 20. Efficiency Checks | |
| 20.02. PROCEDURE ANALYSE function.flv | 21 MB |
| 20.01. Efficiency Checks.flv | 7 MB |
| 20.03. EXPLAIN command pt.1.flv | 9 MB |
| 20.04. EXPLAIN command pt.2.flv | 6 MB |
| 20.05. EXPLAIN command pt.3.flv | 7 MB |
| 00. Introduction | |
| 00.01. Welcome.flv | 10 MB |
| 00.02. What the Course Will Cover.flv | 8 MB |
| 00.03. System Requirements.flv | 6 MB |
| 00.04. Brief Review of Part 1.flv | 3 MB |
| 01. Configuration | |
| 01.01. Startup Options.flv | 15 MB |
| 01.02. Configuration File.flv | 12 MB |
| 01.03. Important Configuration Options.flv | 11 MB |
| 02. Manipulating Data | |
| 02.01. Data Manipulation Basics.flv | 4 MB |
| 02.02. Warnings and Errors.flv | 12 MB |
| 02.03. SQL Modes.flv | 10 MB |
| 02.04. Changing Syntax Interpretation.flv | 8 MB |
| 02.05. Elevating Warnings to Errors.flv | 11 MB |
| 02.06. Interpreting Error Messages.flv | 9 MB |
| 02.07. Note Warnings.flv | 6 MB |
| 02.08. System Error Warnings.flv | 8 MB |
| 03. Inserting Data | |
| 03.01. Inserting Data.flv | 9 MB |
| 03.02. Inserting Data (Archaic Syntax).flv | 6 MB |
| 03.03. INSERT demonstration.flv | 14 MB |
| 03.04. Default Values on Insert.flv | 8 MB |
| 03.05. AUTO_INCREMENT on insert.flv | 8 MB |
| 03.06. AUTO_INCREMENT issues.flv | 13 MB |
| 03.07. LAST_INSERT_ID function.flv | 12 MB |
| 03.08. Common INSERT Errors.flv | 9 MB |
| 04. Deleting Data | |
| 04.01. Deleting data.flv | 9 MB |
| 04.02. DELETE with WHERE.flv | 10 MB |
| 04.03. DELETE with LIMIT.flv | 13 MB |
| 04.04. DELETE with ORDER BY.flv | 9 MB |
| 04.05. DELETE result messages.flv | 3 MB |
| 05. Updating Data | |
| 05.01. Updating Data.flv | 12 MB |
| 05.02. UPDATE with WHERE.flv | 8 MB |
| 05.03. UPDATE with LIMIT.flv | 11 MB |
| 05.03. UPDATE with ORDERY BY.flv | 6 MB |
| 05.04. UPDATE result messages.flv | 7 MB |
| 06. Other MySQL DML Commands | |
| 06.01. Replacing Command.flv | 7 MB |
| 06.02. REPLACE demonstration.flv | 9 MB |
| 06.03. ON DUPLICATE KEY UPDATE Option of INSERT.flv | 9 MB |
| 06.04. ON DUPLICATE KEY UPDATE demonstration.flv | 8 MB |
| 06.05. TRUNCATE TABLE Command.flv | 6 MB |
| 06.06. TRUNCATE TABLE Demonstration.flv | 11 MB |
| 06.07. Safe Updates Mode.flv | 13 MB |
| 07. Importing Data | |
| 07.01. Importing Data.flv | 11 MB |
| 07.02. Basic Import Demonstrations.flv | 11 MB |
| 07.03. Importing Non-Tab Formats.flv | 13 MB |
| 07.04. Skipping Header Lines on Import.flv | 5 MB |
| 07.05. Changing Import Column Order.flv | 11 MB |
| 07.06. Converting Data On Import pt.1.flv | 8 MB |
| 07.07. Converting Data On Import pt.2.flv | 7 MB |
| 07.08. Importing on the Shell Command Line.flv | 19 MB |
| 08. Deriving New Tables | |
| 08.01. New Tables From Existing Tables.flv | 11 MB |
| 08.02. CREATE TABLE Using SELECT.flv | 11 MB |
| 08.03. Including Other Features.flv | 12 MB |
| 08.04. CREATE TABLE Using LIKE.flv | 6 MB |
| 08.05. Populating Derived Tables.flv | 4 MB |
| 08.06. Temporary Tables.flv | 12 MB |
| 08.07. Altering Derived Tables.flv | 7 MB |
| 09. Multi-Table Queries | |
| 09.01. Addressing Multiple Tables.flv | 13 MB |
| 09.02. Column Name Conflicts.flv | 5 MB |
| 09.03. Resolving Column Name Conflicts.flv | 6 MB |
| 09.04. Table Name Conflicts.flv | 7 MB |
| 09.05. Resolving Table Name Conflicts.flv | 10 MB |
| 10. Subqueries | |
| 10.01. Subquery Basics.flv | 10 MB |
| 10.02. Shape of The Result.flv | 12 MB |
| 10.03. Guaranteeing a Single Row Result.flv | 9 MB |
| 10.04. Scalar Subqueries.flv | 5 MB |
| 10.05. Table Subqueries.flv | 7 MB |
| 10.06. Columnar Subqueries.flv | 7 MB |
| 10.07. Row Subqueries.flv | 4 MB |
| 10.08. EXISTS Subqueries pt.1.flv | 3 MB |
| 10.09. EXISTS Subqueries pt.2.flv | 4 MB |
| 10.10. Correlated vs Non-Correlated Subqueries.flv | 7 MB |
| 10.11. Nesting Multiple Levels.flv | 5 MB |
| 10.12. Building Queries In Layers.flv | 6 MB |
| 10.13. Addressing The Same Table Twice.flv | 2 MB |
| 10.14. When to Use Subqueries.flv | 6 MB |
| 11. Joins | |
| 11.01. The FROM Clause.flv | 6 MB |
| 11.02. Join Basics pt.1.flv | 13 MB |
| 11.03. Join Basics pt.2.flv | 10 MB |
| 11.04. Inner Join Syntax.flv | 11 MB |
| 11.05. Basic Inner Join Demos.flv | 9 MB |
| 11.06. Inner Join Aggregation.flv | 9 MB |
| 11.07. The ON Clause.flv | 7 MB |
| 11.08. The USING() function.flv | 8 MB |
| 11.09. Natural Joins.flv | 6 MB |
| 11.10. Outer Joins.flv | 7 MB |
| 11.11. Join Criteria Options.flv | 6 MB |
| 11.12. Multiple Table Joins.flv | 10 MB |
| 11.13. Self Joins.flv | 9 MB |
| 11.14. Problems Joins Cannot Solve.flv | 5 MB |
| 14. Transactions and Locking | |
| 14.12. Row Locking Demos.flv | 16 MB |
| 14.01. Transaction Basics.flv | 11 MB |
| 14.02. Transactions in MySQL.flv | 8 MB |
| 14.03. AUTOCOMMIT Mode.flv | 11 MB |
| 14.04. Transaction Commands.flv | 10 MB |
| 14.05. Savepoints.flv | 9 MB |
| 14.06. Isolation.flv | 10 MB |
| 14.07. Isolation Levels.flv | 12 MB |
| 14.08. Transaction Demos.flv | 10 MB |
| 14.09. Locking.flv | 11 MB |
| 14.10. Locking in MySQL.flv | 12 MB |
| 14.11. Explicit Row Locking with InnoDB.flv | 11 MB |
| 14.13. Explicit Table Locking.flv | 15 MB |
| 14.14. Table Locking Demos.flv | 10 MB |
| 14.15. Deadlock Resolution.flv | 8 MB |
| 14.16. Implicit Commits.flv | 10 MB |
| 12. Views | |
| 12.01. What a View Is.flv | 7 MB |
| 12.02. Uses of Views.flv | 8 MB |
| 12.03. Basic Syntax of a View.flv | 8 MB |
| 12.04. View Column Names.flv | 9 MB |
| 12.05. Updatabale Views.flv | 7 MB |
| 12.06. Insertable Views.flv | 7 MB |
| 12.07. View Consistency.flv | 4 MB |
| 12.08. View Viability.flv | 5 MB |
| 12.09. Altering or Dropping Views.flv | 6 MB |
| 12.10. View Metadata.flv | 13 MB |
| 13. Multiple Table DML Operations | |
| 13.01. Multiple Table INSERT.flv | 11 MB |
| 13.02. Multiple Table UPDATE.flv | 9 MB |
| 13.03. Multiple Table DELETE.flv | 9 MB |
| 13.04. Advantages and Limitations to Multi-Table UPDATEs and DELETEs.flv | 12 MB |
| 15. Stored Routine Basics | |
| 15.01. Procedures and Functions.flv | 9 MB |
| 15.02. Why Use Stored Routines.flv | 12 MB |
| 15.03. Basic CREATE FUNCTION syntax.flv | 8 MB |
| 15.04. Invoking a Function.flv | 6 MB |
| 15.05. Basic CREATE PROCEDURE syntax.flv | 5 MB |
| 15.06. Invoking a Procedure.flv | 5 MB |
| 15.07. Database Association.flv | 7 MB |
| 15.08. Stored Routine Metadata.flv | 13 MB |
| 15.09. Where They Are Stored.flv | 11 MB |
| 15.10. Dropping Stored Routines.flv | 7 MB |
| 16. Stored Routing Programming | |
| 16.01. Compound Statements.flv | 11 MB |
| 16.02. Compound statements Demos.flv | 7 MB |
| 16.03. Procedure Parameter Types.flv | 10 MB |
| 16.04. IN Parameters.flv | 9 MB |
| 16.05. INOUT Parameters.flv | 5 MB |
| 16.06. OUT Parameters.flv | 6 MB |
| 16.07. Declaring Local variables.flv | 7 MB |
| 16.08. Assigning Values to Variables.flv | 8 MB |
| 16.09. Variable scope.flv | 11 MB |
| 16.10. Conditional Blocks.flv | 11 MB |
| 16.11. IF Block Demos.flv | 10 MB |
| 16.12. CASE Block Demos.flv | 12 MB |
| 16.13. Iterative Blocks.flv | 10 MB |
| 16.14. LOOP Block Demos.flv | 9 MB |
| 16.15. REPEAT Block Demos.flv | 13 MB |
| 16.16. While Block Demos.flv | 5 MB |
| 16.17. The LEAVE statement.flv | 11 MB |
| 16.18. The ITERATE Statement.flv | 14 MB |
| 16.19. More We Can DECLARE.flv | 13 MB |
| 16.20. Declaring Conditions.flv | 3 MB |
| 16.21. Declaring Error Handlers.flv | 10 MB |
| 16.22. Declaring Cursors.flv | 14 MB |
| 16.23. Limitations on Cursors.flv | 15 MB |
| 17. Triggers | |
| 17.01. Trigger Basics.flv | 9 MB |
| 17.02. Uses for Triggers.flv | 9 MB |
| 17.03. Trigger Syntax.flv | 10 MB |
| 17.04. Trigger Examples.flv | 10 MB |
| 17.05. Exploring Triggers.flv | 10 MB |
| 17.06. Tigger Metadata.flv | 13 MB |
| 17.07. Dropping Triggers.flv | 13 MB |
| 17.08. User Accounts for Triggers.flv | 7 MB |
| 17.09. Trigger Limitations.flv | 13 MB |
| 18. Events | |
| 18.01. Event Basics.flv | 11 MB |
| 18.02. Event Execution.flv | 11 MB |
| 18.03. Event Syntax.flv | 11 MB |
| 18.04. Schedule Types.flv | 10 MB |
| 18.05. User Accounts for Events.flv | 10 MB |
| 18.06. Event Metadata.flv | 13 MB |
| 18.07. Event Limitations.flv | 8 MB |
| 19. Indexes | |
| 19.01. Index Basics.flv | 10 MB |
| 19.02. Defining Indexes for a Table.flv | 9 MB |
| 19.04. Dropping Indexes from a Table.flv | 3 MB |
| 19.05. Compound Indexes.flv | 5 MB |
| 19.06. Prefix Length Indexes.flv | 5 MB |
| 19.07. Covering Indexes.flv | 4 MB |
| 19.08. FULLTEXT Indexes pt.1.flv | 13 MB |
| 19.09. FULLTEXT Indexes pt.2.flv | 8 MB |
| 21. Conclusion | |
| 21.01. What We Covered.flv | 7 MB |
| 21.02. Where To Go From Here.flv | 5 MB |
| 22. Credits | |
| 22.01. About This Author.flv | 10 MB |
| mysql5dev2.zip | 26 KB |
| VTC - MySQL 5 Development - Part 2.nfo | 7 KB |
본 웹사이트는 광고를 포함하고 있습니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.

