Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2Ewill clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on: Create and alter databases. Manage security and implement permissions. Protect, backup, and restore data. Enforce and ensure data integrity. Modify and manipulate data. Create views, triggers, functions, and stored procedures.

Business Modeling and Data Mining demonstrates how real world business problems can be formulated so that data mining can answer them. The concepts and techniques presented in this book are the essential building blocks in understanding what models are and how they can be used practically to reveal hidden assumptions and needs, determine problems, discover data, determine costs, and explore the whole domain of the problem. This book articulately explains how to understand both the strategic and tactical aspects of any business problem, identify where the key leverage points are and determine where quantitative techniques of analysis -- such as data mining -- can yield most benefit. It addresses techniques for discovering how to turn colloquial expression and vague descriptions of a business problem first into qualitative models and then into well-defined quantitative models (using data mining) that can then be used to find a solution. The book completes the process by illustrating how these findings from data mining can be turned into strategic or tactical implementations. Teaches how to discover, construct and refine models that are useful in business situations Teaches how to design, discover and develop the data necessary for mining Provides a practical approach to mining data for all business situations Provides a comprehensive, easy-to-use, fully interactive methodology for building models and mining data Provides pointers to supplemental online resources, including a downloadable version of the methodology and software tools.

Sams Teach Yourself SQL in 21 Days, Fourth Editionprovides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.

.NET Windows Forms are a new programming paradigm introduced with Microsoft's .NET initiative. Windows Forms are very similar to Web Forms, which allow programmers to build complex Web application interfaces easily, sharing the same underlying framework and programming concepts. Windows Forms, however, are used for the Win32 platform, instead of the Internet, and allow programmers to build traditional Windows desktop-based applications structured around .NET. Sams Teach Yourself .NET Windows Forms in 21 Days covers all the major aspects of Windows Forms necessary to build professional, functional applications. This book follows the tried-and-tested 21 Days tutorial model to guide the reader through Windows Forms. It features code examples and tips for programmers migrating from pre-Windows Forms Microsoft technologies. The reader will be introduced to the many controls available for .NET Windows Forms and how to build them, learn how to create events and event handlers, explore ADO.NET and methods to retrieve data from dynamic data sources, and learn how to take advantage of the Internet and Internet Explorer from their .NET Windows Forms applications. As readers advance through the tutorials, they progress toward more advanced topics and projects by creating simple graphical applications and enhancing existing ones, learn how to integrate with other .NET applications, use Web services, build Windows services, build Windows Forms controls, create multi-threaded applications, work with COM and COM+ configure and deploy .NET Windows Forms, and how to de-bug .NET Windows Forms.

This guide teaches readers how to design and implement their an open source database. Topics include designing and creating a database; normalizing data; adding tables, columns and indexes; importing and exporting data; administering, optimizing and troubleshooting My SQL; and locks and keys.

Sams Teach Yourself Transact-SQL in 21 Days, 2E will teach programmers how to develop Transact-SQL queries. There will be a focus on providing methods for improving productivity without a reducing performance. Specifically, the reader will:Learn Transact-SQL syntax Learn how to add, delete, and modifying data using Transact-SQL Understand coding standards Review variations from ANSI-standard SQL Be presented with basic server operations. Recognize performance issues with queries. This book will also include:Constructs such as CUBE, ROLLUP, CASE, and JOIN. Techniques to solve complex problems How the server uses indexes Methods to write (correctly) stored procedures and triggers. Templates of procedures and triggers (reference) Advanced Topics such as: Outer and self joins Temporary tables Sub-queries.

A guide to ASP and IIS fundamentals covers dynamic content, interactivity, writing files on the Web server, personalizing content, reading databases, and debugging scripts.