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 Database Pl/SQL Developer Certified Professional Training

This course is designed and developed by Oracle, an integrated set of complete application development tools and techniques for any technology platform and Operating System.

by London IT Training (LIT)
Wise Owl Education 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 Education [Claim Listing ]
Insight Logo

Microsoft SQL Fundamentals Of Querying

You will compose SQL queries to retrieve desired information from a database. You should have basic computer skills, be familiar with concepts related to database structure and terminology, and want to use SQL to query databases.

by Insight [Claim Listing ]
London IT Training (LIT) Logo

Oracle Certified Associate (OCA) Java Se 8 Programmer Training

The Java SE 8 Oracle Certified Associate (OCA) certification will help you develop a strong understanding of the Java programming language.

by London IT Training (LIT)
QA Logo

Microsoft Business Intelligence End to End with SQL Server 2016

This workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build and operate a business intelligence solution using SQL Server 2016 Integration Services, Analysis Services, Reporting Services and Power BI.

by QA [Claim Listing ]

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