Bøger af Kathi Kellenberger

Beginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008. Beginning T-SQL begins with an introduction to databases, normalization, and to SQL Server Management Studio. Attention is given to Azure SQL Database and how to connect to remote databases in the cloud. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional. Important techniques such as windowing functions are covered to help write fast executing queries that solve real business problems.A stand-out feature in this book is that most chapters end with a "e;Thinking About Performance"e; section. These sections cover aspects of query performance relative to the content just presented. They'll help you avoid beginner mistakes by knowing about and thinking about performance from Day 1.Imparts best practices for writing T-SQLHelps you avoid common errorsShows how to write scalable code for good performance

Intermediate-Advanced user level

Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports to delight business analysts and other users of corporate data. Deliver mobile reports to anywhere and any device. Build vital knowledge of Reporting Services at a time when Microsoft's dominance in business intelligence is on the rise.Beginning SQL Server Reporting Services turns novices into skilled report developers. The book begins by explaining how to set up the development environment. It then walks you through creating your first reports using the built-in wizard. After showing what is possible, the book breaks down and explains the skills needed to create reports from scratch. And not just reports! But also dashboards with charts, graphs, and maps. Each chapter builds on knowledge gained in the previous chapters with step-by-step tutorials. Build reports with and without the built-in wizard. Build interactive features such as drill-through reports. Build dashboards full of charts, graphs, and maps. Build mobile reports.  What You Will LearnSet up your development environment.Organized projects and share components among reports.Create report using a wizard.Create reports from scratch, including grouping levels, parameters, and drill through features.Build interactive dashboard with graphs, charts, and maps.Deploy and manage reports for use by others in the business. Who This Book Is ForDatabase professionals of all experience levels who have some experience in databases and want to make the leap into business intelligence reporting. The book is an excellent choice for those needing to add Reporting Services to their current list of skills, or who are looking for a skill set that is in demand for in order to break into IT.

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL Server database engine.

Even if you have little or no knowledge of T-SQL, Beginning T-SQL 2008 will bring you up to intermediate level and teach you best practices along the way.