강의

멘토링

커뮤니티

BEST
Programming

/

Database

[7-day completion] Thinking database modeling

[TPC DB!] A course that allows you to learn database modeling while thinking, learn database modeling step by step, and master everything from database modeling to web programming implementation all at once.

(4.7) 29 reviews

556 learners

Level Basic

Course period Unlimited

  • bitcocom
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
ERD
ERD
backend
backend
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
ERD
ERD
backend
backend

Reviews from Early Learners

Reviews from Early Learners

4.7

5.0

조준용

17% enrolled

Perfect! I understood it very well. Thank you so much.

5.0

blueday

100% enrolled

Thank you for your hard work.

5.0

yongtaek.lee

32% enrolled

Thank you for the detailed explanation.

What you will gain after the course

  • How to model a database and what the procedure is

  • Creating various outputs through modeling

  • How to use SQL statements (MySQL)

  • How to use modeled data in your programs

  • Reverse engineering, forward engineering

  • IntelliJ web development environment (Java, Tomcat)

  • Through this course, you can learn database modeling step by step and learn how to apply and utilize the models produced step by step to DBMS. You can test your individual learning ability through a comprehensive exam and learn the technologies used in database (modeling, SQL) and backend development through program implementation .

  • Thinking Database Modeling Process

  • Thinking Database Modeling Learning Sequence

After taking the lecture, you will be able to create results like this.

You can create modeling output (1)

Outputs from conceptual modeling (ERD)

You can use TOOL (2)

You can use the TOOL to create a model.

You can utilize modeled data (3)

You can use data created through modeling.
You can implement an MVC-based online shopping cart.

I can understand the IntelliJ web development environment (4)

You can understand the IntelliJ-based Java web development environment.

  • After taking this course, you will be able to model databases, easily analyze SQL statements, and understand the overall structure of a database ( DBMS) .

  • You can develop practical skills through hands-on training, from database modeling to web programming implementation.

  • You can go beyond simple SQL statements to analyze SQL statements and use advanced SQL.


  • Database modeling improves program analysis capabilities and backend development capabilities.

  • 0 -

    Installing MySQL 8.x (DBMS)

    https://dev.mysql.com/downloads/

  • 1 -

    Database Requirements Analysis

    Understand the requirements and requirements of a database system.

  • 2 -

    Conceptual Data Modeling (ERD)

    Create an entity-relationship diagram (ERD) to visualize the data structure.

  • 3 -

    Logical Data Modeling (RM)

    Develop a relational model that represents data relationships and constraints.

  • 4 -

    Physical Data Modeling (PM) Designing a practical database schema for a database management system.

  • 5 -

    Structured Query Language (SQL)

    Learn SQL to interact with databases and perform CRUD operations.

  • 6 -

    Perform data modeling tasks

    Practice implementing data modeling concepts using real-world scenarios .

  • 7 -

    Thinking Database Modeling Comprehensive Exam

  • 8 - Web Programming

    From database modeling to web programming implementation.


(1) Requirements analysis

After analyzing the client's requirements, learn how to create a requirements definition document and object definition document (entities, attributes, relationships).

(2) Conceptual modeling

Learn the process of creating a model using a visual tool called ERD, which is derived from entities, attributes, and relationships through requirements.

(3) Logical modeling

Learn how to create a logical relational model (RM) structured in a table format using a model created through ERD.

(4) Physical modeling

Learn the process of creating a table definition (type, length, constraints, etc.) using a logical model and then creating a physical model by looking at the table definition.

(5) Generate SQL script
Create a table in the database by creating a SQL schema using forward engineering using the created physical model.

(6) SQL practice
Learn SQL to interact with databases, query data, and perform CRUD operations.

(7) Comprehensive database modeling exam
A comprehensive exam designed to test your understanding and application of database modeling concepts.

(8) From modeling to web programming
From database modeling to web programming implementation. IntelliJ IDEA Community Edition, Tomcat 9, MVC Framework.

Things to note before taking the course

Practice environment

  • Operating System and Version (OS): Window

  • Tools used: MySQL 8.x, Workbench 8, IntelliJ IDEA Community Edition,

    JDK 11 or higher,

    Tomcat 9,

    Servlet, JSP,

    MyBatis 3.x,

    Bootstrap 4.x,

    MVC Framework

  • To learn the MVC-based online shopping cart web programming implementation, you need to know the basic concepts of Java, Servlet, JSP, and MyBatis .


Learning Materials

  • Lecture notes provided in PDF format, 135 pages

  • Web practice source code available on GitHub

  • Files required during the lecture are attached separately to the video.
    Lecture: 02_Thinking Database Modeling_Table of Contents (Lecture materials, GitHub link attached)

Recommended for
these people

Who is this course right for?

  • Database beginner

  • Beginner to programming (coding)

  • People interested in database modeling

  • People who want to learn SQL statements

  • People who need to understand the IntelliJ web development environment

Need to know before starting?

  • DB modeling part (SQL basics)

  • Web programming part (understanding Java, Servlet, JSP, MVC)

Hello
This is

8,545

Learners

650

Reviews

670

Answers

4.9

Rating

14

Courses

Hello, I am instructor Park Mae-il.
I run a SW Education Center and provide consulting and outsourced SW training for universities, government offices, and corporations.


📄 Key Teaching Experience and more

- Goorm Specialized High School Major Camp Lectures (Full Stack Course)
- Industry-Academic Cooperation Teacher at Software Meister High School
- Gwangju Artificial Intelligence Academy Lectures
- Fast Campus Backend Bootcamp Lectures
- Director of Education and Lecturer at Smart Human Resources Development Center
- KEPCO (Korea Electric Power Corporation) In-House Coding Commissioned Training
- Hanyang University ERICA Online Lectures
- Management of Bit Software Education Center (Overseas Employment, Government-funded Training)
- SW Recruitment Training Project (Ministry of Science, ICT and Future Planning)
- Vocational Skills Development Training Teacher for AI, IT Development, etc.
* Education Inquiries and Partnerships (KakaoTalk Channel)

🎤 Online Educational Content Provider

Inflearn: Java, DB, MVC, Spring, Spring AI & Agent, IoT
Fast Campus: Java, Spring Boot

email : bitcocom@empas.com

Curriculum

All

47 lectures ∙ (17hr 17min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

29 reviews

4.7

29 reviews

  • abcd123123님의 프로필 이미지
    abcd123123

    Reviews 327

    Average Rating 5.0

    5

    6% enrolled

    • bitcocom
      Instructor

      I hope the lecture will be helpful to you. Thank you.

  • haklae07242777님의 프로필 이미지
    haklae07242777

    Reviews 1

    Average Rating 5.0

    5

    32% enrolled

    • ours1903026699님의 프로필 이미지
      ours1903026699

      Reviews 1

      Average Rating 5.0

      5

      17% enrolled

      Perfect! I understood it very well. Thank you so much.

      • bitcocom
        Instructor

        I'm glad you understood it well. Fighting to complete it all the way to the end. Thank you~~

    • red81661127님의 프로필 이미지
      red81661127

      Reviews 5

      Average Rating 5.0

      5

      32% enrolled

      • bitcocom
        Instructor

        Thank you~ I hope the lecture will be helpful to you.

    • nsyoon4352님의 프로필 이미지
      nsyoon4352

      Reviews 13

      Average Rating 4.3

      4

      32% enrolled

    $27.50

    bitcocom's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!