MariaDB Standard Developer

Opis

This course will help developers understand how to set up MariaDB and develop applications using MariaDB with their choice of the Java, R2DBC, Node.js, Python, PHP, Perl, C/C++ or .NET programming languages.

Developers will gain hands-on experience via lab exercises that explore how to use native and non-native MariaDB connectors to access MariaDB databases, manipulate and extract data, run queries efficiently and handle errors.

Level: Basic
Course duration: 3 days

Cel

Teaches developers how to set up and develop applications with MariaDB using multiple programming languages: Java, R2DBC, Node.js, Python, PHP, Perl, C/C++ and .NET. Course includes hands-on lab exercises using native and non-native MariaDB connectors to manipulate and extract data, run queries and handle errors.

Grupa docelowa:

Uwagi:

CLASS DETAILS

This is a 3-day course. Each day is a 6.5-hour session that includes instructor-led training, followed by hands-on exercises. We will keep a 30 min lunch/coffee break at 12:00.

Formats: In person, live virtual, or on-demand course

NOTE - This course will also prepare students for the MariaDB Certified Database Administrator Associate exam

LIVE LEARNING: ONLINE AND ON-SITE

MariaDB offers flexible training options so your team can learn the way that works best for them: online or on-site. The most popular option is the virtual classroom, which uses technology such as Zoom. An instructor will speak through an audio feed and will share screens on their computer, including a slide presentation and a terminal window. Students can interact with the instructor and other students via a text-chat interface and through their audio feeds. A copy of the slide presentation and lab exercises workbook will be provided so students may annotate them during class.

Wymagania:

Prerequisites:

• Basic MariaDB skills
• Familiarity with database fundamentals
• Experience developing simple applications in a programming language such as Java, R2DBC, Node.js, Python, PHP, Perl, C/C++
  or .NET

Recommendation:

• Prior experience with MariaDB

Konspekt

Students will learn a wide range of skills for developing applications using MariaDB, including the following:

• Describe the client/server architecture of MariaDB
• Understand the most commonly used storage engines in MariaDB, such as InnoDB, Xpand, ColumnStore, Aria, S3, MyRocks and Spider
• Invoke MariaDB client programs and describe both the native and non-native connectors that provide connectivity for client programs
• Perform basic administrative tasks such as creating users, enabling MariaDB server logs and bulk importing data
• Understand MariaDB schema objects, including temporal tables, built-in functions, stored procedures, sequences, flexible and invisible columns, views, triggers and events
• Describe and use common table expressions and window functions
• Evaluate data types and character sets
• Explain the purpose of data modeling and database design
• Secure MariaDB using data-in-transit encryption and best practices for network and server security
• Use SQL statements to retrieve and modify the contents of database tables
• Write multiple-table queries and use nested queries in SQL statements
• Describe the concept of joining tables and list the types of joins
• Understand database compatibility enhancements such as PL/ SQL support 
• Access JSON data in a document store
• Program with MariaDB connectors to access data, handle errors and run queries efficiently from applications written in both native and non-native MariaDB connectors
• List the various metadata access methods available, and retrieve metadata