DATABASE
WITH MYSQL
UPSKILL NOW
learnerspoint.org
follow us
Training summary
MySQL is one of the best Relational Database Management Systems
(RDBMS) used for developing web-based software applications.
This MySQL training course in Dubai covers MySQL programming,
installation, backup, troubleshooting, and configuration. With this
Database with MySQL course, professionals will acquire knowledge
on backing up databases, installing DBA on UNIX, Linux, and Win-
dows, error handling, and the best practices in MySQL.
Training summary
Located at the
heart of Dubai
Learners Point is a well-recognized institute in
corporate and individual training in the MENA
region and has contributed to the career success of
more than 110,000 professionals since its founding
in 2001. We are ISO 9001:2015 quality management
system certified.
Our training institute is licensed by the Government
of Dubai, UAE, and our certifications are widely
recognized by employers around the globe.
We are also associated with CPD UK, the premier accreditation service provider in the United Kingdom.
Who should
attend the
program?
The Database with MySQL course is ideal for:
Freshers seeking to learn about Data Management
DBA Professionals
SQL Professionals
Database Developers
Web Developers
Network Administrators
Audience
Objectives
Successful completion of the Database with MySQL
course will enable the candidate to:
Get an understanding of Related Security Concepts
Install and configure the MySQL DBA program and use
MySQL Database as a Service
Discover the application of MySQL Database Creation,
MySQL Database Commands, and MySQL Database
Architecture
Become familiar with MySQL Workbench, Create Data-
base, and Date Format
Objectives
Course outline
Introduction and Installation of MySQL
Introduction
Installing MySQL
Text and StarrModels Database Implementation
What is a Database and how do we model it?
Data
Database Management
Database Management Part II
Database Theory Quiz
Database Theory Answers
Basics of SQL and Single Entities
Introduction to the basics
Modeling Reality
Creating a Table in MySQL
Inserting Rows
Querying a Table
Course outline
Retrieval of Values
Ordering Output
Calculating
Built-In Functions
Subqueries
Regular Expression
Distinct
Modifying Existing Rows in a Database
Basics of SQL Quiz
Basics of SQL Answers
One-to-Many Relationship
Introduction to One-to-Many Relationship
Why Create a One-to-Many Relationship?
Creating the Tables in MySQL
Joins
Group By
Course outline
How to Properly Structure a SQL Query
More Functionality of REGEXP
Correlated Subqueries
Views
One-To-Many Quiz
One-To-Many Answers
Many-to-Many Relationship
What is the purpose of Many-to-Many Relationships
Three Table Joins
Exists/Not Exists Functionality
Divide
Union
Many-to-Many Quiz
Many-to-Many Answers
Course outline
One-to-One Recursive Relationship
Mapping the Relationships
Querying the Relationships
How to Model a 1:1 Recursive Relationship
How to Model a 1:M Recursive Relationship
More on Querying
Modeling an M:M Recursive Relationship
Querying an M:M Recursive Relationship
1:1 and Recursive Relationships Quiz
1:1 and Recursive Relationships Answers
Advanced-Data Modeling
Geography
Family Matters
Bookish Matters
History
Entities
Data Modeling Review Questions
Data Modeling Review Answers
Course outline
Spatial and Temporal Databases
Spatial Modeling
Spatial Querying
Temporal Databases
Spatial and Temporal Databases Review Questions
Spatial and Temporal Databases Review Answers
NBA Today Data Model
Data Model Part I
Data Model Part II
Mapping the Data Models
Inserting the Data
Queries Part I
Queries Part II
Course outline
About our trainer
We, at Learners Point, take immense pride in our
teaching methods and instructors. Our instructors
are some of the best experts from their fields and
employ a practical approach to learning. Many of
them are globally recognised and have a diverse
set of experience in their field of expertise. You are Our cutting edge teaching methods make every
always sure to have the best in the industry as your program an immersive and productive experience for
teachers who are ready to guide you at every step the learners. Our learning methods are research-driven
and make the experience informative yet enjoyable. and are continuously updated to stay relevant to pres-
Apart from the focus on learning your chosen ent times as well as the future. You will enjoy practical
course, our instructors also encourage students to applications of everything learned through theory and
develop communication skills and interpersonal skills regular mock examinations to help monitor your
necessary to excel in the practical world. We offer one progress. Our courses are led by an instructor in a
of the best Database with MySQL courses in Dubai. classroom setup and we do offer online high-quality
sessions as well for individuals. We also monitor the
training sessions with a progress tracker to maintain
high standards of instruction & ethics.
Trainer
Students review
Rachelle Ann
“I had a really great experience with the Learners Point
Academy learning MySQL. They are very flexible and
accommodating. I had a really hectic work schedule in the
middle of taking this course but they always made sure to
arrange my schedule according to my free time. I really like
the instructors, they are very helpful and approachable. I
learned a lot of new things from this MySQL class. I recom-
mend this academy big-time!!!”
Thomas Mummina
“I had a one-of-a-kind experience at Learners Point Acade-
my. I have been to lots of training academies but Learners
Point stands out. They are efficient and give timely
responses when made an inquiry during and after the
training. The staff is amazing, I must add. They provide the
best customer service ever!! The trainers were extremely
knowledgeable and they surpassed my expectations.
Thank you Learners Point for such a great experience and I
will totally recommend it to my colleagues.”
Student review
+971 (04) 403 8000 | (04) 3266 880
[email protected]
#610 - Business Center, Burjman Metro Station
Exit 4, Mashreq Bank Building - Dubai
learnerspoint.org
follow us
