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

Stay Ahead Logo

Oracle Database 19c Essential Administration

The Oracle Database 19c Essential Administration course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 19c database.

by Stay Ahead [Claim Listing ]
Wise Owl Training Logo

Introduction To SQL

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them.

by Wise Owl Training [Claim Listing ]
Mullan I.T. Training Logo

SQL Server

Learn how to write SQL (Structured Query Language) to access, extract, organise & manipulate the data stored in your relational database.

by Mullan I.T. Training [Claim Listing ]
Best Practice Training Limited Logo

Administering Microsoft SQL Server Databases

Administering Microsoft SQL Server 2014 Databases is a five day course which provides essential skills and knowledge to the participants for maintaining Microsoft SQL Server 2014 database. This course mainly focuses on teaching delegates ways to use SQL Server 2014 features

by Best Practice Training Limited [Claim Listing ]
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 ]

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