| introduction course materials prerequisites course outline setup microsoft official curriculum microsoft certified professional program facilities module 1: sql server overview what is sql server? sql server integration sql server databases sql server security working with sql server lab a: sql server overview review module 2: overview of programming sql server designing enterprise application architecture .sql server programming tools the transact-sql programming language elements of transact-sql additional language elements ways to execute transact-sql statements recommended practices lab a: overview of transact-sql review module 3: creating and managing databases creating databases creating filegroups managing databases introduction to data structures recommended practices lab a: creating and managing databases review module 4: creating data types and tables creating data types creating tables generating column values generating scripts recommended practices lab a: creating data types and tables review module 5: implementing data integrity types of data integrity enforcing data integrity defining constraints types of constraints disabling constraints using defaults and rules deciding which enforcement method to use recommended practices lab a: implementing data integrity review module 6: planning indexes introduction to indexes index architecture how sql server retrieves stored data how sql server maintains index and heap structures deciding which columns to index recommended practices lab a: determining the indexes of a table review module 7: creating and maintaining indexes creating indexes creating index options maintaining indexes lab a: creating and maintaining indexes introduction to statistics querying the sysindexes table setting up indexes using the index tuning wizard performance considerations recommended practices lab b: viewing index statistics review module 8: implementing views introduction to views advantages of views defining views modifying data through views, optimizing performance by using views recommended practices lab a: implementing views review module 9: implementing stored procedures introduction to stored procedures creating, executing, modifying, and dropping stored procedures lab a: creating stored procedures using parameters in stored procedures executing extended stored procedures handling error messages performance considerations recommended practices lab b' creating stored procedures using parameters review module 10: implementing user-defined functions what is a user-defined function? defining user-defined functions examples of user-defined functions recommended practices lab a: creating user-defined functions review module 11: implementing triggers introduction to triggers defining triggers how triggers work examples of triggers performance considerations recommended practices lab a: creating triggers review module 12: programming across multiple servers introduction to distributed queries executing an ad hoc query on a remote data source setting up a linked server environment executing a query on a linked server executing a stored procedure on a linked server managing distributed transactions modifying data on a linked server using partitioned views recommended practices lab a: using distributed data review module 13: optimizing query performance introduction to the query optimizer obtaining execution plan information using an index to cover a query indexing strategies overriding the query optimizer recommended practices lab a: optimizing query performance review module 14: analyzing queries queries that use the and operator queries that use the or operator lab a: analyzing queries that use the and and or operators queries that use join operations lab b: analyzing queries that use different join strategies recommended practices review module 15: managing transactions and locks introduction to transactions and locks managing transactions sql server locking managing locks recommended practices lab a: managing transactions and locks review classroom setup guide classroom requirements classroom configuration setup instructions automated classroom setup classroom setup checklist customization information |
内容加载中，请稍后...
商品评论（0条）