How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you'll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language -- helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow real-world best practices for T-SQL programming.To complement the learning experience, the book provides exercises to practice and apply what you've learned. And you'll examine recommended solutions to compare with your own work.
Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server’s spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You’ll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server’s spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You’ll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects. Explains spatial concepts from the ground up—no prior knowledge is necessary Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer Brilliantly illustrated with code examples that run in SQL Server 2012, that you can adapt and use as the basis for your own projects. What you’ll learn The fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems How to create and store spatial data using the geometry and geography data types How to use of spatial indexes in the design of highly-performant databases Write spatial queries to answer practical, business questions Pass spatial data seamlessly between database and application layers using T-SQL and C# Overcome common issues, including how to deal with invalid, imprecise, or erroneous spatial data Apply advanced techniques such as routefinding and clustering Who this book is for Pro Spatial with SQL Server 2012 is the go-to book for anyone involved in spatial applications involving Microsoft SQL Server 2012. The book helps database administrators create and optimize the performance of spatial database. The book gives developers what they need to know in order to make effective use of the extensive support for location-based data provided by SQL Server, T-SQL, and C#. Table of Contents1. Spatial Reference Systems 2. Spatial Features 3. Spatial Datatypes 4. Creating Spatial Data 5. Importing Spatial Data 6. Geocoding 7. Precision, Validity, and Errors 8. Transformation and Reprojection 9. Examining Spatial Properties 10. Modification and Simplification 11. Aggregation and Combination 12. Testing Spatial Relationships 13. Clustering and Distribution Analysis 14. Route Finding 15. Triangulation and Tesselation 16. Visualization and User Interface 17. Reporting Services 18. Indexing 19.
Teach yourself how to use ADO.NET 4, the data access technology that helps you create data-focused software faster and easier. With STEP BY STEP, you set the pace -- building and practicing the skills you need, just when you need them! Gain a firm understanding of the fundamental concepts and tools provided with ADO.NET 4.0, one feature at a time. With clear discussions and hands-on examples written in Visual Basic and C#, you'll move step-by-step through the learning process. Manage data and information in a database-like fashion -- without access to a database Connect to external data sources, including databases and other standard data formats Use Entity Framework to interact with underlying data stores Learn why LINQ is a popular tool for analyzing information retrieved by ADO.NET Drive information to end users by binding data directly to Windows Forms and Web Forms Go beyond the core functionality of ADO.NET to manipulate data in advanced ways Your online learning resources include: Files for building skills and practicing the book's lessons Examples and code in both the Visual Basic and C# languages Fully searchable eBook
Vidya Vrat Agarwal
Assuming only basic knowledge of C#, Beginning C# 5.0 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers. A comprehensive tutorial on both SQL Server 2012 and Visual Studio 2012, Beginning C# 5.0 Databases explains and demonstrates various techniques and ways to build a database application using T–SQL and C#. Full of practical, detailed examples, it’s been fully revised and updated for Winforms using C# 5.0 and Visual Studio 2012 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience. Comprehensively and concisely explains fundamental database concepts and database programming techniques Rich in step-by-step working examples of both T–SQL and C# programs Covers all the features ADO.NET most database programming ever requires What you’ll learn How relational databases work and how to use them How to create database and table objects using SQL Server 2012 How to write SQL queries to modify data in SQL Tables How to write SQL queries to retrieve data using various querying techniques, including JOINS How to write stored procedures in T–SQL and call them from C# 5.0 programs How C# 5.0 uses various techniques to access databases How to build Windows form based applications How to handle runtime anomalies i.e. Exceptions How to program with each individual object of ADO .NET How to use XML in database applications How to use LINQ to simplify C# database programming How to use ADO .NET Entity Framework How to use SQL CLR to create stored procedures using C# Who this book is for Beginning C# 5.0 Databases is for every C# programmer. Database programming requires relatively little knowledge of C# but a lot of knowledge about relational database concepts, database language SQL and ADO.NET. This book assumes no prior database experience and teaches you, always through hands–on examples, how to create and use relational databases with SQL Server 2012 and how to access them with C# 5.0 using ADO.NET. Almost every application needs to access a database, and this book teaches all the fundamentals you need and may ever need to develop professional database applications. Table of Contents Getting and Understanding Your Tools Understanding Relational Databases Creating Database and Tables Manipulating Database Data Querying Database Using Stored Procedures Using XML Understanding Transactions Building Windows Form Applications Introduction to ADO .NET Handling Exceptions Making Connections Executing ADO.NET Commands to Retrieve Data Using Data Readers Using Data Sets and Data Adapters Using Data Controls with ASP.NET Applications Working with Text and Binary Data Using LINQ Using ADO.NET Entity Framework Using the CLR in SQL Server