0
Your cart

Your cart is empty

Browse All Departments
Price
  • R100 - R250 (20)
  • R250 - R500 (50)
  • R500+ (857)
  • -
Status
Format
Author / Contributor
Publisher

Books > Computing & IT > Computer software packages > Database software

MySQL Database Service Revealed - Running MySQL as a Service in the Oracle Cloud Infrastructure (Paperback, 1st ed.): Charles... MySQL Database Service Revealed - Running MySQL as a Service in the Oracle Cloud Infrastructure (Paperback, 1st ed.)
Charles Bell
R1,427 R1,132 Discovery Miles 11 320 Save R295 (21%) Ships in 10 - 15 working days

Access all the information you need to begin using the MySQL Database Service (MDS) in the Oracle Cloud Infrastructure (OCI). MDS is Oracle's new platform as a service (PAAS) offering for open-source database users. This book covers getting started with an account in OCI, gives a brief overview of OCI services available, and provides a short tutorial on MDS. Reading this book helps you take advantage of the powerful OCI features by building your own MySQL database in the cloud. Examples in this book center around running MDS in OCI, and include several of the popular use cases as well as advice on how to implement them. In addition, you will learn more about the related MDS OCI features, such as the high availability features currently available. Finally, you will learn how to back up and restore your data as well as how to get your data into and out of the cloud. The skills you learn in this book will help you get started using MDS and letting Oracle do the heavy lifting of managing MDS operations and implementation. What You Will Learn Use Oracle Cloud Infrastructure (OCI) Deploy MySQL Database Service (MDS) systems in the cloud Connect your applications to MDS Back up and recover using the data recovery features of MDS Employ the newest high availability features of MDS Who This Book Is For Systems engineers, developers, and database professionals who want to learn about the powerful features of the MySQL Database Service (MDS) and how to incorporate cloud-based database storage into their infrastructure and applications. Readers who are new to MySQL will appreciate the tutorial chapter, and those familiar with MySQL will learn the latest features of MDS as well as how to build inexpensive, powerful MySQL database servers in the Oracle Cloud Infrastructure (OCI).

SQL Server 2005 T-SQL Recipes - A Problem-Solution Approach (Paperback, 1st ed.): Joseph Sack SQL Server 2005 T-SQL Recipes - A Problem-Solution Approach (Paperback, 1st ed.)
Joseph Sack
R1,560 R1,266 Discovery Miles 12 660 Save R294 (19%) Ships in 10 - 15 working days

If you are looking for a succinct, easy to use, and up-to-date reference guide for SQL Server 2005 and T-SQL, I highly recommend "SQL Server 2005 T-SQL Recipes," -- David Hayden, .NET Developer

Each chapter is completely autonomous, so you can just look up the syntax you need at the time without having to rely on knowledge from previous chapters. Its really an excellent reference that deserves a place on your desk. -- Sean McCown, ITBookworm

Need to brush up on specific SQL Server tasks, procedures, or Transact-SQL commands? Not finding what you need from SQL Server books online? Or perhaps you just want to familiarize yourself with the practical application of new T-SQLAAA1/2related features. "SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach" is an ideal book, whatever your level as a DBA or developer.

This AAA1/2no-fluffAAA1/2 desk reference offers direct access to the information you need to get the job done. It covers basic T-SQL data manipulation, the use of stored procedures, triggers and UDFs, and advanced T-SQL techniques for database security and maintenance. It also provides hundreds of practical recipes that describe the utilities of features and functions, with a minimim of background theory.

Additionally, this book provides AAA1/2how-toAAA1/2 answers to common SQL Server T-SQL questions, conceptual overviews, and highlights of new features introduced in SQL Server 2005. It also features concise T-SQL syntax examples, and you can use the book to prepare for a SQL Server-related job interview or certification test.

Oracle Database Administration - The Essential Reference (Paperback): David C. Kreines Oracle Database Administration - The Essential Reference (Paperback)
David C. Kreines
R991 R735 Discovery Miles 7 350 Save R256 (26%) Ships in 12 - 17 working days

