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

London IT Training (LIT) Logo

Oracle Certified Professional (Java Ee 7 Application Developer Training)

This course is designed for Java EE (Enterprise Edition) software developers.

by London IT Training (LIT)
JMD Training and Consultancy Logo

SQL Training Course

If you’re looking for really great SQL training you’re in the right place.Companies large and small choose us – why? Your own tailored, two day SQL training course, at your own premises at the same price as a standard course from elsewhere.

by JMD Training and Consultancy [Claim Listing ]
London IT Training (LIT) Logo

SQL Server Reporting Services (SSRS) Training

SQL (Structured Query Language) is the most extensively used database language to learn, and a vast range of database systems uses it to create queries and manipulate data.

by London IT Training (LIT)
ALX Logo

Oracle Database SQL

This course covers all the skills needed to use Oracle Database in professional work. Structured knowledge of SQL can be an asset to business analysts, report writers, application developers in the RAD environments (Oracle Forms, Oracle Fusion and even Microsoft Access)

by ALX [Claim Listing ]
Global Knowledge Logo

Oracle Advanced Pl/sql

This course,designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design,packages,cursors,large objects and collections.

by Global Knowledge [Claim Listing ]

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