0
Your cart

Your cart is empty

Browse All departments
Price
  • R100 - R250 (37)
  • R250 - R500 (107)
  • R500+ (1,176)
  • -
Status
Format
Author / Contributor
Publisher

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

XML and JSON Recipes for SQL Server - A Problem-Solution Approach (Paperback, 1st ed.): Alex Grinberg XML and JSON Recipes for SQL Server - A Problem-Solution Approach (Paperback, 1st ed.)
Alex Grinberg
R774 R732 Discovery Miles 7 320 Save R42 (5%) Ships in 10 - 15 working days

Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you'll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database's own execution plans Replace external and manual JSON processes with SQL Server's internal, JSON functionality Who This Book Is For Database administrators, .NET developers, business intelligence developers, and other professionals who want a deep and detailed skill set around working with XML and JSON in a SQL Server database environment. Web developers will particularly find the book useful for its coverage of transforming database result sets into JSON text that can be transmitted to front-end web applications.

Access VBA Programming for Dummies (Paperback): Alan Simpson Access VBA Programming for Dummies (Paperback)
Alan Simpson
R832 R515 Discovery Miles 5 150 Save R317 (38%) Ships in 10 - 15 working days

This friendly, easy-to-use guide shows experienced Access users how to use VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming Author has written more than ninety computer books and has been working with databases since the early 1980s

The Art of SQL (Paperback): Stephane Faroult, Peter Robson The Art of SQL (Paperback)
Stephane Faroult, Peter Robson
R1,128 R883 Discovery Miles 8 830 Save R245 (22%) Ships in 10 - 15 working days

For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later.

In "The Art of SQL," author and SQL expert Stephane Faroult argues that this "safe approach" only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

"The Art of SQL" offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the numberof users doubles? What if you want to keep several years of data online? Faroult's way of looking at SQL performance may be unconventional and unique, but he's deadly serious about writing good SQL and using SQL well. "The Art of SQL" is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.

DB2 10 for Z/OS: Cost Savings... Right Out of the Box - Cost Savings ... Right Out of the Box (Paperback): Dave Beulke, Roger... DB2 10 for Z/OS: Cost Savings... Right Out of the Box - Cost Savings ... Right Out of the Box (Paperback)
Dave Beulke, Roger Miller, Julian Stuhler, Surekha Parekh
R478 R351 Discovery Miles 3 510 Save R127 (27%) Ships in 10 - 15 working days

Providing expert knowledge about the features in the new release of DB2 for z/OS, this extensive guide details the innovations of DB2 10's SQL and pureXML enhancements--which increase productivity, enhance performance, and simplify application ports. DB2 for z/OS continues to be the undisputed leader in total system availability, scalability, security, and reliability at the lowest cost per transaction. This resource focuses on the features and functions of DB2 10 for IT, including improving operational efficiencies and reducing costs, as well as covering innovations in resiliency for business-critical information, rapid application and warehouse deployment for business growth, and enhanced business analytics and mathematical functions with QMF.

The Ten Commandments of VBA for Microsoft Access Newbies - Practices that produce safe, understandable, and reliable software... The Ten Commandments of VBA for Microsoft Access Newbies - Practices that produce safe, understandable, and reliable software (Paperback)
Peter N Roth Mse
R516 Discovery Miles 5 160 Ships in 7 - 11 working days
Microsoft (R) Access 2010 - Illustrated Brief (Paperback): Lisa Friedrichsen Microsoft (R) Access 2010 - Illustrated Brief (Paperback)
Lisa Friedrichsen
R613 R532 Discovery Miles 5 320 Save R81 (13%) Ships in 15 - 25 working days

Loved by instructors for its visual and flexible way to build computer skills, the Illustrated Series is ideal for teaching Microsoft Office Access 2010 to both computer rookies and hotshots. Each two-page spread focuses on a single skill, making information easy to follow and absorb. Large, full-color illustrations represent how the students' screen should look. Concise text introduces the basic principles of the lesson and integrates a case study for further application.

