Microsoft SQL Server 2005 Video CBT Course by Examples SQL ,T_SQL, Administration,for DBA and Developers Start Price USD 25.00 Current Price USD 25.00 Time Left 2 days 1 hours 48 minutes Bid Count 0 Buy It Now Price - Reserve Price - Start Time Thursday, November 13, 2008 End Time Monday, January 12, 2009 Location New York, New York See more about 'Microsoft SQL Server 2005 Video CBT Course by Examples' Description   Updated May  2008 Microsoft SQL Server 2005  Video CBT Course by Examples  for DBA and Developers.   1 .Introduction  SQL Server Overview Transact SQL  Installing SQL Server 2005   sql, T-SQLtables, procedure,functions,index, views,transactions ,cursor,xml, serviceprincipal ,securables ,permissionsAdministrative Tools 2. Using Transact-SQL on a SQL Server Database introduces youto Transact-SQL and provides details about how to create and execute Transact-SQL statements in order to manage a SQL Server database and its data. Thechapter also introduces you to the SQL Server programming tools that allowyou to use Transact-SQL to interface with the database. 3. Designing a SQL Server Database introduces you to the processof creating a SQL Server database. It describes the basic concepts of databasedesign and provides information about planning a database, identifying systemrequirements, and developing a logical data model. 4. Implementing SQL Server Databases and Tables explains how tocreate and manage a SQL Server database. It then discusses data types and howto identify which ones to use when creating a table. The chapter also describeshow to create these tables¡ªusing the data type information¡ªand how to modifythe tables after they have been created. 5. Implementing Data Integrity provides an overview of the variousmethods that you can use to maintain data integrity and a description of the typesof data integrity that you will find in a SQL Server database. The chapter alsoprovides detailed information about the various types of integrity constraints thatyou can use to enforce data integrity and how to implement them in a database. 6. Accessing and Modifying Data provides detailed informationabout four Transact-SQL statements (SELECT, INSERT, UPDATE, andDELETE) and describes how each statement is used in Query Analyzer toretrieve and modify data. This chapter also introduces you to other methods foradding, modifying, and deleting data. 7. Managing and Manipulating Datadescribes more techniques formanaging and manipulating data, including how to import and export data, howto manipulate heterogeneous data, how to use Transact-SQL cursors, and howto extract data in XML format. 8.Implementing Stored Procedures. introduces you to the types ofstored procedures available in SQL Server  and how to create, execute, andalter them. You are also introduced to programming stored procedures. 9. Implementing Triggers introduces you to triggers and how to usethem to extend data integrity and implement complex business logic. You willlearn when it is appropriate to implement triggers and when basic constraintswill suffice. You will also learn how to program triggers and how to use systemcommands and functions commonly used in trigger programming. 10. Implementing Views introduces you to views and the variousfunctionality that they support. You will learn how to use views to insert,update, and modify data. 11. Implementing Indexes introduces you to the structure and purposeof indexes and the types and characteristics of indexes. You will learn howto determine when an index is appropriate, the type of index to create, and howto create it. 12. Managing SQL Server Transactions and Locks introduces you tothe fundamentals of transactions and locks and describes how transactions andlocks are used to process data modifications. 13. Designing and Administering SQL Server Security. introducesyou to SQL Server security. You will learn how to design SQL Serversecurity to accommodate user requirements and protect the database fromunauthorized access. 14. SQL Server Monitoring and Performance Tuning examines how to use SQLProfiler to monitor a database system and explores methods of improving databaseperformance through partitioning and index tuning. 15. Distributed database    Distributed daatbase design and implementation 16. Database Backups  Restoring Data  , maintenance,Data Storage SQL Profiler ,High Availability and more .....   ----------------------------------------------------------------- System requirements It is regular DVD format.  It can be played on a regular home DVD player . It can also be played on a computer with DVD rom.   License Agreement The price is for 1 license  only . You can use by yourself or use it in a classroom as long as the main user is at the scene. You are not allowed to duplicate any part of the video.    Place a Bid!