인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
Programming

/

Database

MariaDB client development, internal functions

We will look at usage and examples of the 108 main internal functions provided by MariaDB using the HeidiSQL development tool.

19 students are taking this course

MariaDB
Thumbnail

This course is prepared for Basic Learners.

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! 🤓

Have you ever had concerns like this?

😇 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?

Learn MariaDB internal functions 💡

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


Learn things like this 📚

1. Learning mainly about useful internal functions

  • It is divided into five sections: time functions, string functions, number processing functions, IF/CASE control statements, and group functions. We will select and inform you of frequently used internal functions for each section.


2. Various information related to internal functions

  • Information that you need to know about internal functions and general database knowledge is also included.


3. Various examples

  • It provides detailed examples and explanations based on lesson plans organized in mind map format.


4. Use HeidiSQL development tools

  • Run the provided examples directly using the HeidiSQL development tool and check the results.

※ Some examples are referenced from the MariaDB reference site .


I recommend this to these people 🙋

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


Expected Questions Q&A 💬

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.


Recommended for
these people!

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

Hello
This is

2,657

Students

64

Reviews

27

Answers

4.8

Rating

11

Courses

안녕하세요 소프트웨어알림장』입니다. 데이터베이스 및 미들웨어 애플리케이션 개발, 응용 분야의 경험을 쌓아왔으며 MySQL과 MariaDB를 바탕으로 SQL을 활용한 강좌들을 제작하고 있습니다. 유튜브 채널 "SQL뱅크" 를 운영하고 있습니다.

Curriculum

All

25 lectures ∙ (2hr 40min)

Lecture resources

are provided.

Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!