MySQL Instructor-led Training
Free server access, Class recordings, Certification guidance, Job & Interview assistance, Course Completion Certificate
Uplatz
Summary
- Uplatz Certificate of Completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
Uplatz offers comprehensive training on MySQL Developer and Administration. This is instructor-led online course.
This course covers MySQL Developer and Administration comprehensively.
MySQL is a database management system that allows you to manage relational databases. It is open source software backed by Oracle. It means you can use MySQL without paying a dime. Also, if you want, you can change its source code to suit your needs.
Even though MySQL is open source software, you can buy a commercial license version from Oracle to get premium support services.
MySQL is pretty easy to master in comparison with other database software like Oracle Database, or Microsoft SQL Server.
MySQL can run on various platforms UNIX, Linux, Windows, etc. You can install it on a server or even in a desktop. Besides, MySQL is reliable, scalable, and fast.
The MySQL database has become the world's leading open source database. With consistent fast performance, high reliability and ease of use it is the open source database of choice for many organisations.
This MySQL course is designed to give students practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.
In this MySQL training, you will learn and acquire skills as follows:
- Using client programs to access a MySQL database
- Creating, altering and dropping a MySQL database
- Writing SQL statements to select data from a MySQL database
- Writing joins and subqueries
- Using SQL expressions
- Using SQL aggregate functions and scalar functions
- Inserting, updating, deleting and replacing rows
- Creating and altering tables, indexes and views
- Using transactions
- Granting and revoking access privileges on tables and views
- Exporting and importing data
Certificates
Uplatz Certificate of Completion
Digital certificate - Included
Course Completion Certificate by Uplatz
Course media
Resources
- Course Syllabus - MySQL - download
Description
MySQL Course Curriculum
Theory, Terminology and Concepts
- Client/Server Concepts
- Database and Database Objects
Data Definition using SQL
- Databases
- Data Types
- Tables
- Constraints and Indexes
- Views
Basic Data Manipulation using SQL
- Recurring SQL Constructs
- Adding data
- Modifying data
- Removing data
- Searching data
Advanced Data Manipulation using SQL
- Expressions
- Grouping and Aggregate Functions
- Joining Tables
Transactions
- Transaction Concepts
- SQL for working with Transaction
Import/Export
- Tools for Import/Export
- SQL for Import/Export
MySQL Admin
- Install and configure MySQL Server and client programs.
- Recognize the key components of the MySQL architecture.
- Secure your server.
- Troubleshoot server slowdowns and other issues.
- Improve query performance.
- Configure and administer a variety of replication topologies.
- Understand the benefits of MySQL Cloud.
Requirements
Passion and determination to achieve your goals!
Career path
MySQL Programmer
MySQL Administrator
Questions and answers
Hi. What do "live classes" actually consist of? Do you need special video software or do you watch live videos on a website? Cheers. Jack.
Answer:Hi Jack Live classes are instructor led courses in an online classroom. We use an online software to conduct the classes. During the class, you will be able to listen to the tutor, speak to the tutor, and tutor will be sharing his screen to deliver the class, there is also an option where you can share your screen if you want to clarify your doubts with the tutor. Regards Indu Khemchandani Uplatz
This was helpful.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.