MySQL 5 Development (Part 1)

Easy-to-undestand video tutorials

As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and "why" those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!

Durée 11
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 :

  • Configuration

    • (02:18) MySQL Server Configuration
    • (05:53) Server Startup Options
    • (05:25) MySQL Configuration File
    • (06:00) Important Configuration Options
  • Client Programs

    • (05:48) Command Line Operations
    • (04:05) Using a Command Line Client
    • (06:06) Command Line Client Help File
    • (06:27) MySQL Client Batch Mode
    • (06:01) MySQL Client Interactive Mode pt. 1
    • (04:32) MySQL Client Interactive Mode pt. 2
    • (06:02) MySQL Client Interactive Mode pt. 3
    • (06:49) Executing Scripts
    • (07:11) Exploring Databases and Tables
  • SELECT Statement Basics

    • (06:18) SELECT Arithmetic
    • (04:42) Selecting More Than One Column
    • (05:03) Operators and Functions
    • (05:50) Column Aliases
    • (05:01) NULL
    • (05:24) Data Type Basics
  • Variables

    • (03:55) What is a Variable?
    • (01:42) User Variables
    • (02:50) Assignment Operator
    • (05:53) SET Statement
    • (04:36) System Variables
    • (07:12) Variable Scope
  • Calculations and Expressions

    • (02:35) New Values From Old
    • (03:45) Operators and Operands
    • (03:39) Arithmetic Operators
    • (05:12) String Operators
    • (05:28) Comparison Operators
    • (06:22) Logical Operators
    • (02:59) Order of Precedence
    • (03:28) Functions and Parameters
    • (06:31) Useful Numeric Functions
    • (07:10) Useful Character String Functions
    • (05:33) Temporal Operations
    • (05:09) Useful Temporal Functions
    • (07:27) Decision-Making Functions
    • (04:52) NULL-Related Functions
    • (02:41) Useful System Functions
  • Querying SQL Data

    • (05:02) Using a Database
    • (04:59) Selecting FROM a Table
    • (05:08) Targeting Rows Using WHERE
    • (06:59) Complex WHERE Criteria
    • (05:56) Sorting Results Using ORDER BY
    • (03:38) Going to Extremes Using LIMIT
    • (03:54) Avoiding Duplicates Using DISTINCT
    • (04:52) Aggregation Queries
    • (06:10) Subtotals Using GROUP BY
    • (02:43) Filter Derived Columns with HAVING
    • (05:17) Multilevel Sums Using WITH ROLLUP
    • (06:44) Summarizing SELECT Clauses
    • (03:07) Some Clauses Cannot Coexist
  • Databases and Tables

    • (04:42) Databases in MySQL
    • (06:57) Creating a Database
    • (02:47) Aspects of a Table
    • (05:12) Creating a Table
    • (05:08) Table Options
    • (06:35) Column Options
    • (05:29) Auto-Incrementation
    • (04:54) Altering a Table
    • (03:43) Adding and Dropping Columns
    • (06:09) Altering a Column
    • (04:27) Dropping a Table
    • (04:26) Dropping a Database
  • Data Type Details

    • (02:23) Data Type Categories
    • (07:00) Integer Numbers
    • (07:36) Floating Point Numbers
    • (04:49) Fixed Decimal Numbers
    • (07:24) BIT Data Type
    • (03:13) Strings
    • (05:45) Basic Character Strings
    • (06:35) ENUM Character Strings
    • (06:08) SET Character Strings
    • (06:54) Character Sets
    • (06:51) Collations
    • (07:00) Fonts and Keystroke Mapping
    • (05:21) Binary Strings
    • (05:43) Temporal Data
    • (06:16) Timestamp and Time Types
  • Storage Engines

    • (06:29) Storage Engine Basics
    • (04:34) Discovering Storage Engines
    • (06:20) MyISAM
    • (06:36) InnoDB
    • (05:31) Memory
    • (01:54) Example
    • (03:53) CSV
    • (02:38) Archive
    • (04:41) Federated
    • (02:27) Blackhole
    • (02:27) Third Party Engines
  • Exporting Data

    • (02:57) Basic Export Concepts
    • (04:44) Exporting Using SQL Commands pt. 1
    • (05:06) Exporting Using SQL Commands pt. 2
    • (05:03) Exporting on the Shell Command Line
    • (07:02) Using MySQLDUMP for Scripts
    • (07:21) Using MySQLDUMP for Exporting
  • Prepared Statements

    • (07:53) Prepared Statement Basics
    • (07:00) Prepared Statement Demonstration
    • (03:32) Commands That Can Be Prepared
    • (03:26) When to Use Them
  • Server Information

    • (07:07) Metadata
    • (06:39) SHOW Commands
    • (03:07) DESCRIBE Command
    • (06:58) MySQLSHOW Command Line Client
    • (04:55) Information_Schema Database pt. 1
    • (06:40) Information_Schema Database pt. 2
  • Conclusion

    • (03:00) What We Covered
    • (03:08) Where to Go from Here
  • Credits

    • (02:50) About the Author
Formateur : David Swain
Langue : Anglais
Durée : 11
Nombre de séquences vidéo : 129
SKU : 34225
Réf :
ISBN : 1-936334-93-3
Date de publication : 2011-05-27
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