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

Acudemy Logo

MySQL Database Administration

This course is designed to give administrators the knowledge and skills needed to maintain successful and efficient operations of MySQL databases and services. Administrators will gain practical experience in setting up, administering and troubleshooting the database.

by Acudemy
London IT Training (LIT) Logo

HBASE Training

HBase is a non-relational database that allows you to read and write massive datasets in real-time. It lets you store a large amount of data in a table format.

by London IT Training (LIT)
Enliten IT Logo

Oracle 19c Administration

This Oracle Database 19c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.  

by Enliten IT [Claim Listing ]
Elite Training Logo

O1010 – 10g DBA Fundamentals I Oracle

This course is aimed at the DBA's who often have to make the first attempt at solving performance problems prior to, and as they develop. We cover all aspects of internal database tuning on an Oracle 10g platform in this three-day course.

by Elite Training [Claim Listing ]
Seven Institute Logo

PHP & MySQL For Web Development

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.

by Seven Institute [Claim Listing ]

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