Introduction to Database Based on MSSQL Server 2016: From Basics to Practical Application Part.2

This course is designed to help you learn various functions needed for presentation creation using the Han Show program, and develop practical skills applicable to both work and exams. It goes beyond simply acquiring design functions to cultivate logical thinking and problem-solving abilities, helping you create systematic and persuasive presentation materials. In particular, this course is designed with a curriculum optimized for the ITQ exam, making it effective for exam preparation. Learners can systematically study core presentation functions such as slide creation, utilizing shapes, images, tables, and charts, animations and transition effects, and develop practical skills by solving problems similar to actual exams. Through this, students will not only acquire ITQ certification but also simultaneously secure presentation creation abilities and application skills that can be immediately utilized in work environments.

1. Learn the main functions of Excel so you can create documents easily and quickly. 2. Learn tips commonly used in practice.

Learn the core techniques of 'Prompt Engineering' to get exactly the answers you want from AI. From a complete beginner's first steps to expert practical applications, maximize your AI utilization skills!

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. This course is designed to meet the examination criteria for obtaining a computer proficiency certificate. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate.

Learn the key features of Photoshop CC 2020 to use Photoshop easily and quickly.

This is a lecture where you can learn JavaScript through theory and practice. We explain step by step so that even those who are new to coding can easily understand. Part 1 covers an overview of JavaScript, variables, data types, operators, control statements, and the basics of jQuery.

This course is designed to learn the fundamentals of networks that form the foundation of the internet. It is structured to help you understand the basic concepts and structure of networks and systematically learn the principles of internet communication. Learners will acquire foundational theoretical and practical knowledge about networks, establishing a foundation for learning in the IT and information communication fields.

This is a lecture to prepare for the Information Processing Engineer practical subject certification, and you can acquire basic knowledge to understand the development requirements of information systems, etc. (Part 1)

This course is designed to prepare you for the Information Security Engineer written exam by concisely summarizing core theories and strengthening practical skills through problem-solving. Take a step closer to obtaining your Information Security Engineer certification with past exam analysis and practical preparation strategies.

In this course, you will learn advanced 2D drawing techniques and practical application methods in AutoCAD 2022.

In this course, you will learn how to use basic commands for 2D drawings in AutoCAD 2022.

Through this course, you can study short answer and descriptive questions from past practical exams for the Information Security Engineer.

Learn the basics of using AutoCAD and the basic functions for 2D CAD work.

This course is designed to prepare you for the Information Security Engineer written exam by concisely summarizing core theories and strengthening practical skills through problem-solving. Take a step closer to obtaining your Information Security Engineer certification with past exam analysis and practical preparation strategies.

When you want to try using Figma, a UI design authoring tool, or when you want to create something with Figma, you'll practice the most basic usage methods.

Learn the basic functions for performing 3D CAD work using AutoCAD.

This is a series of video lectures for AWS beginners and college students enrolled in AWS Educate. We will briefly introduce the AWS registration process and free tier services.

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 course is a **practical-focused lecture** that covers how to apply **conversational AI (ChatGPT, etc.)** to actual company work. Beyond simple AI usage methods, it is structured to enable learning of specific cases such as work automation, document creation, idea generation, and data analysis assistance that can be utilized in various departments and job environments. Through this course, learners will master methods to streamline repetitive and time-consuming tasks with AI, and experience smart workflows that collaborate with AI. Additionally, by understanding AI's strengths and limitations, it helps make correct decisions in actual business situations. Upon completing this course, you will be able to utilize conversational AI including ChatGPT as a tool to enhance work productivity, which will serve as an important foundation for securing competitiveness in future work environments.

This course is a hands-on lecture that covers the basic usage of the Cursor AI tool and how to apply it to actual website creation. Learners will understand the AI-based development environment and experience code writing and automation features using Cursor. The curriculum is designed not just to teach the tool's functions, but to help students develop practical skills through an actual website production project. Furthermore, it covers essential elements frequently used in website development—such as HTML, CSS, and JavaScript—along with efficient development methods using AI assistance, making it easy for beginners to follow along. By taking this course, learners will gain the ability to quickly implement ideas and complete websites using Cursor AI, which will serve as an excellent first step in adapting to the latest development environments.

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

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

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

You will be able to extract the data you want directly without the help of a developer. We will comfortably cover everything needed for analysis, from simple queries to joins. Start learning SQL with a lecture directly from the author of the book <SQL for Product Managers>.

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 is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

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.

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

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.

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.

"I have a backend technical interview in a week, what should I start with?" The secret to answers that make interviewers nod Master the actual answer patterns of Naver, Kakao, Coupang, and Toss successful candidates in just 3 days!

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.

In this lesson, you will learn how to create an .EXE file. You will also learn how to install an MSSQL database and request data in C#.

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

Learn common components of global-scale services through popular papers, books, and articles.

This is a WPF lecture that will be helpful to developers who are considering introducing WPF in WinForms, application developers who are hoping to get a job in the US, and those who are hoping to get a job as a developer. It is not a lecture focused on theory and design, but covers content that can be used in practice.

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.

If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.

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 🚀