MySQL 5 Development (Part 2)

Easy-to-undestand video tutorials

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...

Plus d'infos...
Durée 17h5
Avec : David Swain
Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE
Formation téléchargeable
VISIONNAGE ILLIMITÉ
Formation téléchargeable
DISPONIBLE SUR USB

Nos clients ont également vu :

  • Inserting Data

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

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

    • (07:48) Updating Data
    • (05:02) UPDATE with WHERE
    • (07:09) UPDATE with LIMIT
    • (03:36) UPDATE with ORDER BY
    • (05:25) UPDATE Result Messages
  • Other MySQL DML Commands

    • (05:02) REPLACE Command
    • (05:54) REPLACE Demo
    • (05:15) ON DUPLICATE KEY UPDATE Option
    • (05:22) ON DUPLICATE KEY UPDATE Demo
    • (03:48) TRUNCATE Command
    • (05:56) TRUNCATE Demonstration
    • (07:14) Safe Updates Mode
  • Importing Data

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

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

    • (08:04) Addressing Multiple Tables
    • (04:35) Column Name Conflicts
    • (04:13) Resolving Column Name Conflicts
    • (05:03) Table Name Conflicts
    • (06:31) Resolving Table Name Conflicts
  • Subqueries

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

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

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

    • (06:52) Multiple Table INSERT
    • (05:52) Multiple Table UPDATE
    • (05:48) Multiple Table DELETE
    • (06:40) Advantages and Limitations
  • Transactions and Locking

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

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

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

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

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

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

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

    • (03:54) What We Covered
    • (03:14) Where to Go from Here
  • Credits

    • (06:58) About the Author
Formateur : David Swain
Langue : Anglais
Durée : 17h5
Nombre de séquences vidéo : 184
SKU : 34278
Réf :
ISBN : 978-1-61866-021-3
Date de publication : 2011-11-22
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :




David Swain

+ 10 000 TUTOS EN VIDÉO
FORMEZ-VOUS EN ILLIMITÉ
SUR
VOD.TUTOROM.FR

A partir de 19€/mois seulement
Abonnez-vous