MariaDB For Developers Training

 >>  MariaDB For Developers Training

MariaDB For Developers Training


 (4.9) | 750 Ratings


Introduction


MariaDB For Developers Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

MariaDB For Developers Course Details

Module 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

Module 2: The Database Structures used in MariaDB

Creating Databases and Tables

  • Creating a Database
  • Create tables
  • Inserting the data
  • Examples

Altering tables

  • Prudence when altering table
  • Essential changes
  • Optional changes
  • Indexes
  • Examples

Module 3: Basics on handling data

Inserting data

  • The syntax
  • Real-time examples
  • Other possibilities
  • Examples

Selecting data

  • Basic selection
  • Selecting by criteria
  • Ordering results
  • Limiting results
  • Combining tables
  • Expressions and the like
  • Counting and grouping results
  • Examples

Updating and deleting data

  • Updating data
  • Deleting the data
  • Examples

 Joining and Subquerying Data

  • Merging Results
  • Joining Tables
  • Subqueries
  • Examples

Module 4: Builtin functions

String Functions

  • Formatting Strings
  • Extracting Text
  • Searching Strings and Using Lengths
  • Converting String Types
  • Compression String
  • Examples

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
  • Examples

Aggregate and Numeric Functions

  • Aggregate functions
  • Numeric functions
  • Examples

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

MariaDB For Developers Course Details

Module 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

Module 2: The Database Structures used in MariaDB

Creating Databases and Tables

  • Creating a Database
  • Create tables
  • Inserting the data
  • Examples

Altering tables

  • Prudence when altering table
  • Essential changes
  • Optional changes
  • Indexes
  • Examples

Module 3: Basics on handling data

Inserting data

  • The syntax
  • Real-time examples
  • Other possibilities
  • Examples

Selecting data

  • Basic selection
  • Selecting by criteria
  • Ordering results
  • Limiting results
  • Combining tables
  • Expressions and the like
  • Counting and grouping results
  • Examples

Updating and deleting data

  • Updating data
  • Deleting the data
  • Examples

 Joining and Subquerying Data

  • Merging Results
  • Joining Tables
  • Subqueries
  • Examples

Module 4: Builtin functions

String Functions

  • Formatting Strings
  • Extracting Text
  • Searching Strings and Using Lengths
  • Converting String Types
  • Compression String
  • Examples

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
  • Examples

Aggregate and Numeric Functions

  • Aggregate functions
  • Numeric functions
  • Examples

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry