Description
Course “Introduction to Databases with MySQL” will introduce you to one of the most widely used database management systems (DBMS) used in the development of modern information systems – MySQL
The training pays serious attention to the relational model, ER diagrams (tables and relationships) and working with the SQL language (data extraction, selection, projection, joins, aggregation, grouping, modification, deletion and insertion).
Through it you will acquire fundamental knowledge of working with functions, procedures, transactions and triggers. This course lays the foundations of your knowledge of working with databases, making it easier to use them in real-world applications.
The best performers during the training would have the opportunity to meet with potential employers.
Method of conducting
Video Records, Online Consultation
Price
Price $270 instead of $310
Enrollment deadline
The course is available permanently/year round
Start on the course
March 13th, 2025
What you will learn:
- Working with MySQL databases
- Design and creation of databases and tables
- You have mastered SQL syntax
- Writing SQL queries
- Transaction Management
- Using procedures and functions
- Handling and storing data
* If you think you already have knowledge that might cover the content of the Introduction to Databases with MySQL course, you have the option to take a placement test on the level.
Course Program “Introduction to Databases with MySQL”
- Introduction to RDBMS
- Data Management
- Database Engines
- Data Types
- Query Basics and SQL Statements
- Retrieving Data
- Writing Data
- Modifying Existing Records
- Filtering Data Using AND, OR and NOT Logical Operators
- Filtering Data Using IN, BETWEEN and LIKE Logical Operators
- Database Design
- Table Relations
- E/R Diagrams
- The CREATE DATABASE Statement
- The DROP DATABASE Statement
- The CREATE TABLE Statement
- The DROP TABLE Statement
- Constraints
- The CREATE INDEX Statement
- The AUTO INCREMENT Field
- Views
- String Functions
- Math/Numeric Functions
- Date Functions
- Advanced Functions
- The JOIN Clause
- The INNER JOIN
- The LEFT JOIN
- The RIGHT JOIN
- The CROSS JOIN
- The UNION Operator
- Indices
- Grouping
- Aggregate Functions
- Having Clause
- Pivot Tables
- Introduction to Functions
- Introduction to Stored Procedures
- Stored Procedures with Parameters
- Error Handling
- Introduction to Transactions
- Transactional and Locking Statements
- Introduction to Triggers
- Trigger Syntax
Duration
The material is designed for 4 weeks but each student sets his own pace.
Start of training
March 13th, 2025 – after that the course is available permanently/year round
| It is suitable for: | |
|---|---|
| Beginners | ✔ |
| Specialists with 3-5 years of experience | ✖ |
| Senior professionals | ✖ |
| Forms of training: | |
|---|---|
| Video Records, Online Consultations | ✔ |
| Present | ✖ |
| Hybrid | ✖ |
| Type of training: | |
|---|---|
| Paid | ✔ |
| Free | ✖ |
| Price | $270 instead of $ |
| Exams and certificates: | |
|---|---|
| Exam – online | ✔ |
| Certificate | ✔ |
| Certificate of Professional Training | ✖ |
Is prior knowledge required?
“Introduction to Databases with MySQL” is specially designed for absolute beginners with no previous IT experience.
Career guidance
Personal consultation with the training lecturer and expert from DevStyleR Academy about career development opportunities in the IT field, advice from business practice and how to behave in a job interview.
| What should we know about the course? | |
|---|---|
| How to register | Registration takes place via the ADD TO CART button (at the beginning of the product) |
| Enrollment deadline | Training is available year-round |
| Form of training | Learners have access to an interactive learning platform that includes lecture recordings, self-assessment tests, assignments, real-world examples, and hands-on materials. |
| Will there be an exam? | Yes, the exam will be conducted in online format |
| Will I get a certificate? | All participants who have completed the course have the opportunity to apply, pay and receive** a certificate for completed training.
**only after full payment of the tuition fee in the respective course
|
| Can I start work? | After reaching the required level of knowledge, we will assist you with meetings with potential employers. |
