Course Duration: 1 day
Course Overview:
MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google. MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it
is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features.
Course Highlights
– Writing queries
– Creating and updating databases and tables
– Using MariaDB built-in functions
– Sorting and filtering data
– Updating tables with triggers
– Working with subselects and views
– Creating and using a stored function
Pre-requisite
This is a beginner course. No SQL or programming language knowledge is required.
Target Audience
– Website administrators
– Web developers
Course Outline
Module 1 Get Ready
– What is SQL?
– Why Use MariaDB
– Download MariaDB
– MariaDB Command Line
Module 2: Terminology
– Database/Schema
– Table
– Column/Field
– Row/Record
Module 3: Data Types
– INT
– DECIMAL
– VARCHAR
– CHAR
– TEXT
– DATE, TIME & YEAR
– TIMESTAMP & DATETIME
– ENUM
– SET
– NULL
– Character Set
Module 4 Basic Queries
– Database
– Tables
– Create
– Read
– Update
– Delete
Module 5 Functions
– Math Functions
– Date/Time Functions
– String Functions
– Operators
– Group By
Module 6: Advanced Queries
– Inserting & Deleting Records
– Joining Table
Module 7 Relational Database
– Relational Database Concept
– Foreign Key
