필요할 때 찾아 쓰는 SQL 쿼리북, Part I
SQL뱅크
가끔 데이터 처리가 막혀 답답한 경우가 있습니다. 전문 프로그래머나 개발자도 아닌데 파이썬이나 Java 같은 생소한 분야를 배우기엔 시간도 모자라고 쉬워 보이지도 않죠. 자주 쓰는 거라면 엑셀과 SQL 기초 정도가 전부인 분들을 위해 준비했습니다. 필요할 때 찾아 쓰는 SQL 쿼리북, 첫 번째 파트입니다.
초급
SQL, MariaDB, HeidiSQL
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.
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 these concerns?
😇 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?
Learn MariaDB internal functions 💡
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
Learn things like this 📚
1. Learning focused on 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 you need to know about internal functions and general database knowledge is also included.
3. Various examples
- We provide detailed examples and explanations based on lesson plans organized in mind map format.
4. Using 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 🙋
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
Expected Questions Q&A 💬
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.
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
2,606
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".
Curriculum
All
25 lectures ∙ (2hr 40min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
Not enough reviews.
Please write a valuable review that helps everyone!
Limited time deal ends in 3 days
$17,320.00
25%
$18.70
swa's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
