SQL Server

SQL for Beginners: Learn the Structured Query Language for the Most Popular Databases including Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, and Oracle

Learn Essential SQL and Database Skills Knowing how to craft SQL queries and navigate your way around a database is an essential skill if are a Database Administrator, System Administrator, or Programmer. Step-by-Step in Plain English This book guides you step-by-step by teaching you how to create databases, populate those databases with data, extract just the data …

Learn more

Microsoft SQL Server 2008 R2 Unleashed

This is the industry’s most comprehensive and useful guide to SQL Server 2008 and 2008 R2. It presents start-to-finish coverage of SQL Server’s core database server and management capabilities, plus complete introductions to Integration, Reporting, and Analysis Services, application development, and much more.   Four expert SQL Server administrators, developers, and consultants have packed this book …

Learn more

Microsoft SQL Server 2014 Query Tuning & Optimization

Optimize Microsoft SQL Server 2014 queries and applications Microsoft SQL Server 2014 Query Tuning & Optimization is filled with ready-to-use techniques for creating high-performance queries and applications. The book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution …

Learn more

Professional Microsoft SQL Server 2012 Administration

An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of …

Learn more

Beginning Microsoft SQL Server 2012 Programming

Get up to speed on the extensive changes to the newest release of Microsoft SQL Server 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 …

Learn more

Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

Implement, maintain, and repair SQL Server 2012 databases As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and …

Learn more

T-SQL Querying (Developer Reference)

T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the …

Learn more

Professional Microsoft SQL Server 2014 Administration

Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft’s SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update’s enhanced support of large-scale enterprise databases and significant price …

Learn more