Introduction to MariaDB and HeidiSQL For Beginners
4.0 (86 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,478 students enrolled

Introduction to MariaDB and HeidiSQL For Beginners

Practical guide to learn the basics of the powerful MariaDB | Learn MariaDB From Scratch
4.0 (86 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,478 students enrolled
Created by Ahmad Mohey
Last updated 2/2020
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 3 articles
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Install MariaDB and HeidiSQL.
  • Brief Introduction to cloud databases.
  • Understand basics of MariaDB.
  • Create MariaDB database instances on Amazon Web Services (AWS).
  • Create MariaDB databases and schemas.
  • Create and manage users in MariaDB.
  • Create tables using SQL script.
  • Create tables using HeidiSQL
  • Understand the different data types available in MariaDB.
  • Understand Constraints and how to apply them.
  • Create primary keys and foreign keys in different ways.
  • Design relational databases and create relationships between tables in MariaDB.
  • Generate Entity Relationship Diagram (ERD).
  • How to grant privileges in MariaDB.
Course content
Expand all 21 lectures 01:53:35
+ Databases, Users and Privileges In MariaDB
4 lectures 13:14
Create Your First Database In MariaDB
03:33
Create Users
07:00
Exercise : Create Database and User
02:12
Summary
00:29
+ Database Tables, Primary and Foreign Keys In MariaDB
12 lectures 01:19:12
Database Tables
11:58
Data Types
07:01
Primary Keys
10:03
Constraints
06:49
Exercise : Create Tables Employees and Jobs
08:58
Foreign Keys
08:47
Exercise : Create Table Previous Experience
10:38
Import Data Into Database
04:04
Exercise : Import Data (Employees and Cities)
01:51
Entity Relationship Diagram (ERD) - DbVisualizer
07:33
Summary
00:54
The Final Lecture
00:36
Requirements
  • MariaDB (Free)
  • HeidiSQL (Free)
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.

Who this course is for:
  • Complete beginners, no prior experience is required.
  • Anyone want to learn MariaDB and relational databases.
  • Anyone want to become familiar with SQL syntax.