Database Systems

Materials

Materials	Topics	Code
Database Environment	ERD Referential Integrity SQL Server Environment	00_introduction.sql
Data Manipulation I	CRUD Constraint Begin Tran Order By	01_data_manipulation_1.sql
Data Manipulation II	Aggregate Functions Grouping String Date	02_data_manipulation_2.sql
Data Manipulation III	Join Set Operator	03_data_manipulation_3.sql
Advanced SQL I	Subquery In and Exists Any, Some, All	05_advanced_sql_1.sql
Advanced SQL II	Views Stored Procedure Trigger Function	06_advanced_sql_2.sql
Normalization and ERD Modelling	Normalization ER Modelling	-

Databases

• bodyshop
• coffee_shop
• doto
• oden
• salon

All of the Databases and ERD are taken from Software Laboratory Center: BINUS University.

Reading Materials

• SQL Server using Docker: https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash
• Fix PolyBase in SQL Server: https://nielsberglund.com/2019/11/20/fix-polybase-in-sql-server-2019-developers-edition/
• Documentation: https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-ver15