Course Description

  Welcome to Introduction to MariaDB and HeidiSQL For Beginners course, The practical guide to learn the basics of MariaDB and HeidiSQL.

MariaDB is a free powerful, open source object-relational database system.

Learning how to work with relational databases is one of the best ways to boost your career!   MariaDB is getting popular each day and many companies are using MariaDB as a relational database. 

This course will  start with you from zero level experience in MariaDB and relational databases , starting to level up as we are going through the course.   

This course will guide you how to install MariaDB on a local machine as well as creating instances on the cloud, on the one of the most required cloud services providers in the market...Amazon Web Services (AWS).

You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)

Some of the points we will be covering :

  • How to install the MariaDB.

How to use HeidiSQL.

  • Create databases with MariaDB.*

Understand what is schema and how to create a schema.

  • How* create tables using SQL script.

How to create tables using pgAdmin.

  • Use different datatypes available in MariaDB.

How to create views.

  • Understand what does DBaaS mean.

You will learn how to create users to access your database based on specific permissions you gave them.

  • How to create different constraints.

Create primary keys in MariaDB.

  • Create foreign keys in MariaDB.*

How to import a bulk of data in and out of your database.

  • Generate Entity Relationship Diagram (ERD) using another powerful tool called DbVisualizer.

Give your CV a huge boost by learning MariaDB...do not hesitate enrolling.

Course Details
en
en
Ahmad Mohey
Self-paced
Beginner
2 hours
Course Details
en
en
Ahmad Mohey
Self-paced
Beginner
2 hours
Course Description

  Welcome to Introduction to MariaDB and HeidiSQL For Beginners course, The practical guide to learn the basics of MariaDB and HeidiSQL.

MariaDB is a free powerful, open source object-relational database system.

Learning how to work with relational databases is one of the best ways to boost your career!   MariaDB is getting popular each day and many companies are using MariaDB as a relational database. 

This course will  start with you from zero level experience in MariaDB and relational databases , starting to level up as we are going through the course.   

This course will guide you how to install MariaDB on a local machine as well as creating instances on the cloud, on the one of the most required cloud services providers in the market...Amazon Web Services (AWS).

You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)

Some of the points we will be covering :

  • How to install the MariaDB.

How to use HeidiSQL.

  • Create databases with MariaDB.*

Understand what is schema and how to create a schema.

  • How* create tables using SQL script.

How to create tables using pgAdmin.

  • Use different datatypes available in MariaDB.

How to create views.

  • Understand what does DBaaS mean.

You will learn how to create users to access your database based on specific permissions you gave them.

  • How to create different constraints.

Create primary keys in MariaDB.

  • Create foreign keys in MariaDB.*

How to import a bulk of data in and out of your database.

  • Generate Entity Relationship Diagram (ERD) using another powerful tool called DbVisualizer.

Give your CV a huge boost by learning MariaDB...do not hesitate enrolling.