SQL in a Nutshell, 4th Edition
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts-all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards; Fundamental concepts necessary for understanding relational databases and SQL commands; An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard; The implementation of each comma ...
For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts-all packed into a succinct, comprehensive, and easy-to-use format. Sections include: Background on the relational database model, including current and previous SQL standards; Fundamental concepts necessary for understanding relational databases and SQL commands; An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard; The implementation of each comma ...
C# Database Basics
Working with data and databases in C# certainly can be daunting if you're coming from VB6, VBA, or Access. With this hands-on guide, you'll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C# - basic skills you need if you intend to program with this language. No previous knowledge of C# is necessary. By following the examples in this book, you'll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book's code samples will help you get started on your own projects. ...
Working with data and databases in C# certainly can be daunting if you're coming from VB6, VBA, or Access. With this hands-on guide, you'll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C# - basic skills you need if you intend to program with this language. No previous knowledge of C# is necessary. By following the examples in this book, you'll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book's code samples will help you get started on your own projects. ...
Working with NHibernate 3.0
This book provides examples using the IQuery, ICriteria, QueryOver, and LINQ to NHibernate API's within the context of an example Guitar Store inventory program. The reader is walked through the creation of a Microsoft SQL Server 2008 database, the creation of a Visual Studio 2010 solution consisting of 3 projects (a Window Presentation Foundation (WPF), a Console Application, and a Class Library). Each one utilizes the .NET 4.0 framework. Then the reader is walked through the steps required to configure and use the many features available contained within NHibernate 3.2. Further instructions and examples exist for the insertion of parent / child relationships, Session management, entity states (transient, persistent and detached), deletion, caching, and batching. ...
This book provides examples using the IQuery, ICriteria, QueryOver, and LINQ to NHibernate API's within the context of an example Guitar Store inventory program. The reader is walked through the creation of a Microsoft SQL Server 2008 database, the creation of a Visual Studio 2010 solution consisting of 3 projects (a Window Presentation Foundation (WPF), a Console Application, and a Class Library). Each one utilizes the .NET 4.0 framework. Then the reader is walked through the steps required to configure and use the many features available contained within NHibernate 3.2. Further instructions and examples exist for the insertion of parent / child relationships, Session management, entity states (transient, persistent and detached), deletion, caching, and batching. ...
Beginning Database Design
The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently. Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle. Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance. ...
The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently. Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle. Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance. ...
Microsoft SQL Server Reporting Services Recipes
Have you mastered the "how-tos" of Reporting Services? Can you confidently design simple reportsbut now you need help with meeting the demands of more complex and advanced types of reports? If so, this is the ideal resource for you. Packed with proven design practices, this book serves as a collection of recipes for solving design problems so that you don't have to reinvent the wheel with each challenge you face. Organized by specific types of reports, the book covers grouped reports, charts, composite reports, dashboards, forms and labels, interactive reports, and more. ...
Have you mastered the "how-tos" of Reporting Services? Can you confidently design simple reportsbut now you need help with meeting the demands of more complex and advanced types of reports? If so, this is the ideal resource for you. Packed with proven design practices, this book serves as a collection of recipes for solving design problems so that you don't have to reinvent the wheel with each challenge you face. Organized by specific types of reports, the book covers grouped reports, charts, composite reports, dashboards, forms and labels, interactive reports, and more. ...
Applied XML Programming for Microsoft .NET
XML is everywhere in the Microsoft .NET Framework, from Remoting to Web services and from data access to configuration. Learn about the extensive XML core classes in .NET and find out how to program against its parser in this in-depth guide - written by a popular programming author and consultant on cutting-edge technologies such as Microsoft ASP.NET and Microsoft ADO.NET. You'll find authoritative explanations of technologies such as schemas, transformations, and XPath, plus extensive discussion of data access issues such as synchronization and serialization, the DiffGram format, and the XML extensions in Microsoft SQL Server. ...
XML is everywhere in the Microsoft .NET Framework, from Remoting to Web services and from data access to configuration. Learn about the extensive XML core classes in .NET and find out how to program against its parser in this in-depth guide - written by a popular programming author and consultant on cutting-edge technologies such as Microsoft ASP.NET and Microsoft ADO.NET. You'll find authoritative explanations of technologies such as schemas, transformations, and XPath, plus extensive discussion of data access issues such as synchronization and serialization, the DiffGram format, and the XML extensions in Microsoft SQL Server. ...
Access 2010 All-in-One For Dummies
If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it's what you need to make Access more accesssible. ...
If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it's what you need to make Access more accesssible. ...
Business Intelligence in Microsoft SharePoint 2013
Dive into the business intelligence features in SharePoint 2013 - and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. Led by a group of BI and SharePoint experts, you'll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios - whether you're a SharePoint administrator, SQL Server developer, or business analyst. ...
Dive into the business intelligence features in SharePoint 2013 - and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server 2012. Led by a group of BI and SharePoint experts, you'll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios - whether you're a SharePoint administrator, SQL Server developer, or business analyst. ...
Professional ASP.NET 2.0 XML
You'll also learn more about SQL Server 2005 XML features, XML serialization, and XML Web services. You'll see how XML can be used to increase application efficiency and reach. Two helpful real-life case studies used throughout the book demonstrate the many ways that XML documents can be created, transformed, and transmitted to other systems using ASP.NET. ...
You'll also learn more about SQL Server 2005 XML features, XML serialization, and XML Web services. You'll see how XML can be used to increase application efficiency and reach. Two helpful real-life case studies used throughout the book demonstrate the many ways that XML documents can be created, transformed, and transmitted to other systems using ASP.NET. ...
Expert One-on-One Visual Basic 2005 Database Programming
Are you hesitant to migrate to Visual Studio 2005? Maybe you're ready to upgrade to Visual Basic 2005 but feel a bit overwhelmed by ADO.NET 2.0 and the Visual Data Tools of this new release. In this hands-on guide, I'll share with you the best practices, the latest features, and advanced data management techniques with Visual Basic 2005 and SQL Server or SQL Server Express 2005. Plus, I'll incorporate simple to moderately complex project examples that feature real-world, database front-end applications with Windows and Web forms. ...
Are you hesitant to migrate to Visual Studio 2005? Maybe you're ready to upgrade to Visual Basic 2005 but feel a bit overwhelmed by ADO.NET 2.0 and the Visual Data Tools of this new release. In this hands-on guide, I'll share with you the best practices, the latest features, and advanced data management techniques with Visual Basic 2005 and SQL Server or SQL Server Express 2005. Plus, I'll incorporate simple to moderately complex project examples that feature real-world, database front-end applications with Windows and Web forms. ...