SQL Primer vs SQL Code Play

1970 E.F. Codd has started a revolution with his paper 'A relational model of data for large shared data banks, Communications of the ACM, Volume 13, Issue 6 (June 1970)' that finally led to the today's omnipresent database query language SQL. This little app shows some primitive and derived operations with the following information: * SQL92 and SQL86/89 sample queries, * the results of the queries and * appropriate descriptions. Furthermore the SQL test script that has been used for the calculation of the samples can be displayed. The app is interesting for the first contact with the database subject and for all who are using SQL86/89 queries for over two decades now and finally want to change to SQL92 also ;)

SQL Code Play – Learn and Practice SQL with Live Output and Offline Support SQL Code Play is your all-in-one mobile solution to learn, practice, and master SQL programming directly on your iPhone or iPad. This powerful and lightweight app is perfect for students, beginners, software developers, and data professionals who want to strengthen their SQL skills or prepare for database interviews. With over 70+ carefully crafted SQL examples, a built-in SQLite editor, and full offline access, SQL Code Play gives you a real-time SQL coding experience right from your mobile device. No setup, no internet, no distractions — just pure SQL learning and coding. Whether you're learning SQL from scratch, testing queries, or brushing up on fundamentals, this app helps you build confidence with hands-on practice and detailed explanations. Why Choose SQL Code Play? SQL Code Play goes beyond theory. It brings you an interactive SQL learning environment with practical code samples, live execution, and instant output. This isn’t just a static tutorial — it's an actual SQL lab in your pocket. The app includes 70+ example queries across a wide range of topics, making it easy to understand each concept with real use cases. Each example is explained clearly and includes real output to reinforce learning. You can also write your own queries, modify existing code, and save your work for future reference. Perfect for those preparing for job interviews, working on academic assignments, or getting started with data analysis Key Features: Built-in SQL Editor: Run SQL queries using an integrated SQLite compiler. 70+ Real Examples: Practice with ready-to-use queries from beginner to advanced level. Instant Output: Get immediate results when you run any query. In-Depth Explanations: Each SQL example includes a clear and concise explanation. Offline SQL Learning: No internet required to access tutorials or run examples. Save and Edit Queries: Customize your own code and store it for reuse. SQL Interview Preparation: Great resource to prepare for SQL technical interviews. Clean and Simple UI: Designed for ease of use and focused learning. Beginner-Friendly: No prior programming or database experience needed. Learn Core SQL Topics Including: Basic SQL syntax: SELECT, INSERT, UPDATE, DELETE Filtering data with WHERE, IN, BETWEEN, LIKE Logical operators: AND, OR, NOT Sorting and grouping: ORDER BY, GROUP BY, HAVING Aggregate functions: COUNT, SUM, AVG, MIN, MAX Subqueries and nested SELECTs Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN Working with NULL values String and date functions Using DISTINCT and LIMIT clauses SQL constraints: PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE Who Can Benefit from SQL Code Play? Students learning SQL for coursework or projects Developers need a quick and portable SQL testing tool Data analysts practicing queries for real-world data Beginners starting their database learning journey Professionals preparing for job interviews or technical assessments Anyone who wants to learn SQL in a simple and interactive way Subscription and Ads SQL Code Play is free to use and includes all learning material and features with ads. Ads help support the continued development of the app. If you prefer an ad-free experience, you can easily remove ads by subscribing to the premium version via in-app purchase. Your Pocket SQL Editor and Learning Tool No need for heavy tools or internet connections — SQL Code Play turns your mobile device into a complete SQL practice environment. Learn, write, run, and understand SQL queries at your own pace. Whether you have just a few minutes or a full hour, this app helps you make consistent progress in your SQL journey. With offline access, interactive learning, and real examples, SQL Code Play makes it easier than ever to become confident in SQL, whether you're learning for fun, school, or your career. Terms of Use https://www.apple.com/legal/internet-services/itunes/dev/stdeula/