We will look at usage and examples of the 108 main internal functions provided by MariaDB using the HeidiSQL development tool.
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's 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?
One way to use SQL statements more efficiently when processing data with MariaDB is to leverage its built-in functions. Leveraging existing functions offers advantages in terms of accuracy and efficiency, rather than developing procedures or functions on an as-needed basis. Most of the functionality developers and analysts need is already implemented as built-in functions. Therefore, if you're familiar with the types and usage of MariaDB's built-in functions, you'll be able to achieve the desired results more accurately and in less time.
In this course, you'll learn about the most frequently used internal functions among the countless internal functions provided by MariaDB, along with examples of their use and application. A thorough understanding of the internal functions guaranteed and supported by MariaDB will provide a technical foundation for generating and analyzing various statistics.
Suitable for each section of the lecture
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 .
A person in charge of tasks that require programming using MariaDB's internal functions
Programmers who are more familiar with databases and SQL than with other languages.
IT developers and data analysts interested in data analysis and utilization
Q. Why should I learn?
When dealing with data, leveraging SQL and internal functions provided by the database can be faster, more accurate, and more efficient than using other languages.
Q. Is this a course that non-majors can also take?
It's no more difficult 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 section 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,605
Learners
64
Reviews
27
Answers
4.8
Rating
10
Courses
안녕하세요 『소프트웨어알림장』입니다. 데이터베이스 및 미들웨어 애플리케이션 개발, 응용 분야의 경험을 쌓아왔으며 MySQL과 MariaDB를 바탕으로 SQL을 활용한 강좌들을 제작하고 있습니다. 유튜브 채널 "SQL뱅크" 를 운영하고 있습니다.
Hello, this is "SQL BANK". I have accumulated experience in developing database and middleware applications and in various application fields. I create tutorials utilizing SQL based on MySQL and MariaDB. I also run a YouTube channel called "SQL BANK".
All
25 lectures ∙ (2hr 40min)
Course Materials:
$18.70
Check out other courses by the instructor!
Explore other courses in the same field!
