Your email was sent successfully. Check your inbox.

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

Proceed reservation?

Export
Filter
  • Ben-Gan, Itzik  (7)
  • Redmond, Wash. : Microsoft Press  (7)
  • Electronic books ; local  (7)
  • Gesellschaft
  • 1
    Online Resource
    Online Resource
    Querying Microsoft SQL Server 2012 : exam 70-461 training kit (2012)
    Redmond, Wash. : Microsoft Press
    Details
    Language: English
    Pages: 1 online resource (1 v.) , ill.
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; SQL (Computer program language) ; Handbooks, manuals, etc ; Database management ; Handbooks, manuals, etc ; Electronic books ; Electronic books ; local
    Abstract: Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD-featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Create database objects Work with data Modify data Troubleshoot and optimize queries For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
    Note: Includes index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9780735667259/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 2
    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.
  • 3
    Online Resource
    Online Resource
    Inside Microsoft SQL Server 2008 : T-SQL programming (2010)
    Redmond, Wash. : Microsoft Press
    Details
    ISBN: 9780735639928 , 0735639922
    Language: English
    Pages: 1 online resource (xxvi, 798 p.) , ill.
    Parallel Title: Erscheint auch als
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language-solving complex problems with real-world solutions. Discover how to: Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. Handle transactions, concurrency, and error handling. Efficiently use temporary objects, including temporary tables, table variables, and table expressions. Evaluate when to use set-based programming techniques and when to use cursors. Work with dynamic SQL in an efficient and secure manner. Treat date- and time-related data in a robust manner. Develop CLR user-defined types and learn about temporal support in the relational model. Use XML and XQuery and implement a dynamic schema solution. Work with spatial data using the new geometry and geography types and spatial indexes. Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture. Use Service Broker for controlled asynchronous processing in database applications. All the book's code samples will be available for download from the companion Web site.
    Note: Description based on print version record. - Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735639928/?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 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.
  • 5
    Online Resource
    Online Resource
    Inside Microsoft SQL Server 2008 : T-SQL querying (2009)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 9780735634763 , 0735634769
    Language: English
    Pages: xxiv, 798 p , ill.
    Keywords: SQL server ; Client/server computing ; Relational databases ; Electronic books ; local
    Abstract: Tackle the toughest set-based querying and query tuning problems-guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals-and gain practical approaches and advanced techniques to optimize your code's performance. Discover how to: Move from procedural programming to the language of sets and logic Optimize query tuning with a top-down methodology Assess algorithmic complexity to predict performance Compare data-aggregation techniques, including new grouping sets Manage data modification-insert, delete, update, merge-for performance Write more efficient queries against partitioned tables Work with graphs, trees, hierarchies, and recursive queries Plus-Use pure-logic puzzles to sharpen your problem-solving skills
    Note: Includes index
    URL: https://learning.oreilly.com/library/view/-/9780735634763/?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
    Inside Microsoft SQL server 2005 : T-SQL programming (2006)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735621977 , 9780735621978
    Language: English
    Keywords: SQL server ; Handbooks, manuals, etc ; SQL (Computer program language) ; Handbooks, manuals, etc ; Client/server computing ; Electronic books ; local
    Abstract: A comprehensive, hands-on reference for database developers and administrators, this book focuses on advanced language features of Transact-SQL (T-SQL), the database programming language built into SQL Server. Includes code and table examples.
    Note: Title from title screen. - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0735621977/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 7
    Online Resource
    Online Resource
    Inside Microsoft SQL server 2005 : T-SQL querying (2006)
    Redmond, Wash. : Microsoft Press | Boston, Mass. :Safari Books Online,
    Details
    ISBN: 0735623139 , 9780735623132
    Language: English
    Keywords: SQL server ; Handbooks, manuals, etc ; SQL (Computer program language) ; Handbooks, manuals, etc ; Client-server computing ; Electronic books ; local
    Abstract: This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)-one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on advanced querying techniques and how queries are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL
    Note: Title from title screen. - Includes bibliographical references and index
    URL: https://learning.oreilly.com/library/view/-/0735623139/?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...