MySQL Fundamentals

Approved by Habanero Data
mySQL
next available COURSE:
Duration :
4 Day/s
DURATION
4 Day/s
USD $
650
USD
$ 650
NGN ₦
300,000
NGN
₦ 300,000

Course Information

Everything you need to know

  • Course Syllabus
  • Your trainer
  • Key Information

What is MySQL?

MySQL is one of the world’s most popular database management systems based on Structured Query Language (SQL). It is an open-source and reliable database, compatible with large web applications and online publishing providers. MySQL allows simple and cost-effective management of large amounts of information.

About the course
 
The course introduces MySQL to beginners without prior knowledge about SQL. Learners will be able to identify its features and uses, understand relational database basics, and build a database by the final training day. Beginners can easily use it and gain advanced skills within a few weeks.
 

Audience:
Data Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects

Recommended Prerequisites: None

Course Schedule: 4 Days, 32 Academic Hours

Course Syllabus:

Day 1
Introduction to MySQL

  • Course Goals
  • Course Lesson Map
  • Classroom Environment
  • MySQL Overview
  • MySQL Community Resources
  • MySQL Client/Server Model
  • MySQL Connectors
  • Installation of the MySQL server
  • Starting and stopping the MySQL server
  • Using the MySQL client
  • MySQL Workbench
  • Querying Table Data
  • The SELECT Statement
  • Query Data From An Application
  • Troubleshooting Problems
  • Data Types
  • Data Types as Part of Database Design
  • Numeric Data Types
  • Temporal Data Type
  • String Data Types
  • Character Set and Collation Support
  • Data Type Considerations
  • The Meaning Of NULL

 

Day 2
Functions, Queries

  • Functions in MySQL Expressions
  • Using Functions
  • String Functions
  • Date And Time Functions
  • Numeric Functions
  • Aggregate Functions
  • Spaces in Function Names
  • RANK Window Functions
  • Joins and Unions
  • Querying Multiple Tables
  • Joining Tables with SELECT
  • Inner Joins
  • Outer Joins
  • Table Name Aliases
  • Combining Multiple Queries with UNION
  • Subqueries
  • Nesting Queries
  • Writing Simple Subqueries
  • Writing Complex Subqueries

 

Day 3
Creating Databases and Tables

  • Creating a Database
  • Creating a Table
  • Showing How a Table Was Created
  • Column Options
  • Table Options
  • Copying an Existing Table Structure
  • Confirming the Creation of a New Table
  • Copying an Existing Table Structure
  • Creating a Temporary Table
  • Indexes, Keys, and Constraints
  • Deleting Databases and Tables
  • Adding, Removing and Modifying Table Columns
  • Adding, Removing and Modifying Indexes and Constraints
  • Modifying Table Data
  • Inserting Records
  • Replacing Existing Records
  • Updating Existing Records
  • Deleting Records
  • Exporting and Importing A Script
  • Multistatement Transactions
  • Modifying Data From An Application

 
Day 4
Securing Your Database

  • Layers of Security
  • Creating Users
  • Creating Roles
  • Assigning Privileges to Users And/Or Roles
  • Creating Views to Control Access
  • Backing Up Your Database
  • Importance Of Backups
  • Creating a Backup
  • Options for Backup
  • Restoring a Backup
  • JSON
  • JSON Use Cases
  • Retrieving Data From JSON Columns
  • Creating a JSON Column
  • Inserting Data Into a JSON Column
  • Updating a JSON Column
  • Conclusion
  • Course Goals
  • Resources
  • Evaluation

 

Our international certified trainers have highly experienced Microsoft Power BI practitioners who have real-world expertise.

I – Laptops will be provided for all candidates with pre-installed

II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).

For more information on our training, please enquire using the form above or call +2348103382376

MySQL Fundamentals

Contact Our Team Today!








    What's Included

    Find out what’s included in the training programme.
    COURSE MANUALS
    REFRESHMENTS
    INSTRUCTOR

    Delivery Options

    Everything you need to know

    CLASS ROOM TRAINING
    ONLINE TRAINING
    ONSITE TRAINING

    Course Schedule

    Find out the next available dates

    MySQL Fundamentals

    Available Dates

    Available Places

    Book or Enquire

    July 19, 2021

    Abuja, Accra, Addis Ababa, Freetown, Kigali, Lagos, Nairobi

    We are happy to help

    Call our team today on +2348103382376 or email training@habanerodata.net

    We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.