ลิงค์ความรู้พื้นฐานDatabase จากBlogของ Grant Fritchey
1: Install SQL Server (5 มิย. 2017)
https://www.scarydba.com/2017/06/05/database-fundamentals-2/
2: SQL Server Management Studio (12 มิย. 2017)
https://www.scarydba.com/2017/06/12/database-fundamentals-2-sql-server-management-studio/
3: What’s in a database ? (19 มิย. 2017)
https://www.scarydba.com/2017/06/20/database-fundamentals-3-whats-database/
4: สร้าง Database (26 มิย. 2017)
https://www.scarydba.com/2017/06/26/database-fundamentals-4-create-database/
5: คุณสมบัติของ Database (17 กค.2017)
https://www.scarydba.com/2017/07/17/database-fundamentals-5-database-properties/
6: สร้าง Table ด้วย SSMS GUI (24 กค. 2017)
https://www.scarydba.com/2017/07/24/database-fundamentals-6-create-table/
7: สร้าง Table ด้วย T-SQL (7 สค. 2017)
https://www.scarydba.com/2017/08/07/database-fundamentals-7-create-table-using-t-sql/
8: ชนิดของข้อมูล Data Types (29 สค. 2017)
https://www.scarydba.com/2017/08/29/database-fundamentals-8-data-types/
9: Schema as Containers (6 กย. 2017)
https://www.scarydba.com/2017/09/06/database-fundamentals-9-schemas-containers/
10: Modifying tables (12 กย. 2017)
https://www.scarydba.com/2017/09/12/database-fundamentals-10-modifying-tables/
11: Why Learn T-SQL ? (18 กย. 2017)
https://www.scarydba.com/2017/09/18/database-fundamentals-11-learn-t-sql/
12: เพิ่มข้อมูลด้วย SSMS GUI (25 กย. 2017)
https://www.scarydba.com/2017/09/25/database-fundamentals-12-adding-data-ssms-gui/
13: บันทึกข้อมูลด้วย T-SQL (11 ตค. 2017)
https://www.scarydba.com/2017/10/11/database-fundamentals-13-data-entry-t-sql/
14: Modifying Data through SSMS (16 ตค. 2017)
https://www.scarydba.com/2017/10/16/database-fundamentals-14-modifying-data-ssms/
15: Modifying Data with T-SQL (27 พย. 2017)
https://www.scarydba.com/2017/11/27/database-fundamentals-15-modifying-data-t-sql/
16: Removing Data with T-SQL (22 มค. 2018)
https://www.scarydba.com/2018/01/22/database-fundamentals-16-removing-data-t-sql/
17: Learning T-SQL (18 มิย. 2018)
https://www.scarydba.com/2018/06/18/database-fundamentals-17-learning-t-sql/
18: The SELECT Statement (23 กค. 2018)
https://www.scarydba.com/2018/07/23/database-fundamentals-18-the-select-statement/
19: เชื่อมไฟล์ฐานข้อมูล JOINS (8 ตค. 2018)
https://www.scarydba.com/2018/10/08/database-fundamentals-19-joins/
20: Using the JOIN Operator, Inner Join (3 ธค. 2018)
https://www.scarydba.com/2018/12/03/database-fundamentals-20-using-the-join-operator-inner-join/
21: Using the JOIN Operator, OUTER JOIN (15 เมย. 2019)
https://www.scarydba.com/2019/04/15/database-fundamentals-21-using-the-join-operator-outer-join/
22: Using the Join Operator, CROSS JOIN (23 กย. 2019)
https://www.scarydba.com/2019/09/23/database-fundamentals-22-using-the-join-operator-cross-join/
23: (ถูกข้ามไป ไม่ปรากฏใน Blog)
24: Filtering Data กรองข้อมูล (14 ตค. 2019)
https://www.scarydba.com/2019/10/14/database-fundamentals-24-filtering-data/
25 : Referential Integrity (26 พค.2020)
https://www.scarydba.com/2020/05/26/database-fundamentals-25-referential-integrity/
26 : The Primary Key War (22 มิย.2020)
https://www.scarydba.com/2020/06/22/database-fundamentals-26-the-primary-key-war/
27 : Creating a Primary Key in the Table Designer (14 กค.2020)
https://www.scarydba.com/2020/07/14/database-fundamentals-27-creating-a-primary-key-in-the-table-designer/
28 : Creating a Primary Key Using T-SQL (28 กค.2020)
https://www.scarydba.com/2020/07/28/database-fundamentals-28-creating-a-primary-key-using-t-sql/
29 : Creating Foreign Keys with Table Designer (2 พย.2020)
30: Create Foreign Keys with T-SQL (24 พค.2021)
https://www.scarydba.com/2021/05/24/database-fundamentals-30-create-foreign-keys-with-t-sql/
31: Unique Constraints from the GUI (28 กพ. 2022)
https://www.scarydba.com/2022/02/28/database-fundamentals-31-unique-constraints-from-the-gui/
31: Create Unique Constraints with T-SQL (25 กค. 2022)
https://www.scarydba.com/2022/07/25/database-fundamentals-32-create-unique-constraints-with-t-sql/
--------------
Grant Fritchey อยู่บริษัท Red Gate Software
https://www.red-gate.com/simple-talk/author/grant-fritchey/