FileMaker Pro 13: The Missing Manual (Paperback): Susan Prosser, Stuart Gripman FileMaker Pro 13: The Missing Manual (Paperback)
Susan Prosser, Stuart Gripman
R899 R660 Discovery Miles 6 600 Save R239 (27%) Ships in 10 - 15 working days

You don't have to be a techie to use FileMaker Pro 13, but you do need to know what you're doing. With clear, step-by-step instructions, this friendly guide shows you how to create a powerful database that lets you do almost anything with your data. Whether you're running a business, printing a catalog, or planning a wedding, you'll discover how to customize your database and put it to work on several devices.

The important stuff you need to know: Get started. Tour FileMaker Pro's features and create your first database in minutes.Explore the entire platform. Use FileMaker on a desktop, server, WebDirect, or FileMaker Go.Catalog your data. View, sort, and shape information in dozens of ways.Create professional documents. Publish reports, invoices, and other documents with ease.Harness processing power. Use calculations and scripts to crunch numbers, search text, and automate tasks.Add visual power and clarity. Create colorful charts to illustrate and summarize your data.Think like a developer. Dive into advanced topics like relational databases, scripting, and designing for multiple devices.

This bestselling book helps you use FileMaker Pro quickly and efficiently, whether you're experienced with the program or just beginning.

Agile Oracle Application Express (Paperback, 1st ed.): Patrick Cimolini, Karen Cannell Agile Oracle Application Express (Paperback, 1st ed.)
Patrick Cimolini, Karen Cannell
R1,024 Discovery Miles 10 240 Ships in 7 - 11 working days

Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits from Oracle Application Express. The secret is to couple Application Express with an agile software development approach. This book leads the way.

Oracle Application Express is well-suited to agile processes, with its support for rapid prototyping and team development. Application Express supports a gamut of enabling technologies such as SQL, HTML, CSS, JavaScript, and more that enable you to deliver any type of web application to meet your development needs. Agile Oracle Application Express helps you take the feature set of Application Express and marry it with the processes of agile development to iteratively design, create, and deliver quality applications on time and within budget. What you'll learn Discover how Application Express features compliment agile development Apply principles of agile software development to Application Express projects Deliver working code to your clients quickly Meet cost, schedule, and quality targets Increase productivity through team-based techniques Create the right amount and size of governance for any Application Express project Who this book is for

Agile Oracle Application Express is a must-read for highly skilled and highly motivated Application Express (APEX) developers who are comfortable taking responsibility within a self-organizing team environment. These APEX developers want to raise themselves to a higher level of organizational maturity that will position them to improve on APEX's already highly productive software development platform. Table of Contents Agile Software Development Agile and APEX Core APEXvs. Enhanced APEX Supporting Technologies Project Management Team Development Rules and Guidelines Documentation Quality Assurance Summary

DB2 11 System Administrator for z/OS: Certification Study Guide - Exam 317 (Paperback): Judy Nall DB2 11 System Administrator for z/OS: Certification Study Guide - Exam 317 (Paperback)
Judy Nall
R1,740 R1,175 Discovery Miles 11 750 Save R565 (32%) Ships in 10 - 15 working days
DB2 9 for Developers (Paperback): Philip K. Gunning DB2 9 for Developers (Paperback)
Philip K. Gunning
R1,583 R1,080 Discovery Miles 10 800 Save R503 (32%) Ships in 10 - 15 working days

Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.

Oracle Case Management Solutions (Hardcover): Leon Smiers, Manas Deb, Joop Koster, Prasen Palvankar Oracle Case Management Solutions (Hardcover)
Leon Smiers, Manas Deb, Joop Koster, Prasen Palvankar
R1,594 Discovery Miles 15 940 Ships in 10 - 15 working days

