강의

챌린지

멘토링

로드맵

커뮤니티

[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

40 learners

Level Beginner

Course period Unlimited

SQL
SQL
Oracle
Oracle
DBMS/RDBMS
DBMS/RDBMS
sql-join
sql-join
SQL
SQL
Oracle
Oracle
DBMS/RDBMS
DBMS/RDBMS
sql-join
sql-join

What you will gain after the course

  • 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 youngcodikimssam

Career Verified

573

Learners

32

Reviews

23

Answers

5.0

Rating

19

Courses

👩The person who created this course

A current vocational training instructor dedicated to training developers, with over 15 years of experience teaching English and full-stack development (backend and frontend), video production, coding, design, big data, and machine learning, with the goal of [making English and coding easy and fun for non-majors]!


🎖 Career History

[The First Step to Earning 1 Million Won a Month as a Side Job for Someone Who Knows Nothing About Computers] author

Selected as an instructor with an A rating in the Ministry of Employment and Labor's NCS National Competency Standards lectures

Selected as an Outstanding Instructor (received the top award for three consecutive years in 2017, 2018, and 2019)

Formerly in charge of planning and development for Samsung ODD

Special lecture at the Department of Computer Engineering, Catholic University

Special lectures for the Department of Multimedia at Yongin Songdam University and many others


🚵 Qualifications

Vocational Skills Training Instructor [Information Technology Development] Ministry of Employment and Labor

Vocational Skills Training Instructor [Information Technology Operations] Ministry of Employment and Labor

Vocational Skills Training Instructor[Information Technology Strategy and Planning] Ministry of Employment and Labor

Vocational Skills Training Instructor[Artificial Intelligence] Ministry of Employment and Labor

Vocational Skills Training Instructor[Immersive Content Production] Ministry of Employment and Labor

Vocational Training Instructor [Cultural Content Production] Ministry of Employment and Labor

Vocational Skills Training Instructor [Multimedia] Ministry of Employment and Labor

Vocational Skills Training Instructor [General Office Administration] Ministry of Employment and Labor

Vocational Skills Training Instructor[General Affairs] Ministry of Employment and Labor

Vocational Skills Training Instructor [Design] Ministry of Employment and Labor

Vocational Skills Training Instructor [Video Production] Ministry of Employment and Labor

Vocational Skills Training Instructor [Printing] Ministry of Employment and Labor

Vocational Skills Training Instructor [Publishing] Ministry of Employment and Labor

Big Data Specialist Level 1 Korea Vocational Competency Promotion Institute

Information Processing Engineer Human Resources Development Service of Korea

Office Automation Industrial Engineer Human Resources Development Service of Korea

Computer Skills Level 2 Korea Chamber of Commerce and Industry

ITQ OA Master Korea Productivity Center

Word Processor Level 1 Korea Chamber of Commerce and Industry

Multimedia Content Production Specialist Korea Creative Content Agency

Visual Design Industrial Engineer Human Resources Development Service of Korea

Computer Graphics Operation Craftsman Human Resources Development Service of Korea

Web Design Technician Human Resources Development Service of Korea

GTO Photoshop Level 1 Global Certification Examination Institute

GTO Illustrator Level 1 Global Certification Examination Institute


👩‍🏫 Currently employed as a vocational skills training instructor

Courses taught: English / Information Technology Development / Front-End / Back-End / Full-Stack / Java Web Development / UI/UX Engineering / Big Data Platform Construction / Big Data System Development / Programming Languages / Python / Java / Big Data Analysis / Big Data Specialist / Programming Languages / Content Planning


  Inflearn's Creating Responsive Web Pages Using Bootstrap 3 (BOOTSTRAP). To celebrate reaching approximately 100,000 subscribers, I have received many requests via DM for additional courses, so I am currently planning, producing, and uploading a full-stack course with the latest version. Your great interest and warm comments are a tremendous source of motivation for Young Cody Kim's course production.

 

Although it may be slow, we will move forward step by step with you, creating high-quality courses.

 

More

Curriculum

All

17 lectures ∙ (4hr 13min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

2 reviews

5.0

2 reviews

  • c76813305538님의 프로필 이미지
    c76813305538

    Reviews 3

    ∙

    Average Rating 5.0

    5

    18% enrolled

    Following Java, I'm taking the Oracle course. I will listen diligently!

    • soohyunkim9644님의 프로필 이미지
      soohyunkim9644

      Reviews 4

      ∙

      Average Rating 5.0

      5

      35% enrolled

      youngcodikimssam's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!

      Limited time deal ends in 7 days

      $22,280.00

      24%

      $23.10