강의

멘토링

로드맵

Inflearn brand logo image
BEST
Programming

/

Database

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

Easy explanations and examples are provided so that you can apply them directly to your work.

(4.6) 110 reviews

1,146 learners

  • softcampus
  • nury
SQL
Oracle
PL/SQL
DBMS/RDBMS

Reviews from Early Learners

What you will learn!

  • Basic concepts and characteristics of databases

  • Installing and Configuring Oracle Database 11g

  • Writing SQL queries and managing data

  • Insert, modify, and delete data

  • Creating and Managing Tables

  • Transaction management and index use

  • Connecting Java Programs to Oracle Databases

Oracle SQL Database 11g PL/SQL Developer

This course covers only the developer-focused portions of Oracle Database. Therefore, it omits the essential knowledge for DBAs and focuses solely on developers. It's designed to provide a quick overview of the essential knowledge developers need to develop software that uses databases. Through extensive examples, you'll learn practical commands and other relevant information. Completing this course will also help you learn Servlets and JSP, which are essential for developing Java web applications.

Learning Objectives

  • You can develop software that uses databases.

Helpful people

  • Anyone interested in Oracle Database, including college students, the general public, and developers, can learn.

Note

  • This course requires no prior knowledge. However, the final lecture integrates with Java programming, so prior knowledge of the Java language is helpful.

Introduction of knowledge sharers

Yoon Jae-seong

I've been developing and teaching a variety of applications, from the early days of mobile content development in Korea's IT industry to Android and iPhone app development. I currently serve as the Director of Development at Softcampus, Inc.

Development experience
SKT launches "Island Adventure" mobile content development
- KT launches mobile content development for "Quiz Soccer"
SK launches "Mobile Certified Broker"
- Development of the iPhone "Hanjatong" app
- iPhone "Health Training" app development
- KT/SK Dales of Commons content development
- Development of KT mini games (Gradually Grabbing Land, Aladdin's Magic Lamp, Mystery Block Detectives, BUZZ and BUZZ)

Teaching experience
We have been developing and providing lectures for 18 years to current and unemployed people from famous domestic companies such as Samsung Multicampus, Busan IT Industry Promotion Agency, Jeonju Information and Culture Industry Promotion Agency, Incheon IT Industry Promotion Agency, Korea Radio Promotion Agency, SK C&C, T Academy, Korea Robot Industry Promotion Agency, Daejeon ETRI, Samsung Electronics, NICA Training Center, Korea Productivity Center, and Hanwha S&C.

Lecture content
- Start Google Angular.js (Angular) Course
- Bootstrap 4 & 3 Framework Tutorial
- JavaScript Tutorials for Beginners
- jQuery Programming for Beginners
- CSS & CSS3 for Beginners
- HTML & HTML5 Tutorials for Beginners
- node.js server Tutorials (Node.js server programming course)
- Kotlin for Android: Beginner one step
- Kotlin for Android: Deepening Course, Level 2
- Kotlin for Android: Advanced 3-Step Course (Kotlin for Android: 3-Step Final Course)
- Oracle SQL Database 11g PL/SQL Developer (Oracle Database 11G)
- MySQL Database for Beginners
- C Programming for Beginners
- Kotlin, Google's official development language for beginners
- Python for beginners

Lecture area

I lecture on Java, Android, Framework, Databases, UML, iPhone, Big Data Processing and Analysis, Python, the Internet of Things, Data Analysis with R/Python, Deep Learning, Machine Learning, AI, and Spark. Drawing on my diverse experience, I teach with examples and explanations that make it as easy as possible to apply to practical applications. Since this is not an offline course, please use the Q&A for any questions you may have. I'll be sure to answer any questions you may have.

This is the Oracle 11 version shared drive. https://drive.google.com/drive/folders/1f11i7pkl2pOFnWARgHevupQsN-ry8sQL?usp=sharing

Recommended for
these people

Who is this course right for?

  • Database beginner

  • People who want to learn SQL

  • People who want to become database administrators

  • Java Developer

  • People interested in optimizing database performance

Hello
This is

15,412

Learners

769

Reviews

589

Answers

4.7

Rating

38

Courses

Curriculum

All

38 lectures ∙ (8hr 8min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

110 reviews

4.6

110 reviews

  • 소중한 펭귄님의 프로필 이미지
    소중한 펭귄

    Reviews 3

    Average Rating 4.3

    3

    63% enrolled

    강의자체는 나쁘지 않으나..... 강사님의 침 넘기는 소리, 입술 부딧히는 소리, 그리고 부분적으로 녹음이 인코딩 되지 않아 설명이 누락된 부분이 있습니다. 지엽적이라고 할 수 있으나, 강의를 듣는데 많이 거슬리네요. 그리고 이 강의는 매우 기본 강의입니다. 바램이 있다면 PL/SQL의 TRIGGER, 함수, CURSOR, 패키지, PROCEDURE에 대한 강의가 개설되기를 희망합니다.

    • leeds님의 프로필 이미지
      leeds

      Reviews 6

      Average Rating 5.0

      5

      32% enrolled

      • 류희정님의 프로필 이미지
        류희정

        Reviews 4

        Average Rating 5.0

        5

        32% enrolled

        Oracle 어려웠는데 정말 잘 설명해 주어서 좋아요 완전 추천 합니다.

        • leejy님의 프로필 이미지
          leejy

          Reviews 8

          Average Rating 5.0

          5

          32% enrolled

          • safe0628님의 프로필 이미지
            safe0628

            Reviews 2

            Average Rating 4.5

            4

            32% enrolled

            $8.80

            softcampus's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!