MySQL Developer Techniques (SQL-4305)

Voorkennis | Doel | Onderwerpen | Data & prijzen | Aanmelden
Deze PlusPartner cursus hebben we niet meer in ons assortiment maar nog wel andere cursussen, bijvoorbeeld:Meer informatie? Klik hier!

This instructor-led course is designed for MySQL[tm] developers who wish to obtain the skills required to create complex queries and efficient structures while improving the performance of their database applications. In addition, the MySQL developers will also be provided with additional query writing techniques that support creating reports that support the end users along with the skills required to create and utilize trees and hierarchical data structures. Students that can benefit from this course include:Certified MySQL Developers and others with similar experience who want to utilize advanced SQL features to create queries that will result in better results and improved performance of their database queries A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


Wij adviseren onderstaande voorkennis:

  • Attendance to the MySQL for Developers course, or an equivalent mastery of database concepts, SQL and the MySQL server.


  • Utilize multiple indexing options

Onderwerpen cursus MySQL Developer Techniques (SQL-4305)

De cursus MySQL Developer Techniques (SQL-4305) behandelt de volgende onderwerpen:

    • Introduction
    • Improving Performance with Indexes
    • Improving Searches of Date and Text Fields
    • Improving Inserts and Updates
    • Improving Calculations
    • Improving Joins
    • Trees and Hierarchical Data
    • Utilizing Advanced Index Structures
    • Working with Locking Levels
    • Creating Reports
    • Conclusion

    Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?

Vraag informatie aan

Gedetailleerde onderwerpenlijst cursus MySQL Developer Techniques (SQL-4305)

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus MySQL Developer Techniques (SQL-4305) behandeld zullen worden:

    • Introduction
      • MySQL Overview, Products and Services
      • Supported Operating Systems
      • MySQL Certification Program
      • Training Curriculum Paths
      • MySQL Website
      • Installing MySQL
      • Installing the world database
    • Improving Performance with Indexes
      • Query Executions in MySQL
      • Why Indexes?
      • When MySQL Uses an Index
      • Optimize Indexes
    • Improving Searches of Date and Text Fields
      • Strings in Multiple Columns
      • Case Sensitivity
      • INET_ATON and INET_NTOA functions
      • Searching Dates
      • String Dates to SQL Dates
      • Dates to Integer Values
      • Dates to Strings
      • Nonspecific Date Searches
    • Improving Inserts and Updates
      • INSERT Process
      • Storage Engine Specifics
      • MySQL Extensions
    • Improving Calculations
      • Aggregate Multiplication Functions
      • Running Total Queries
      • Avoiding Division by Zero
      • Median Values
      • Simulating RANK
      • Solving Complex Problems
      • Miscellaneous
    • Improving Joins
      • Query Optimizer
      • EXPLAIN
      • Overview of JOINs
      • Improving JOIN performance
    • Trees and Hierarchical Data
      • Graph, Trees and Hierarchies
      • Adjacent List Structures
      • Nested Set Structures
      • Path Enumeration
    • Utilizing Advanced Index Structures
      • MySQL Index Types
      • FULL TEXT Indexes
      • Simulating Function Based Indexes in MySQL
      • Optimizing End of Field Searches
    • Working with Locking Levels
      • Locks
      • Explicit Table Locks
      • Storage Engine Locking Techniques
      • Locking Issues
    • Creating Reports
      • Calculate Multiple Conditions
      • Create a Calculated Report
      • Quarterly Reports
      • SQL Bar Chart
      • Decision Tables
      • Materialized Views
      • Producing Sequential or Missing Data
    • Conclusion
      • Course Overview
      • Training and Certification Website
      • Course Evaluation
      • Thank You!
      • QA Session

Getoonde informatie onder voorbehoud, genoemde prijzen zijn exclusief BTW.

Share |

  Bel mij!
  Brochure aanvragen
  Aanmelden voor nieuwsbrief
  Stel een vraag