실무 SQL 완전정복 - SECTION 7 : 데이터 조작어, 데이터 정의어 마스터하기

Dive deep into database management with this comprehensive section covering DML (Data Manipulation Language) and DDL (Data Definition Language). Learn how to effectively interact with your database and manage its structure. We'll explore the essential commands for manipulating data and defining database objects.

Here's a breakdown of what you'll learn:

• DML (Data Manipulation Language): Master INSERT, UPDATE, and DELETE statements. Discover how to leverage subqueries to enhance your data manipulation capabilities.
• DDL (Data Definition Language): Understand the different types of DDL commands and how to use them to create, modify, and delete databases. Learn to execute CREATE DATABASE, ALTER DATABASE, and DROP DATABASE commands. You'll also learn how to inspect your database structure.
• CREATE TABLE: Get hands-on experience with CREATE TABLE syntax. Learn about various data types, including auto-generated values, auto-calculated columns, and the IDENTITY property. Explore the uniqueidentifier data type and techniques for creating tables based on existing structures.
• Constraints: Types & Setup: A crucial section covering various constraint types like PRIMARY KEY, NOT NULL, UNIQUE, CHECK, FOREIGN KEY, and DEFAULT. Understand how to implement these constraints to ensure data integrity.
• Constraints: Advanced Configuration: Delve into advanced FOREIGN KEY configurations, specifically focusing on ON DELETE and ON UPDATE options. Compare and contrast NO ACTION, CASCADE, SET NULL, and SET DEFAULT behaviors. Learn the differences between column-level and table-level constraint settings.
• ALTER TABLE: Learn how to modify existing tables using ALTER TABLE statements. Cover topics like adding, changing, and deleting columns, as well as adding and removing constraints. Understand the difference between DROP TABLE and TRUNCATE TABLE commands.

Throughout this section, we'll apply these concepts using the Northwind database, solving real-world problems by setting up various constraints. This practical approach will solidify your understanding of database design and management.