home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
MySQL fundamentals course

Intended for

Analysts, developers, and database administrators who will be using MySQL; web server maintainers who are not yet familiar with MySQL; and anybody wanting to gain knowledge of the detailed workings of a relational database system.

Background

The participants must have insight in relational database systems (see course RDBMS concepts) and have elementary knowledge of SQL (cf. course SQL fundamentals). You can test for yourself to see whether you have sufficient background by printing and filling out the self-tests (PDF file - 57 KB and PDF file - 56 KB).

Some knowledge of either PHP (cf. PHP programming: fundamentals course), Java (cf. course Java programming), Perl (cf. Perl programming: fundamentals course) or an other programming language is advisable but not necessary.

Training method

Classroom instruction with exercises (about 50% of the time).

Course leader

Peter Vanroose.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
17/11/2010 Leuven1200 EUR
01/12/2010NWoerden1200 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

This course presents a description of MySQL: what it is, what it is intended for, and how it can be used. The participant will learn

  • the setup of the software package MySQL;
  • the use of the "client" tools: command line interface, graphical interfaces, admin interface;
  • the MySQL objects for data storage and manipulation;
  • creating databases, tables, and users;
  • preparing a database for use, viz. authorisations and indexes.

Attention is also paid to the use in the context of a web server, to MySQL in relation to other RDBMS, and to specific topics like models for data storage, integrity, authorisations, and performance.

Moreover, this course will explain how to install the system and use it in practice, both on Unix/Linux systems and on MS-Windows. After completion, the participants will not only have the necessary theoretical background of MySQL as RDBMS but also will have had sufficient practical training to start working with MySQL in an independent way.

Together with RDBMS concepts and SQL fundamentals this course forms a well-balanced whole, in such a manner that the participants will have an 'complete overview' of MySQL as RDBMS after successful conclusion of this course.

Main topics

  • Introduction: MySQL environment; client-server-model; position within the relational model
  • SQL data definition language (DDL): MySQL objects (like tables, storage engines, indexes and views); datatypes; characteristics creation of objects; using them; and parameters
  • SQL embedded in a program, esp. for supporting dynamic web pages
  • Metadata: MySQL's INFORMATION_SCHEMA; the DESCRIBE statement
  • Securing the MySQL environment and assigning authorizations
  • Utilities: export/import of external data; defragmentation; check and repair
  • Data integrity, locking and transactions
  • Performance: basic principles; use of indexes to improve performance; the 'EXPLAIN' statement