Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu05:theorie:02 [2024/09/26 12:38] – vdemir
+++ modul:m290:learningunits:lu05:theorie:02 [2024/10/17 12:43] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU06b - SQL-DDL: Table Management ======
+====== LU07b - SQL-DDL: Table Management ======
 **Source**:
-  * [[https://www.w3schools.com/sql/sql_create_table.asp|CREATE TABLE]]
+  * [[https://www.w3schools.com/sql/sql_create_table.asp| W3Schools | CREATE TABLE]]
-  * [[https://www.w3schools.com/sql/sql_alter.asp|ALTER TABLE]]
+  * [[https://www.w3schools.com/sql/sql_alter.asp| W3Schools | ALTER TABLE]]
-  * [[https://www.w3schools.com/sql/sql_drop_table.asp|DROP TABLE]]
+  * [[https://www.w3schools.com/sql/sql_drop_table.asp| W3Schools | DROP TABLE]]
 ===== Learning Objectives =====
 In this learning unit, we will learn how to manage database tables, i.e.
-  -how to create
+  - how to create
-  -how to modify and
+  - how to modify and
-  -how to delete database tables
+  - how to delete database tables
 ===== CREATE TABLE =====
 Let's start by creating a table based on the ERD of the student management tool, as shown below:
-Our goal is to create the table "stundent" on our database. For that we need to know how the basic syntax for creating table is.
+Our goal is to create the table "stundent" in our database. For that we need to know how the basic syntax for creating of table is.
   CREATE TABLE table_name (