Synopsis
Do you need to extend your knowledge of querying in SQL Server? Then this book helps you take your existing skills to the next level as you discover how to write complex and robust SQL queries that enable you to deliver powerful analyses and meaningful insights.This book takes you further on your journey to mastering SQL querying with SQL Server. Step by step, you learn how to build on your existing knowledge and understand the subtleties of T-SQL, the Microsoft flavor of the standard database query language. No matter what your current level of SQL knowledge, this book helps you improve your existing proficiency and gives you the confidence to handle any SQL querying challenge. If you are coming to SQL Server from another database, then this book helps you transition smoothly to T-SQL, as well as deepening your knowledge of many of the more advanced SQL Server query techniques.In an age in which data is key, you need to ensure that you have the right skills to analyze your data and produce the insight that gives you the competitive edge. So get ahead with SQL using the dozens of practical and enjoyable examples and the methodical and comprehensive approach that this book provides.To smooth the learning curve, all the sample data used in the book, as well as all the essential query snippets, are available online at www.tetraspublishing.com.
Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.
À propos de l?auteur
Adam Aspin is an independent Business Intelligence (BI) consultant based in the United Kingdom. He has worked with SQL Server for over 20 years. During this time, he has developed several dozen database and analytical systems based on Microsoft databases. He has applied his skills for a range of clients in industry sectors across finance, utilities, telecoms, insurance, retail, and luxury goods. A graduate of Oxford University, Adam moved into IT early in his career. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2, Informix, and PostgreSQL. He is, however, most at home in the Microsoft universe developing applications with SQL Server, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, and Power BI. Adam is a frequent contributor to SQLServerCentral.com and Simple Talk. He is a regular speaker at SQL Server User Groups, SQL Saturdays, and conferences such as SQL Bits. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years. Karine Aspin is a principal consultant with Calidra Limited, a UK-based data and analytics consultancy. A mathematics graduate of the Swiss Federal Institute of Technology she previously worked for a range of IT companies including IBM Global Services. Fluent in both French and English, Karine has worked on most of the major database systems currently available. These include SQL Server, MySQL, Oracle, PostgreSQL, Sybase and, of course, DB2 and Informix. When not helping clients to deliver analytics and insight from their data, Karine devotes any remaining free time to equestrian pursuits
Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.