| MySQL 5 Development (Part 2) Tutorials Online |
 |
|
Description MySQL 5 Development (Part 2)
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. |
| Sample - Preview the First 3 chapters of MySQL 5 Development (Part 2) video free. Free learning MySQL 5 Development (Part 2) online. |
01 Introduction
0101 Welcome
0102 What the Course Will Cover
0103 System Requirements
0104 Brief Review of Part 1
02 Configuration
0201 Startup Options
0202 Configuration File
0203 Important Configuration Options
03 Manipulating Data
0301 Data Manipulation Basics
0302 Warnings and Errors
0303 SQL Modes
0304 Changing Syntax Interpretation
0305 Elevating Warnings to Errors
0306 Interpreting Error Messages
0307 Note Warnings
0308 System Error Warnings
04 Inserting Data
0401 Inserting Data
0402 Inserting Data Archaic Syntax
0403 INSERT Demonstrations
0404 Default Values on Insert
0405 AUTO_INCREMENT on Insert
0406 AUTO_INCREMENT Issues
0407 LAST_INSERT_ID Function
0408 Common INSERT Errors
05 Deleting Data
0501 Deleting Data
0502 DELETE with WHERE
0503 DELETE with LIMIT
0504 DELETE with ORDER BY
0505 DELETE Result Messages
06 Updating Data
0601 Updating Data
0602 UPDATE with WHERE
0603 UPDATE with LIMIT
0604 UPDATE with ORDER BY
0605 UPDATE Result Messages
07 Other MySQL DML Commands
0701 REPLACE Command
0702 REPLACE Demo
0703 ON DUPLICATE KEY UPDATE Option
0704 ON DUPLICATE KEY UPDATE Demo
0705 TRUNCATE Command
0706 TRUNCATE Demonstration
0707 Safe Updates Mode
08 Importing Data
0801 Importing Data
0802 Basic Import Demonstrations
0803 Importing Non-Tab Formats
0804 Skipping Header Lines on Import
0805 Changing Import Column Order
0806 Converting Data on Import pt. 1
0807 Converting Data on Import pt. 2
0808 Importing on the Shell Command Line
09 Deriving New Tables
0901 New Tables from Existing Tables
0902 CREATE TABLE Using SELECT
0903 Including Other Features
0904 CREATE TABLE Using LIKE
0905 Populating Derived Tables
0906 Temporary Tables
0907 Altering Derived Tables
10 Multi-Table Queries
1001 Addressing Multiple Tables
1002 Column Name Conflicts
1003 Resolving Column Name Conflicts
1004 Table Name Conflicts
1005 Resolving Table Name Conflicts
11 Subqueries
1101 Subquery Basics
1102 Shape of the Result
1103 Guaranteeing a Single Row
1104 Scalar Subqueries
1105 Table Subqueries
1106 Columnar Subqueries
1107 Row Subqueries
1108 EXISTS Subqueries pt. 1
1109 EXISTS Subqueries pt. 2
1110 Correlated vs Non-Correlated
1111 Nesting to Multiple Levels
1112 Building Queries in Layers
1113 Addressing the Same Table Twice
1114 When to Use Subqueries
12 Joins
1201 The FROM Clause
1202 Join Basics pt. 1
1203 Join Basics pt. 2
1204 Inner Join Syntax
1205 Basic Inner Join Demos
1206 Inner Join Aggregation
1207 The ON Clause
1208 The USING Option
1209 Natural Joins
1210 Outer Joins
1211 Join Criteria Options
1212 Multiple Table Joins
1213 Self Joins
1214 Problems Joins Cannot Solve
13 Views
1301 What a View Is
1302 Uses of Views
1303 Basic Syntax of a View
1304 View Column Names
1305 Updatable Views
1306 Insertable Views
1307 View Consistency
1308 View Viability
1309 Altering or Dropping a View
1310 View Metadata
14 Multiple Table DML Operations
1401 Multiple Table INSERT
1402 Multiple Table UPDATE
1403 Multiple Table DELETE
1404 Advantages and Limitations
15 Transactions and Locking
1501 Transaction Basics
1502 Transactions in MySQL
1503 AUTOCOMMIT Mode
1504 Transaction Commands
1505 Savepoints
1506 Isolation
1507 Isolation Levels
1508 Transaction Demos
1509 Locking Basics
1510 Locking in MySQL
1511 Explicit Row Locking with InnoDB
1512 Row Locking Demos
1513 Explicit Table Locking
1514 Table Locking Demos
1515 Deadlock Resolution
1516 Implicit Commits
16 Stored Routine Basics
1601 Procedures and Functions
1602 Why Use Stored Routines
1603 Basic Create Function Syntax
1604 Invoking a Function
1605 Basic Create Procedure Syntax
1606 Invoking a Procedure
1607 Database Association
1608 Stored Routine Metadata
1609 Where They Are Stored
1610 Dropping Stored Routines
17 Stored Routine Programming
1701 Compound Statements
1702 Compound Statement Demos
1703 Procedure Parameter Types
1704 IN Parameters
1705 INOUT Parameters
1706 OUT Parameters
1707 Declaring Local Variables
1708 Assigning Values to Variables
1709 Variable Scope
1710 Conditional Blocks
1711 IF Block Demos
1712 CASE Block Demos
1713 Iterative Blocks
1714 LOOP Block Demos
1715 REPEAT Block Demos
1716 WHILE Block Demos
1717 The LEAVE Statement
1718 The ITERATE Statement
1719 More We Can DECLARE
1720 Declaring Conditions
1721 Declaring Error Handlers
1722 Declaring Cursors
1723 Limitations on Cursors
18 Triggers
1801 Trigger Basics
1802 Uses for Triggers
1803 Trigger Syntax
1804 Trigger Examples
1805 Exploring Triggers
1806 Trigger Metadata
1807 Dropping Triggers
1808 User Accounts for Triggers
1809 Trigger Limitations
19 Events
1901 Event Basics
1902 Event Execution
1903 Event Syntax
1904 Schedule Types
1905 User Accounts for Events
1906 Event Metadata
1907 Event Limitations
20 Indexes
2001 Index Basics
2002 Defining Indexes for a Table
2003 Adding Indexes to a Table
2004 Dropping Indexes from a Table
2005 Compound Indexes
2006 Prefix Length Indexes
2007 Covering Indexes
2008 FULLTEXT Indexes pt. 1
2009 FULLTEXT Indexes pt. 2
21 Efficiency Checks
2101 Efficiency Checks
2102 PROCEDURE ANALYSE function
2103 EXPLAIN Command pt. 1
2104 EXPLAIN Command pt. 2
2105 EXPLAIN Command pt. 3
22 Conclusion
2201 What We Covered
2202 Where to Go from Here
23 Credits
2301 About the Author
sku |
|
