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


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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.



Expected Duration (hours)
1.1

Lesson Objectives

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

  • 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
  • Course Number:
    it_dasqpmdj_01_enus

    Expertise Level
    Beginner