SQL Primer vs SQL Programming Guide

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 ;)

Learn SQL Quickly and Easily! SQL Programming is the ultimate learning tool for mastering SQL and core database concepts from the ground up. Designed for beginners, this app provides clear, step-by-step tutorials across four major SQL database systems: • MySQL • PostgreSQL • MSSQL • Oracle Choose your preferred SQL dialect to personalize your learning journey. Whether you're brand new to databases or brushing up on your skills, this app makes SQL simple and accessible. Why Choose SQL Programming app? • Beginner-Friendly – No prior programming or database knowledge required • Multi-Platform Learning – Learn syntax and features unique to MySQL, PostgreSQL, MSSQL, and Oracle • Interactive Quizzes – Reinforce concepts and prepare for coding interviews, tests, and exams • Smart Learning Tools – Save favorite topics and use full-text search to find what you need fast • Multilingual Support – Available in English, French, German, Italian, Portuguese, and Spanish • Regular Updates – New content and quiz questions added with every version Comprehensive Topics Include: • Introduction to Databases • SQL Basics & Data Types • Creating & Modifying Tables • Inserting, Updating & Deleting Data • Querying with SELECT • Filtering & Sorting Data • String & Math Functions • Aggregates & Grouping • SQL Joins & Subqueries • Views, Indexes & Constraints • Transactions & Triggers • Stored Procedures & Window Functions • Cascade Actions Whether you're preparing for a job interview, studying for an exam, or learning SQL for the first time, SQL Programming is your go-to SQL learning companion.