|
Books > Computing & IT > Computer software packages > Database software > General
Pro SQL Server 2012 Administration is a one-stop source for all the
knowledge you'll need to professionally manage a database under
Microsoft SQL Server 2012. SQL Server administration is a complex
field requiring an unusually broad and well-rounded skill set. A
good database administrator must be part system administrator, part
database design expert, and part SQL tuning optimization guru.
Above all, he or she must be capable of restoring a damaged
database at any time. Database administration requires excellent
people skills for dealing with management and clients, and solid
technical skills for dealing with the hardware and the software.
Pro SQL Server 2012 Administration addresses all aspects of
database administration, regardless of the size of the
implementation. Install SQL Server 2012 and create new database
environments. Develop a sound backup strategy for your database.
Perform recovery as needed, which many consider to be job #1.
Authors Ken Simmons and Sylvester Carstarphen also help you
automate your work through the use of policy-based
management.Performance optimization gets good coverage, so that you
can render assistance when developers need help with problem
queries. Rare among database and other technical books is solid
guidance on the people side of the equation. Success as a database
administrator comes from working well with others, becoming
involved in the community, and building the right combination of
technical knowledge and people skills to solve problems and get
things done professionally and amicably. Simmons and Carstarphen
pay special attention to these aspects of the job in this new
edition of their comprehensive book on SQL Server administration.*
Helps you manage a SQL Server 2012 database at professional level *
Covers the gamut of database administration skills * Provides
guidance on performance optimization What you'll learn * Install
SQL Server 2012 and create new databases * Implement backup &
recovery strategies to protect your database, and your job *
Diagnose and resolve query performance problems * Apply
policy-based management for consistency across all databases in an
organization * Turn every interaction with a client, manager or
executive into a stepping-stone towards career success Who this
book is for Pro SQL Server 2012 Administration is aimed at junior
and seasoned database administrators who are looking to develop
their knowledge and skill set in Microsoft SQL Server 2012. Readers
should already have some exposure to databases in general, or to
SQL Server in specific. Table of Contents * What's New?*
Pre-Install Considerations * Choosing a High-Availability Solution
* Installing and Upgrading * Post Installation * Multi-Server
Administration * Security * Administering Database Objects *
Indexing for Performance * Managing Backups * Restore and Recovery
Strategies * Automating Routine Maintenance * Monitoring Your
Server * Auditing * Extended Events Interface * Managing Query
Performance * Secrets to Excelling as a Professional DBA * What's
Next?
Learn to exploit vulnerable database applications using SQL
injection tools and techniques, while understanding how to
effectively prevent attacks Key Features Understand SQL injection
and its effects on websites and other systems Get hands-on with SQL
injection using both manual and automated tools Explore practical
tips for various attack and defense strategies relating to SQL
injection Book DescriptionSQL injection (SQLi) is probably the most
infamous attack that can be unleashed against applications on the
internet. SQL Injection Strategies is an end-to-end guide for
beginners looking to learn how to perform SQL injection and test
the security of web applications, websites, or databases, using
both manual and automated techniques. The book serves as both a
theoretical and practical guide to take you through the important
aspects of SQL injection, both from an attack and a defense
perspective. You'll start with a thorough introduction to SQL
injection and its impact on websites and systems. Later, the book
features steps to configure a virtual environment, so you can try
SQL injection techniques safely on your own computer. These tests
can be performed not only on web applications but also on web
services and mobile applications that can be used for managing IoT
environments. Tools such as sqlmap and others are then covered,
helping you understand how to use them effectively to perform SQL
injection attacks. By the end of this book, you will be well-versed
with SQL injection, from both the attack and defense perspective.
What you will learn Focus on how to defend against SQL injection
attacks Understand web application security Get up and running with
a variety of SQL injection concepts Become well-versed with
different SQL injection scenarios Discover SQL injection manual
attack techniques Delve into SQL injection automated techniques Who
this book is forThis book is ideal for penetration testers, ethical
hackers, or anyone who wants to learn about SQL injection and the
various attack and defense strategies against this web security
vulnerability. No prior knowledge of SQL injection is needed to get
started with this book.
Explore expert techniques such as advanced indexing and high
availability to build scalable, reliable, and fault-tolerant
database applications using PostgreSQL 13 Key Features Master
advanced PostgreSQL 13 concepts with the help of real-world
datasets and examples Leverage PostgreSQL's indexing features to
fine-tune the performance of your queries Extend PostgreSQL's
functionalities to suit your organization's needs with minimal
effort Book DescriptionThanks to its reliability, robustness, and
high performance, PostgreSQL has become one of the most advanced
open source databases on the market. This updated fourth edition
will help you understand PostgreSQL administration and how to build
dynamic database solutions for enterprise apps with the latest
release of PostgreSQL, including designing both physical and
technical aspects of the system architecture with ease. Starting
with an introduction to the new features in PostgreSQL 13, this
book will guide you in building efficient and fault-tolerant
PostgreSQL apps. You'll explore advanced PostgreSQL features, such
as logical replication, database clusters, performance tuning,
advanced indexing, monitoring, and user management, to manage and
maintain your database. You'll then work with the PostgreSQL
optimizer, configure PostgreSQL for high speed, and move from
Oracle to PostgreSQL. The book also covers transactions, locking,
and indexes, and shows you how to improve performance with query
optimization. You'll also focus on how to manage network security
and work with backups and replication while exploring useful
PostgreSQL extensions that optimize the performance of large
databases. By the end of this PostgreSQL book, you'll be able to
get the most out of your database by executing advanced
administrative tasks. What you will learn Get well versed with
advanced SQL functions in PostgreSQL 13 Get to grips with
administrative tasks such as log file management and monitoring
Work with stored procedures and manage backup and recovery Employ
replication and failover techniques to reduce data loss Perform
database migration from Oracle to PostgreSQL with ease Replicate
PostgreSQL database systems to create backups and scale your
database Manage and improve server security to protect your data
Troubleshoot your PostgreSQL instance to find solutions to common
and not-so-common problems Who this book is forThis database
administration book is for PostgreSQL developers and database
administrators and professionals who want to implement advanced
functionalities and master complex administrative tasks with
PostgreSQL 13. Prior experience in PostgreSQL and familiarity with
the basics of database administration will assist with
understanding key concepts covered in the book.
Here is the expert-level, insider guidance you need on using Azure
SQL Database as your back-end data store. This book highlights best
practices in everything ranging from full-stack projects to mobile
applications to critical, back-end APIs. The book provides
instruction on accessing your data from any language and platform.
And you learn how to push processing-intensive work into the
database engine to be near the data and avoid undue networking
traffic. Azure SQL is explained from a developer's point of view,
helping you master its feature set and create applications that
perform well and delight users. Core to the book is showing you how
Azure SQL Database provides relational and post-relational support
so that any workload can be managed with easy accessibility from
any platform and any language. You will learn about features
ranging from lock-free tables to columnstore indexes, and about
support for data formats ranging from JSON and key-values to the
nodes and edges in the graph database paradigm. Reading this book
prepares you to deal with almost all data management challenges,
allowing you to create lean and specialized solutions having the
elasticity and scalability that are needed in the modern world.
What You Will Learn Master Azure SQL Database in your development
projects from design to the CI/CD pipeline Access your data from
any programming language and platform Combine key-value, JSON, and
relational data in the same database Push data-intensive compute
work into the database for improved efficiency Delight your
customers by detecting and improving poorly performing queries
Enhance performance through features such as columnstore indexes
and lock-free tables Build confidence in your mastery of Azure SQL
Database's feature set Who This Book Is For Developers of
applications and APIs that benefit from cloud database support,
developers who wish to master their tools (including Azure SQL
Database, and those who want their applications to be known for
speedy performance and the elegance of their code
Use this guide to one of SQL Server 2019's most impactful
features-Big Data Clusters. You will learn about data
virtualization and data lakes for this complete artificial
intelligence (AI) and machine learning (ML) platform within the SQL
Server database engine. You will know how to use Big Data Clusters
to combine large volumes of streaming data for analysis along with
data stored in a traditional database. For example, you can stream
large volumes of data from Apache Spark in real time while
executing Transact-SQL queries to bring in relevant additional data
from your corporate, SQL Server database. Filled with clear
examples and use cases, this book provides everything necessary to
get started working with Big Data Clusters in SQL Server 2019. You
will learn about the architectural foundations that are made up
from Kubernetes, Spark, HDFS, and SQL Server on Linux. You then are
shown how to configure and deploy Big Data Clusters in on-premises
environments or in the cloud. Next, you are taught about querying.
You will learn to write queries in Transact-SQL-taking advantage of
skills you have honed for years-and with those queries you will be
able to examine and analyze data from a wide variety of sources
such as Apache Spark. Through the theoretical foundation provided
in this book and easy-to-follow example scripts and notebooks, you
will be ready to use and unveil the full potential of SQL Server
2019: combining different types of data spread across widely
disparate sources into a single view that is useful for business
intelligence and machine learning analysis. What You Will Learn
Install, manage, and troubleshoot Big Data Clusters in cloud or
on-premise environments Analyze large volumes of data directly from
SQL Server and/or Apache Spark Manage data stored in HDFS from SQL
Server as if it were relational data Implement advanced analytics
solutions through machine learning and AI Expose different data
sources as a single logical source using data virtualization Who
This Book Is For Data engineers, data scientists, data architects,
and database administrators who want to employ data virtualization
and big data analytics in their environments
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
successfully Develop a dynamic SQL Server environment and
streamline big data pipelines Discover best practices for fixing
performance issues, database access management, replication, and
security Book DescriptionSQL Server is one of the most popular
relational database management systems developed by Microsoft. This
second edition of the SQL Server Administrator's Guide will not
only teach you how to administer an enterprise database, but also
help you become proficient at managing and keeping the database
available, secure, and stable. You'll start by learning how to set
up your SQL Server and configure new and existing environments for
optimal use. The book then takes you through designing aspects and
delves into performance tuning by showing you how to use indexes
effectively. You'll understand certain choices that need to be made
about backups, implement security policy, and discover how to keep
your environment healthy. Tools available for monitoring and
managing a SQL Server database, including automating health
reviews, performance checks, and much more, will also be discussed
in detail. As you advance, the book covers essential topics such as
migration, upgrading, and consolidation, along with the techniques
that will help you when things go wrong. Once you've got to grips
with integration with Azure and streamlining big data pipelines,
you'll learn best practices from industry experts for maintaining a
highly reliable database solution. Whether you are an administrator
or are looking to get started with database administration, this
SQL Server book will help you develop the skills you need to
successfully create, design, and deploy database solutions. What
you will learn Discover SQL Server 2019's new features and how to
implement them Fix performance issues by optimizing queries and
making use of indexes Design and use an optimal database management
strategy Combine SQL Server 2019 with Azure and manage your
solution using various automation techniques Implement efficient
backup and recovery techniques in line with security policies Get
to grips with migrating, upgrading, and consolidating with SQL
Server Set up an AlwaysOn-enabled stable and fast SQL Server 2019
environment Understand how to work with Big Data on SQL Server
environments Who this book is forThis book is for database
administrators, database developers, and anyone who wants to
administer large and multiple databases single-handedly using
Microsoft's SQL Server 2019. Basic awareness of database concepts
and experience with previous SQL Server versions is required.
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 DescriptionSQL 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 forThis 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.
Prepare for Microsoft Exam 70-765-and help demonstrate your
real-world mastery of provisioning SQL Server databases both on
premise and in SQL Azure. Designed for experienced IT professionals
ready to advance their status, Exam Ref focuses on the critical
thinking and decision-making acumen needed for success at the MCSA
level. Focus on the expertise measured by these objectives: *
Implement SQL in Azure * Manage databases and instances * Manage
storage This Microsoft Exam Ref: * Organizes its coverage by exam
objectives * Features strategic, what-if scenarios to challenge you
* Assumes you have working knowledge of SQL Server administration
and maintenance, as well as Azure skills Provisioning SQL Databases
About the Exam Exam 70-765 focuses on skills and knowledge for
provisioning, upgrading, and configuring SQL Server; managing
databases and files; and provisioning, migrating, and managing
databases in the Microsoft Azure cloud. About Microsoft
Certification Passing this exam as well as Exam 70-764:
Administering a SQL Database Infrastructure earns you MCSA: SQL
2016 Database Administration certification, qualifying you for a
position as a database administrator or infrastructure specialist.
See full details at: microsoft.com/learning
The database industry is a multi-billion, world-wide,
all-encompassing part of the software world. Quantifiers in Action:
Generalized Quantification in Query, Logical and Natural Languages
introduces a query language called GQs-Generalized Quantification
in Query. Most query languages are simply versions of First Order
Logic (FOL). GQs are an extension of the idea of quantifier in FOL.
GQs are a perfect example of a practical theory within
databases.
This book provides a brief background in logic and introduces
the concept of GQs, and then develops a query language based on
GQs. Using Query Language with Generalized Quantifiers, the reader
explores the efficient implementation of the concept, always a
primary consideration in databases. This professional book also
includes several extensions for use with documents employing
question and answer techniques.
Designed for practitioners and researchers within the database
management field; also suitable for advanced-level students in
computer science.
Take your first steps to become a fully qualified data analyst by
learning how to explore large relational datasets Key Features
Explore a variety of statistical techniques to analyze your data
Integrate your SQL pipelines with other analytics technologies
Perform advanced analytics such as geospatial and text analysis
Book DescriptionUnderstanding and finding patterns in data has
become one of the most important ways to improve business
decisions. If you know the basics of SQL, but don't know how to use
it to gain the most effective business insights from data, this
book is for you. SQL for Data Analytics helps you build the skills
to move beyond basic SQL and instead learn to spot patterns and
explain the logic hidden in data. You'll discover how to explore
and understand data by identifying trends and unlocking deeper
insights. You'll also gain experience working with different types
of data in SQL, including time-series, geospatial, and text data.
Finally, you'll learn how to increase your productivity with the
help of profiling and automation. By the end of this book, you'll
be able to use SQL in everyday business scenarios efficiently and
look at data with the critical eye of an analytics professional.
Please note: if you are having difficulty loading the sample
datasets, there are new instructions uploaded to the GitHub
repository. The link to the GitHub repository can be found in the
book's preface. What you will learn Perform advanced statistical
calculations using the WINDOW function Use SQL queries and
subqueries to prepare data for analysis Import and export data
using a text file and psql Apply special SQL clauses and functions
to generate descriptive statistics Analyze special data types in
SQL, including geospatial data and time data Optimize queries to
improve their performance for faster results Debug queries that
won't run Use SQL to summarize and identify patterns in data Who
this book is forIf you're a database engineer looking to transition
into analytics, or a backend engineer who wants to develop a deeper
understanding of production data, you will find this book useful.
This book is also ideal for data scientists or business analysts
who want to improve their data analytics skills using SQL.
Knowledge of basic SQL and database concepts will aid in
understanding the concepts covered in this book.
Thorough and updated coverage of database design and SQL for DB2
are the focus of this guide for the relational database-management
system used on IBM i computer systems. Suitable for classroom
instruction or self-study, this book explains the most widely used
database language and the way that language is implemented on a
variety of computer platforms. Topics covered include database
concepts, SQL inquiries, web applications, and database security,
and the material is reinforced by numerous illustrations, examples,
and exercises.
|
|