Learn how to create, manage, and maintain both simple and advanced databases in SQL Server. Where's the action at in any database platform? The database.Put data in, pull data out, and change data in your database using the Transact-SQL (TSQL) language-beyond knowing what commands do what, you'll understand the syntax of the language so you can do much more with TSQL than we could ever teach you in the video.Automate tasks with SQL Server Agent so you can kick back, sip a cool drink, and get paid to do so-okay, so that may be overkill, but automating boring, common database tasks can make your life a lot easier.Copy data easily from one SQL Server to another using snapshot, transactional, or merge replication-and understand why you'd use each one.
Install SQL Server 2005-even upgrade with minimal downtime-then configure your installation for your database needs.Here's what you'll learn to do with SQL 2005:
Plus you'll be preparing for MCTS certification exam 70-431 at the same time. As you go through and watch each video, you learn not only the features that SQL Server 2005 has, but what they do and-most importantly-how to use them. In this series, instructor Garth Schulte shows you what's new, what's different, and what's useful. With this new version, there's a lot to learn. SQL Server 2005 is faster than all previous versions-it broke the 1,000,000 transactions per minute milestone, which means it can now compete with the major players in the enterprise database market.Now DBAs and Developers can work together more easily-the tools for each job have been integrated and simplified inside the new SQL Server Management Studio.SQL Server 2005 makes your life as a DBA or Developer easier because it combines good productivity features, easy to use new tools, and a more powerful than ever database engine.While much of the core functionality has been carried over from previous versions of SQL Server, many of the rules of play have changed: SQL Server 2005 has been tweaked drastically to make your life as a Database Administrator (DBA) or Developer easier. Exam-Pack 70-431: SQL Server 2005 Implementation and Maintenance