Introduction to MariaDB and HeidiSQL For Beginners

欢迎学习 MariaDB 和 HeidiSQL 入门课程，这是学习 MariaDB 和 HeidiSQL 基础知识的实用指南。
MariaDB 是一个免费的功能强大的开源对象关系数据库系统。
学习如何使用关系数据库是提升职业生涯的最佳方式之一！MariaDB 每天都在流行，许多公司正在使用 MariaDB 作为关系数据库。
本课程将从您对 MariaDB 和关系数据库的零级经验开始，随着我们学习本课程而开始升级。
本课程将指导您如何在本地计算机上安装 MariaDB 以及如何在云上创建实例，该实例是市场上最需要的云服务提供商之一……亚马逊网络服务 (AWS)。

Practical guide to learn the basics of the powerful MariaDB | Learn MariaDB From Scratch

Video: .MP4, 1280×720 30 fps | Audio: AAC, 48kHz, 2ch | Duration: 01:53:35
Genre: eLearning | Language: English + Subtitles | Size: 717 MB

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.

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.