Mysql Introduction (Intermediate)

by Systematix Training Claim Listing

The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Query Browser. The basic SQL statements,including the use of SQL functions and the basic table and view handling statements are introduced.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Systematix Training Logo

img Duration

3 Days

Course Details

Overview

This course is designed to provide the skills needed to create and alter a MySQL database and query and modify data held within such a database.

It 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 Query Browser. The basic SQL statements,including the use of SQL functions and the basic table and view handling statements are introduced.

 

The delegates will practise:

  • 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

 

Prerequisites

There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.

  • Reading Branch

    Soane Point, 6-8 Market Place, Reading

Check out more MySQL courses in UK

Systematix Training Logo

SQL Introduction to Querying

Students will learn what SQL is and how it can help them query a database to answer business questions.

by Systematix Training [Claim Listing ]
Futuretech Info Vision Limited Logo

Microsoft SQL

This training will introduce you to a range of functions and features incorporated in Microsoft SQL like the primary functions of storing/retrieving data as requested by the users of this application. This training covers exam 70-462.

by Futuretech Info Vision Limited
EQV (UK) Ltd Training Logo

SQL Programming Introduction

This SQL Introduction programming course teaches relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills.

by EQV (UK) Ltd Training [Claim Listing ]
London IT Training (LIT) Logo

Oracle Certified Professional (Mysql 8. 0 Database Administrator Training)

Oracle offered another course named ‘Oracle Certified Professional, MySQL 8.0 Database Administrator’ that enables Database Administrators, including other Database Professionals, to enhance and optimize their organization’s investment in MySQL.

by London IT Training (LIT)
SureSkills Logo

SQL Database Management & Development

Research shows that many companies are concerned about their ability to support data management growth and responsibility. With a low organisational profile, data tends to be maintained rather than managed.

by SureSkills [Claim Listing ]

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy