| 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 |
- |
All of the Databases and ERD are taken from Software Laboratory Center: BINUS University.
- 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