SQL

Richard Nuckolls  is a Microsoft Certified Solution Developer and Azure enthusiast. During his 20 years of experience, he's done server and database administration, desktop and web development, and more recently has led teams in building production content management systems and web-scale analytics systems in Azure.

Carl Gold  is the Chief Data Scientist at Zuora, Inc, a comprehensive subscription management platform and newly public Silicon Valley "unicorn". Zuora is widely recognized in a leader in all things pertaining to subscription and recurring revenue, with 1,000 customers across a range of industries worldwide. Carl joined Zuora in 2015 and created the predictive analytics system for Zuora's subscriber analysis product, Zuora Insights.

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, Cloud engineers, Machine Learning programmers, and other professionals routinely need to query a database using SQL.

This practical guide bridges the gap between general cloud computing architecture in Microsoft Azure and scientific computing for bioinformatics and genomics. You'll get a solid understanding of the architecture patterns and services that are offered in Azure and how they might be used in your bioinformatics practice. You'll get code examples that you can reuse for your specific needs. And you'll get plenty of concrete examples to illustrate how a given service is used in a bioinformatics context.

Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. In the second edition of this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's a data lake using Hive, a modern lakehouse with Iceberg or Delta Lake, a different system like Cassandra, Kafka, or SingleStore, or a relational database like PostgreSQL or Oracle.

Dr.B.Chandra is an Adjunct Professor at the School of IT, Indian Institute of Technology, Delhi from Jan 2017. She served the computer Science Group of the Department of Maths, IIT Delhi as a senior professor from 1979 till June 2016. During her tenure she was the Head of the Department for three years and was deeply involved in the curriculum of M.Tech program in Maths and Computing. She was the chief data scientist at Sprinklr Solns for more than a year from August 2016.

John L. Viescas  is an independent database consultant with more than 50 years of experience. He began his career as a systems analyst, designing large database applications for IBM mainframe systems. He spent 6 years at Applied Data Research in Dallas, Texas, where he directed a staff of more than 30 people and was responsible for research, product development, and customer support of database products for IBM mainframe computers. While working at Applied Data Research, John completed a degree in business finance at the University of Texas at Dallas, graduating cum laude.

Fast access to data has become a critical game changer. Today, a new breed of company understands that the faster they can build, access, and share well-defined datasets, the more competitive they’ll be in our data-driven world. In this practical report, Scott Haines from Twilio introduces you to operational analytics, a new approach for making sense of all the data flooding into business systems.

Joyce Kay Avila has more than 25 years as a business and technology leader. She is a Texas Certified Public Accountant and currently holds one Amazon Web Services certification and one Snowflake certification. She also holds twelve Salesforce certifications, including the Tableau CRM and Einstein Discovery certification along with several Salesforce Architect-level certifications.

Sveta Smirnova is a MySQL Support Engineer at Percona. Her main professional interests are problem-solving, working with tricky issues and bugs, and teaching others how to deal with MySQL issues, bugs and gotchas effectively. In addition to authoring "MySQL Troubleshooting" and "JSON UDF Functions for MySQL", Sveta has spoken at many events, including Fosdem, Percona Live, and Oracle Open World.

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products.