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
Course facts
- Know-how of the basics for designing and implementing a MySQL-based application
- Knowledge of the basic database design commands
- Create queries
- Programming with MySQL
- Designing databases with SQL commands
- Choose the appropriate data type
- Display of information from several tables as desired
- Introduction
- Database Management System (DBMS)
- Installation
- Administration tool
- Options
- Commands
- Script
- Output
- Modelling
- Entity
- Property
- Relation
- Structured Query Language (SQL)
- Vocabulary
- Identifiers
- Data type
- Comment
- Databases
- Generate
- Displays
- Define
- Delete
- Permissions
- Issuing
- Ado
- Tables
- Generate
- Displays
- Describing
- Renaming
- Update
- Empty
- Delete
- Constraints
- Primary keys
- Increment
- Uniqueness
- Default
- Zero value
- Test
- Linkages
- Species
- Foreign keys
- Tuples
- Generate
- Queries
- Update
- Delete
- Sorting
- Criterion
- Limit
- Filtration
- Projection
- Aggregation
- Alias
- Rating
- Operator
- Placeholder
- Union
- Functions
- Figures
- Text
- Date
- Special
- Alliances
- Indices
- Generate
- Delete
- Sighting
- Generate
- Questioning
- Update
- Delete
- Procedures
- Generate
- Execute
- Parameter
Component of the following courses
This course is aimed for database developers.
Good user knowledge of the Windows or Linux operating system