강의

멘토링

로드맵

Inflearn brand logo image
Programming

/

Database

[Oracle SQL: From Beginner to Expert] Learning Database with Practical Examples

Starting from elementary school coding education to high school students in IT software departments, computer science college students, and job seekers from non-technical backgrounds, you can now meet the easy and fun coding lectures of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education, not only offline but also online. With Young Cody Kim, who has produced over 500 frontend, backend, full-stack, and web developers, your dream of becoming a developer will soon become reality!

(5.0) 2 reviews

19 learners

  • youngcodikimssam
예제문제
이론 실습 모두
기초탄탄
쿼리
SQL
Oracle
DBMS/RDBMS
sql-join

What you will learn!

  • Oracle DBMS Installation and DB Construction

  • Administrator Account Setup

  • SQL Basic Syntax

  • CRUD Practice

  • Automatic key value generation using sequence

  • Inner Join vs Outer Join

  • Utilizing Date and Time Functions

  • Practice by solving SQL query problems

DBMS/RDBMS, SQL, sql-join, backend, Java

Oracle SQL courses [ start with basic database concepts and progress to advanced query writing, data analysis, and real-world case studies ]and are structured to help you solidify your skills through hands-on practice.


SQL (Structured Query Language) is an essential language for effectively managing databases and retrieving, modifying, deleting, and analyzing data. Oracle SQL provides particularly powerful features for handling large-scale databases and is an optimized tool for data management and business logic implementation.

In this course, you will learn to understand the basic concepts of databases and build a database environment from Oracle installation and configuration to administrator account setup. Additionally, you will strengthen your foundation in SQL syntax, master data joining techniques such as inner joins and outer joins, and acquire query patterns frequently used in practice through date and time functions and various real-world examples.

By solving problems based on real data and repeatedly practicing writing and optimizing complex SQL queries, you will gain complete confidence in data analysis and business applications.

Master database management and utilization skills through Oracle SQL courses, and develop powerful data processing capabilities that can be immediately applied in real-world work!


👩🏻‍💻 Starting from the very basics

Frontend, Backend, and Full-Stack Job Preparation Course for Non-Majors

Oracle SQL: From Basics to Practice Course Features

A course packed with 15 years of teaching expertise🎯


This is an Oracle SQL course packed with the know-how of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education for high school students in IT Software departments, computer science college students, and non-major job seekers.

This course is designed for beginners who are new to databases, covering everything from basic database concepts to easy-to-follow SQL syntax, table creation, and methods for data insertion and retrieval.

The type who stakes their life on easy and fun explanations 👨‍🏫


I am Teacher Kim, who constantly strives to help even complete beginners understand and grow step by step through Young Coder Kim's easy and fun explanations and unique memorization techniques.

Additionally, you can gradually learn practical web development through various clone coding projects. Challenge yourself to pursue your dream of becoming a developer through web design, frontend, backend, and full-stack job courses designed for non-majors starting from the very basics.

Check your skills by solving SELF_EX


You can build your skills by checking what you've learned through the SELF_EX problems provided in each chapter. The problems, which are based on the core concepts and practical content of each unit, greatly help you check your understanding of the learning material and supplement areas where you're lacking.

It serves as an important checkpoint that helps naturally improve and develop skills by combining learning with problem-solving practice.


📚 Here's what you'll learn in Oracle SQL: From Basics to Practice!

This course is a customized lecture for everyone from beginners who are encountering databases for the first time to those who want to learn skills that can be used immediately in practice!

Oracle DB Installation and Environment Configuration: DB Installation and Basic Setup That Even Beginners Can Follow

Table creation and management: Understanding basic management methods such as creating, modifying, and deleting tables that store data

SQL Basic Syntax: Utilizing core commands like SELECT, INSERT, UPDATE, DELETE

Inner and Outer Joins: JOIN Syntax and Practical Applications for Efficient Data Combination


Utilizing Date and Time Functions: Learning Data Analysis Skills with SQL Functions for Handling Dates and Times


Database Administrator Skills: Basic capabilities of a DB administrator including user account management, permission settings, etc.

🎬Oracle SQL: Learning Content from Basics to Practice


  1. Oracle DB Installation and Configuration: Learn from installation to initial setup through hands-on practice.

  2. Understanding Database Fundamentals: Start by easily learning DB concepts and structures.

  3. Oracle Account Management: Set up administrator accounts and learn DB management skills.

  4. SQL Syntax Learning: Practice basic syntax such as SELECT, INSERT, UPDATE, DELETE step by step.

  5. Using Inner Joins: Learn and practice the core principles of data combination.

  6. Understanding Outer Joins: Learn the differences between LEFT, RIGHT, and FULL OUTER JOIN and how to use them.

  7. Date and Time Functions: Learn how to use various functions for handling date data through practical exercises.

  8. SQL Problem Solving: Develop practical problem-solving skills by working through complex query problems.

Conquer SQL and databases by following step-by-step from basics to practical application! 🚀

