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 |
본 웹사이트는 광고를 포함하고 있습니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.
광고 클릭에서 발생하는 수익금은 모두 웹사이트 서버의 유지 및 관리, 그리고 기술 콘텐츠 향상을 위해 쓰여집니다.