Organizations increasingly need to deal with unstructured processes that traditional business process management (BPM) suites are not designed to deal with. High-risk, yet high-value, loan origination or credit approvals, police investigations, and healthcare patient treatment are just a few examples of areas where a level of uncertainty makes outcome and execution of work flow non-deterministic. Case management is a way to govern and control these unstructured processes and non-deterministic outcomes. Oracle recently completed its BPM technology stack with broad case management functionality and is now able to deliver case management capabilities in a variety of flavors that combine packaged applications and middleware technology. Oracle Case Management Solutions is the first book to translate case management from a business problem perspective into appropriate Oracle product usage. Covering the key Oracle technologies that support case management solution components, it explains how to conceptualize and implement quality case management solutions with these products. The team of authors consists of leading industry consultants engaged in providing case management solutions as well as veteran software product management professionals dealing with tools for building case management applications. The authors share insights gained through their extensive case management experience in terms of its use in solving real-world business problems and in applying technologies to create efficient fit-for-purpose computer applications that embody modern computing trends. Detailing a proven solution architecture and reliable roadmap for case management implementation and adoption, the book includes tutorials with step-by-step instructions on building case management solutions using Oracle Siebel and Oracle BPM suites.

Microsoft SQL Server 2008 Reporting Services (Paperback, 3rd edition): Brian Larson Microsoft SQL Server 2008 Reporting Services (Paperback, 3rd edition)
Brian Larson
R1,291 R1,034 Discovery Miles 10 340 Save R257 (20%) Ships in 7 - 11 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

B password Book - The Personal Internet Address, Password Log Book Password book 6x9 in. 110 pages, Password Keeper, Vault,... B password Book - The Personal Internet Address, Password Log Book Password book 6x9 in. 110 pages, Password Keeper, Vault, Notebook and Online Organizer with alphabets a-z tabs. (Paperback)
Rebecca Jones
R162 Discovery Miles 1 620 Ships in 7 - 11 working days
MySQL Cookbook - Solutions for Database Developers and Administrators (Paperback, 3rd Revised edition): Paul Dubois MySQL Cookbook - Solutions for Database Developers and Administrators (Paperback, 3rd Revised edition)
Paul Dubois
R1,912 R1,160 Discovery Miles 11 600 Save R752 (39%) Ships in 10 - 15 working days

MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you'll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration

Little Book Of Passwords - Password book, password log book and internet password organizer, Website/App Password Notebook:... Little Book Of Passwords - Password book, password log book and internet password organizer, Website/App Password Notebook: 6x9" Password book 120 Pages 8 Addresses per page (Paperback)
Notebooks for All
R145 Discovery Miles 1 450 Ships in 7 - 11 working days
Database Systems for Advanced Applications - 9th International Conference, DASFAA 2004, Jeju Island, Korea, March 17-19, 2003,... Database Systems for Advanced Applications - 9th International Conference, DASFAA 2004, Jeju Island, Korea, March 17-19, 2003, Proceedings (Paperback, 2004 ed.)
YoonJoon Lee, Jianzhong Li, Kyu-Young Whang, Doheon Lee
R3,309 R2,767 Discovery Miles 27 670 Save R542 (16%) Ships in 10 - 15 working days

The 9th International Conference on Database Systems for Advanced Appli- tions (DASFAA 2004) was held during March 17-19, 2004 on the beautiful Jeju island of Korea. The DASFAA conference provides an international forum for technical discussions among researchers, developers, and users of database - stems from academia, business, and industry. The main focus of DASFAA is on research in database theory, development of advanced DBMS technologies, and their advanced applications. A premier database conference in the Asia/Paci?c region, DASFAA has been held every two years, and in many countries in the - gion. To promote the area further and to answer the needs of many participants, the steering committee decided to hold the conference annually. DASFAA 2004 was the ?rst such annual conference. The conference was organized by the Special Interest Group on Databases (SIGDB) of the Korea Information Science Society and the Advanced Infor- tion Technology Research Center (AITrc) at KAIST - an engineering research center of excellence (ERC) supported by the Korea Science and Engineering Foundation (KOSEF). We had a number of sponsors who made generous cont- butionstomaketheconferencesuccessful. TheyareOracleKorea, SamsungSDS, Korea Telecom Data, Inc., the United States Air Force O?ce of Scienti?c Re- arch, theAsianO?ceofAerospaceResearch&Development, theArmyResearch O?ce-Far East, and the Korea Advanced Institute of Science and Technology (KAIST).

