Learn MariaDB From Scratch
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 databases
- Creating Tables
- Creating Views
- Creating stored procedures
- Creating user accounts and managing access
- Generating queries
- Generating reports
- Providing 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 system
- How to create a session and connect to the MariaDB database using HeidiSQL
- How to use HeidiSQL
- How to create a Table
- How to populate a Table
- How 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
Who this course is for:
- Anyone new to databases
- Anyone interested in learning something new
- Anyone new to MariaDB
Instructor
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.