MySQL

Easy-to-undestand video tutorials

Virtual Training Company's MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner's understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below.

Durée 7
Avec : Joshua Mostafa
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 :

  • Operators in MySQL

    • (05:03) Arithmetic Operators
    • (08:07) Numeric Comparison Operators
    • (05:34) String Comparison Operators
    • (08:48) Logical Operators
    • (07:21) Bitwise Operators
    • (08:41) Regular Expressions 1
    • (06:38) Regular Expressions 2 Pt 1
    • (05:10) Regular Expressions 2 Pt 2
    • (04:53) Operators Syntax Recap
  • Querying Your Data

    • (03:37) Sorting Retrieved Data
    • (03:05) Specifying Numbers of Results
    • (05:25) Joining Tables Pt 1
    • (03:37) Joining Tables Pt 2
    • (07:55) More On Joining Tables
    • (08:05) Data Aggregation
    • (03:00) Queries Syntax Recap
  • More Complex SQL

    • (08:09) Using Default Data
    • (05:16) Date And Time 1 Pt 1
    • (04:02) Date And Time 1 Pt 2
    • (04:54) Date And Time 2
    • (06:49) ENUM column type
    • (06:51) SET column type Pt 1
    • (05:28) SET column type Pt 2
    • (03:12) Using Variables
    • (05:25) Conditional: IF()
    • (03:18) Complex Syntax Recap
  • Good Practices

    • (05:14) Using SQL batch files Pt 1
    • (04:41) Using SQL batch files Pt 2
    • (05:17) Data Modeling Pt 1
    • (05:55) Data Modeling Pt 2
    • (05:11) Normalization Pt 1
    • (03:56) Normalization Pt 2
    • (13:32) Optimizations
  • Security

    • (07:31) Users And Privileges
    • (08:08) More About Users And Privileges
    • (04:37) The mysql Database Pt 1
    • (04:16) The mysql Database Pt 2
    • (05:43) Encryption
    • (03:25) Security Syntax Recap
  • Building A Database Application

    • (07:12) Planning The Structure
    • (05:33) Designing The Database Pt 1
    • (04:49) Designing The Database Pt 2
    • (06:25) Creating The Database Pt 1
    • (04:33) Creating The Database Pt 2
    • (06:38) Logging In And Out
    • (05:59) Checking Videos In And Out Pt 1
    • (07:06) Checking Videos In And Out Pt 2
    • (06:26) Searching For A Video
    • (08:05) Adding A New Title
    • (03:51) Signing Up A New Customer
    • (04:45) Hiring And Firing Employees Pt 1
    • (04:28) Hiring And Firing Employees Pt 2
    • (08:03) Listing Debtors
  • Credits

    • (00:44) About the Author
Formateur : Joshua Mostafa
Langue : Anglais
Durée : 7
Nombre de séquences vidéo : 72
SKU : 33364
Réf :
ISBN : 1930519745
Date de publication : 2002-07-25
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 :




Joshua Mostafa

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

A partir de 19€/mois seulement
Abonnez-vous