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

  • 2m 25s
  • 8m 5s
    Learn how to install and launch MariaDB on Microsoft Windows, and then connect to it from the command prompt. FREE ACCESS
  • Locked
    3.  Installing DBeaver on Windows
    6m 11s
    Learn how to install and launch DBeaver as a user interface for MariaDB on Microsoft Windows. FREE ACCESS
  • Locked
    4.  Installing MariaDB on macOS
    10m 43s
    In this video, you will learn how to install and launch MariaDB on macOS, and then how to connect to it from the terminal. FREE ACCESS
  • Locked
    5.  Installing DBeaver on macOS
    10m 7s
    In this video, find out how to install and launch DBeaver as a user interface for MariaDB on macOS. FREE ACCESS
  • Locked
    6.  Getting Started with MariaDB
    10m 22s
    During this video, you will learn how to execute commands from the DBeaver interface. FREE ACCESS
  • Locked
    7.  Loading Data from a File
    7m 24s
    Learn how to load data from a CSV file into a table using MariaDB. FREE ACCESS
  • Locked
    8.  Inserting into Tables
    7m 33s
    In this video, you will learn how to insert rows into tables. FREE ACCESS
  • Locked
    9.  Course Summary
    1m 59s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.