A concise reference to the enormous store of information Oracle8 or Oracle7 DBAs need every day, Oracle Database Administration covers DBA tasks like installation, tuning, backups, networking, auditing, and query optimization. It's also a set of quick references on initialization parameters, SQL statements, data dictionary tables, system privileges, roles, and syntax for SQL*Plus, Export, Import, and SQL*Loader.

SQL Injection Attacks and Defense (Paperback, 2nd edition): Justin Clarke SQL Injection Attacks and Defense (Paperback, 2nd edition)
Justin Clarke
R1,273 Discovery Miles 12 730 Ships in 12 - 17 working days

"SQL Injection Attacks and Defense, First Edition: " Winner of the Best Book Bejtlich Read Award

""SQL injection is probably the number one problem for any server-side application, and this book unequaled in its coverage."" -Richard Bejtlich, "Tao Security blog "

SQL injection represents one of the most dangerous and well-known, yet misunderstood, security vulnerabilities on the Internet, largely because there is no central repository of information available for penetration testers, IT security consultants and practitioners, and web/software developers to turn to for help.

"SQL Injection Attacks and Defense, Second Edition" is the only book devoted exclusively to this long-established but recently growing threat. This is the definitive resource for understanding, finding, exploiting, and defending against this increasingly popular and particularly destructive type of Internet-based attack.

"SQL Injection Attacks and Defense, Second Edition" includes all the currently known information about these attacks and significant insight from its team of SQL injection experts, who tell you about: Understanding SQL Injection - Understand what it is and how it works Find, confirm and automate SQL injection discovery Tips and tricks for finding SQL injection within code Create exploits for using SQL injection Design apps to avoid the dangers these attacks SQL injection on different databases SQL injection on different technologies SQL injection testing techniques Case Studies
"Securing SQL Server, Second Edition" is the only book to provide a complete understanding of SQL injection, from the basics of vulnerability to discovery, exploitation, prevention, and mitigation measures. Covers unique, publicly unavailable information, by technical experts in such areas as Oracle, Microsoft SQL Server, and MySQL---including new developments for Microsoft SQL Server 2012 (Denali). Written by an established expert, author, and speaker in the field, with contributions from a team of equally renowned creators of SQL injection tools, applications, and educational materials.

Migrating to the Cloud - Oracle Client/Server Modernization (Paperback): Tom Laszewski, Prakash Nauduri Migrating to the Cloud - Oracle Client/Server Modernization (Paperback)
Tom Laszewski, Prakash Nauduri
R1,112 R799 Discovery Miles 7 990 Save R313 (28%) Ships in 12 - 17 working days

Migrating to the Cloud: Oracle Client/Server Modernization is a reference guide for migrating client/server applications to the Oracle cloud. Organized into 14 chapters, the book offers tips on planning, determining effort and budget, designing the Oracle cloud infrastructure, implementing the migration, and moving the Oracle cloud environment into production. Aside from Oracle application and database cloud offerings, the book looks at various tools and technologies that can facilitate migration to the cloud. It includes useful code snippets and step-by-step instructions in database migration, along with four case studies that highlight service enablement of DOS-based applications, Sybase to Oracle, PowerBuilder to APEX, and Forms to Java EE. Finally, it considers current challenges and future trends in cloud computing and client/server migration. This book will be useful to IT professionals, such as developers, architects, database administrators, IT project managers, and executives, in developing migration strategies and best practices, as well as finding appropriate solutions.

