> > D61918GC30

MySQL for Beginners (D61918GC30)

Course Description Schedule Course Outline
 

Who Should Attend

  • Administrator
  • Database Administrators
  • Database Designers

Prerequisites

Required Prerequisites

  • Basic computer literacy is required

Suggested Prerequisites

  • Knowledge of database concepts
  • Previous experience with any command-line program

Course Objectives

  • Understand the features and benefits of MySQL
  • Install and start the MySQL server
  • Understand the basics of relational databases
  • Understand the SQL and MySQL languages
  • Understand Data/Column types with regard to efficient database design
  • View a database design structure and content
  • Create a database design using an efficient structure
  • Extract basic database information using the SELECT command
  • Troubleshoot syntax and understand typical warnings and errors
  • Delete or modify a database, and table row data
  • Group query data with aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use simple functions (String, Date, Numerical)
  • Describe MySQL connectors, their major features and differences
  • Understand MySQL storage engines, transactions and features of the common engines

Course Content

If you're looking to build a solid foundation in your development career, this course is an ideal place to begin. MySQL for Beginners will introduce you to the fundamentals of relational databases and SQL through hands-on exercises.

Learn To:

  • Install the MySQL server.
  • Describe the features and benefits of MySQL.
  • Describe the basics of relational databases.
Classroom Training
Modality: C

Duration 4 days

Price (VAT excl.)
  • Belgium: 1,800.- €
  • The Netherlands: 1,820.- €
Dates and Booking
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date