Course

Introduction to MySQL («MYD»)

MySQL is a widely used database and development platform. As a database developer, this course teaches you the basics necessary to plan, design, and implement a MySQL-based application.
Vendor code

MYD

Duration 2 days
Price 1'500.–
Course documents Digicomp courseware
Register
Add to watch List

Course facts

Key Learnings
  • Understanding the fundamentals of designing and implementing a MySQL-based application as a database developer
  • Knowing the basic commands for database design
  • Creating queries
  • Programming with MySQL
  • Designing databases with SQL commands
  • Choosing the appropriate data type
  • Displaying information from multiple tables as required
Content

1 Introduction

2 Database Management System (DBMS)

  • Installation
  • Administration tool
  • Options
  • Commands
  • Script
  • Output

3 Modelling

  • Entity
  • Property
  • Relation

4 Structured Query Language (SQL)

  • Vocabulary
  • Identifiers
  • Data type
  • Comment

5 Databases

  • Generate
  • Displays
  • Define
  • Delete

6 Permissions

  • Issuing
  • Ado

7 Tables

  • Generate
  • Displays
  • Describing
  • Renaming
  • Update
  • Empty
  • Delete

8 Constraints

  • Primary keys
  • Increment
  • Uniqueness 
  • Default
  • Zero value
  • Test

9 Linkages

  • Species
  • Foreign keys

10 Tuples

  • Generate
  • Queries
  • Update
  • Delete

11 Sorting

  • Criterion
  • Limit

12 Filtration

  • Projection
  • Aggregation
  • Alias
  • Rating
  • Operator
  • Placeholder

13 Union

14 Functions

  • Figures
  • Text
  • Date
  • Special

15 Alliances

16 Indices

  • Generate
  • Delete

17 Sighting

  • Generate
  • Questioning
  • Update
  • Delete

18 Procedures

  • Generate
  • Execute
  • Parameter
Target audience

This course is aimed for database developers.

Requirements

Good user knowledge of the Windows or Linux operating system

Download

Download course details as PDF

Questions

Any questions?
First name
Last name
Company optional
Email
Phone
I would like to book this course as a company course
First name
Last name
Company optional
Email
Phone
Number of participants
Desired course location
Start date (DD.MM.YYYY)
End date (DD.MM.YYYY)

Choose your date

7
Apr
2025
8
Apr
2025
Lausanne
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
22
May
2025
23
May
2025
Geneva
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
3
Jul
2025
4
Jul
2025
Lausanne
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
11
Aug
2025
12
Aug
2025
Geneva
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
23
Sep
2025
24
Sep
2025
Lausanne
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
6
Nov
2025
7
Nov
2025
Geneva
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
18
Dec
2025
19
Dec
2025
Lausanne
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.
Next date
7
Apr
2025
8
Apr
2025
Lausanne
French
Timetable
CHF 1’500.-
exkl. 8.1% Mwst.
CHF 1’500.-
exkl. 8.1% Mwst.

Further courses

COURSE

Introduction to PHP («PHP»)

3 days
CHF
2'250.–
Learn more