강의

멘토링

로드맵

BEST
Programming

/

Database

MariaDB client development, HeidiSQL

Learn how to write SQL queries and work with databases using the MariaDB client development tool HeidiSQL.

(4.9) 29 reviews

1,152 learners

  • swa
SQL
MariaDB
HeidiSQL
DBMS/RDBMS
Data Engineering

Reviews from Early Learners

What you will learn!

  • We will take a detailed look at the overall usage of MariaDB client development tool, HeidiSQL.

  • MariaDB's host, schema, user structure, etc.

Learn about HeidiSQL , a MariaDB client development tool.
Take your database design & management to the next level! 🏃

HeidiSQL ,
For what purpose
Would it be good to learn it?

1 When you want to develop tables, views, functions, and SQL queries through MariaDB or MySQL database.
2. For those who want to use free development tools as well as paid development tools.
3 If you want to learn SQL and DATABASE in some way, but are worried because you don't know which one is good
4 App developers who need to handle databases as quickly as possible with as little effort and time as possible.

Please read!

  • All videos of this course can be viewed for free on the YouTube channel ("SQL Bank"). (Study materials not provided)

  • If you watch on Inflearn, you will receive an ad-free environment + a lecture file with available resources . Please keep this in mind when purchasing a course.

Learn more about:

  • (1) Creating a connection session and table - Creating a connection session - Creating a table - Entering data
  • (2) Query window and result tab - Executing a query in the query window - Examining the result tab (grid row) function
  • (3) Export grid rows (result sets) - Export grid rows (result sets) in various formats - to clipboard and file
  • (4) Export database to SQL - Export database to SQL - Create backup and recovery scripts, create by file/compress and directory units, etc.
  • (5) Import CSV file - Import a text file containing comma-separated data into a table.
  • (6) Copy/Copy selected rows in the result window, SQL reconstruction, Log window - Copy in the result window, Copy selected rows function - Organize SQL neatly - SQL log window and setting functions
  • (7) Find text string (query window, result window, server) - Find string in SQL query window - Find string in grid result window - Find text in server
  • (8) How to use the Data tab - Input/edit/delete in the Data tab - Sorting in ascending/descending order through column header values - Adding a WHERE clause through a filter - Paging function for records viewed in the Data tab
  • (9) Snippets and SQL functions, SQL keywords, etc. - Table columns, SQL functions, SQL keywords - Snippets, query history
  • (10) Query Profile, Parameter Linking - Query Profile, Parameter Linking

Recommended for
these people

Who is this course right for?

  • If you are a member of the crew who wants to learn SQL and DATABASE in some way but is worried about what would be best, here is the answer!

  • Mr. Kim, who is in charge of app development among the S/W, always has to keep in mind the entire process from apps to web servers, middleware, and databases!

  • Park, the manager, is not familiar with the new database that was urgently changed according to the requirements, but he has to design and provide a guide right away!

Need to know before starting?

  • database

  • SQL

Hello
This is

2,610

Learners

65

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

10 lectures ∙ (1hr 45min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

29 reviews

4.9

29 reviews

  • ericserra4918님의 프로필 이미지
    ericserra4918

    Reviews 99

    Average Rating 4.9

    5

    100% enrolled

    Thank you for your detailed explanation. If possible, please open a new lecture on configuring load balancer, auto scaling, CDN, and DNS as 3Tier (WEB-WAS-DB) with Naver Cloud.

    • swa
      Instructor

      Thank you for your kind words and evaluation. Unfortunately, the courses and content you suggested are far from my area of expertise, so it seems difficult for me.

  • everick93569님의 프로필 이미지
    everick93569

    Reviews 315

    Average Rating 4.9

    5

    10% enrolled

    Thank you~!

    • hwangsangjin님의 프로필 이미지
      hwangsangjin

      Reviews 8

      Average Rating 5.0

      5

      30% enrolled

      Thank you for the great lecture!

      • parkchanwoo73617님의 프로필 이미지
        parkchanwoo73617

        Reviews 50

        Average Rating 4.8

        5

        100% enrolled

        Thank you for the great lecture :)

        • duvet03152428님의 프로필 이미지
          duvet03152428

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          I was using Oracle and needed to use MariaDB, so I got HeidiSQL and was confused about what it was. Thank you for the simple and good lecture!

          $8.80

          swa's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!