Rakuten Kobo

100 SQL Server Mistakes and How to Avoid Them

by Peter Carter ...

All the mistakes you might make with SQL Server—and how to avoid them!100 SQL Server Mistakes and How to Avoid Them prepares you for the pitfalls database professionals often encounter—from administration to development, availability, and security. You'll learn to sidestep common errors that slow down your T-SQL code and ensure your SQL Server is installed and configured to handle anything your ... Read more

$65.99 CAD

All the mistakes you might make with SQL Server—and how to avoid them!100 SQL Server Mistakes and How to Avoid Them prepares you for the pitfalls database professionals often encounter—from administration to development, availability, and security. You'll learn to sidestep common errors that slow down your T-SQL code and ensure your SQL Server is installed and configured to handle anything your
... Read more
The MySQL Workshop

A practical guide to working with data and managing databases with MySQL

by Thomas Pettit, Scott Cosentino, Dr. Vlad Sebastian Ionescu ...

Learning MySQL just got a whole lot easier, thanks to this hands-on workshop, complete with simple explanations, engaging examples, and realistic exercises that focus on helping you to build and maintain databases effectivelyKey FeaturesLearn how to set up and maintain a MySQL databaseRun SQL queries to create, retrieve, and manipulate dataUse MySQL effectively with common business applications ... Read more

$27.19 CAD or Free with Kobo Plus

Learning MySQL just got a whole lot easier, thanks to this hands-on workshop, complete with simple explanations, engaging examples, and realistic exercises that focus on helping you to build and maintain databases effectivelyKey FeaturesLearn how to set up and maintain a MySQL databaseRun SQL queries to create, retrieve, and manipulate dataUse MySQL effectively with common business applications
... Read more
Programming SQL Server 2005

Prepare for Deeper SQL Server Waters

by Bill Hamilton ...

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.Programming SQL Server 2005 from O'Reilly provides a ... Read more

$39.99 CAD

SQL Server 2005, Microsoft's next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power--making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.Programming SQL Server 2005 from O'Reilly provides a
... Read more
SQL Pocket Guide

A Guide to SQL Usage

by Alice Zhao ...

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.In this updated edition, author Alice Zhao describes how these database ... Read more

$31.19 CAD

If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.In this updated edition, author Alice Zhao describes how these database
... Read more
Routine SAS SQL

by Rick Aster ...

A practical introduction to the use of SQL, the popular database language, in the SAS environment. With a modest level of SQL skill, you can use SQL on SAS data or combine SAS data with database data. ... Read more

$10.99 CAD

A practical introduction to the use of SQL, the popular database language, in the SAS environment. With a modest level of SQL skill, you can use SQL on SAS data or combine SAS data with database data.
... Read more
Oracle Database 12c PL/SQL Programming

by Michael McLaughlin ...

Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and ... Read more

$95.69 CAD

Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and
... Read more
Programmer avec MySQL

SQL - Transactions - PHP - Java - Optimisations - XML - JSON - Avec 40 exercices corrigés - 6e édition

by Christian Soutou ...

Series series Noire
Apprendre SQL par l'exempleParticulièrement destiné aux débutants, cet ouvrage permet de découvrir tous les aspects de la programmation SQL (création de tables, évolution, mises à jour et extractions) par le biais du système de gestion de bases de données MySQL. Les concepts du langage procédural de MySQL y sont décrits avec précision : variables, structure de contrôle, interactions avec la base, ... Read more

$33.61 CAD

Apprendre SQL par l'exempleParticulièrement destiné aux débutants, cet ouvrage permet de découvrir tous les aspects de la programmation SQL (création de tables, évolution, mises à jour et extractions) par le biais du système de gestion de bases de données MySQL. Les concepts du langage procédural de MySQL y sont décrits avec précision : variables, structure de contrôle, interactions avec la base,
... Read more
Expert Cube Development with SSAS Multidimensional Models

by Chris Webb, Alberto Ferrari, Marco Russo ...

An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you.You are ... Read more

$34.09 CAD or Free with Kobo Plus

An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you.You are
... Read more
SQL Antipatterns

Avoiding the Pitfalls of Database Programming

by Bill Karwin ...

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns--the most common errors he's identified in those thousands of requests for help.Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common ... Read more

$31.99 CAD

Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns--the most common errors he's identified in those thousands of requests for help.Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common
... Read more
SQL Server Analysis Services 2012 Cube Development Cookbook

by Baya Dewald, Steve Hughes, Paul Turley ...

A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL ... Read more

$41.79 CAD or Free with Kobo Plus

A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS.If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL
... Read more
Oracle Database 11g & MySQL 5.6 Developer Handbook

by Michael McLaughlin ...

Series series Oracle Press
Master Application Development in a Mixed-Platform EnvironmentBuild powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with ... Read more

$63.79 CAD

