Autorizácie

  • Oracle
  • ForgeRock
  • symantec
  • gurulabs
Newsletter

Chcete dostávať od nás najnovšie informácie? Pošlite nám svoj email.


Using MySQL

ID kurzu : MySQL-U Trvanie kurzu : 2 dni

This course covers the fundamentals of MySQL.



Vyberte dátum

ID kurzu :
MySQL-U

Cena
Na požiadanie

Trvanie kurzu
2 dni

Objednať

Who Can Benefit

Application developers, administrators, users who also need to work with the database server directly (table design, loading data, queries).

Prerequisites

Basic computer literacy. Understanding of SQL fundamentals is useful (the pace of this course is fast - we will shortly also be offering a longer course). :

Skills Gained

At completion of this course, you should be able to:

  • Find and effectively utilize resources such as the MySQL website, the online reference manual, mailing lists and others.
  • Understand the fundamentals of relational databases and the client/server concept.
  • List the major features and roadmap of MySQL.
  • Perform a basic MySQL installation on Windows or Linux.
  • Use the standard command-line and graphical clients to connect with the MySQL Server and execute basic commands.
  • Identify column types and their characteristics, choosing the appropriate type.
  • Understand automatic type and column conversions.
  • Create and modify databases and tables (Data Definition Language).
  • Import data from a file or via an ODBC connection.
  • Understand and use most common functions and expressions.
  • Write and execute basic SQL queries including joins and aggregation.
  • Perform operations on data (Data Manipulation Language).
  • Establish a basis for further MySQL training.

Details

Products covered MySQL 4.0 and 4.1, Command-line and graphical clients/tools.

Applies to MySQL Version: 4.0, 4.1