-
Before You Start 1
-
Module 0: 실습 환경 구성 30 minLecture1.1
-
-
Section 1: Modules 1-2 4
-
Module 1: Introduction to Transact-SQL 01 hourLecture2.1
-
Lab 1 . Introduction to Transact-SQL 30 minLecture2.2
-
Module 2: Querying Tables with SELECT 30 minLecture2.3
-
Lab 2 . Querying Tables with SELECT 30 minLecture2.4
-
-
Section 2: Modules 3-5 6
-
Module 3: Querying Multiple Tables with Joins 30 minLecture3.1
-
Lab 3 . Querying Multiple Tables with Joins 30 minLecture3.2
-
Module 4: Using Set Operators 20 minLecture3.3
-
Lab 4 . Using Set Operators 30 minLecture3.4
-
Module 5: Using Functions and Aggregating Data 30 minLecture3.5
-
Lab 5 . Using Functions and Aggregating Data 30 minLecture3.6
-
-
Section 3: Modules 6-8 6
-
Module 6: Using Subqueries and APPLY 30 minLecture4.1
-
Lab 6 . Using Subqueries and APPLY 30 minLecture4.2
-
Module 7: Using Table Expressions 30 minLecture4.3
-
Lab 7 . Using Table Expressions 30 minLecture4.4
-
Module 8: Grouping Sets and Pivoting Data 30 minLecture4.5
-
Lab 8 . Grouping Sets and Pivoting Data 30 minLecture4.6
-
-
Section 4: Modules 9-11 6
-
Module 9: Modifying Data 30 minLecture5.1
-
Lab 9 . Modifying Data 30 minLecture5.2
-
Module 10: Programming with Transact-SQL 30 minLecture5.3
-
Lab 10 . Programming with Transact-SQL 30 minLecture5.4
-
Module 11: Error Handling and Transactions 30 minLecture5.5
-
Lab 11 . Error Handling and Transactions 30 minLecture5.6
-
This content is protected, please login and enroll course to view this content!