Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Choose date
From: R14 599,00
Price excluding VAT
Introduction:
This four-day instructor-led course helps you learn about the world’s most popular open source database. Expert Oracle University instructors will teach you how to use the MySQL Server and tools, while helping you develop deeper knowledge of using relational databases. This course will teach you everything you need to know to start using the incredibly popular MySQL database in your Web, Cloud and embedded applications. In learning about MySQL, you will develop an understanding of relational databases and how to design a robust and efficient database. You will harness that power by learning SQL and use it to build databases, populate them with data and query that data through extensive hands-on practices.
Audience profile:
End Users, Administrators, Database Designers and Developers
Pre-requisites:
Before attending this course, students must have:
- Basic computer literacy
- Knowledge of database concepts
- Experience with any command-line program
Course objectives:
After completing this course, students will be able to:
- Explain the relational database model
- Describe the features and benefits of MySQL
- Install and configure the MySQL server and clients
- Design efficient databases
- Use Structured Query Language (SQL) to build your database and query data
- Employ appropriate MySQL tools
Lesson 1: Introduction to MySQL
This lesson describes the goals of the course and the classroom learning environment. Lessons: |
|
|
|
|
|
|
|
|
|
Lab: | |
|
|
Lesson 2: MySQL Server and Client
This lesson describes the nature and architecture of the MySQL Server/Client model, communication protocols and connectors. Lessons: |
|
|
|
|
|
|
|
|
Lab: |
|
|
|
|
|
|
Lesson 3: MySQL Database Basics.
This lesson explains the concepts of relational databases and the use of data definition and data manipulation language. Lessons: |
|
|
|
|
|
|
|
|
|
|
|
Lesson 4: MySQL Database Design
This lesson explores the concepts of database modelling and the implementation of referential integrity and database normalisation. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 5: Table Data Types
This lesson describes the available data types and their implementation within table design. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
Lesson 6: Database and Table Creation
This lesson explains the statements used for creating databases and database tables. Lessons: |
|
|
|
|
|
|
Lab: |
|
|
|
|
Lesson 7: Basic Queries
This lesson describes how to retrieve data from a database with the SELECT statement. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
|
|
Lesson 8: Database and Table Maintenance
This lesson describes how to manipulate databases and database tables. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 9: Table Data Manipulation
This lesson describes how to manipulate table data through the use of INSERT, UPDATE, REPLACE and DELETE statements. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
Lesson 10: Functions
This lesson describes how to use built-in functions within SQL statements. Lessons: |
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 11: Joining Tables
This lesson explains the use of join statements to obtain information from multiple tables. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
Lesson 12: Table Subqueries
This lesson describes the different types of subqueries and their usages. Lessons: |
|
|
Lab: |
|
|
|
|
Lesson 14: MySQL Graphical User Interface Tools
This lesson describes how to use MySQL’s graphical user interface tool. Lessons: |
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 15: Supplemental Information
This lesson provides supplemental information on various MySQL storage engines. Lessons: |
|
|
|
|
|
|
Lab: |
|
|
|
|
|
|
|
|
Lesson 16: Conclusion
This lesson provides a summary of all the concepts covered within the preceding lessons. Lessons: |
|
|
|
|
|
|
|
|
|
|
Torque IT specializes in providing our Clients with Vendor authorized instructor-led training, enablement IT courses, and certification solutions.
Associated certifications and exam:
This course prepares students to write Exam (None). On successful completion of this course students will receive an Oracle University attendance certificate.
