MySQL Course for Beginners


This hands-on class covers all the basics of relational databases, like SQL and MySQL. At the end of the course participants will be able to design and maintain databases in MySQL and other SQL based databases. Participants will also be familiar in querying, retrieving filtering and sorting information from existing databases.
Though the course is based on MySQL, it is a general SQL course without using any MYSQL specific features.


Target Group:
This is the right course for new users of SQL or MySQL, who have little or no previous experience with a relational database management system.

Our other SQL-Course:
Content:
  • History of datbases and SQL
  • SQL vs. MySQL
  • The basics of relational databases
  • Create Databases
  • Organize Data into Tables
  • Primary and Foreign Keys
  • Extract Information from a database using the SELECT command
  • CASE, WHERE and ORDER BY clauses
  • Use simple functions (String, Date, Numerical)
  • Deleting and modifying databases and tables
  • Nested sub-queries
  • Group query data with aggregation
  • Using JOIN to connect data from multiple table rows


Dates:
  • From Mon, 12th Dec, 2016 until Fri, 16th Dec, 2016 (5 days)
  • From Mon, 20th Mar, 2017 until Fri, 24th Mar, 2017 (5 days)
  • From Mon, 12th Jun, 2017 until Fri, 16th Jun, 2017 (5 days)
  • From Mon, 11th Sep, 2017 until Fri, 15th Sep, 2017 (5 days)
  • From Mon, 11th Dec, 2017 until Fri, 15th Dec, 2017 (5 days)

Duration of the course:
5 days

The fees for this SQL course per day:

Toronto, Canada:
$524 per day (exclusive of HST)
Lake Constance, Hemmenhofen, Germany:
€369 per day (exclusive of VAT)
plus € 90 for full board and lodging in 4 star hotel
Berlin, Germany:
€401 per day (exclusive of VAT)
London, England:
£401 per day (exclusive of VAT)


Attention:
The price of this course includes participation in the seminar and board and lodging in a 4-star hotel located at Lake Constance.
The price comprises:
Schulungsunterlagen

© The content and the images of this website are underlying copyright as described in the Imprint.