강의

멘토링

커뮤니티

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

540 learners

  • bitcocom
데이터베이스
데이터모델링
ERD
백엔드
DBMS/RDBMS
SQL
backend

Reviews from Early Learners

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,240

Learners

636

Reviews

665

Answers

4.9

Rating

12

Courses

안녕하세요 박매일 강사입니다.
SW교육센터를 운영중이며 대학, 관공서, 기업체에 컨설팅 및 SW위탁교육을 진행하고 있습니다.


📄 주요 강의경력외 다수

- 구름 특성화고 전공캠프 강의(Full Stack 과정)
- 소프트웨어마이스터고등학교 산학협력교사
- 광주인공지능사관학교 강의
- 패스트캠퍼스 백엔드 부트캠프 강의
- 스마트인재개발원 교육부장 및 강의
- 한국전력공사 In-House 코딩 위탁 교육
- 한양대학교 ERICA 온라인 강의
- 비트소프트웨어교육센터운영(해외취업,국비교육)
- SW채용연수사업(미래창조과학부)

🎤 온라인 교육콘텐츠 제공

인프런 : Java,DB,MVC,Spring,Spring AI,IoT
패스트캠퍼스 : 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

    Limited time deal ends in 8 days

    $24,640.00

    30%

    $27.50

    bitcocom's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!