Course
Introduction to MySQL
Course Duration
3 Days
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.
Private Courses
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
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
-
- Comprehensive course materials and exercises
Course Content
-
DATABASE CONCEPTSWhat is a database?
Database management systems
Tables, rows and columns
Indexes, primary keys, unique constraints and foreign keys
Client-Server architecture
Supported data types
Storage engines and table types
The Information_Schema and MySQL Databases -
USING THE MySQL CLIENTWhat is the MySQL client?
Getting started and Logging in
Selecting a database
Client commands
Entering and executing SQL statements
Retrieving previous commands
Creating, editing and executing SQL files
Redirecting output into a file
Command line execution of MySQL Scripts -
BASIC SELECTThe SQL SELECT statement
Case sensitivity
Quotes
Statement terminator
Syntax conventions
The select clause
The FROM clause
Conditions and the WHERE clause
Logical operators
The ORDER BY clause
Column aliases
Arithmetic expressions
Precedence of operators -
LIMIT, UNION AND AGGREGATE FUNCTIONSThe LIMIT clause
UNION
UNION ALL
Aggregate functions
The GROUP BY clause
Using Rollup with GROUP BY
The HAVING clause -
SUBQUERIES AND JOINSSubqueries
Cartesian products
Joins with original syntax
Table aliases
Natural joins
Join using
Join on
Multi-table joins -
NUMERIC AND CHARACTER FUNCTIONSFunction types
Testing functions
Numeric functions
Character functions -
DATE, TIME AND OTHER FUNCTIONSDate and time column types
Date and time formats
The date format function
Functions to return date time
Functions to extract components from date time
Date time arithmetic
Miscellaneous functions -
DATABASES AND TABLESCreating a database
Selecting a database
Creating tables
Auto_increment
Show create table
Column operations
Constraint operations
Copying tables
Renaming tables
Changing engine for tables
Dropping tables
Temporary tables -
INDEXES AND VIEWSWhat is an index?
Creating an index
Reviewing indexes
Dropping indexes
What is a view?
Creating views
View restrictions
Dropping views -
MANAGING DATAInserting rows
Replacing rows
Updating rows
Deleting rows
The truncate statement
The COMMIT and ROLLBACK commands
Savepoints
Implicit commits -
ACCESS CONTROLCreating users
Renaming users
Dropping users
Granting privileges
Revoking privileges -
IMPORT AND EXPORTExporting using SQL
Importing using SQL
Exporting from the command line
Importing from the command line
Related Courses
PHP Programming & MySQL for Web Development The PHP Programming & MySQL for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MYSQL database system and HTML.
MySQL Database Administration This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands.The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and m
You can choose your learning path and delivery style. Courses can be delivered at your office or at one of our training venues, it's your choice. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
You can master SQL, please contact us to book a place or request a quote.
-
Course Options
Please contact us to discuss options for this coursePrivatePrivateFlexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.Public ScheduledPublic ScheduledFixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
- Virtual Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/19/2024 5:04:26 PM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/19/2024 5:04:26 PM