비전공자를 위한 SQL 입문

To build precise cost accounting knowledge and practical skills, this course covers core costing principles including calculation and reporting, structured with case studies for direct real-world use.

We'll cover the most fundamental core principles of using Excel as a business tool. We'll teach you various Excel elements from the principles of Excel calculations to functions, formulas, aggregation, and filter utilization. The content is structured around how to construct formulas, understanding functions at the center of formulas, and methods for utilizing aggregation and filter features.

We have systematically organized inventory/material management techniques, resolved data duplication and errors, and established a foundation for effective MRP system operation. Through this, you will acquire the know-how to respond to demand and supply volatility and develop capabilities for effective inventory management execution and operational strategies.

This is designed for practitioners in both public and private sectors who handle urban planning, development activities, maintenance projects, and licensing work to systematically understand the provisions of the National Land Planning Act and apply them in practice.

To enable office workers to actively and effectively use AI in their work, we provide various techniques for reducing 'Hallucination' (i.e., nonsensical) answers and accurately eliciting desired responses.

It is structured around practical guidelines for HR and labor managers, covering human resources, labor, wage, industrial accident, retirement, and employment management. Additionally, it offers solutions to various HR and labor legal issues frequently encountered in businesses, integrating diverse cases and precedents.

The content has been structured to be applicable in practice by integrating the internal audit planning process and audit points for each department in the field with various case studies.

This is a course designed to improve your ability to successfully communicate your arguments and ideas in various presentation situations such as proposals, reports, and briefings. We hope that through this course, you will become a more competitive presenter.

This patent guide is designed to legally protect the development achievements of universities, research institutes, and companies, and to secure exclusive technological competitiveness. Additionally, we provide efficient and competitive research and development directions through understanding intellectual property-based R&D trends and predicting technology gaps.

We provide comprehensive guidance on discovering, proposing, and transferring technology-based innovative products to business divisions, and inform you about the functions and roles of R&D, product development, marketing, and business divisions related to product development.

We provide strategic implementation plans that can offer direct assistance in performing duties, focusing on essential content that corporate education and training managers must know. We have also included methodologies and procedures for designing corporate human resource development systems, as well as content on recent applications of competency modeling and case analyses of educational systems through job analysis.

Based on comprehensive theories including job analysis procedures for job-centered human resource management, NCS job analysis, job analysis and performance management (KPI), and job-based pay systems, this content is structured in an easy-to-understand manner by combining various cases with issues that frequently occur in the field.

We aim to improve the Personal Skills and Work Skills of key talent. We provide solutions for growing into key talent, including fostering creativity and thinking skills, methods to enhance interpersonal relationship skills, and followership.

We provide you with comprehensive information on everything needed to manage partner companies. You can learn logical and rational selection and evaluation methods for partner companies, as well as various management techniques to ensure manufacturing quality from partner companies. Additionally, we help you improve your ability to systematically manage partner companies and maintain partnership relationships with them.

This course is designed to be easily understandable with various case studies covering quality strategy development, implementation, and goal monitoring techniques to achieve quality objectives under established quality policies. Additionally, it presents methods for recognizing and evaluating quality issues by converting them into monetary units, which are common management metrics, and is a process that can measure the accurate performance of current quality management systems through the introduction and operation of quality costs, while developing systematic and continuous quality cost management capabilities.

We will introduce the concept of Statistical Process Control (SPC) as a scientific approach for quality improvement and data literacy. Additionally, we have structured this content by integrating data-driven Quality Control (QC) techniques and application methods for reducing process variation with various case studies.

The content has been structured to help improve job competency by covering the accounting knowledge necessary for work performance, from basic concepts up to the composition stages of financial statements. We have explained double-entry bookkeeping concepts and content related to financial position and business performance by incorporating various practical cases.

You can understand the difference between adjusting entries and closing entries, verify the closing procedures for each account, and communicate accounting information through financial statements.

We have structured the content so that you can understand everything from the complex and confusing concepts of chart of accounts to their practical application all at once. For the convenience of managers and practitioners, we have created a table of contents that allows you to find chart of accounts based solely on transaction details, and we systematically include not only chart of accounts considering various industries but also journal entry methods, so any company can apply them to suit their own circumstances.

We have presented key credit analysis checklists related to business feasibility review by integrating them with various case studies. Additionally, we have explained the credit analysis methodologies that Credit Analysts use in practice to enhance their applicability in the field.

Starting from elementary school coding education to high school students in IT software departments, computer science college students, and job seekers from non-technical backgrounds, you can now meet the easy and fun coding lectures of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education, not only offline but also online. With Young Cody Kim, who has produced over 500 frontend, backend, full-stack, and web developers, your dream of becoming a developer will soon become reality!

By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

Make the most of relational database systems!

You will be able to extract the data you want directly without the help of a developer. We will provide everything you need for analysis, from simple queries to joins. Start learning SQL with a direct lecture from the author of the book <Planner's SQL>.

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

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

This course teaches MS-SQL through baseball/company databases.