The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.
Get up to speed on the extensive changes to the newest release of Microsoft SQL Server 2012
This step-by-step tutorial will show you how to create more productive management applications and gain business intelligence from your SQL Server database environment. You’ll learn the foundation objects of SQL and basic queries and joins. You’ll then add objects to your database and use items that are important to the physical design. Next, you’ll explore SQL Server scripting. By the end, you’ll have gained the necessary skills to build a world-class database for your world-class application, using the full capabilities of Microsoft SQL Server 2012. Download eBook Free »
SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL.
This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you’ll learn how to deal with a host of common SQL dilemmas.
SQL and Relational Theory: How to Write Accurate SQL Code, 2nd Edition
Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory: How to Write Accurate SQL Code, 2nd Edition draws on decades of research to present the most up-to-date treatment of SQL available. Download eBook Free »
Demystifies the concepts that relate to NoSQL databases, including column-family oriented stores, key/value databases, and document databases.
Delves into installing and configuring a number of NoSQL products and the Hadoop family of products.
Explains ways of storing, accessing, and querying data in NoSQL databases through examples that use MongoDB, HBase, Cassandra, Redis, CouchDB, Google App Engine Datastore and more.
Looks at architecture and internals.
Provides guidelines for optimal usage, performance tuning, and scalable configurations.
Presents a number of tools and utilities relating to NoSQL, distributed platforms, and scalable processing, including Hive, Pig, RRDtool, Nagios, and more.
NoSQL databases are an efficient and powerful tool for storing and manipulating vast quantities of data. Most NoSQL databases scale well as data grows. In addition, they are often malleable and flexible enough to accommodate semi-structured and sparse data sets. This comprehensive hands-on guide presents fundamental concepts and practical solutions for getting you ready to use NoSQL databases. Expert author Shashank Tiwari begins with a helpful introduction on the subject of NoSQL, explains its characteristics and typical uses, and looks at where it fits in the application stack. Unique insights help you choose which NoSQL solutions are best for solving your specific data storage needs.
Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business
Practical SAP query examples from an SAP Business One expert
Detailed steps to create and troubleshoot SQL queries for Alerts, Approvals, Formatted Searches, and Crystal Reports
Understand the importance and benefit of keeping SQL queries simple and easy to understand
Benefit from special tips and tricks related directly to SQL queries within SAP Business One
SAP Business One is an integrated Enterprise Resource Planning (ERP) software which offers an ideal solution for growing small to midsized businesses. For such companies, retrieving the most relevant information from their business data can be key to standing out from the competition. SAP Business One is a rapidly growing software package and this book is timely in giving those businesses an advantage in the area of Business Intelligence. Having SQL query skills in- house is the most important and cost-effective move you can make in this growing field.
Update ANSI SQL references to implement the newer 2008 ANSI Standard, which includes numerous fixes and clarifications to existing statements. The previous edition was based on 2003 ANSI Standards.
Now covers Oracle and Microsoft implementations of SQL (in addition to the MySQL examples of the fourth editiion) so that any student can read the lessons and perform the exercises regardless of which SQL implementation they are using.
New exercises and examples in order to make them completely up to date and relevant. This will include updating references to MySQL content as the 5.1 version of the database supports more ANSI compliant commands and modern database functionality.
Add more advanced functions of modern day databases such as indexed views, binary data, and geospatial data – all of which are hot topics within the database world right now.
Add sections to cover the topic of Object-Relational Mappers in three different varieties that allow for the mapping of data elements between systems, ie. data to object-oriented classes.
In just 24 sessions of one hour or less, you’ll learn how to use SQL to build effective databases, efficiently retrieve your data, and manage everything from performance to security! Using this book’s straightforward, step-by-step approach, you’ll learn hands-on through practical examples.
Discovering SQL: A Hands-On Guide for Beginners: 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.