SQL Server Data Automation Through Frameworks - Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory... SQL Server Data Automation Through Frameworks - Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory (Paperback, 1st ed.)
Andy Leonard, Kent Bradshaw
R812 Discovery Miles 8 120 Ships in 12 - 17 working days

Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you've already spent on licensing SQL Server. The tools and methods from this book may be applied to on-premises and Azure SQL Server instances. The SSIS framework from this book works in Azure Data Factory (ADF) and provides DevOps personnel the ability to execute child packages outside a project-functionality not natively available in SSIS. Frameworks not only reduce the time required to deliver enterprise functionality, but can also accelerate troubleshooting and problem resolution. You'll learn in this book how frameworks also improve code quality by using metadata to drive processes. Much of the work performed by data professionals can be classified as "drudge work"-tasks that are repetitive and template-based. The frameworks-based approach shown in this book helps you to avoid that drudgery by turning repetitive tasks into "one and done" operations. Frameworks as described in this book also support enterprise DevOps with built-in logging functionality. What You Will Learn Create a stored procedure framework to automate SQL process execution Base your framework on a working system of stored procedures and execution logging Create an SSIS framework to reduce the complexity of executing multiple SSIS packages Deploy stored procedure and SSIS frameworks to Azure Data Factory environments in the cloud Who This Book Is For Database administrators and developers who are involved in enterprise data projects built around stored procedures and SQL Server Integration Services (SSIS). Readers should have a background in programming along with a desire to optimize their data efforts by implementing repeatable processes that support enterprise DevOps.

T-SQL Querying (Paperback): Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee T-SQL Querying (Paperback)
Itzik Ben-Gan, Adam Machanic, Dejan Sarka, Kevin Farlee
R1,597 Discovery Miles 15 970 Ships in 10 - 15 working days

T-SQL insiders help you tackle your toughest queries and query-tuning problems Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL's internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and refining. All code and techniques are fully updated to reflect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012. Write faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation techniques, including new grouping sets Efficiently perform data-analysis calculations Make the most of T-SQL's optimized bulk import tools Avoid date/time pitfalls that lead to buggy, poorly performing code Create optimized BI statistical queries without additional software Use programmable objects to accelerate queries Unlock major performance improvements with In-Memory OLTP Master useful and elegant approaches to manipulating graphs About This Book For experienced T-SQL practitioners Includes coverage updated from Inside Microsoft SQL Server 2008 T-SQL Querying and Inside Microsoft SQL Server 2008 T-SQL Programming Valuable to developers, DBAs, BI professionals, and data scientists Covers many MCSE 70-464 and MCSA/MCSE 70-461 exam topics

Microsoft Access 2010 VBA Macro Programming (Paperback, Ed): Richard Shepherd Microsoft Access 2010 VBA Macro Programming (Paperback, Ed)
Richard Shepherd
R1,150 R927 Discovery Miles 9 270 Save R223 (19%) Ships in 10 - 15 working days

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Develop custom Access VBA macrosPerfect for power users, Microsoft Access 2010 VBA Macro Programming reveals how to maximize the features and functionality of Access 2010. You'll get in-depth details on Access VBA programming and application development followed by 20 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. This practical resource then explains how to include the subroutines in the Access menu system and transform a set of interrelated VBA macros into an Access add-in package. Create your own Access 2010 VBA macros right away with help from this hands-on guide. Learn how to: Create and enhance forms and reports Design custom dialog boxes and buttons Develop custom menus for the Ribbon Use SQL queries with VBA Create table macros Use Office object models to interact with other Microsoft applications Create and manipulate charts and graphs Work with external databases Add functionality to your programs with API calls Animate objects in Access Enhance database security Create audit trails Handle large text files Transfer data via FTP

SQL Server 2014 - A Step by Step Guide to Learning SQL (Hardcover): Sikha Bagui, Richard Earp SQL Server 2014 - A Step by Step Guide to Learning SQL (Hardcover)
Sikha Bagui, Richard Earp
R4,722 R4,140 Discovery Miles 41 400 Save R582 (12%) Ships in 12 - 17 working days

Written for readers who have little or no previous experience with databases, SQL, or Microsoft SQL Server database software, this book provides a systematic approach to learning SQL (Structured Query Language) using SQL Server database software. It starts with simple SQL concepts, and progresses to more complex query development. Each chapter is written in a step-by-step manner and has examples that can be executed using SQL Server. Using the sample database, readers can experience hands-on SQL programming in SQL Server. This text also presents exercises at the end of the chapters to help readers gain proficiency in SQL.

The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit - Database Implementation and Maintenance (Paperback): Mark Horninger The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit - Database Implementation and Maintenance (Paperback)
Mark Horninger
R1,325 R997 Discovery Miles 9 970 Save R328 (25%) Ships in 12 - 17 working days

SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the largest update since SQL Server 2005. SQL Server 2008 is a much more significant update than SQL Server 2005, because it brings increased ability to deliver data across more platforms, and thus many different types of devices. New functionality also allows for easy storage and retrieval of digitized images and video. These attributes address the recent explosion in the popularity of web-based video and server and desktop virtualization.
The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit prepares readers for the Microsoft Certified Technology Specialist exam: SQL Server 2008, Implementation and Maintenance.
This is The 'Real' Microsoft Exam Prep Kit, and provides the reader with independent and unbiased exam tips and warnings everything they need to know to ensure certification success.Authored by Mark Horninger, a nationally recognized leader in SQL Server with over 50 Microsoft certifications to his credit; Mark knows what it takes to successfully navigate Microsoft exams.Complete study package offers Syngress proven pedagogy including practice exams via the book s companion site
"

Ethereum For Dummies (Paperback): Mg Solomon Ethereum For Dummies (Paperback)
Mg Solomon
R795 R530 Discovery Miles 5 300 Save R265 (33%) Ships in 12 - 17 working days

Dive into a secure future Professionals look to Ethereum as a blockchain-based platform to develop safe applications and conduct secure transactions. It takes a knowledgeable guiding hand to understand how Ethereum works and what it does -- and Ethereum For Dummies provides that guidance. Written by one of the leading voices in the blockchain community and best selling author of Blockchain For Dummies, this book demystifies the workings of Ethereum and shows how it can enhance security, transactions, and investments. As an emerging application of blockchain technology, Ethereum attracts a wide swath of professionals ranging from financial pros who see it as a way to enhance their business, security analysts who want to conduct secure transactions, programmers who build apps that employ the Ethereum blockchain, or investors interested in cashing in on the rise of cryptocurrency. Ethereum For Dummies offers a starting point to all members of this audience as it provides easy-to-understand explanation of the tools and techniques of using Ethereum. Understand the fundamentals of Ethereum Build smart contracts Create decentralized applications Examine public and private chains If you need to get a grip on one of the biggest applications of blockchain technology, this book makes it easier.

Securing SQL Server - Protecting Your Database from Attackers (Paperback, 3rd edition): Denny Cherry Securing SQL Server - Protecting Your Database from Attackers (Paperback, 3rd edition)
Denny Cherry
R1,081 Discovery Miles 10 810 Ships in 12 - 17 working days

SQL server is the most widely-used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, Third Edition, you will learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book, Denny Cherry - a Microsoft SQL MVP and one of the biggest names in SQL server - will teach you how to properly secure an SQL server database from internal and external threats using best practices as well as specific tricks that the author employs in his role as a consultant for some of the largest SQL server deployments in the world. Fully updated to cover the latest technology in SQL Server 2014, this new edition walks you through how to secure new features of the 2014 release. New topics in the book include vLANs, setting up RRAS, anti-virus installs, key management, moving from plaintext to encrypted values in an existing application, securing Analysis Services Objects, Managed Service Accounts, OS rights needed by the DBA, SQL Agent Security, Table Permissions, Views, Stored Procedures, Functions, Service Broker Objects, and much more.

Integrating Data (Paperback): Bill Inmon, Patty Haines, David Rapien Integrating Data (Paperback)
Bill Inmon, Patty Haines, David Rapien
R959 R761 Discovery Miles 7 610 Save R198 (21%) Ships in 10 - 15 working days
Oracle Autonomous Database in Enterprise Architecture - Utilize Oracle Cloud Infrastructure Autonomous Databases for better... Oracle Autonomous Database in Enterprise Architecture - Utilize Oracle Cloud Infrastructure Autonomous Databases for better consolidation, automation, and security (Paperback)
Bal Mukund Sharma, Krishna Kumar K M, Rashmi Panda
R1,139 Discovery Miles 11 390 Ships in 10 - 15 working days

