Narrow Your Results
Foreword Advanced computing technologies have allowed businesses, governments, academia, and other organizations to greatly improve and expand their use of information to enhance the ability to achieve their goals. However, with expanded use of data comes an expansion of data processing...
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...
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available Key Features * Explore new features of SQL Server 2019 to set up, administer, and maintain your database solution...
Leverage the features of Azure SQL database and become an expert in data management Key Features * Explore ways to create shards and elastic pools to scale Azure SQL databases * Automate common management tasks with PowerShell * Implement over 40 practical activities and...
Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019. Key Features * Gain insights into what's new in SQL Server 2019 * Understand use cases and customer scenarios that can be implemented with...
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...
Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features * Discover T-SQL functionalities and services that help you interact with relational databases * Understand the roles, tasks and responsibilities of a...
Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your businessKey Features* Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies* Learn tabular...
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...
Bring the performance and security of SQL Server to Linux About This Book • Design and administer your SQL Server solution on the open source Linux platform • Install, configure, and fine-tune your database application for maximum performance • An easy-to-follow...
"Implement and administer successful database solution with SQL Server 2017 About This Book • Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution • Design and configure, manage, and secure a...
"Develop and run efficient R scripts and predictive models for SQL Server 2017 About This Book • Learn how you can combine the power of R and SQL Server 2017 to build efficient, cost-effective data science solutions • Leverage the capabilities of R Services to perform...
Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems. Key Features * Explore more than 20 real-world use cases to understand SQL Server features * Get to grips with the SQL...
Cut through the noise and get real results with a step-by-step approach to learning SQL Key Features * A structured, straightforward introduction to SQL for beginners * A SQL tutorial with step-by-step exercises and activities that help build key skills * Structured to let you...
"Find, explore, and extract big data to transform into actionable insights Key Features *Perform end-to-end data analysis?from exploration to visualization *Real-world examples, tasks, and interview queries to be a proficient data scientis t*Understand how SQL is used for big data processing...
The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who...
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...
It is a major challenge to migrate very large databases from one system, say for example, to transfer critical data from Oracle to SQL Server. One has to consider several issues such as loss of data being transferred, the security of the data, the cost and effort, technical...
