Your email was sent successfully. Check your inbox.

An error occurred while sending the email. Please try again.

Proceed reservation?

Export
Filter
  • MPI Ethno. Forsch.  (10)
  • Ben-Gan, Itzik  (5)
  • Schwartz, Baron  (5)
  • SQL (Computer program language)  (10)
Datasource
  • MPI Ethno. Forsch.  (10)
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    T-SQL fundamentals (2023)
    [Place of publication not identified] : Pearson Education
    Details
    Language: English
    Pages: 1 online resource (608 pages) , illustrations
    Edition: [First edition].
    DDC: 005.75/85
    Keywords: SQL server ; SQL (Computer program language) ; Client/server computing ; Database management
    Abstract: Starting with the background to T-SQL querying and programming, including: logical query processing, book-querying constructs (single table queries, joins, subqueries, table expressions, set operators, data analysis), data modifications, temporal tables, transactions and concurrency, SQL Graph (completely new to this edition), as well as programmatic T-SQL constructs. The book includes extensive exercises and solutions with explanations, allowing the reader to practice what they've learned. This book is widely considered as the authoritative guide on T-SQL fundamentals. It focuses on understanding why things work the way they do, and not just how to make them work. When people understand the "why" the code they write tends to be more correct and more meaningful. This edition of the book includes coverage of the newest T-SQL additions up to and including SQL Server 2022.
    Note: Includes index
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    Online Resource
    Online Resource
    T-SQL fundamentals (2016)
    Redmond, Washington : Microsoft Press
    Details
    ISBN: 9781509302031 , 1509302034
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Edition: Third edition.
    Keywords: SQL (Computer program language) ; Electronic books ; Electronic books ; local
    Abstract: Effectively query and modify data using Transact-SQL Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL's roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL
    Note: Includes index. - Description based on online resource; title from title page (Safari, viewed August 24, 2016)
    URL: https://learning.oreilly.com/library/view/-/9781509302031/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 3
    Online Resource
    Online Resource
    T-SQL querying (2015)
    Redmond, WA : Microsoft
    Details
    ISBN: 9780133986631 , 0133986632
    Language: English
    Pages: 1 online resource (1 volume) , illustrations.
    Keywords: SQL (Computer program language) ; Query languages (Computer science) ; Electronic books ; Electronic books ; local
    Abstract: 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 authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL's optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics
    Note: Includes index. - Description based on online resource; title from title page (Safari, viewed March 11, 2015)
    URL: https://learning.oreilly.com/library/view/-/9780133986631/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Microsoft SQL Server 2012 T-SQL fundamentals (2012)
    Redmond, Wash. : Microsoft Press
    Details
    ISBN: 9780735673939
    Language: English
    Pages: 1 online resource (1 v.) , ill.
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; SQL (Computer program language) ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Gain a solid understanding of T-SQL-and write better queries Master the fundamentals of Transact-SQL-and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you'll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you'll quickly learn how to write effective code-whether you're a programmer or database administrator. Discover how to: Work with programming practices unique to T-SQL Create database tables and define data integrity Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Implement insert, update, delete, and merge data modification strategies Tackle advanced techniques such as window functions, pivoting and grouping sets Control data consistency using isolation levels, and mitigate deadlocks and blocking Take T-SQL to the next level with programmable objects
    Note: Includes index. - Description based on print version record
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 5
    Online Resource
    Online Resource
    High performance MySQL (2012)
    Sebastopol, CA : O'Reilly Media
    Details
    Language: English
    Pages: 1 online resource (xxviii, 793 p.) , ill.
    Edition: 3rd ed.
    Parallel Title: Erscheint auch als
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Relational databases ; Database management ; Electronic books ; Electronic books ; local
    Abstract: How can you bring out MySQL's full power? With High Performance MySQL , you'll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover. Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL's principles in action. With this book, you'll learn how to think in MySQL. Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views Implement improvements in replication, high availability, and clustering Achieve high performance when running MySQL in the cloud Optimize advanced querying features, such as full-text searches Take advantage of modern multi-core CPUs and solid-state disks Explore backup and recovery strategies-including new tools for hot online backups
    Note: First ed. by Jeremy D. Zawodny and . 2004. - Includes index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9781449332471/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Wysoko wydajne MySQL : optymalizacja, archiwizacja, replikacja (2012)
    [Gliwice?] : Helion
    Details
    Language: Polish
    Pages: 1 online resource (1 v.) , ill.
    Edition: Wydanie II.
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Książka Wysoko wydajne MySQL. Optymalizacja, archiwizacja, replikacja. Wydanie II szczegółowo prezentuje zaawansowane techniki, dzięki którym można w pełni wykorzystać cały potencjał, drzemiący w MySQL.
    Note: Authorized translation of the English ed. of High performance MySQL, 2nd ed. O'Reilly Media, c2008. Cf. Copyright page. - Includes index. - Description based on online resource; title from title page (Safari, viewed July 11, 2013)
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Diagnosing and fixing MySQL performance problems (2010)
    [Calif.?] : O'Reilly Media
    Details
    Language: English
    Pages: 1 streaming video file (3 hours 1 minute 4 seconds) , digital, sd., col.
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Electronic videos ; local
    Abstract: "The typical trial-and-error approach to diagnosing and solving performance problems breaks down when the problems are difficult. As the complexity of the problem increases, so does the need for a methodical approach and powerful tools. This tutorial will teach you how to be systematic. We'll run through the process and then emphasize getting to know your toolkit, including iostat, vmstat, and mk-query-digest. You will learn the approach Percona consultants have put to use across thousands of customer machines. We're going to try and teach you to be as practical as possible, with only minimal emphasis on performance theory where it's needed. The main focus will be on MySQL versions 5.0, 5.1 and XtraDB on Linux operating systems"--Resource description page.
    Note: Description from resource description page (viewed Aug. 30, 2010). - In three parts
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 8
    Online Resource
    Online Resource
    Microsoft SQL server 2008 : T-SQL fundamentals (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735626014 , 9780735626010
    Language: English
    Pages: xviii, 394 p , ill. , 23 cm
    Keywords: SQL server ; SQL (Computer program language) ; Client/server computing ; Electronic books ; local
    Abstract: Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance-including exercises and code samples-that show you how to develop code to query and modify data. You'll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries. Discover how to: Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query processing Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735626010/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 9
    Online Resource
    Online Resource
    High performance MySQL : Optimierung, Backups, Replikation und Lastverteilung (2009)
    Köln : O'Reilly | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9783897218895 , 3897218895
    Language: German
    Pages: xix, 743 p
    Edition: Dt. Ausg. der 2. Aufl.
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Electronic books ; local
    Abstract: Einführungen in MySQL gibt es viele. Wer aber größere MySQL-Server betreut, die verlässlich laufen müssen, egal was Programmierer oder Benutzer auf sie loslassen, der braucht weiter reichende Informationen. In High Performance MySQL beschreiben sechs anerkannte Experten mit langjähriger Erfahrung auf großen Systemen alle Stellschrauben, an denen MySQL-Admins drehen können, um Sicherheit, Performance, Datenintegrität und Robustheit zu erhöhen. Von Profis für Profis Hier geht es nicht um kleine Webauftritte mit Datenbankanbindung! Lernen Sie stattdessen fortgeschrittene Techniken kennen, mit denen Sie MySQLs Potenzial voll ausreizen können -- um große, skalierbare Systeme zu entwerfen, zu optimieren und zu sichern. Behandelt werden Benchmarking, Indizes, Storage-Engines, Replikationen, Lastverteilung und Hochverfügbarkeit, Backups, Sicherheit... und zu jedem Aspekt die richtigen Werkzeuge, mit denen sich Ihre Ziele am besten realisieren lassen. Praxiserprobt muss es sein Der eine ist MySQL-Guru bei Yahoo!, der andere Angestellter Nr. 25 bei MySQL AB und dort nacheinander für das MySQL-Manual, die Trainingskurse und die Entwicklung des Supports zuständig, wieder ein anderer war bei MySQL AB im High-Performance-Team - die Autoren dieses Buchs wissen, wovon sie sprechen. Graue Theorie finden Sie woanders, hier geht es um bewährte Techniken aus der Praxis. Ein Klassiker wird runderneuert Die erste Auflage von "High Performance MySQL" wurde hoch gelobt und hat schon unzähligen Lesern wertvolle Dienste geleistet. Nun war es an der Zeit, dieses anerkannte Handbuch einmal komplett zu aktualisieren, um nützliches Referenzmaterial zu erweitern, neue Features der Versionen MySQL 5.0 und 5.1 zu ergänzen und zahlreiche Themen wie die Optimierung der Storage-Engine InnoDB zu vertiefen. "Im Meer der MySQL-Literatur findet man so viel konzentriertes Know-how, das deutlich über Selbstverständlichkeiten hinausgeht, nicht allzu häufig." Linux-Magazin , November 2008, zur engl. Originalausgabe
    Note: Title from resource description page (viewed May 27, 2009). - "Übersetzung und Deutsche bearbeitung: Kathrin Lichtenberg, Ilmenau."--Copyright page. - Includes index. - Text in German; translated from English
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    High performance MySQL (2008)
    Sebastopol, Calif. : O'Reilly Media | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780596101718 , 0596101716
    Language: English
    Pages: [712] p , ill.
    Edition: 2nd ed. /
    Keywords: MySQL (Electronic resource) ; SQL (Computer program language) ; Electronic books ; local
    Abstract: High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: Emphasis throughout on both performance and reliability Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views A detailed discussion on how to build very large, highly scalable systems with MySQL New options for backups and replication Optimization of advanced querying features, such as full-text searches Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
    Note: Title from title screen. - Includes index. - Previous ed.: published as by Jeremy Zawodny and Derek Balling. 2004
    URL: https://learning.oreilly.com/library/view/-/9780596101718/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
Close ⊗
This website uses cookies and the analysis tool Matomo. More information can be found here...