Master Application Development in a Mixed-Platform EnvironmentBuild powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with
... Read more
SQL Database Programming

The Ultimate Guide to Learning SQL Database Programming Fast!

by Tim Warren ...

SQL DATABASE PROGRAMMINGThe ability to use SQL (Structured Query Language) is a hugely powerful skill.This book is aimed at complete beginners, and will take you through all of the steps needed to master SQL.You will learn how to use databases, the different SQL features, why you need to learn these skills, and how they can be used practically!You will be taken step by step through all of the ... Read more

$2.99 CAD or Free with Kobo Plus

SQL DATABASE PROGRAMMINGThe ability to use SQL (Structured Query Language) is a hugely powerful skill.This book is aimed at complete beginners, and will take you through all of the steps needed to master SQL.You will learn how to use databases, the different SQL features, why you need to learn these skills, and how they can be used practically!You will be taken step by step through all of the
... Read more
Advanced SQL with SAS

by Christian FG Schendera ...

This book introduces advanced techniques for using PROC SQL in SAS. If you are a SAS programmer, analyst, or student who has mastered the basics of working with SQL, Advanced SQL with SAS® will help take your skills to the next level. Filled with practical examples with detailed explanations, this book demonstrates how to improve performance and speed for large data sets. Although the book ... Read more

$65.59 CAD or Free with Kobo Plus

This book introduces advanced techniques for using PROC SQL in SAS. If you are a SAS programmer, analyst, or student who has mastered the basics of working with SQL, Advanced SQL with SAS® will help take your skills to the next level. Filled with practical examples with detailed explanations, this book demonstrates how to improve performance and speed for large data sets. Although the book
... Read more
SQL All-in-One For Dummies

by Allen G. Taylor, Richard Blum ...

The most thorough SQL reference, now updated for SQL:2023SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there ... Read more

$31.99 CAD

The most thorough SQL reference, now updated for SQL:2023SQL All-in-One For Dummies has everything you need to get started with the SQL programming language, and then to level up your skill with advanced applications. This relational database coding language is one of the most used languages in professional software development. And, as it becomes ever more important to take control of data, there
... Read more
Sql Guide (Speedy Study Guides)

by Speedy Publishing ...

SQL stands for Structured Query Language, and it is a programming language that is entirely designed for the management of data in a database system. Knowing SQL is an essential skill for today's programmer, and if you are looking for a career in information tech, you will quickly realize that SQL can push you far ahead of the rest of the people competing for the position. SQL is a very rich, very ... Read more

$6.29 CAD

SQL stands for Structured Query Language, and it is a programming language that is entirely designed for the management of data in a database system. Knowing SQL is an essential skill for today's programmer, and if you are looking for a career in information tech, you will quickly realize that SQL can push you far ahead of the rest of the people competing for the position. SQL is a very rich, very
... Read more
PLI Basic Training Using VSAM, IMS and DB2

by Robert Wingate ...

This book will teach you the basic information and skills you need to develop applications with PLI on IBM mainframes running z/OS. The instruction, examples and sample programs in this book are a fast track to becoming productive as quickly using PLI with VSAM, IMS and DB2. The content is easy to read and digest, well organized and focused on honing real job skills. ... Read more

$9.99 CAD

This book will teach you the basic information and skills you need to develop applications with PLI on IBM mainframes running z/OS. The instruction, examples and sample programs in this book are a fast track to becoming productive as quickly using PLI with VSAM, IMS and DB2. The content is easy to read and digest, well organized and focused on honing real job skills.
... Read more
Introducing Microsoft SQL Server 2019

Reliability, scalability, and security both on premises and in the cloud

by Kellyn Gorman, Allan Hirt, Dave Noderer, Mitchell Pearson, James Rowland-Jones, Dustin Ryan, Arun Sirpal, Buck Woody ...

Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019.Key FeaturesGain insights into what’s new in SQL Server 2019Understand use cases and customer scenarios that can be implemented with SQL Server 2019Discover new cross-platform tools that simplify management and analysisBook DescriptionMicrosoft SQL Server comes ... Read more

$33.59 CAD or Free with Kobo Plus

Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019.Key FeaturesGain insights into what’s new in SQL Server 2019Understand use cases and customer scenarios that can be implemented with SQL Server 2019Discover new cross-platform tools that simplify management and analysisBook DescriptionMicrosoft SQL Server comes
... Read more
SQL in 10 Minutes a Day, Sams Teach Yourself

by Ben Forta ...

Series series Sams Teach Yourself
Just the parts of SQL you need to know from simple data retrieval to the use of SQL joins, subqueries, stored procedures, cursors, triggers, and table constraintsDesigned for anyone interacting with databases, this SQL book methodically, systematically, and simply teaches you in lessons that each take 10 minutes or less to complete. Lessons includeSQL statements, including complex SQL statements ... Read more

