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 courseinstall and launch MariaDB on Microsoft Windows, then connect to it from the command promptinstall and launch DBeaver as a user interface for MariaDB on Microsoft Windowsinstall and launch MariaDB on macOS, then connect to it from the terminalinstall and launch DBeaver as a user interface for MariaDB on macOS
-
execute commands from the DBeaver environmentload data from a CSV file into a table using MariaDBoutline how to insert rows into tablessummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 25sUP NEXT
-
2.Installing MariaDB on Windows8m 5s
-
3.Installing DBeaver on Windows6m 11s
-
4.Installing MariaDB on macOS10m 43s
-
5.Installing DBeaver on macOS10m 7s
-
6.Getting Started with MariaDB10m 22s
-
7.Loading Data from a File7m 24s
-
8.Inserting into Tables7m 33s
-
9.Course Summary1m 59s
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.