EncartaLabs

MariaDB for Developers

( Duration: 5 Days )

MariaDB is one of the most popular database servers and it has been developed by the original developers of MySQL. MariaDB is open source and as a relational database it provides SQL interface for data access.

MariaDB for Developers training course is designed particularly for MariaDB Developers. The course gives a complete understanding of a MariaDB (or MySQL) database with practical experience of using SQL commands.

Features of MariaDB:

  • MariaDB is open source.
  • Security releases are more transparent and quick.
  • Migration is easy and highly compatible.
  • Improved performance and is radically faster than MySQL

By attending MariaDB for Developers workshop, attendees will learn:

  • Basics of MariaDB and Installation of MariaDB.
  • Database structures in MariaDB.
  • Functions in MariaDB.
  • Data handling in MariaDB.

  • The course MariaDB for developers is most helpful for Application Developers and IT Developers. Benefits include ability to build applications, data handling and understanding concepts of Database structures in MariaDB.

COURSE AGENDA

1

The Software Installation

  • Installing MYSQL and MariaDB
    • The installation Packages
    • Licensing
    • Finding the software
    • Choosing a Distribution
    • The_AMP Alternatives
    • Post installation
  • The Basics and the mysqlClient
    • The mysql Client
    • Connecting to the server
    • Starting to explore Databases
2

The Database Structures used in MariaDB

  • Creating Databases and Tables
    • Creating a Database
    • Create tables
    • Inserting the data
  • Altering tables
    • Prudence when altering table
    • Essential changes
    • Optional changes
    • Indexes
3

Basics on handling data

  • Inserting data
    • The syntax
    • Real-time examples
    • Other possibilities
  • Selecting data
    • Basic selection
    • Selecting by criteria
    • Ordering results
    • Limiting results
    • Combining tables
    • Expressions and the like
    • Counting and grouping results
  • Updating and deleting data
    • Updating data
    • Deleting the data
  • Joining and Subquerying Data
    • Merging Results
    • Joining Tables
    • Subqueries
4

Builtin functions

  • String Functions
    • Formatting Strings
    • Extracting Text
    • Searching Strings and Using Lengths
    • Converting String Types
    • Compression String
  • Date and Time Functions
    • Date and Time Data types
    • Current Date and Time
    • Extracting Date and Time components
    • Formatting dates
    • Adjusting to standards and TimeZones
    • Adding and subtracting Dates and Time
    • Comparing Dates and times
  • Aggregate and Numeric Functions
    • Aggregate functions
    • Numeric functions

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top