$28.99 CAD

Just the parts of SQL you need to know from simple data retrieval to the use of SQL joins, subqueries, stored procedures, cursors, triggers, and table constraintsDesigned for anyone interacting with databases, this SQL book methodically, systematically, and simply teaches you in lessons that each take 10 minutes or less to complete. Lessons includeSQL statements, including complex SQL statements
... Read more
Oracle PL/SQL Best Practices

Write the Best PL/SQL Code of Your Life

by Steven Feuerstein ...

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11gR2, Feuerstein has rewritten this new edition in the ... Read more

$21.59 CAD

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11gR2, Feuerstein has rewritten this new edition in the
... Read more
Introduction to Search with Sphinx

From installation to relevance tuning

by Andrew Aksyonoff ...

This concise introduction to Sphinx shows you how to use this free software to index an enormous number of documents and provide fast results to both simple and complex searches. Written by the creator of Sphinx, this authoritative book is short and to the point.Understand the particular way Sphinx conducts searchesInstall and configure Sphinx, and run a few basic testsIssue basic queries to ... Read more

$18.39 CAD

This concise introduction to Sphinx shows you how to use this free software to index an enormous number of documents and provide fast results to both simple and complex searches. Written by the creator of Sphinx, this authoritative book is short and to the point.Understand the particular way Sphinx conducts searchesInstall and configure Sphinx, and run a few basic testsIssue basic queries to
... Read more
SQL the One

Microsoft SQL Server Interview Guide

by Uday Arumilli ...

Congratulations! You are going to WIN your next SQL Server interview. “SQL The One” book can guide you to achieve the success in your next interview. This book covers Microsoft SQL Server interview experiences, questions and answers for a range of SQL DBA’s and SQL Server Professionals. All of these questions have been collected from the people who attended interviews at various multinational ... Read more

$8.23 CAD

Congratulations! You are going to WIN your next SQL Server interview. “SQL The One” book can guide you to achieve the success in your next interview. This book covers Microsoft SQL Server interview experiences, questions and answers for a range of SQL DBA’s and SQL Server Professionals. All of these questions have been collected from the people who attended interviews at various multinational
... Read more
Job Ready SQL

by Kimberly A. Weiss, Haythem Balti ...

Learn the most important SQL skills and apply them in your job—quickly and efficiently!SQL (Structured Query Language) is the modern language that almost every relational database system supports for adding data, retrieving data, and modifying data in a database. Although basic visual tools are available to help end-users input common commands, data scientists, business intelligence analysts, ... Read more

$35.99 CAD

Learn the most important SQL skills and apply them in your job—quickly and efficiently!SQL (Structured Query Language) is the modern language that almost every relational database system supports for adding data, retrieving data, and modifying data in a database. Although basic visual tools are available to help end-users input common commands, data scientists, business intelligence analysts,
... Read more
SQL Server 2017 Developer???s Guide

A professional guide to designing and developing enterprise database applications

by William Durkin, Dejan Sarka, Milo≈° Radivojeviƒá ...

Build smarter and efficient database application systems for your organization with SQL Server 2017Key Features\[\*\]Build database applications by using the development features of SQL Server 2017\[\*\]Work with temporal tables to get information stored in a table at any time\[\*\]Use adaptive querying to enhance the performance of your queriesBook DescriptionMicrosoft SQL Server 2017 is a ... Read more

$51.99 CAD or Free with Kobo Plus

Build smarter and efficient database application systems for your organization with SQL Server 2017Key Features\[\*\]Build database applications by using the development features of SQL Server 2017\[\*\]Work with temporal tables to get information stored in a table at any time\[\*\]Use adaptive querying to enhance the performance of your queriesBook DescriptionMicrosoft SQL Server 2017 is a
... Read more
Learning PostgreSQL 11

A beginner's guide to building high-performance PostgreSQL database solutions

by Andrey Volkov, Christopher Travers ...

Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applicationsKey FeaturesMonitor, secure, and fine-tune your PostgreSQL 11 databaseLearn client-side and server-side programming using SQL and PL/pgSQLDiscover tips on implementing efficient database solutionsBook DescriptionPostgreSQL is one of the most popular open source database management systems in the world, ... Read more

$37.59 CAD or Free with Kobo Plus

Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applicationsKey FeaturesMonitor, secure, and fine-tune your PostgreSQL 11 databaseLearn client-side and server-side programming using SQL and PL/pgSQLDiscover tips on implementing efficient database solutionsBook DescriptionPostgreSQL is one of the most popular open source database management systems in the world,
... Read more

eReaders

Apps

Accessories

Shopping Cart

You're getting the VIP treatment!

Your Shopping Cart is empty

Available:

1 audiobook monthly

+ FREE 30-day trial

Available:

1 audiobook monthly

+ FREE 30-day trial

Recommended For You

SQL eBooks

Show: