The Introduction to MySQL course 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 Workbench.
The Introduction to MySQL course 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 Workbench.
The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced.
Prerequisites
There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful.
Objectives
Create and alter a MySQL database and query and modify data held within such a database
Certification
Together with the MySQL for Developers course, this course covers the major topics required for the MySQL 5.6 Developer Certified Professional Exam(1Z0-882).
Together with theMySQL Database Administration course, this Introduction to MySQL course will teach the major topics required for the delegate to work towards achieving the MySQL 5.6 Database Administrator Certified Professional Exam(1Z0-883).
Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.
Exams are not included as part of the course.
Target Audience
Anyone who needs to access and work with a MySQL Database.
Skills Gained
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
What's included
For courses held on our premises, complimentary tea, coffee and biscuits are available. Lunch is not provided, however, there is a wide variety of eateries within a short walk of the centre.
Comprehensive course materials and exercises
Established in 1992, IT Training Solutions Ltd began life as an on-site computer training company in response to the business world's growing demand for flexible, high-quality training at an affordable price.
Our training is made to fit your requirements. The course schedule allows you to book a place on an existing course, whilst private training can be based on an existing course, or a number of lessons taken from several courses. We can also write bespoke courses for you based on your in-house systems or development program.
If you have an IT issue that you would like help with, one of our experienced IT professionals can visit in person or virtually and resolve the issue for you.
We can provide help with specific tasks, one off projects and we can also help with regular projects. We also provide desk-side support and floor walking.
This is an associate-level course offered by Oracle. Oracle PL/SQL (Procedural Language extensions to SQL) Developer Certified Associate (JP) is not an entry-level course and is designed for IT professionals who already have experience working on Database development and design.
This is a database specialist package designed to give you enhanced knowledge and understanding of the various softwares and applications for database management.
This 4 weekdays or 4 weekends OCP Oracle Certified Professional 11g Database course is designed to provide delegates with the necessary knowledge to pursue Oracle Certified Professional 11g Database (OCP) certification.
In this course, you’ll learn the core concepts of relational databases, and you’ll get your feet wet with structured query language (SQL), which is used to manage data in a relational database management system.
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.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy