Mastering Oracle Database 11g Using LLM

Build a fully functional smart farm platform that integrates sensor data collection, MQTT communication, web dashboards, and AI-driven environmental analysis. Experience the entire process of agricultural digital transformation (DX) through a hands-on project, covering everything from IoT sensor integration and FastAPI/Spring-based API servers to React/Vue dashboard development and cloud deployment.

This is an advanced course where you will directly implement and interpret practical statistical techniques such as sampling distributions, hypothesis testing, regression analysis, and logistic regression using R. By utilizing AI tutors like ChatGPT and Gemini, you will learn everything from code generation to interpreting analysis results and writing reports, allowing you to take your data analysis capabilities to the next level.

Feeling overwhelmed by where to start with complex data analysis? I will clearly guide you through how to utilize R and AI Tutors using the practical know-how I've built up.

Through a systematic curriculum of 40 lectures, you will learn everything from the basic theories of AI to the applied AI technologies of each algorithm. Through mathematical intuition and R coding algorithm learning and practice, you will develop immediately applicable AI model development capabilities, covering everything from designing algorithm models for data analysis, machine learning, and their application tools to selecting and utilizing them.

Practical Hadoop & Hive Big Data with LLM Hadoop Ecosystem with AI Tutor This course focuses on understanding the Hadoop Ecosystem, a core technology of the Big Data era, and provides hands-on learning on how to process large-scale data using Distributed Storage (HDFS), Distributed Processing (MapReduce), and Data Warehousing (Hive). The curriculum is designed to help you master the core technologies of big data processing step-by-step, from Hadoop's basic structure and operating principles to HDFS, YARN, MapReduce, and Hive. In particular, you will build practical skills applicable in the field by performing tasks ranging from setting up a virtual machine-based practice environment to actual data processing and analysis. Furthermore, this course goes beyond simple video lectures by providing a self-directed learning environment utilizing an LLM-based AI Tutor. Students can maximize their learning efficiency through the AI Tutor, which provides Q&A for Hadoop and Hive concepts, error troubleshooting, practice problem generation, HiveQL writing support, and project learning guides.

We would like to provide an opportunity to learn SQL, a language used in relational databases, in general. In particular, we wrote the execution examples in the ORACLE environment. The learning content is largely divided into 2 parts and a total of 11 lectures. After learning the entire content, you can cultivate the ability to perform tasks in a database along with the general knowledge of SQL, and you can also prepare for the nationally certified SQL developer qualification.

Extract and utilize data through Oracle 18c and become a database expert!

A must-have subject for aspiring developers and those looking to get a job in big data!!

Learn practical strategies for designing efficient and scalable database structures that accurately reflect the complex requirements of real-world scenarios.

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

This course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

Currently, Android development can be done using both Java and Kotlin. You can develop the same Android applications regardless of which language you choose. This course covers most aspects of Android application development, from basics to advanced topics, and all code is written using Kotlin starting from the fundamentals. Additionally, it utilizes Google's latest UI library, Material 3. This course involves completing three projects throughout the entire Android curriculum. By working on these projects, you can master advanced techniques actually used in the industry, such as Hilt, Retrofit, Room Database, and MVVM. Furthermore, you can increase productivity using AI by performing "vibe coding" with Gemini within the Android development tools. Soft Campus will always strive to provide the most up-to-date lectures.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

You can learn about JWT and ws communication using Spring Boot, and how to handle high TPS.

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

This is a [Data Analysis, Programming Language] lecture prepared for SQL data analysis beginners. This is a SQL SELECT basic grammar lecture that starts without installing SQL.

This course focuses more on data modeling through entity design than on JPA technical explanations. Based on the principle that solid DB design is the foundation of application development, we analyze various design patterns—such as one-to-many, many-to-many, inheritance, and collections—alongside business scenarios. You will learn by directly observing the process of code being transformed into actual tables on screen. To ensure immediate practical application, we provide business use cases, source code, and test codes for each design pattern.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

★PYTHON★ This is a basic lecture on server development using Fast API. Learn how to develop servers easily, quickly, and conveniently using various packages such as Fast API, SQLAlchemy, Pydantic, and Starlette! Don't worry, we have prepared a DB backup file as well as integration with PostgreSQL! We will teach you the "basics" of UI design using Dash and Plotly and provide the source code used in the lecture :)

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

This is a course for learning MS-SQL through baseball and corporate databases.

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

Do you want to generate significant profits even in a bear market? Are you interested in automated trading but haven't been able to start because of coding, trading strategy design, exchange APIs, or server deployment? In this course, we guide even those new to Python to turn trading ideas into concrete strategies using ChatGPT and Codex, and implement them into backtesting and live automated trading code. We will practice Binance Futures automated trading using Python and CCXT, technical indicator strategies, DCA (dollar-cost averaging) backtesting, and Upbit API-based Kimchi Premium strategies. Afterward, we will apply Telegram notifications and order safety features, manage the completed bot with GitHub, and deploy it to a cloud server. Rather than leaving all investment decisions to the LLM, humans will determine the strategies and risk management criteria, while using the LLM as an assistant to help with strategy design, coding, and troubleshooting. After completing the course, you won't just be running the provided code—you will be able to create, verify, modify, and deploy your own unique strategies!