Get up to speed with Oracle's Autonomous Databases and implementation strategies for any workload or use case, including transactional, data warehousing, and non-relational databases Key Features Explore ADB, its business benefits, and architectural considerations Migrate the existing workload to ADB, explore high availability, and use cloud native methods for monitoring and event notifications Leverage APEX, JSON, the REST API, and SQL Developer Web features for rapid development Book DescriptionOracle Autonomous Database (ADB) is built on the world's fastest Oracle Database Platform, Exadata, and is delivered on Oracle Cloud Infrastructure (OCI), customer data center (ExaCC), and Oracle Dedicated Region Cloud. This book is a fast-paced, hands-on introduction to the most important aspects of OCI Autonomous Databases. You'll get to grips with concepts needed for designing disaster recovery using standby database deployment for Autonomous Databases. As you progress, you'll understand how you can take advantage of automatic backup and restore. The concluding chapters will cover topics such as the security aspects of databases to help you learn about managing Autonomous Databases, along with exploring the features of Autonomous Database security such as Data Safe and customer-managed keys for Vaults. By the end of this Oracle book, you'll be able to build and deploy an Autonomous Database in OCI, migrate databases to ADB, comfortably set up additional high-availability features such as Autonomous Data Guard, and understand end-to-end operations with ADBs. What you will learn Explore migration methods available for Autonomous Databases, using both online and offline methods Create standby databases, RTO and RPO objectives, and Autonomous Data Guard operations Become well-versed with automatic and manual backups available in ADB Implement best practices relating to network, security, and IAM policies Manage database performance and log management in ADB Understand how to perform data masking and manage encryption keys in OCI's Autonomous Databases Who this book is forThis book is for decision makers, enterprise cloud architects, solution consultants, cloud engineers, implementation partners, and technology students, as well as anyone who wants to learn about Oracle's Autonomous Databases delivered on Oracle Cloud Infrastructure (OCI). Beginner-level knowledge of Linux and OCI and networking concepts and databases, along with hands-on experience in OCI environments is required before getting started with this book.

Promethean Oracle (Miscellaneous printed matter): Sophia Shultz, Mark Cogan Promethean Oracle (Miscellaneous printed matter)
Sophia Shultz, Mark Cogan
R1,034 R787 Discovery Miles 7 870 Save R247 (24%) Ships in 12 - 17 working days

When Prometheus stole the sacred Olympian flame and bestowed it upon humanity, he literally sparked the growth of civilization. Now Prometheus presents us with a different but no less significant gift: the guiding flame of insight, drawn from the stories and energies of the kings, gods, and heroes who complement history and mythology's great queens, goddesses, and heroines. This rich and lovely 50-card oracle deck and guidebook unifies male energies with those of the Chakras to create a unique and fresh approach to personal divination. You will be led by warriors like Odysseus, cunning kings like Hammurabi, quiet prophets like Elijah, and monsters like Pazuzu to strong intuitive wisdom that can be applied to your well-being and life's serious and day-to-day issues. The evocative portrait cards, each featuring a Chakra will, like Prometheus, bring the fire of knowledge and renewal to your soul.

Data Wrangling - Using Pandas, SQL, and Java (Paperback): Oswald Campesato Data Wrangling - Using Pandas, SQL, and Java (Paperback)
Oswald Campesato
R1,272 Discovery Miles 12 720 Ships in 12 - 17 working days

This book is intended primarily for those who plan to become data scientists as well as anyone who needs to perform data cleaning tasks. It contains a variety of features of NumPy and Pandas and how to create databases and tables in MySQL. Chapter 7 covers many data wrangling tasks using Python scripts and awk-based shell scripts. Companion files with code are available for downloading from the publisher. FEATURES: Provides the reader with basic Python 3, Java, and Pandas programming concepts, and an introduction to awk. Includes a chapter on RDBMs and SQL. Companion files with code.

Microsoft SQL Server 2008 Reporting Services (Paperback, 3rd edition): Brian Larson Microsoft SQL Server 2008 Reporting Services (Paperback, 3rd edition)
Brian Larson
R1,703 R1,370 Discovery Miles 13 700 Save R333 (20%) Ships in 10 - 15 working days

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. The Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface

