| introduction course materials prerequisites course outline appendices microsoft official curriculum microsoft certified professional program facilities module 1: introduction to transact-sql the transact-sql programming language types of transact-sql statements transact-sql syntax elements lab a: using sql server books online review module 2: using transact-sql querying tools sql query analyzer using the object browser tool in sql query analyzer using templates in sql query analyzer using the osql utility executing transact-sql statements .recommended practices lab a: creating and executing transact-sql scripts review module 3: retrieving data retrieving data by using the select statement filtering data formatting result sets how queries are processed how queries are cached automatically performance considerations recommended practices lab a: retrieving data and manipulating result sets review module 4: grouping and summarizing data listing the top n values using aggregate functions group by fundamentals generating aggregate values within result sets using the compute and compute by clauses recommended practices lab a: grouping and summarizing data review module 5: joining multiple tables using aliases for table names combining data from multiple tables combining multiple result sets recommended practices lab a: querying multiple tables review module 6: working with subqueries introduction to subqueries using a subquery as a derived table using a subquery as an expression using a subquery to correlate data using the exists and not exists clauses recommended practices lab a: working with subqueries review module 7: modifying data using transactions inserting data deleting data updating data performance considerations recommended practices lab a: modifying data review module 8: querying full-text indexes introduction to microsoft search service microsoft search service components getting information about full-text indexes writing full-text querie recommended practices lab a: querying full-text indexes review module 9: introduction to programming objects displaying the text of a programming object introduction to views advantages of views creating views introduction to stored procedures introduction to triggers introduction to user-defined functions recommended practices lab a: working with views review appendix a: library database case study appendix b: database schemas automated classroom setup guide classroom requirements classroom configuration setup instructions automated classroom setup classroom setup checklist customization information |
内容加载中，请稍后...
商品评论（0条）