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.
DurationCourse 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.
Developing and working on the database using NoSQL is now being considered as a key skill in the arena of Big Data.
The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, and backing up and recovering data. This MySQL Database Administration course also covers MySQL replication and its role in high availability and scalabilit...
The PHP & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MySQL Database system.
Using the free version of Microsoft SQL Server, one of the top 3 Relational Database Management Systems used by 98 of the Fortune 100 companies we will cover all the necessary skills to build, maintain and interrogate a relational database system.
Teradata is a data warehousing solution used to handle massive data warehouse operations. Participants will obtain in-depth knowledge of Teradata’s database architecture, as well as the product’s capabilities and benefits, throughout this Teradata certification course.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan