PHP 프로그래밍 실무 완전 정복! with MySQL

This course is designed to provide step-by-step learning from the basic concepts of database systems to the utilization of Relational Database Management Systems (RDBMS) and SQL. Learners will understand the principles of databases and be able to create systematic data structures through data modeling and design methods. Additionally, they will experience actual data processing by practicing data manipulation and management techniques using SQL. Through this course, students can go beyond simple theoretical learning to build a foundation that can be utilized for both practical work and certification exam preparation by acquiring efficient data management and application skills.

This course is designed to help you learn fundamental algorithm concepts through JAVA programming. Rather than stopping at theoretical explanations, it is structured to allow natural understanding by directly implementing various algorithms in code. Students will learn progressively from basic sorting and search algorithms to more challenging algorithms, developing both problem-solving abilities and programming thinking skills. Additionally, by integrating JAVA language syntax and usage methods through hands-on practice, you can master both algorithm theory and actual implementation simultaneously. Through this course, learners will not only establish an understanding of algorithms but also acquire algorithm implementation capabilities using JAVA, securing practical programming skills that can be utilized in academics, employment, and professional work.

"This is a course for learning the overall usage of Notion, an all-in-one productivity tool that enables efficient management of work and life in a Mac environment. You can learn step-by-step from Notion's basic functions to databases, automation, AI utilization, and practical template creation, acquiring work and self-management methods optimized for Mac users. Through a hands-on curriculum, you can increase productivity in both daily life and work."

This course is a practical-focused program that covers the comprehensive utilization of **Google Sheets, the most widely used spreadsheet program in the world**. Starting with basic functions such as fundamental input, formatting, and cell management that even first-time users can easily follow, the course progressively advances to professional features including advanced function utilization, data analysis and visualization, conditional formatting, and pivot tables through step-by-step learning. Additionally, by focusing intensively on Google Sheets' unique strengths of real-time collaboration tools and cloud-based sharing features, learners can experience an efficient work environment where multiple people can simultaneously create, edit, and review documents. Through this course, learners can go beyond simple spreadsheet usage to simultaneously strengthen their data-driven decision-making abilities and collaboration capabilities, significantly improving work productivity.

This course is a video tutorial on creating a TodoList app using only questions with the Cursor AI artificial intelligence tool.

This course is a hands-on lecture that covers learning the basic usage of the Cursor AI artificial intelligence tool and applying it to actual website development. Learners will understand AI-based development environments and experience code writing and automation features using Cursor. The course is structured not just to learn the tool's functions, but to develop practical skills through actual website development projects. Additionally, the course covers basic elements frequently used in website development such as HTML, CSS, and JavaScript, along with efficient development methods utilizing AI assistance features, making it easy for beginners to follow along. Upon completing this course, learners will gain the ability to quickly implement ideas and complete websites using Cursor AI, which will serve as a great first step in adapting to modern development environments.

"This is a course for learning the comprehensive usage of Notion, an all-in-one productivity tool that enables efficient management of work and life in a Mac environment. You can learn step-by-step from Notion's basic functions to databases, automation, AI utilization, and creating practical templates, acquiring work and self-management methods optimized for Mac users. Through a hands-on curriculum, you can increase productivity in both daily life and work."

This course covers everything from building a database to creating tables and manipulating and changing data within the database using various SQL queries.

This is a hands-on course where you'll build an AI-based autonomous driving car using Raspberry Pi and various sensors.

This is a basic C++ course for those who are new to C++ programming. You will learn and practice how to utilize C++ along with an overview of programming and the basic grammar of C++.

This is a course to learn in various languages how to call various open data provided by the public data portal from various programming languages and how to use JSON data provided as a result of the call.

This lecture is designed to prepare for the Information Security Engineer written exam, and it will help you concisely summarize the core theories and strengthen your practical skills through problem solving. Take a step closer to obtaining the Information Security Engineer certification with analysis of past questions and practical preparation strategies.

This course goes beyond the React beginner level and is an intermediate learning course that intensively covers the principles and usage of Hooks, which are most frequently utilized in practical development. Through Hooks, the core tool of functional components, you can learn step-by-step how to implement state management, lifecycle control, performance optimization, and more. In particular, it systematically organizes the roles and usage patterns of basic Hooks like useState and useEffect, as well as advanced Hooks such as useRef, useMemo, and useCallback, and is structured to help you understand which Hook to choose for different situations. Through practical examples, you'll go beyond simple code writing to experience: State management optimization between components Prevention of unnecessary rendering Dynamic data management and DOM control This allows you to develop the intuition to solve problems frequently encountered in real projects. Upon completing this course, you'll master Hook-based development flow, which is the core of React, and be able to confidently apply it to more complex application structures.

This course is designed to learn the fundamental theories and practical processes necessary for applying AI modeling and service planning to real-world work environments. Learners can acquire essential foundational knowledge to skillfully perform AI modeling projects and experience various practical procedures used in actual business settings. The course is specifically structured to provide step-by-step learning of the entire workflow from AI service environment analysis → goal setting → requirements analysis → service model design → scenario planning → utilization planning → execution plan development → performance evaluation planning. Through this approach, learners can develop systematic thinking and practical application skills for how to introduce and utilize AI from business and service planning perspectives, rather than limiting themselves to purely technical learning. Upon completing this course, learners will understand the overall planning and execution process of AI projects and will be able to strengthen their capabilities as AI service planners, PMs, and data-driven strategists in actual corporate environments.

Notion's powerful and convenient database features allow even beginners to easily build a DB. In this course, you will learn about database concepts and related terms (tables, rows, columns, etc.), as well as the basic usage of the Notion database.

This lecture is designed to prepare for the Information Security Engineer written exam, and it will help you concisely summarize the core theories and strengthen your practical skills through problem solving. Take a step closer to obtaining the Information Security Engineer certification with analysis of past questions and practical preparation strategies.

This course will help you learn JavaScript through theory and practice. It explains step by step so that even beginners can easily understand. Part 2 covers JavaScript functions and events, types of functions, and core libraries.

This is a course to learn the Python programming language with 100 problems. This course consists of a total of 3 parts, and in Part 1, you will solve problems on the topics of variables, data types, operators, conditional statements, and loops.

This course helps build a basic understanding of algorithms using the C# programming language. It also covers the full process of coding 12 algorithms essential for industry use.

This course will teach you how to create an EPUB format e-book using Sigil and learn various techniques required for creating e-books.

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

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

This course was created to provide you with knowledge and experience in PHP while creating https://opentutorials.org.

This course systematically teaches normalization and denormalization, which are core concepts in database design. Learners will understand the necessity and principles of normalization, and acquire step-by-step knowledge from First Normal Form to Third Normal Form and BCNF normalization techniques. Additionally, they will learn denormalization techniques that are essential considerations in practical database design, and discover actual application methods for performance optimization. Furthermore, learners can understand the essence of NULL values and their operational results, which are important concepts in databases, and examine the concept and characteristics of **Artificial Identifiers** to experience the importance of data integrity and management. Through this course, learners can establish a foundation for solving various problems that may arise during the data modeling process and develop database design capabilities applicable to both theory and practice.

The SQLD Latest Past Exam Problem Solving Course is a practical preparation lecture that reflects the 2024 revised exam standards and is based on actual past exam questions. Going beyond simply checking answers, it meticulously covers the question's intent, key testing points, and common pitfalls, developing practical problem-solving skills for SQLD certification success.

You can master Database development, which is essential for mobile/web development, through MySQL.

MySQL for non-majors! This lecture quickly skims through essential concepts with brief explanations, then allows you to learn MySQL hands-on by "playing" with examples on the site.

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

This course teaches you how to implement modern web applications that combine the accessibility of the web with the excellent information management capabilities of a database by linking PHP and MySQL.

This is a content about backend development using two databases, MySQL and Mongo, for job seekers preparing for backend employment.

The Laravel framework, built on PHP, provides developers with convenient features. This course was created to help those who have difficulty learning Laravel due to the difficult-to-understand official website or books.

This course covers how to create web applications using Node.js and MySQL.

You will learn about what a node is, the latest JavaScript grammar, the node API, npm, the module system, databases, testing, and more. You will create a project using five practical examples. You will also deploy a service to the cloud and convert a node project to TypeScript.

This is a full-stack restaurant map tutorial that allows you to learn everything from front-end, back-end, Kakao Map API usage, and deployment all at once while creating a restaurant map of your favorite YouTuber.

Create a SNS service using Vue and Nuxt frameworks. Learn the full stack knowledge required for the service.

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

I learned it the hard way, so you can learn it the easy way I've discarded unnecessary theory and included only the SQL essentials. Quickly build your SQL confidence.

This course allows you to learn the major trends in web development by following the overall web technologies required to complete a website.

The basic steps to learn SQL injection attacks, the flower of web hacking! This is a lecture on basic SQL grammar!