Supercharging Node.js Applications with Sequelize - Create high-quality Node.js apps effortlessly while interacting with your... Supercharging Node.js Applications with Sequelize - Create high-quality Node.js apps effortlessly while interacting with your SQL database (Paperback)
Daniel Durante, Sascha Depold
R918 Discovery Miles 9 180 Ships in 10 - 15 working days

A hands-on implementation guide to application development in Node.js using the powerful Sequelize ORM Key Features Use the highly powerful JavaScript library to map your database to objects easily Build an application from scratch with easy-to-follow steps and examples Discover industry best practices, tips, and techniques on Sequelize to manage your database with ease Book DescriptionContinuous changes in business requirements can make it difficult for programmers to organize business logic into database models, which turns out to be an expensive operation as changes to the database may result in errors and incongruity within applications. Supercharging Node.js Applications with Sequelize helps you get to grips with Sequelize, a reliable ORM that enables you to alleviate these issues in your database and applications. With Sequelize, you'll no longer need to store information in flat files or memory. This book takes a hands-on approach to implementation and associated methodologies for your database that will have you up and running in no time. You'll learn how to configure Sequelize for your Node.js application properly, develop a better sense of understanding of how this ORM works, and find out how to manage your database from Node.js using Sequelize. Finally, you'll be able to use Sequelize as the database driver for building your application from scratch. By the end of this Node.js book, you'll be able to configure, build, store, retrieve, validate, and associate your data from a database to a Node.js application. What you will learn Configure and optimize Sequelize for your application Validate your database and hydrate it with data Add life cycle events (or hooks) to your application for business logic Organize and ensure the integrity of your data even on preexisting databases Scaffold a database using built-in Sequelize features and tools Discover industry-based best practices, tips, and techniques to simplify your application development Who this book is forThis book is for beginner- to intermediate-level Node.js developers looking to upgrade their skills and use Sequelize as their ORM of choice. Basic knowledge of and prior experience with JavaScript and SQL are needed to make the most out of this book.

Exam Ref 70-768 Developing SQL Data Models (Paperback): Stacia Varga Exam Ref 70-768 Developing SQL Data Models (Paperback)
Stacia Varga
R896 R797 Discovery Miles 7 970 Save R99 (11%) Ships in 9 - 15 working days

Prepare for Microsoft Exam 70-768-and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. 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: * Design a multidimensional BI semantic model * Design a tabular BI semantic model * Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) * Configure and maintain SSAS This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you are a database or BI professional with experience creating models, writing MDX or DAX queries, and using SSAS

The Data Lakehouse Architecture (Paperback): Bill Inmon, Ranjeet Srivastava The Data Lakehouse Architecture (Paperback)
Bill Inmon, Ranjeet Srivastava
R1,196 R934 Discovery Miles 9 340 Save R262 (22%) Ships in 10 - 15 working days
Exam Ref 70-764 Administering a SQL Database Infrastructure (Paperback): Victor Isakov Exam Ref 70-764 Administering a SQL Database Infrastructure (Paperback)
Victor Isakov
R902 R708 Discovery Miles 7 080 Save R194 (22%) Ships in 12 - 17 working days

Prepare for Microsoft Exam 70-764-and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. Focus on the expertise measured by these objectives: * Configure data access and auditing * Manage backup and restore of databases * Manage and monitor SQL Server instances * Manage high availability and disaster recovery This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access. About the Exam Exam 70-764 focuses on skills and knowledge required for database administration. About Microsoft Certification Passing both Exam 70-764 and Exam 70-765 (Provisioning SQL Databases) earns you credit toward an MCSA: SQL 2016 Database Administration certification. See full details at: microsoft.com/learning