Aws - The Complete Beginner to Advanced Guide for Amazon Web Service - The Ultimate Tutorial (Paperback): Richard Connor Aws - The Complete Beginner to Advanced Guide for Amazon Web Service - The Ultimate Tutorial (Paperback)
Richard Connor
R365 Discovery Miles 3 650 Ships in 7 - 11 working days
Aws - The Leading Global Cloud Service Provider Amazon Web Services 2019 (Paperback): David McCarthy Aws - The Leading Global Cloud Service Provider Amazon Web Services 2019 (Paperback)
David McCarthy
R262 Discovery Miles 2 620 Ships in 7 - 11 working days
PostgreSQL Basic Training for Application Developers (Paperback): Robert Wingate PostgreSQL Basic Training for Application Developers (Paperback)
Robert Wingate
R439 Discovery Miles 4 390 Ships in 7 - 11 working days
Computer Networking Security Beginners Guide - The Guide to CyberSecurity to Learn through a Top-Down Approach all the... Computer Networking Security Beginners Guide - The Guide to CyberSecurity to Learn through a Top-Down Approach all the Defensive Actions to be taken to Protect yourself from the Dangers of the Network (Paperback)
Kevin Morgan
R231 Discovery Miles 2 310 Ships in 7 - 11 working days
INFORMIX Basic Training for Application Developers (Paperback): Robert Wingate INFORMIX Basic Training for Application Developers (Paperback)
Robert Wingate
R439 Discovery Miles 4 390 Ships in 7 - 11 working days
SQL - The Most Up-To-Date Guide For Beginners To Learn SQL Programming (Paperback): Jym Lawrence SQL - The Most Up-To-Date Guide For Beginners To Learn SQL Programming (Paperback)
Jym Lawrence
R433 Discovery Miles 4 330 Ships in 7 - 11 working days
Microsoft SQL Server 2012 Step by Step (Paperback): Patrick LeBlanc Microsoft SQL Server 2012 Step by Step (Paperback)
Patrick LeBlanc
R1,087 R970 Discovery Miles 9 700 Save R117 (11%) Ships in 7 - 11 working days

Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012

Teach yourself the programming fundamentals of SQL Server 2012--one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply techniques for building high-performing applications Use clustering, database mirroring, and log shipping

Computer networking first step - The Essential Guide To Networking To Introduce Yourself To The Computer Network Through a... Computer networking first step - The Essential Guide To Networking To Introduce Yourself To The Computer Network Through a Top-down Approach And Various Infrastructures (Paperback)
Tim Wired
R368 Discovery Miles 3 680 Ships in 7 - 11 working days
SQL Server - Learn SQL Server in 1 Day (Paperback): Krishna Rungta SQL Server - Learn SQL Server in 1 Day (Paperback)
Krishna Rungta
R280 Discovery Miles 2 800 Ships in 7 - 11 working days
Free Delivery
Pinterest Twitter Facebook Google+
You may like...
Quantitative Electroencephalographic…
Tim Tinius Paperback R687 Discovery Miles 6 870
Database Systems: Pearson New…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R1,722 Discovery Miles 17 220
Oracle Database 10g RMAN Backup…
Matthew Hart, Robert Freeman Paperback R1,443 R1,133 Discovery Miles 11 330
Portable DBA Oracle
Robert Freeman Paperback R1,168 R927 Discovery Miles 9 270
Oracle Exalogic Elastic Cloud Handbook
Tom Plunkett, Tj Palazzolo, … Paperback R1,141 R884 Discovery Miles 8 840
Professional Microsoft SQL Server 2016…
Paul Turley Paperback R1,146 R814 Discovery Miles 8 140
Oracle Business Process Management Suite…
Manoj Das, Manas Deb, … Paperback R1,343 R1,059 Discovery Miles 10 590
Oracle Database Administration for…
Michelle Malcher Paperback R1,048 R818 Discovery Miles 8 180
Learning PHP, MySQL & JavaScript 5e
Robin Nixon Paperback R1,219 R767 Discovery Miles 7 670
SAP HANA XSA - Native Development for…
Francesco Alborghetti, Jonas Kohlbrenner, … Hardcover R1,648 R1,440 Discovery Miles 14 400

 

Partners