SQL Programming Pro
iOS Universel / Education
This is an app designed to help beginners quickly learn SQL and database concepts.
The application introduces SQL from the ground up, covering all the essential topics for those new to databases. It offers tutorials and examples across four major SQL database management systems:
• MySQL,
• MSSQL,
• PostgreSQL,
• Oracle.
Users can choose their preferred SQL flavour to focus on, ensuring a personalised learning experience tailored to their interests.
The SQL Programming Pro app requires no prior programming or database knowledge, making it ideal for absolute beginners. For those with some experience, it serves as a helpful resource for refreshing concepts and exploring practical examples.
The program also features test quizzes to help with learning SQL programming, making it an excellent resource for interview preparation, tests, and exams.
The Pro version offers additional features, including:
• Favorites feature: Allows users to save topics and access them quickly.
• Full-text search: Enables quick navigation across all app content.
The application is available in the following languages: English, French, German, Italian, Portuguese, and Spanish.
• The app content covers the following topics:
• Introduction to Databases
• SQL Basics
• Data Types
• Creating and Modifying Tables
• Inserting, Updating, and Deleting Data
• Querying Data (SELECT)
• Filtering and Sorting Data
• Functions (String, and Math Functions)
• Aggregations and Grouping
• Joins
• Subqueries
• Views
• Indexes
• Constraints
• Transactions
• Triggers
• Stored procedures
• Window functions
• Cascade actions
The content of the application and the test Q&A are updated with each new version.
Quoi de neuf dans la dernière version ?
Updated content and libraries.
New UI design for quizzes.
Added new languages. Now, the application is available in the following languages: English, French, German, Italian, Portuguese, and Spanish.
