Microsoft Sql Server 2000 Weekend Crash Course

Microsoft SQL Server 2000 Weekend Crash Course includes 30 sessions on the key aspects of Microsoft SQL Server 2000. Each session is designed to take 30 minutes to complete, so the Crash Course is an intense 15-hour learning period. You can complete the Crash Course over a weekend -- but you can also easily adapt the Crash Course sessions to whatever schedule best suits your needs.

Learn SQL fast! With SQL Weekend Crash Course, you can get up to speed on how to use SQL -- the standard international database language -- in a single weekend! This book consists of 30 sessions that teach the core concepts of ANSI SQL over a weekend (from Friday evening through Sunday afternoon). Naturally, you can adapt your learning to whatever schedule meets your needs. Coverage focuses on the following databases: Access, Oracle9i, SQL Server 2000, MySQL, and PostgreSQL. You'll pick up valuable skills such as: * Retrieving data * Adding, updating and deleting data * Using SQL within an application * Building database tables with SQL * Protecting the contents of a database * Dynamic SQL

Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle, SQL Server, and MySQL. Introduces SQL concepts, explains SQL statements, and clearly shows how to write efficient and effective SQL code Uses a hands-on style and a sample database that incorporates all SQL concepts taught in the book; this database will be enhanced through the book as key points and lessons are covered Covers topics such as how SQL interacts with the sample database via various interfaces, including vendor-provided utilities, programming languages, SQL clients, and productivity software Includes appendices with primers on database normalization, set theory and bollean algebra, RDBMS software step-by-step setup guides, and database connectivity Learn how to write effective, efficient SQL code with Discovering SQL: A Hands-On Guide for Beginners.

Written by expert web developers from Price Waterhouse-Coopers, ASP.NET Database Programming Weekend Crash Course will quickly enable you to create dynamic data-driven web applications using Microsoft's exciting new .NET technologies. Open the book on Friday evening and by Sunday afternoon -- after completing 30 fast, focused lessons -- you will have mastered the skills necessary to begin creating robust, dynamic, data-driven web applications with ASP.NET. Starting with ASP.NET basics, expert authors Jason and Tony teach you what they need to know to begin creating ASP.NET applications quickly, and then dive into building database applications with ADO.NET, Web Services, SOAP, XML and more. This book is a must have for any developer building web applications on Microsoft's new .NET Framework.

Focus: Book consists of 30 sessions that teach the core concepts of Windows .NET Server to Windows Administrators over a weekend. Covers the new features of the Windows .NET Server, including headless servers, Remote Desktop Services (RDS), and performance management. Learn how to implement Windows .NET Server as the base OS for the Microsoft .NET Framework and.NET Enterprise Servers, including SQL Server 2000 and Exchange 2000 Server. Covers Windows .NET Server's improvements to networking, Active Directory, usability, reliability, scalability, disaster recovery, management, and Internet integration as well as Windows basics and architecture; installing the Windows .NET Server; and managing server security. Running example: A running example of a fictitious major international bank is used to demonstrate key concepts. Windows interface tutorial on CD: For readers with no prior Windows experience at all, a Windows interface tutorial will be included as an appendix on the CD that accompanies the book. WCC series features: Each session takes 30 minutes to complete. Four time-to-go icons gauge the reader's progress through any given session. "Quiz Yourself" questions (at the end of each session) and "Part Review" questions allow the reader to review what they have just learned. Skill assessment software on the CD-ROM helps readers gauge their skill level before and after reading this book. ABOUT THE CD-ROM The CD-ROM has skills assessment software based on the sessions in the book and an appendix on the Windows interface.

Focus: Book consists of 30 sessions that teach the core concepts of Windows .NET Server to Windows Administrators over a weekend. Covers the new features of the Windows .NET Server, including headless servers, Remote Desktop Services (RDS), and performance management. Learn how to implement Windows .NET Server as the base OS for the Microsoft .NET Framework and.NET Enterprise Servers, including SQL Server 2000 and Exchange 2000 Server. Covers Windows .NET Server's improvements to networking, Active Directory, usability, reliability, scalability, disaster recovery, management, and Internet integration as well as Windows basics and architecture; installing the Windows .NET Server; and managing server security. Running example: A running example of a fictitious major international bank is used to demonstrate key concepts. Windows interface tutorial on CD: For readers with no prior Windows experience at all, a Windows interface tutorial will be included as an appendix on the CD that accompanies the book. WCC series features: Each session takes 30 minutes to complete. Four time-to-go icons gauge the reader's progress through any given session. "Quiz Yourself" questions (at the end of each session) and "Part Review" questions allow the reader to review what they have just learned. Skill assessment software on the CD-ROM helps readers gauge their skill level before and after reading this book. ABOUT THE CD-ROM The CD-ROM has skills assessment software based on the sessions in the book and an appendix on the Windows interface.

Open the book on Friday evening and by Sunday afternoon ñ- after completing 30 fast, focused lessons - you will have mastered the skills necessary to begin creating robust, dynamic, data-driven web applications with ASP.NET. In just one weekend, expert developer Robert Standefer leads you into the new world ofMicrosoft.NET, and enables you to create robust, dynamic, data-drive web applications. Starting with ASP.NETbasics, Robert teaches you what you need to know to begin creating ASP.NET applications quickly, and easily. This book is a must have for any developer building web applications on Microsoft's new .NET Framework.