Course
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
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