Course Overview The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench.
Course Overview
The Introduction to MySQL course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates 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.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
The delegate 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
Who will the course benefit?
Anyone who needs to access and work with a MySQL Database.
Our trainers offer a lifetime of support after each course. Our pass rates are consistently above industry averages, however, if you do not pass first time, you can sit on a subsequent course free of charge (just pay the exam fee).
Over 98% of our delegates rate our trainers ‘good’ or ‘excellent’. TSG Training have been a knowledgeable, reputable UK training provider for almost 20 Years.
Install Microsoft SQL Server 2012/14 and the bundled tools Learn many tools that facilitate effective Database Administration Monitor the smooth running of the Database Server Maintain the Database and Indexes Setup and control Database Security
SQL (Microsoft SQL Server) course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.
R 12 is an Oracle E-business suite in Oracle Cloud. Version 12 of Oracle E-business suite is an internet-enabled product that can easily be managed by a particular site.
Querying Microsoft SQL Server 2014 (M10461) course provide delegates with the technical skills required to write Transact-SQL queries to manage SQL Server.
This 3 day course is intended for students who need to learn the essential skills necessary to maintain a Microsoft SQL Server 2016 or 2017 system infrastructure. Being concise and hands-on, it is aimed at quickly getting students familiar with the Microsoft SQL Server administration concepts, tool...
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy