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 versionshared 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
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.