MySQL 8. Design and creation of databases - course RUB 34,990. from Specialist, training, Date: May 2, 2023.

Miscellaneous / by admin / December 05, 2023

MySQL - one of the popular relational database servers. Used on a huge number of websites and content management systems (CMS). Wordpress, Joomla, Drupal, Bitrix and other CMS can and do work with the MySQL DBMS. The most popular PHP frameworks can work with MySQL: Laravel, Symfony, yii and others. To use MySQL effectively, you need to know its tools, capabilities and features.

During the course “MySQL 8. Designing and Creating Databases” you will master the basic techniques and methods of working effectively with the MySQL 8 server. During the training, you will consider the stages of designing and creating databases, study SQL operators in detail, and learn how to manage transactions on the MySQL server. You will be able to create stored procedures and triggers, and learn how to effectively use the storage engines (“engines”) of the MySQL server. This course is a must have for any website developer.

The course is intended for web developers and webmasters who plan to use the MySQL server in their practice. The course will be especially interesting for specialists using PHP and Perl.

instagram viewer

By the end of the course, you will have developed a large volume of SQL query templates, which you can later use in your projects, and create a database for the selected project. Each module contains a large number of practical tasks and ends with a test to consolidate knowledge. All course participants are given homework assignments.
The course program meets the requirements of the professional standard “Programmer”. Upon successful completion of the course, the center is issued a prestigious certificate of advanced training.

You will learn:

-install and configure MySQL 8 server
-work with the mysql console
-design and create efficient databases on the MySQL 8 server
-use MySQL Workbench to design schemas
-manipulate data on the MySQL 8 server using the SQL language effectively
-use stored procedures and triggers in databases
-use and manage transactions
-back up information and restore after a disaster
-optimize queries and server configuration for more efficient operation
- listeners will learn the name of the dolphin on the MySQL 8 logo)

Tarasov Alexey Vladimirovich

courses

“For a ship that does not know where it is sailing, no wind will be favorable” Seneca
A talented teacher-practitioner, holder of the prestigious international status ZCE (Zend Certified Engineer).

Combines many years of teaching and practical development experience. Listeners love Alexey Vladimirovich for his accessible and understandable presentation of complex topics, clear examples that help them immediately master the material, passion for his work, and good humor.
Alexey Vladimirovich has long-term professional experience in developing, supporting and updating corporate websites. He taught the disciplines “Software Development Technology”, “Theory of Programming Languages and Translation Methods”, “Fundamentals of HTML and CSS” at universities. Specializes in teaching courses on web technologies. During his time at the center, Alexey Vladimirovich trained over 5,000 students.
Author of the courses “Application Development in Symfony”, “JavaScript. Level 3. React and JSX", "React: Redux and react-router".
Alexey Vladimirovich constantly improves his professional level, successfully passing exam 70-480 “Programming in HTML5 with JavaScript and CSS3.
Photos of group graduates are located in our VKontakte community.

Module 1. Installing and starting the MySQL 8 server (4 ac. h.)

-Distribution
-File structure
-Setting up a configuration file
-Initialization of server data
-Start the server
-Start mysql console
-Console commands
-Working with MySQL Workbench
-Basic SQL commands

Module 2. Design of a relational database (4 ac. h.)

-Data types
-Designing a base diagram in WorkBench
-Normalization of the database table
-Create keys
-Relationships between tables
-Working with .mwb files
-Export SQL code from database schema

Module 3. Syntax of SQL expressions for defining data structure (4 ac. h.)

-DDS operators
-Base creation operators
-Creation of tables
-Temporary tables
-Indices
-Full text index
- ALTER modification operator

Module 4. SQL Expressions: Data Manipulation (4 ac. h.)

-CRUD operators
-Data insertion
-Data loading LOAD
-Data update
-Removal
-Data sampling
-Predicates
-Table joins

Module 5. Combining queries and manipulating data (4 ac. h.)

-SELECT join
-Subqueries IN, SOME, ALL, BETWEEN
-EXISTS operator
-Representation
-View restrictions

Module 6. Stored procedures and triggers (4 ac. h.)

-The concept of ROUTINES
-Stored procedures
-Built-in functions
-Working with date/time
-Working with numbers
-Strings
-Own functions
-IF operator
-Creating triggers

Module 7. MySQL transactions and storage types (4 ac. h.)

-Locking tables
-Conditional blocking
-Transactions
-Save points
-Storage types

Module 8. Optimization and maintenance of the MySQL 8 server (4 ac. h.)

-Creating a database backup
-Accounts
-Reset superuser password
-Query optimization
-Data uploading to HTML and XML

Tags cloud

Miscellaneous

Rating

Views

Comments