We will look at usage and examples of the 108 main internal functions provided by MariaDB using the HeidiSQL development tool.
What you will learn!
Time/string/number processing and control statements and group functions provided by MariaDB
Introduction and explanation of 108 major internal functions
Examples of applications that can be applied to real work
Database general knowledge related to internal functions
How to write SQL statements efficiently?
Learn MariaDB internal functions! 🤓
😇 I worked hard to write a program, but it turns out there is already a database function that supports it.
🥺 I want to create statistical queries or programs using SQL, but I don't know where to start.
🥲 What should I do if the same application returns different results on different web servers?
A way to use SQL statements more efficiently when processing data using MariaDB is to utilize the functions provided internally. It is more advantageous in terms of accuracy and efficiency to utilize existing functions than to develop procedures or functions as needed. Most of the functions required by developers or analysts are already implemented as built-in internal functions. Therefore, if you are familiar with the types and usage of internal functions already provided in MariaDB, you will be able to obtain the desired results more accurately in a short period of time.
In this lecture, you can learn about the frequently used internal functions provided by MariaDB and their usage and application examples. If you are familiar with the internal functions guaranteed and supported by MariaDB, it can be a technical foundation for creating and producing various statistics.
Suitable for each section of the lecture
A simple example
With mind map teaching materials
The entire flow at a glance
Easy to use in practice
Learning with MariaDB
※ Some examples are referenced from the MariaDB reference site .
People who need to program using MariaDB internal functions
Programmers who are more familiar with databases and SQL than other languages.
IT developers and data analysts interested in data analysis and utilization
Q. Why should I learn?
When dealing with data, it can be faster, more accurate, and more efficient to use SQL and internal functions provided by the database rather than other languages.
Q. Is this a lecture that non-majors can also take?
It's no harder than learning SQL syntax and basics.
Q. Is there anything I need to prepare before attending the lecture?
You will need MariaDB database and basic SQL knowledge.
Q. What level of content is covered in the class?
This explains all 108 internal functions and reserved words that are considered to be frequently used among the internal functions provided on the MariaDB reference page.
Who is this course right for?
IT developers and data analysts interested in data analysis and utilization
A person in charge of tasks that require programming using internal functions
Programmers who are more familiar with databases and SQL than other languages.
Need to know before starting?
Basic MariaDB and SQL skills
2,657
Students
64
Reviews
27
Answers
4.8
Rating
11
Courses
All
25 lectures ∙ (2hr 40min)
are provided.