| about this curse introduction introductions course materials prerequisites course outline course outline course outline appendices microsoft certified professional program facilities module 1 : sql server overview what is sql server sql server architecture sql server security sql server databases working with sql server lab ii: sql server overview review. . module 2: overview of transact-sql sql server programming tools. the transact-sql programming language elements of transact-sql ways to execute transact-sql statements how queries are processed recommended practices lab 2. l : overview of transact-sql review module 3: creating databases how data is stored creating databases modifying databases creating filegroups lab 3. l : creating databases the library database creating data types creating tables generating scripts recommended practices lab 3.2: creating database objects review module 4:implementing data integrity types of data integrity enforcing data integrity using constraints using defaults and rules deciding which enforcement method to use recommended practices lab 4. l : implementing data integrity review module 5:planning and creating indexes introduction to indexes index architecture creating indexes create index options lab 5. l : creating indexes maintaining indexes performance considerations recommended practices lab 5.2: maintaining indexes review module 6: querying multiple tables combining data from multiple tables combining multiple result sets creating a table from a result set recommended practices lab 6. l : querying multiple tables review module 7: advanced query techniques introduction to subqueries nested subqueries correlated subqueries using the exists and not extsts keywords modifying data recommended practices lab 7. l : advanced query techniques review module 8: summarizing date using aggregate functions. group by fundamentals generating aggregate values within result sets using the compute and compute by clauses listing the top n values recommended practices lab 8. l : summarizing data review module 9: managing transactions and locks introduction to transactions and locks managing transactions managing locks deadlocks. recommended practices lab 9. 1 : managing transactions and locks review module 10: working with distributed data 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 modifying data on a linked server distributing data. recommended practices lab 10.l : working with distributed data review . module 11 : implementing views what is a view advantages of views defining views modifying data through views performance considerations recommended practices lab 1l.1: implementing views review module 12: implementing stored procedures introduction to stored procedures creating, executing, and modifying stored procedures lab 12.1i : creating stored procedures using parameters in stored procedures executing extended stored procedures handling error messages performance considerations recommended practices lab 12.2: creating stored procedures with parameters review module 13: implementing triggers introduction to triggers defining triggers examples of triggers recommended practices lab 13. l : creating triggers review module 14: advanced text queries microsoft search service lab 14.l: microso8 search service microsoft english query lab 14.2: microsoft english query review appendix a: library database case study introduction overview of library operations daily library functions. library database design appendix b: database schemas appendix c: performing basic queries retrieving data formatting result sets lab c. 1 : retrieving data and manipulating result sets modifying data performance considerations recommended practices lab c.2: modifying data review lab c.1 : retrieving data and manipulatingresultsets objective before you begin exercise l retrieving data exercise 2 manipulating result sets lab c.2: modifying data objective before you begin exercise l using the insert statement exercise 2 using the inseb.t statement with the default keyword exercise 3 using the insert statement with the default values keyword exercise 4 using the deletb statement exercise 5 using the update statement appendix d: using cursors what is a cursor methods of calling cursors transact-sql cursors demonstration: using transact-sql cursors recommended practices review trainer lab manual lab 1.1: sol server overview objectives exercise l using sql server books online exercise 2 creating a database diagram lab 2.1 : overview of transact-sql objectives before yon begin exercise l writing basic select statements exercise 2 modifying a script file. exercise 3 using system functions. lab 3.1 : creating databases objective . before you begin exercise l creating the library database exercise 2 managing the growth of the library log file exercise 3 setting an option to clear the transaction log lab 3.2:creating database objects objectives before you begin exercise l creating user-defined data types exercise 2 creating tables in the library database exercise 3 adding and dropping columns exercise 4 generating sql scripts exercise 5 loading the library database with sample data lab 4.1 : implementing data integrity objectives before you begin exercise i defining default constraints exercise 2 defining check constraints exercise 3 defining primary key constraints exercise 4 de8ning foreign key constraints if time permits creating defaults and rules lab 5.1 : creating indeses objective before you begin exercise l creating indexes lab 5.2: maintaining indexes ' objectives before you begin exercise i using the fillfactor and dbcc showcontig options exercise 2 gathering query performance information lab 6.1 : querying multiple tables objectives before you begin exercise. i joining tables. exercise 2 using the union operator to combine result sets exercise 3 creating temporary tables lab 7.1 : advanced query techniques objectives before you begin exercise l using subqueries exercise 2 modifying tables based on data in other tables lab 8.1: summarizing data objectives before you begin exercise l using the group by and iiavdi6 clauses exercise 2 using the rollup and cube operators exercise 3 using the compute and computeby clauses if time permits using the top n keyword lab 9.1 : managing transeactions and locks objectives before you begin exercise l creating and executing a transaction exercise 2 rolling back a transaction exercise 3 viewing locking information exercise 4 setting locking options. lab 10.1 : working with distributed data objectives before you begin exercise l setting up linked servers exercise 2 querying remote data if time permits managing distributed transactions lab 11.1: implementing views objectives before you begin exercise l creating and testing views exercise 2 creating a view of a view exercise 3 encrypting a view de8nition exercise 4 modifying data through views exercise 5 locating view definitions exercise 6 testing effects of ownership chains if time permits creating a view with sql server enterprise manager lab 12.1 : creating stored procedures objectives before you begin exercise l writing and executing a stored procedure exercise 2 locating stored procedure information lab 12.2: creating stored procedures with parameters objectives before you begin exercise l using the create stored procedure wizard exercise 2 creating stored procedures from scripts exercise 3 altering stored procedures exercise 4 customizing error messages exercise 5 using return codes if time permits executing extended stored procedures if time permits monitoring the procedure cache lab 13.1 : creating triggers objectives before you begin exercise l creating triggers exercise 2 creating a trigger for updating derived data exercise 3 creating a trigger that maintains a complex business rule exercise 4 creating a trigger for the reservation table exercise 5 testing nested triggers. lab 14.1 : microsoft search service objectives before you begin exercise l setting up microsoft search service exercise 2 writing full-text queries if time permits setting up microsoft search service by using system stored procedures lab 14.2: microsoft english query objectives before you begin for more information exercise i installing english query. exercise 2 using english query. exercise 3 creating an english query application if time permits review the english query tutorial classroom setup guide classroom requirements classroom configuration setup instructions |
内容加载中，请稍后...
商品评论（0条）