Export citation

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bookmark

Abstract

This book covers all aspects of VB that will help you to jump into real-world projects quickly and work independently. You'll work with various end-to-end examples to help you reduce your R&D time during VB projects, and learn about the drag-and-drop approach to enable you to build an app in a day.

Keywords

Database management.

Export citation

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bookmark

Abstract

"Learn everything you need to know to build efficient SQL queries using this easy-to-follow beginner's guide Key Features Explore all SQL statements in depth using a variety of examples Get to grips with database querying, data aggregate, manipulation, and much more Understand how to explore and process data of varying complexity to tell a story Book Description SQL is a powerful querying language that's used to store, manipulate, and retrieve data, and it is one of the most popular languages used by developers to query and analyze data efficiently. If you're looking for a comprehensive introduction to SQL, Learn SQL Database Programming will help you to get up to speed with using SQL to streamline your work in no time. Starting with an overview of relational database management systems, this book will show you how to set up and use MySQL Workbench and design a database using practical examples. You'll also discover how to query and manipulate data with SQL programming using MySQL Workbench. As you advance, you'll create a database, query single and multiple tables, and modify data using SQL querying. This SQL book covers advanced SQL techniques, including aggregate functions, flow control statements, error handling, and subqueries, and helps you process your data to present your findings. Finally, you'll implement best practices for writing SQL and designing indexes and tables. By the end of this SQL programming book, you'll have gained the confidence to use SQL queries to retrieve and manipulate data. What you will learn Install, configure, and use MySQL Workbench to restore a database Explore different data types such as string, numeric, and date and time Query a single table using the basic SQL SELECT statement and the FROM, WHERE, and ORDER BY clauses Query multiple tables by understanding various types of table relationships Modify data in tables using the INSERT, UPDATE, and DELETE statements Use aggregate functions to group and summarize data Detect bad data, duplicates, and irrelevant values while processing data Who this book is for This book is for business analysts, SQL developers, database administrators, and students learning SQL. If you want to learn how to query and manipulate SQL data for database administration tasks or simply extract and organize relevant data for analysis, you'll find this book useful. No prior SQL experience is required." -- Publisher's description.

Keywords

Database management.

Export citation

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bookmark

Abstract

Learn how to combine SQL Server's analytics with Azure's flexibility and hybrid connectivity to achieve industry-leading performance and manageability for your cloud database.

Key Features

Understand platform availability for SQL Server in Azure Explore the benefits and deployment choices offered by SQL IaaS Get to grips with deploying SQL Server on the Linux development ecosystem

Book Description

Deploying SQL Server on Azure virtual machines allows you to work on full versions of SQL Server in the cloud without having to maintain on-premises hardware. The book begins by introducing you to the SQL portfolio in Azure and takes you through SQL Server IaaS scenarios, before explaining the factors that you need to consider while choosing an OS for SQL Server in Azure VMs. As you progress through the book, you'll explore different VM options and deployment choices for IaaS and understand platform availability, migration tools, and best practices in Azure. In later chapters, you'll learn how to configure storage to achieve optimized performance. Finally, you'll get to grips with the concept of Azure Hybrid Benefit and find out how you can use it to maximize the value of your existing on-premises SQL Server. By the end of this book, you'll be proficient in administering SQL Server on Microsoft Azure and leveraging the tools required for its deployment.

What you will learn

Choose an operating system for SQL Server in Azure VMs Use the Azure Management Portal to facilitate the deployment process Verify connectivity and network latency in cloud Configure storage for optimal performance and connectivity Explore various disaster recovery options for SQL Server in Azure Optimize SQL Server on Linux Discover how to back up databases to a URL

Who this book is for

SQL Server on Azure VMs is for you if you are a developer, data enthusiast, or anyone who wants to migrate SQL Server databases to Azure virtual machines. Basic familiarity with SQL Server and managed identities for Azure resources will be a plus.

Keywords

Database management

Export citation

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bookmark

Abstract

This book is for those application developers who want to achieve greater flexibility and scalability from their software. Whether you are familiar with other NoSQL databases or have only used relational systems, this book will provide you with enough background to move you along at your own pace. If you are new to NoSQL document databases, the design discussions and introductory material will give you the information you need to get started with Couchbase.

Keywords

Database management.

Export citation

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

Bookmark

Abstract

This study addresses the most important legal issues when implementing an open access e-infrastructure for research data. It examines the legal requirements for different kinds of usage of research data in an open access infrastructure, such as OpenAIREplus, which links them to publications. The existing legal framework regarding potentially relevant intellectual property (IP) rights is analysed from the general European perspective as well as from that of selected EU Member States. Various examples and usage scenarios are used to explain the scope of protection of the potentially relevant IP rights. In addition different licence models are analysed in order to identify the licence that is best suited to the aim of open access, especially in the context of the infrastructure of OpenAIREplus. Based on the outcomes of these analyses, some recommendations to the European legislator as well as data- and e-infrastructure providers are given on improving the rights situation in relation to research data. --

Keywords

Database management.