SQL Books
-
Database Programming with Visual Basic .NET, Second Edition
Published 18 years ago includes sample chapter
by Carsten Thomsen, Apress
Take your pick: you may either read this book cover-to-cover, or just refer to it when you want ready-made solutions of "drop-in" code. Either way, Database Programming with Visual Basic .NET, Second Edition will teach you to master ADO.NET programmatically and from within the VS. NET IDE. You will learn the concepts of disconnected data access with ADO.NET. You'll also learn to create tables, constraints, projects, stored procedures, views, and triggers.
-
A Programmer's Guide to ADO .NET in C
Published 18 years ago includes sample chapter
by Mahesh Chand, Apress
This essential guide to Microsoft's ADO.NET overviews C#, then leads you toward deeper understanding of ADO.NET. Author Mahesh Chand provides key information about using each of .NET's major data providers, including OLE DB, SQL Server, and the released version of ODBC. Also featured are the methods and properties associated with these data providers' classes. Further, Chand shows you how to work with XML classes, integrate XML into the ADO
-
Database Programming With C
Published 18 years ago includes sample chapter
by Carsten Thomsen, Apress
Need to master database programming in C#? Then Database Programming with C# is your ultimate resource! You will learn to create database details like tables, constraints, projects, stored procedures, views, triggers, and more. You will build on example code from the book's beginning, wrapping up in the final chapter. (The example application is a complete user management system that includes SQL Server, Active Directory, and Message Queuing.
-
SQL: Access to SQL Server
Published 19 years ago includes sample chapter
by Susan Sales Harkins, Martin W.P. Reid, Apress
SQL: Access to SQL Server is more than just a comprehensive reference tool for Access developers. You'll also find efficient SQL solutions for common Access problems and tasks, as well as helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from just using Access to developing with Access. In addition to learning Jet SQL, readers will embark on a journey into the world of SQL Server 2000.
-
Data Mining & Statistical Analysis Using SQL
Published 19 years ago includes sample chapter
by Jr., John N. Lovett, Apress
Data Mining and Statistical Analysis Using SQL concerns itself with the interface between applied mathematics--the discipline of statistical analysis--and really applied mathematics in the form of Structured Query Language (SQL) code that carries out such analysis. It's a subject that deserves careful coverage in a book, and the authors of this one--both working analysts with distinguished academic backgrounds--have done great work.
-
Code Centric: T-SQL Programming with Stored Procedures and Triggers
Published 20 years ago includes sample chapter
by Garth Wells, Apress
If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, Code Centric: T-SQL Programming with Stored Procedures and Triggers is the book for you. You'll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.
-
Advanced Transact-SQL for SQL Server 2000
Published 20 years ago includes sample chapter
by Itzik Ben-Gan, Tom Moreau, Apress
In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL (T-SQL). Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server, with a focus on the latest version, SQL Server 2000. Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of T-SQL.
-
From Access to SQL Server
Published 20 years ago includes sample chapter
by Russell Sinclair, Apress
Illustrates best practices for migrating Access databases to SQL Server. Carefully explains the differences between these two systems and the changes needed for a smooth migration. Assumes no prior knowledge of SQL Server. Although Microsoft's Access Database is extremely popular and adequate for smaller scale applications, many Access developers are discovering that their applications need a more robust, enterprise-ready database system like SQL Server.