Course

Digicomp Code MYD

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.
Duration 2 days
Price 1'500.–
Course documents Digicomp courseware
Register

Course facts

  • 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

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

This course is aimed for database developers.

Good user knowledge of the Windows or Linux operating system

Download

Download course details as PDF

Questions

Choose your date

Further courses