강의

멘토링

커뮤니티

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 gain after the course

  • 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,616

Learners

67

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

  • ericserra님의 프로필 이미지
    ericserra

    Reviews 100

    Average Rating 4.9

    5

    100% enrolled

    세심한 설명 감사 드립니다. 여건이 되신다면 Naver Cloud로 로드밸런서, 오토스케일링, CDN, DNS를 3Tier(WEB-WAS-DB)로 연동 구성하는 신규강의를 오픈 부탁드립니다.

    • SQL뱅크
      Instructor

      좋은 말씀과 평가 감사드립니다. 아쉽게도 제안해주신 강좌나 내용은 제 전문 분야와 거리가 있어 어려울 듯 합니다.

  • everick9님의 프로필 이미지
    everick9

    Reviews 317

    Average Rating 4.9

    5

    10% enrolled

    감사합니다~!

    • 상진님의 프로필 이미지
      상진

      Reviews 8

      Average Rating 5.0

      5

      30% enrolled

      좋은 강의 감사합니다 !

      • 누팍님의 프로필 이미지
        누팍

        Reviews 50

        Average Rating 4.8

        5

        100% enrolled

        좋은 강의 감사합니다:)

        • 김대한님의 프로필 이미지
          김대한

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          oracle쓰다가 mariaDB를 써야할 일이 생겨서 heidiSQL 받았다가 이게 뭐지뭐지 당황했는데 간단하고 좋은 강의 감사합니다!

          $8.80

          swa's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!