Click the image above to go to the Complete Java Fundamentals to Oracle SQL Bootcamp [Full vers.] roadmap and [ Java Basics PART1, Java Applications PART2, Oracle SQL ] you can download a coupon that allows you to take all three courses at a 30% discount. 🎁🎵

Spring Boot, JPA, TDD, JSP, Java, Spring, Spring Boot, React, Frontend, Backend, Full Stack, Java

What do you learn in each course of the full-stack program for non-majors?

STEP01 | [HTML Starter] Bootcamp for Non-Majors[Click to go to the course]

The meaning of HTML and how to write basic code and create layouts

Web development is like creating an online store that anyone can visit. HTML stands for Hyper Text Markup Language, and you'll learn to create the basic framework by organizing the key core information that becomes the main content of web pages.


STEP02 | Bootcamp for Non-Majors [From CSS Styling to Animation] [Click to Go to This Course]

From the meaning of CSS and basic code writing methods to applying desired styles to HTML for web design

CSS stands for Cascading Style Sheet, where "Cascading" is a word that means hierarchical or waterfall-like. CSS literally allows you to hierarchically select parent and child relationships in HTML structure to apply desired styles, colors, shapes, and animations to desired elements, creating sheets that enable you to design webs that are not boring but interesting and beautiful for users to view. Additionally, until you gain confidence in CSS, you build experience in creating various web designs by repeatedly coding HTML/CSS for clone designs of various practical sites, mobile designs, and web designs.


STEP03 | Bootcamp for Non-Majors [From JS to React][Click to Go to Course]

Learning Vanilla Script and JavaScript ES6 Syntax and Utilizing React

Have you ever felt frustrated while studying React? In Teacher Kim's class, to systematically learn JavaScript, which is the foundation of React, we start with vanilla script, then cover JavaScript ES6 syntax, jQuery, and other basic grammar. Through various practical examples, we solidly build the fundamentals of scripting. After that, we understand and practice various React syntax to implement bulletin boards and member functions using components, state, and memoization. We also learn TypeScript syntax to create ToDoList practice examples, opening the path to React without giving up.


STEP04 | Bootcamp for Non-Majors [Responsive Web Development][Click to Go to Course]

Learn to understand and use @media queries for creating responsive web designs, and master Bootstrap, a framework that makes it easy to create responsive layouts

Learn how to use Bootstrap for developing responsive web pages that adapt their layout according to different device types. This course appropriately balances theory and practice to help you understand Bootstrap's components, verify your learning through hands-on exercises, and complete the implementation of an actual responsive website.

Additionally, for those who want to create responsive websites with their own unique style instead of Bootstrap's predefined styles, we will master the practice of implementing various layouts for different devices using purely HTML/CSS/jQuery without Bootstrap through creating a Hansot Dosirak responsive website.


STEP05-1 | [JAVA Basics] Bootcamp for Non-Majors [Click to Go to Course]

Starting with understanding and practicing the most basic grammar, then learning Java fundamentals and intermediate grammar

You will learn Java, the most fundamental language for web development backend, starting from the most basic grammar and gradually progressing to intermediate level. Through various practical examples, you will naturally acquire the ability to code the programs you want on your own.


STEP05-2 | Bootcamp for Non-Majors [JAVA from Basics to Advanced] [Click to Go to Course]

Understanding and Practice of Java from Basics to Advanced Grammar

Java's Collection Framework is an internal library that has built-in collection classes for storing data, literally meaning to collect and store. By learning various syntax for grouping and managing different data types in one place, and practicing diverse examples from Java basics to advanced concepts, we build a solid foundation that serves as the cornerstone for web development backend.


STEP05-3 | 비전공자를 위한 [Oracle SQL] 부트캠프[현재과정]

Understanding and Practicing Databases

Learn SQL syntax and practice through CRUD operations that involve creating database (DB) tables and reading, writing, modifying, and deleting data in the database, preparing you to utilize databases for user registration, login, and bulletin board creation.


STEP06 | Bootcamp for Non-Majors [From JSP to SpringBoot] [Click to go to the course]

From JSP to Spring Boot

Have you ever experienced frustration while studying Spring Boot, which is currently the most widely used framework in the industry?

In Kim's class, to perfectly understand Spring Boot, we start learning from the most basic syntax of JSP, directly experiencing the evolution of backend syntax from the previous generation to the current generation, naturally acquiring concepts and usage methods, and understanding the principles of how Spring Boot, which automatically implements web development backend, operates.

Master the fundamentals for portfolio creation by learning basic concepts and applications of ORM, JPA, and entities, understanding Spring Security and implementing member functionality using security, practicing JUnit tests and H2 console usage, and ultimately implementing a practical website with member and bulletin board features using Spring Boot and collaborating through GitHub.


STEP07 | Building Web Services for Real-World Deployment [From Hosting to AWS]

[Click to go to the course]

Complete Web Service with Hosting and AWS Deployment

Have you ever had the frustrating experience of a project you developed only running on your computer and not being able to deploy it as an actual service?

