G.T

Hi !!! 我是一個資訊教學工作者，也是微軟(Microsoft)的MCT與思科(Cisco)的CCSI講師，主要教授微軟及思科相關的課程，這裡是屬於學習者的空間，歡迎資訊技術學習者一同來觀看。

PS:參訪此頻道的朋友問到，影片為什麼都沒有聲音；這是因為這裡的影片是原廠官方講師引導課程中的操作練習影片，是教室上課時的輔助教具，所以不會有聲音；有聲音的版本是做為線上教學用的，不會放在這裡頻道上。所以請大家包涵見諒嚕!!!

20461C_Mod12_Lab_E2-Writing Queries That Use the CROSS APPLY an OUTER APPLY Operators

20461C_Mod12_Lab_E2-Writing Queries That Use the CROSS APPLY an OUTER APPLY Operators
20461C_Mod12_Lab_E1-Writing Queries That Use UNION Set Operators and UNION ALL Multi-Set Operators

20461C_Mod12_Lab_E1-Writing Queries That Use UNION Set Operators and UNION ALL Multi-Set Operators
20461C_Mod11_Lab_E4-Writing Queries That Use Inline TVFs

20461C_Mod11_Lab_E4-Writing Queries That Use Inline TVFs
20461C_Mod11_Lab_E3-Writing Queries That Use CTEs

20461C_Mod11_Lab_E3-Writing Queries That Use CTEs
20461C_Mod11_Lab_E2-Writing a SELECT Statement Against a Derived Table

20461C_Mod11_Lab_E2-Writing a SELECT Statement Against a Derived Table
20461C_Mod11_Lab_E1-Writing Queries That Use Views

20461C_Mod11_Lab_E1-Writing Queries That Use Views
20461C_Mod10_Lab_E3-Writing Queries That Use Correlated Subqueries and an EXITS Predicate

20461C_Mod10_Lab_E3-Writing Queries That Use Correlated Subqueries and an EXITS Predicate
20461C_Mod10_Lab_E2-Writing Queries That Use Scalar an Multi-Result Subqueries

20461C_Mod10_Lab_E2-Writing Queries That Use Scalar an Multi-Result Subqueries
20461C_Mod10_Lab_E1-Writing Queries That Use Self-Contained Subqueries

20461C_Mod10_Lab_E1-Writing Queries That Use Self-Contained Subqueries
20461C_Mod9_Lab_E4-Writing Queries That Filter Groups with the HAVING Clause

20461C_Mod9_Lab_E4-Writing Queries That Filter Groups with the HAVING Clause
20461C_Mod9_Lab_E3-Writing a SELECT Statement to Retrieve the Number of Customers

20461C_Mod9_Lab_E3-Writing a SELECT Statement to Retrieve the Number of Customers
20461C_Mod9_Lab_E2-Writing Queries That Use Aggregate Functions

20461C_Mod9_Lab_E2-Writing Queries That Use Aggregate Functions
20461C_Mod9_Lab_E1-Writing Queries That Use the GROUP BY Clause

20461C_Mod9_Lab_E1-Writing Queries That Use the GROUP BY Clause
20461C_Mod8_Lab_E3-Writing Queries That Test for Nullability

20461C_Mod8_Lab_E3-Writing Queries That Test for Nullability
20461C_Mod8_Lab_E2-Writing Queries That Use Logical Functions

20461C_Mod8_Lab_E2-Writing Queries That Use Logical Functions
20461C_Mod8_Lab_E1-Writing Queries That Use Conversion Functions

20461C_Mod8_Lab_E1-Writing Queries That Use Conversion Functions
20461C_Mod7_Lab_E2-Update and Delete Records Using DML

20461C_Mod7_Lab_E2-Update and Delete Records Using DML
20461C_Mod7_Lab_E1-Inserting Records with DML

20461C_Mod7_Lab_E1-Inserting Records with DML
20461C_Mod6_Lab_E4-Writing Queries That Use Character Functions

20461C_Mod6_Lab_E4-Writing Queries That Use Character Functions
20461C_Mod6_Lab_E3-Writing Queries That Return Character Data

20461C_Mod6_Lab_E3-Writing Queries That Return Character Data
20461C_Mod6_Lab_E2-Writing Queries That Use Date and Time Functions

20461C_Mod6_Lab_E2-Writing Queries That Use Date and Time Functions
20461C_Mod6_Lab_E1-Writing Queries That Return Date and Time Data

20461C_Mod6_Lab_E1-Writing Queries That Return Date and Time Data
20461C_Mod5_Lab_E4-Writing Queries That Filter Data Using the OFFSET-FETCH Clause

20461C_Mod5_Lab_E4-Writing Queries That Filter Data Using the OFFSET-FETCH Clause
20461C_Mod5_Lab_E3-Writing Queries That Filter Data Using the TOP Option

20461C_Mod5_Lab_E3-Writing Queries That Filter Data Using the TOP Option
20461C_Mod5_Lab_E2-Witing Queries That Sort Data Using an ORDER BY Clause

20461C_Mod5_Lab_E2-Witing Queries That Sort Data Using an ORDER BY Clause
20461C_Mod5_Lab_E1-Sorting and Filtering Data

20461C_Mod5_Lab_E1-Sorting and Filtering Data
20461C_Mod4_Lab_E5-Writing Queries That Use Cross Joins

20461C_Mod4_Lab_E5-Writing Queries That Use Cross Joins
20461C_Mod4_Lab_E4-Writing Queries That Use Outer Joins

20461C_Mod4_Lab_E4-Writing Queries That Use Outer Joins
20461C_Mod4_Lab_E3-Write a Basic SELECT Statement

20461C_Mod4_Lab_E3-Write a Basic SELECT Statement
20461C_Mod4_Lab_E2-Writing Queries That Use Multiple-Table Inner Joins

20461C_Mod4_Lab_E2-Writing Queries That Use Multiple-Table Inner Joins