昨天的 T-SQL Term 7 Class 1, 业界高级 BI 专家 Dr. Shin 讲了很多内容,
本次课讲述的要点和课程布置的项目已经放在了课程网页上。1. Brief history of T-SQL
2. ...
3. A trick: how to set different color for different instance when you open SSMS
4. ...
5. ...
7. Several important System Functions and Metadata functions.
8. ...
9. Query metadata
10. ...
11. ...
12. ...
13. ...
14. ...
15. SQL Server 2014/2019 Environment and Tools for T-SQL
i. Introduce PowerShell ISE
ii. Introduce SQLCMD
16. ...
17. ...
18. T-SQL Control-Flow-Language
19. Many examples of IF / ELSE
i. A lot of new features in SQL Server 2019
ii. Declare a variable and set a value
iii. Varchar/nvarchar
iv. Syntax changes for dropping a table
v. Create a store procedure with or without parameters
20. Project ( 27 questions on Practical SQL Queries to solve Business Problems)
看过TSQL课视频的同学在微信上发帖说:“感觉和TSQL ”相见恨晚”. 加油学习TSQL,把自己的SQL水平提高到一定 level. 在自己的面试中不要再失败."