In Teacher Kim's class, we don't just stop at writing code, but learn step by step through the entire process from web hosting using Dothome to deploying projects on GIT and AWS EC2.

You can master the deployment processes essential in real-world work, including domain connection, FTP upload, deployment through GitHub, jar packaging, server configuration, image upload path specification, and uninterrupted execution using nohup.

Through this process, you will gain experience in actually launching your website to the world, building both confidence as a developer and real service operation capabilities at the same time.

Java, Object-Oriented, Government-Funded Bootcamp, Spring Boot, SJava, Object-Oriented, Government-Funded Bootcamp, Frontend, Full Stack, Backend, Java, Spring Boot, Spring, Object-Oriented, JSP, Java, Spring, Spring Boot, React, Spring Boot, Spring, Spring, Spring Boot, React, Backend, Frontend, Spring, Spring, Spring Boot, React, Backend, Frontend

Recommended for
these people

Who is this course right for?

  • A coding beginner who just started studying databases

  • SQL beginners encountering the syntax for the first time

  • A student working on full-stack and backend portfolio projects

  • Job seekers preparing for employment as developers

Hello
This is

335

Learners

23

Reviews

18

Answers

5.0

Rating

19

Courses

👩 이 강의를 만든 사람

[ 비전공자도 쉽고 재미있게 배우는 코딩! ] 을 목표로 15년 넘게 풀스택(백엔드, 프론트엔드) 및 영상, 코딩, 디자인, 빅데이터, 머신러닝 등을 강의하며 개발자 인력양성에 진심인 현직 직업훈련교사


🎖 경력사항

[컴퓨터 1도 모르는 사람이 부업으로 월100만원 수입내보기 첫걸음] 의 저자

NCS 국가직무능력강의 고용노동부 평가 A등급 강사선정

그린컴퓨터아카데미수원 우수강사선정(2017, 2018, 2019 3년연속 최우수1등상 수상)

전) 삼성ODD 기획 개발팀 담당

가톨릭대학교 컴퓨터공학부 특강

용인송담대학 멀티미디어학부 특강 및 다수


🚵 자격사항

직업능력훈련교사[정보기술개발] 고용노동부

직업능력훈련교사[정보기술운영] 고용노동부

직업능력훈련교사[정보기술전략·계획] 고용노동부

직업능력훈련교사[인공지능] 고용노동부

직업능력훈련교사[실감형콘텐츠제작] 고용노동부

직업능력훈련교사[문화콘텐츠제작] 고용노동부

직업능력훈련교사[멀티미디어] 고용노동부

직업능력훈련교사[일반사무] 고용노동부

직업능력훈련교사[총무] 고용노동부

직업능력훈련교사[디자인] 고용노동부

직업능력훈련교사[영상제작 ] 고용노동부

직업능력훈련교사[인쇄] 고용노동부

직업능력훈련교사[출판] 고용노동부

빅데이터전문가1급 한국직업능력진흥원

정보처리기사 한국산업인력공단

사무자동화산업기사 한국산업인력공단

컴퓨터활용능력 2급 대한상공회의소

ITQ OA 마스터 한국생산성본부

워드프로세서 1급 대한상공회의소

멀티미디어콘텐츠제작전문가 한국콘텐츠진흥원

시각디자인산업기사 한국산업인력공단

컴퓨터그래픽스운용기능사 한국산업인력공단

웹디자인기능사 한국산업인력공단

GTO 포토샵 1급 글로벌공인자격검정원

GTO 일러 1급 글로벌공인자격검정원


👩‍🏫 현) 그린컴퓨터아카데미 직업능력훈련교사 재직중

담당과정) 정보기술개발/프론트엔드/백엔드/풀스택/자바 웹개발/UIUX엔지니어링/빅데이터플랫폼구축/빅데이터시스템개발/ 프로그래밍언어/파이썬/자바/빅데이터분석/ 빅데이터전문가/프로그래밍언어/콘텐츠기획


  인프런의 부트스트랩3(BOOTSTRAP)를 활용한 반응형 웹페이지 만들기 약 10만명 구독을 기념으로 그동안 추가 강의에 대한 많은 요청을 DM으로 받아 풀스택 강의를 최신버전으로 기획 제작 및 업로드 중입니다. 여러분의 많은 관심과 따뜻한 댓글은 영코디 킴쌤의 강의제작에 큰 원동력이 됩니다.

 

느리지만 차근차근 질좋은 강의로 한걸음씩 여러분과 함께하겠습니다.

 

Curriculum

All

17 lectures ∙ (4hr 13min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

2 reviews

5.0

2 reviews

  • 김수현님의 프로필 이미지
    김수현

    Reviews 4

    Average Rating 5.0

    5

    35% enrolled

    • c7681330님의 프로필 이미지
      c7681330

      Reviews 3

      Average Rating 5.0

      5

      18% enrolled

      자바에이어 오라클 수강합니다.~ 열심히 잘들을게요!

      $23.10

      youngcodikimssam's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!