SQL Recipes vs Professional Data Engineer

An everyday SQL reference, from your first SELECT to window functions. Every query comes with an explanation, and most of them run. • 39 sections: filtering, sorting, calculated fields, functions, GROUP BY, window functions, subqueries, JOIN, UNION, INSERT and UPDATE, data types, tables, views. • Run in the app: more than half of the queries execute against a live practice database, and the result table appears below the query. Needs an internet connection. • Changes in new versions: 7 sections from SQL-92 to SQL:2023, showing what each standard added, with the old and the new query side by side. • Dialects compared: MySQL, PostgreSQL, SQLite, MS SQL Server, Oracle, Firebird, Access. Where they differ, each one is shown separately. • The practice database is the classic MySQL world sample database: countries, cities, languages. The tables are described in the app. • Edit any query and run it again; one tap brings the original back. • Add your own queries; they stay in the app and are always at hand. • Search by section name or by a fragment of a query. • Everything except running works offline. No account needed. WHAT THE FREE VERSION INCLUDES 12 runs and 12 edits a day; the limit resets every morning. The keyword reference is unlocked, with no limits. Up to 5 queries of your own. The full version unlocks every section, lifts the daily limits and raises the run limit to 80 a day. One purchase, no subscription. Built by a developer for developers. In active development since 2015.

Non-Affiliation Disclaimer (Google Professional Data Engineer) This app is an independent exam preparation resource and is not affiliated with, endorsed by, or connected with Google or Google Cloud. All practice materials are created solely for learning and study purposes. Trademark Notice (Google Professional Data Engineer) Google, Google Cloud, and Google Cloud Professional Data Engineer are trademarks or registered trademarks of Google LLC.
Any references to Google Cloud exams or terminology are for identification only and do not imply official endorsement. ===== There are many questions on the web that are either outdated or wrongly answered. I am trying here to filter all those questions and provide you with a nice tool to practice the exam similar to the real-life exam as much as possible. This small app was designed with love to help you 5 things: 1. question content is updated monthly in 2026, so you don’t have to worry that these question is outdated anymore. 2. With 2 EXACT-FILTERING features, you can focus easily on questions you are making mistakes or missing. 3. Save difficult questions offline. So you can practice them later when you have free time. 4. Examination mode will help you take test like a real exam. So you will be more confident. 5. NEARLY-100% questions are packed with straightforward explanations. You will know why it is correct or wrong. No more confusing. In sum, this app is simple and straight-to-the-point like description you are reading. Have fun and enjoy the app!