Last updated 6/2021
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 135.73 MB | Duration: 1h 10m
Learn how to query MariaDB Databases using HeidiSQL
What you'll learn
Learn How to Use HeidiSQL
Create A Table
Populate A Table
Update A Table
Download and Install MariaDB ( We'll cover this in this course)
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.
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
Please Help Me Click Connect Icon Below Here and Share News to Social Network | Thanks you !