
윤재성의 Oracle SQL Database 11g PL/SQL Developer
소프트캠퍼스
쉬운 설명과 예제를 현업에 바로 적용할 수 있도록 구성 하였습니다.
초급
SQL, Oracle, PL/SQL
You can master Database development, which is essential for mobile/web development, through MySQL.
Understanding the basic concepts and structure of databases
Installing and Configuring MySQL Community Server and MySQL Workbench
Retrieving and manipulating data using MySQL commands
Create, modify, and delete databases and tables
Transaction management, constraints, sequences and views management
- In this course, you will learn the developer side of MySQL database.
After completing this course, you will be able to learn other databases or apply them to managing data in web development, mobile development, etc.
You can learn everything from installing MySQL to various basic queries and managing databases and tables.
Yoon Jae-seong
I've been developing and teaching various 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.
Who is this course right for?
Beginner in Programming
People interested in database administration
People who dream of becoming data analysts
Computer Engineering Major
People who want to deal with real databases
All
25 lectures ∙ (5hr 45min)
6. Using Operators
08:59
8. Logical operator
19:08
9. like
11:30
10. Sort
10:50
11. Number functions
10:24
12. String Functions
12:00
13. Date Functions
13:54
14. Group Function
10:26
15. group by, having
18:11
16. Join
22:34
17. Subquery
10:12
18. set
10:27
22. Change Table
08:06
23. Constraints
25:58
24. Sequence
06:16
25. View
09:00
All
31 reviews
4.8
31 reviews
Reviews 4
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 349
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
Reviews 36
∙
Average Rating 5.0
$8.80
Check out other courses by the instructor!
Explore other courses in the same field!