Your email was sent successfully. Check your inbox.

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

Proceed reservation?

Export
Filter
Datasource
Material
Language
Years
Author, Corporation
Publisher
Keywords
  • 1
    Online Resource
    Online Resource
    Exam 70-463 : implementing a data warehouse with Microsoft SQL Server 2012 : 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 ; Examinations ; Study guides ; Electronic data processing personnel ; Certification ; Data warehousing ; Examinations ; Study guides ; Database management ; Examinations ; Study guides ; Electronic books ; Electronic books ; local
    Abstract: Ace your preparation for Microsoft® Certification Exam 70-463 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 online practice tests-featuring multiple, customizable testing options. Maximize your performance on the exam by learning how to: Design and implement a data warehouse Develop and enhance SQL Server Integration Services packages Manage and maintain SQL Server Integration Services packages Build data quality solutions Implement custom code in SQL Server Integration Services packages
    Note: Includes index. - Description based on print version record
    URL: https://learning.oreilly.com/library/view/-/9780735668300/?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
    Abfragen von Microsoft SQL server 2012 : original Microsoft Training für Examen 70-461 (2013)
    Unterschleissheim : Microsoft Press Deutschland
    Details
    Language: German
    Pages: 1 online resource (1 v.) , ill.
    Keywords: SQL server ; Querying (Computer science) ; Relational databases ; Electronic books ; Electronic books ; local
    Abstract: Erlernen Sie das Administrieren von Microsoft SQL Server 2012-Datenbanken und bereiten Sie sich gleichzeitig effizient auf das Examen 70-461 vor.
    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
    Advanced Analytics with Transact-SQL : Exploring Hidden Patterns and Rules in Your Data (2021)
    [Erscheinungsort nicht ermittelbar] : Apress | Boston, MA : Safari
    Details
    ISBN: 9781484271735
    Language: English
    Pages: 1 online resource (308 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local ; Electronic books
    Abstract: Learn about business intelligence (BI) features in T-SQL and how they can help you with data science and analytics efforts without the need to bring in other languages such as R and Python. This book shows you how to compute statistical measures using your existing skills in T-SQL. You will learn how to calculate descriptive statistics, including centers, spreads, skewness, and kurtosis of distributions. You will also learn to find associations between pairs of variables, including calculating linear regression formulas and confidence levels with definite integration. No analysis is good without data quality. Advanced Analytics with Transact-SQL introduces data quality issues and shows you how to check for completeness and accuracy, and measure improvements in data quality over time. The book also explains how to optimize queries involving temporal data, such as when you search for overlapping intervals. More advanced time-oriented information in the book includes hazard and survival analysis. Forecasting with exponential moving averages and autoregression is covered as well. Every web/retail shop wants to know the products customers tend to buy together. Trying to predict the target discrete or continuous variable with few input variables is important for practically every type of business. This book helps you understand data science and the advanced algorithms use to analyze data, and terms such as data mining, machine learning, and text mining. Key to many of the solutions in this book are T-SQL window functions. Author Dejan Sarka demonstrates efficient statistical queries that are based on window functions and optimized through algorithms built using mathematical knowledge and creativity. The formulas and usage of those statistical procedures are explained so you can understand and modify the techniques presented. T-SQL is supported in SQL Server, Azure SQL Database, and in Azure Synapse Analytics. There are so many BI features in T-SQL that it might become your primary analytic database language. If you want to learn how to get information from your data with the T-SQL language that you already are familiar with, then this is the book for you. What You Will Learn Describe distribution of variables with statistical measures Find associations between pairs of variables Evaluate the quality of the data you are analyzing Perform time-series analysis on your data Forecast values of a continuous variable Perform market-basket analysis to predi...
    Note: Online resource; Title from title page (viewed July 16, 2021) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 4
    Online Resource
    Online Resource
    Introducing Azure SQL Ledger : Blockchain technology for a tamper proof record of your data over time (2022)
    [Place of publication not identified] : Apress
    Details
    ISBN: 9781484289020 , 1484289021
    Language: English
    Pages: 1 online resource (1 video file (1 hr., 14 min.)) , sound, color.
    Edition: [First edition].
    DDC: 005.74
    Keywords: Blockchains (Databases) ; Microsoft Azure (Computing platform) ; Instructional films ; Nonfiction films ; Internet videos
    Abstract: This video shows how to use blockchain technology in Azure SQL and SQL Server to provide an immutable record of data change over time, and to prove and attest to business partners that your data is accurate and has not been tempered with. You'll learn about the new, Ledger tables feature in Azure SQL and soon to be in SQL Server 2022 that enables this blockchain feature set. This video shows how Ledger-enabled tables protect your data from even high-privileged users, preventing even database and system administrators from making changes without a record of those changes being made. Also covered in this video is the older feature set around system-versioned, temporal tables. You'll learn how temporal tables are used as the base infrastructure for maintaining the blockchain history in Ledger tables. The video shows how Ledger provides additional protection to ensure that - unlike the case with just temporal tables - rows are cryptographically hashed to ensure against tampering. You can even combine both features, temporal and ledger tables; while ledger tables protect the data, temporal tables allow you to easily see the state of the data on a specific time point. What You Will Learn Understand the technology behind Azure SQL Ledger Create a database with ledger-enabled tables Combine ledger and system-versioning technology in a single table Modify the data in the ledger-enabled table Change the structure of ledger-enabled tables Verify that the ledger data has not been tampered with Understand ledger technology limitations Who This Book Is For For advanced database administrators of Azure SQL Databases who are required to prove that sensitive data has not been tampered with. For administrators requiring a tamper-proof record of history over time. For those who are running SQL Server 2022 either on-premises or through Managed Instances who have the same needs.
    Note: Online resource; title from title details screen (O'Reilly, viewed October 18, 2022)
    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
    Mastering SQL Server 2017 (2019)
    [Erscheinungsort nicht ermittelbar] : Packt Publishing | Boston, MA : Safari
    Details
    ISBN: 9781838983208
    Language: English
    Pages: 1 online resource (696 pages)
    Edition: 1st edition
    Keywords: Electronic books ; local
    Abstract: Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease Key Features Work with temporal tables to access information stored in a table at any time Get familiar with the latest features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality Book Description Microsoft SQL Server 2017 uses the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. By learning how to use the features of SQL Server 2017 effectively, you can build scalable apps and easily perform data integration and transformation. You'll start by brushing up on the features of SQL Server 2017. This Learning Path will then demonstrate how you can use Query Store, columnstore indexes, and In-Memory OLTP in your apps. You'll also learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you'll get up to speed with designing and building SQL Server Integration Services (SSIS) data warehouse packages using SQL server data tools. Toward the concluding chapters, you'll discover how to develop SSIS packages designed to maintain a data warehouse using the data flow and other control flow tasks. By the end of this Learning Path, you'll be equipped with the skills you need to design efficient, high-performance database applications with confidence. This Learning Path includes content from the following Packt books: SQL Server 2017 Developer's Guide by Milos Radivojevic, Dejan Sarka, et. al SQL Server 2017 Integration Services Cookbook by Christian Cote, Dejan Sarka, et. al What you will learn Use columnstore indexes to make storage and performance improvements Extend database design solutions using temporal tables Exchange JSON data between applications and SQL Server Migrate historical data to Microsoft Azure by using Stretch Database Design the architecture of a modern Extract, Transform, and Load (ETL) solution Implement ETL solutions using Integration Services for both on-premise and Azure data Who this book is for This Learning Path is for database developers and solution architects looking to develop ETL solutions with SSIS, and explore the new features in SSIS 2017. Advanced analysis practitioners, business intelligence developers, and database consultants dealing with performance tuning will also find this book useful. Basic understanding of database concepts and T-SQL is required to ...
    Note: Online resource; Title from title page (viewed August 22, 2019) , Mode of access: World Wide Web.
    URL: lizenzpflichtig
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 6
    Online Resource
    Online Resource
    Data science with SQL server quick start guide : integrate SQL server with data science (2018)
    Birmingham, UK : Packt Publishing
    Details
    ISBN: 9781789537130 , 1789537134
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Machine learning ; Data mining ; Data processing ; Electronic books ; Electronic books ; local
    Abstract: Get unique insights from your data by combining the power of SQL Server, R and Python Key Features Use the features of SQL Server 2017 to implement the data science project life cycle Leverage the power of R and Python to design and develop efficient data models find unique insights from your data with powerful techniques for data preprocessing and analysis Book Description SQL Server only started to fully support data science with its two most recent editions. If you are a professional from both worlds, SQL Server and data science, and interested in using SQL Server and Machine Learning (ML) Services for your projects, then this is the ideal book for you. This book is the ideal introduction to data science with Microsoft SQL Server and In-Database ML Services. It covers all stages of a data science project, from businessand data understanding,through data overview, data preparation, modeling and using algorithms, model evaluation, and deployment. You will learn to use the engines and languages that come with SQL Server, including ML Services with R and Python languages and Transact-SQL. You will also learn how to choose which algorithm to use for which task, and learn the working of each algorithm. What you will learn Use the popular programming languages,T-SQL, R, and Python, for data science Understand your data with queries and introductory statistics Create and enhance the datasets for ML Visualize and analyze data using basic and advanced graphs Explore ML using unsupervised and supervised models Deploy models in SQL Server and perform predictions Who this book is for SQL Server professionals who want to start with data science, and data scientists who would like to start using SQL Server in their projects will find this book to be useful. Prior exposure to SQL Server will be helpful.
    Note: Description based on online resource; title from title page (Safari, viewed October 2, 2018)
    URL: https://learning.oreilly.com/library/view/-/9781789537123/?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 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.
  • 8
    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.
  • 9
    Online Resource
    Online Resource
    SQL Server 2017 Integration Services cookbook : ETL techniques to load and transform data from various sources using SQL Server 2017 Integration Services (2017)
    Birmingham, UK : Packt Publishing
    Details
    ISBN: 9781786460875 , 1786460874
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Harness the power of SQL Server 2017 Integration Services to build your data integration solutions with ease About This Book Acquaint yourself with all the newly introduced features in SQL Server 2017 Integration Services Program and extend your packages to enhance their functionality This detailed, step-by-step guide covers everything you need to develop efficient data integration and data transformation solutions for your organization Who This Book Is For This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017. What You Will Learn Understand the key components of an ETL solution using SQL Server 2016-2017 Integration Services Design the architecture of a modern ETL solution Have a good knowledge of the new capabilities and features added to Integration Services Implement ETL solutions using Integration Services for both on-premises and Azure data Improve the performance and scalability of an ETL solution Enhance the ETL solution using a custom framework Be able to work on the ETL solution with many other developers and have common design paradigms or techniques Effectively use scripting to solve complex data issues In Detail SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you'll gain complete hands-on experience of SSIS 2017 as well as the 2016 new features, design and development improvements including SCD, Tuning, and Customizations. At the start, you'll learn to install and set up SSIS as well other SQL Server resources to make optimal use of this Business Intelligence tools. We'll begin by taking you through the new features in SSIS 2016/2017 and implementing the necessary features to get a modern scalable ETL solution that fits the modern data warehouse. Through the course of chapters, you will learn how to design and build SSIS data warehouses packages using SQL Server Data Tools. Additionally, you'll learn to develop SSIS packages designed to maintain a data warehouse using the Data Flow and other control flow tasks. You'll also be demonstrated many recipes on cleansing...
    Note: Description based on online resource; title from title page (Safari, viewed July 21, 2017)
    URL: https://learning.oreilly.com/library/view/-/9781786461827/?ar
    Library Location Call Number Volume/Issue/Year Availability
    BibTip Others were also interested in ...
    Online Resource
    MPI Ethno. Forsch.
  • 10
    Online Resource
    Online Resource
    SQL Server 2017 developer's guide : a professional guide to designing and developing enterprise database applications (2018)
    Birmingham, UK : Packt Publishing
    Details
    Language: English
    Pages: 1 online resource (1 volume) , illustrations
    Keywords: SQL server ; Client/server computing ; Database management ; Electronic books ; Electronic books ; local
    Abstract: Build smarter and efficient database application systems for your organization with SQL Server 2017 About This Book Build database applications by using the development features of SQL Server 2017 Work with temporal tables to get information stored in a table at any time Use adaptive querying to enhance the performance of your queries Who This Book Is For Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book. What You Will Learn Explore the new development features introduced in SQL Server 2017 Identify opportunities for In-Memory OLTP technology Use columnstore indexes to get storage and performance improvements Exchange JSON data between applications and SQL Server Use the new security features to encrypt or mask the data Control the access to the data on the row levels Discover the potential of R and Python integration Model complex relationships with the graph databases in SQL Server 2017 In Detail Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you'll be introduced to R and how to use the R language with Transact-SQL for data exploration and a...
    Note: Description based on online resource; title from title page (viewed April 2, 2018)
    URL: https://learning.oreilly.com/library/view/-/9781788476195/?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...