Visual Basic, SQL Client, Rdl and Rdlc Report Creator - A flawless victory in Visual Studio 64-bit! (Paperback): Richard Thomas... Visual Basic, SQL Client, Rdl and Rdlc Report Creator - A flawless victory in Visual Studio 64-bit! (Paperback)
Richard Thomas Edwards
R374 Discovery Miles 3 740 Ships in 10 - 15 working days
Business Database Technology (2nd Edition) - Theories and Design Process of Relational Databases, SQL, Introduction to OLAP,... Business Database Technology (2nd Edition) - Theories and Design Process of Relational Databases, SQL, Introduction to OLAP, Overview of NoSQL Databases (Paperback, 2nd Updated and Revised ed.)
Shouhong Wang, Hai Wang
R1,208 Discovery Miles 12 080 Ships in 10 - 15 working days
SQL Server Query Tuning and Optimization - Optimize Microsoft SQL Server 2022 queries and applications (Paperback): Benjamin... SQL Server Query Tuning and Optimization - Optimize Microsoft SQL Server 2022 queries and applications (Paperback)
Benjamin Nevarez
R1,382 Discovery Miles 13 820 Ships in 10 - 15 working days

Get well-versed with ready-to-use techniques for creating high-performance queries and applications Key Features Speed up queries and dramatically improve application performance by both understanding query engine internals and practical query optimization Understand how the query optimizer works Learn about intelligent query processing and what is new in SQL Server 2022 Book DescriptionSQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. This book starts by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information it needs to produce efficient execution plans. As you progress, you'll get practical query optimization tips for troubleshooting underperforming queries. The book will also guide you through intelligent query processing and what is new in SQL Server 2022. Query performance topics such as the Query Store, In-Memory OLTP and columnstore indexes are covered as well. By the end of this book, you'll be able to get the best possible performance for your queries and applications. What you will learn Troubleshoot queries using methods including extended events, SQL Trace, and dynamic management views Understand how the execution engine and query operators work Speed up queries and improve app performance by creating the right indexes Detect and fix cardinality estimation errors by examining query optimizer statistics Monitor and promote both plan caching and plan reuse to improve app performance Troubleshoot and improve query performance by using the Query Store Improve the performance of data warehouse queries by using columnstore indexes Handle query processor limitations with hints and other methods Who this book is forThis book is for SQL Server developers who are struggling with slow query execution, database administrators who are tasked with troubleshooting slow application performance, and database architects who design SQL Server databases in support of line-of-business and data warehousing applications.

Services Computing - SCC 2021 - 18th International Conference, Held as Part of the Services Conference Federation, SCF 2021,... Services Computing - SCC 2021 - 18th International Conference, Held as Part of the Services Conference Federation, SCF 2021, Virtual Event, December 10-14, 2021, Proceedings (Paperback, 1st ed. 2022)
Ajay Katangur, Liang-Jie Zhang
R2,581 Discovery Miles 25 810 Ships in 10 - 15 working days

This volume constitutes the proceedings of the 18th International Conference on Services Computing 2021, held as Part of SCF 2021 in December 2021 as a virtual event due to COVID-19. The 5 full papers and 2 short papers presented in this volume were carefully reviewed and selected from 21 submissions. It covers the science and technology of leveraging computing and information technology to model, create, operate, and manage business services.

Free Delivery
Pinterest Twitter Facebook Google+
You may like...
Using Excel for Business and Financial…
DS Fairhurst Paperback R1,823 Discovery Miles 18 230
Spring in Action
Craig Walls Paperback R1,300 Discovery Miles 13 000
Access For Dummies
La Ulrich Paperback R592 Discovery Miles 5 920
Quantitative Electroencephalographic…
Tim Tinius Paperback R969 Discovery Miles 9 690
New Perspectives on Microsoft (R) Access…
Joseph Adamski, Kathy Finnegan Paperback R1,392 R1,235 Discovery Miles 12 350
SQL Antipatterns, Volume 1 - Avoiding…
Bill Karwin Paperback R840 Discovery Miles 8 400
Oracle Internals - Tips, Tricks, and…
Donald K. Burleson Paperback R3,268 Discovery Miles 32 680
Oracle Database Programming with Visual…
Y. Bai Paperback R2,032 Discovery Miles 20 320
Access 97 for Windows Made Simple
Moira Stephen Paperback R493 Discovery Miles 4 930
Learning MySQL and MariaDB
Russell Dyer Paperback R1,205 R869 Discovery Miles 8 690

 

Partners