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, 2nd Mar, 2020 until Fri, 6th Mar, 2020 (5 days)
  • From Mon, 20th Apr, 2020 until Fri, 24th Apr, 2020 (5 days)

Duration of the course:
5 days

The fees for this SQL course per day:

Toronto, Canada:
$554 per day (exclusive of HST)
Lake Constance, Hemmenhofen, Germany:
€389 per day (exclusive of VAT)
plus € 90 for full board and lodging in 4 star hotel
Berlin, Germany:
€424 per day (exclusive of VAT)
London, England:
£424 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.