강의

멘토링

커뮤니티

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) 113 reviews

1,151 learners

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

Reviews from Early Learners

What you will gain after the course

  • 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,683

Learners

797

Reviews

589

Answers

4.7

Rating

39

Courses

Curriculum

All

38 lectures ∙ (8hr 8min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

113 reviews

4.6

113 reviews

  • dslr2002 [DEL] 250831174644님의 프로필 이미지
    dslr2002 [DEL] 250831174644

    Reviews 3

    Average Rating 4.3

    3

    63% enrolled

    The lecture itself is not bad, but... there are some parts where the lecturer's saliva is being swallowed, the sound of his lips being licked, and the recording is not encoded, so there are parts where the explanation is missing. It may be minor, but it is very annoying to listen to the lecture. And this lecture is a very basic lecture. If I may wish, I hope that there will be a lecture on PL/SQL's TRIGGER, function, CURSOR, package, and PROCEDURE.

    • seo107359931님의 프로필 이미지
      seo107359931

      Reviews 2

      Average Rating 5.0

      5

      32% enrolled

      • psyasia4543님의 프로필 이미지
        psyasia4543

        Reviews 6

        Average Rating 5.0

        5

        32% enrolled

        • jwchoi9367님의 프로필 이미지
          jwchoi9367

          Reviews 5

          Average Rating 4.8

          5

          32% enrolled

          • leeds6415님의 프로필 이미지
            leeds6415

            Reviews 6

            Average Rating 5.0

            5

            32% enrolled

            $8.80

            softcampus's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!