SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis

MariaDB 10.5    |    Beginner
  • 9 Videos | 1h 4m 48s
  • Includes Assessment
  • Earns a Badge
Likes 23 Likes 23
MariaDB is a popular tool for SQL programming. To use it, you must first know how to install it on your machine and set it up for your needs. In this course, you'll learn how to install MariaDB for macOS and MS Windows. You'll then run MariaDB from a command line interface (CLI) and create a new custom user for MariaDB from the CLI -an essential step for running MariaDB from a client such as DBeaver, as connecting as root is not considered a best practice. Next, you'll work with DBeaver and recognize how it is a handy user interface to interact with a MariaDB server. Finally, you'll run a few basic MariaDB commands and queries from DBeaver.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    install and launch MariaDB on Microsoft Windows, then connect to it from the command prompt
    install and launch DBeaver as a user interface for MariaDB on Microsoft Windows
    install and launch MariaDB on macOS, then connect to it from the terminal
    install and launch DBeaver as a user interface for MariaDB on macOS
  • execute commands from the DBeaver environment
    load data from a CSV file into a table using MariaDB
    outline how to insert rows into tables
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 25s
    UP NEXT
  • Playable
    2. 
    Installing MariaDB on Windows
    8m 5s
  • Locked
    3. 
    Installing DBeaver on Windows
    6m 11s
    FREE ACCESS
  • Locked
    4. 
    Installing MariaDB on macOS
    10m 43s
    FREE ACCESS
  • Locked
    5. 
    Installing DBeaver on macOS
    10m 7s
    FREE ACCESS
  • Locked
    6. 
    Getting Started with MariaDB
    10m 22s
    FREE ACCESS
  • Locked
    7. 
    Loading Data from a File
    7m 24s
    FREE ACCESS
  • Locked
    8. 
    Inserting into Tables
    7m 33s
    FREE ACCESS
  • Locked
    9. 
    Course Summary
    1m 59s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE SQL Programming with MariaDB: Analyzing Relational Data
Likes 9 Likes 9  
COURSE Database Fundamentals: Working with SQL Commands
COURSE Database Fundamentals: Getting Started with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Relational Database Concepts
Likes 223 Likes 223  
COURSE MySQL Database Development: Introduction
Likes 109 Likes 109  
COURSE Expert Insights on Personal Productivity
Likes 1438 Likes 1438