Learn Mariadb From Scratch

Learn how to query MariaDB Databases using HeidiSQL

What you'll learn
Install MariaDB
Learn How to Use HeidiSQL
Create A Table
Populate A Table
Update A Table
Delete Rows
Requirements
Download and Install MariaDB ( We'll cover this in this course)
Description
If you are new to databases MariaDB might be a good place to start learning about them. MariaDB is a free and open source relational database management system. By open source it means people can contribute and make it even better.It was developed by some of the original developers that created another famous database management system known as MySQL which has since been acquired by the database giant oracle.
MariaDB is used by some very famous internet juggernauts like Facebook, Google and Wikipedia just to mention a few.It has a lot of similarities with MySQL .
  The current version of MariaDB is 10.1 and it can be installed on several platforms like windows ,Mac os and Linux.
When MariaDB IS installed it also installs HeidiSQL which is a useful administrative tool that you can use to communicate with the MariaDB databases .
Some of the tasks that can be performed using HeidiSQL includes the following:
Creating new databasesCreating TablesCreating ViewsCreating stored proceduresCreating user accounts and managing accessGenerating queriesGenerating reportsProviding an editor for queries to be written
In this very basic beginners course you will learn:
How to download and install MariaDB on a windows 7 operating systemHow to create a session and connect to the MariaDB database using HeidiSQLHow to use HeidiSQLHow to create a TableHow to populate a TableHow to update a table How to delete rows
This is a video based course with easy to follow examples.
I look forward to welcoming you on the course.
Thank You

Overview

Section 1: It's All about Maria's DB

Lecture 1 Introduction

Lecture 2 What is MariaDB

Lecture 3 Download and Install MariaDB

Lecture 4 What Heidi Can do

Lecture 5 Database concepts

Lecture 6 Creating a table on MariaDB

Lecture 7 Adding Data into Maria's Table

Lecture 8 Changing Data inside Maria's Table

Lecture 9 Viewing data inside MariaDB

Lecture 10 Removing Data From MariaDB

Lecture 11 Using Aliases

Lecture 12 Conclusion

Lecture 13 Thank You

Anyone new to databases,Anyone interested in learning something new,Anyone new to MariaDB