MySQL Advanced Stored Procedures (SQL-4201)

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!

In the MySQL Advanced Stored Procedures course learn to improve the quality of Stored Procedures, Function and Triggers in your applications as well as how to debug and optimize them! Through a hands-on approach, this instructor-led course with focus on labs is designed to teach you how to maximize the use of stored procedures along with the knowledge to discern when an application should contain stored procedures and when they should not. Students that can benefit from this course:Database developers and administrators that desire to improve the quality of their applications by creating complex logic within the database itself using stored proceduresA 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.

Voorkennis

Wij adviseren onderstaande voorkennis:

  • Having attended the MySQL for Developers course or similar knowledge:

Doel

  • Improve upon the design and structure of your compound stored procedure statements

Onderwerpen cursus MySQL Advanced Stored Procedures (SQL-4201)

De cursus MySQL Advanced Stored Procedures (SQL-4201) behandelt de volgende onderwerpen:

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 Advanced Stored Procedures (SQL-4201)

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus MySQL Advanced Stored Procedures (SQL-4201) behandeld zullen worden:

    • Introduction
      • Structure of MySQL AB
      • MySQL Products and Services
      • MySQL Partners
      • Supported Operating Services
      • MySQL Certification Program
      • Training Curriculum Paths
      • MySQL Website
    • MySQL Stored Procedures Foundation
      • Compound Statements
      • Assigning Variables
      • Parameter Declarations
      • MySQL Supported Operators and Built-in Functions in Stored Routines
      • Obtain Information on Stored Routines
      • Alteration and deletion of Stored Routines
      • Backing Up/Recovery Stored Routines
      • Binary Logging of Stored Routines
    • SQL and MySQL Stored Procedures
      • Flow Control Statements
      • SQL in Stored Routines
      • Dynamic SQL
    • Handling Exceptions and Errors
      • Error Handling Capabilities and Limitations
      • Implementing Error Handlers
      • Other Handler Issues
      • Error Handling Limitations
    • Managing Triggers
      • Creating Triggers
      • Obtain Information on Triggers
      • Delete Triggers
      • Trigger Limitations
    • Data Security
      • Set Permissions
      • View or Stored Routine?
      • Invoker Rights Error
      • Preventing Code Injection
    • Best Practices
      • Fundamental Programming Best Practices
      • Coding Style and Conventions
      • Variable Use Best Practices
      • Flow Control Best Practices
      • Dynamic SQL Best Practices
    • Conclusion
      • Course Overview
      • Training and Certification Website
      • Course Evaluation
      • Thank You!
      • QA Session

Getoonde informatie onder voorbehoud, genoemde prijzen zijn exclusief BTW.

Share |

 
Informatie 
  Contact
  Cursusoverzicht
  Cursuskalender
  Bel mij!
  Brochure aanvragen
  Aanmelden voor nieuwsbrief
  Stel een vraag
 
 
Cursuscategorieën