| Developer: | Paulo Narra (11) | ||
| Price: | $4.99 | ||
| Rankings: | 0 | ||
| Reviews: | 0 Write a Review | ||
| Lists: | 0 + 0 | ||
| Points: | 0 + 1 (1.0) ¡ | ||
| Mac App Store | |||
Description
Did you forget the statements many times?
Do you no longer remember the syntax and the result of an statement?
Developed to easily learn SQL Programming for MySQL
. . . . . . . . . . . . . . . . . . . . .
This App acts as a reference for the SQL language
Learn DML & DDL statements with description, syntax, notes and examples
For each statement is presented:
Detailed description of the statement/command purpose
Syntax of the statement with various options
Two examples executed from a real table (Automobile Table)
Provides:
. . . . . . . . . . . . . . . . . . . . .
1. GENERAL
1.1 - Comments
1.2 - Data Types
2. (DML) Data Manipulation Language
2.1 – SELECT
- Columns, Multi-Column, All Columns
- Expressions, Functions, Alias
- Limit, Distinct, Order By
- Where
- Relational, Math & String Operators
- Wildcards
- Group By, Having, Aggregate Functions
- Union (Any & All)
- Subqueries
- Joins (Inner, Right, Left)
- Select Into
2.2 - INSERT
- With Columns names
- Without Column names
- Rules
- Insert Into ... Select
2.3 - DELETE
- Delete All Rows
- Delete ... Where
- Rules
- Referencial Integrity
2.4 - UPDATE
- Update All Rows
- Update ... Where
- Rules
3. (DDL) DATA DEFINITION LANGUAGE
3.1 - CREATE
- Create Database
- Create Table
- Create Index
- Auto-Increment
- Constraints (PK, FK, CK, DF, UQ, NN)
3.2 - ALTER
- Alter Columns
- Add Constraints
- Drop Constrains
3.3 - DROP
- Drop Table
- Drop Database
- Drop Index
3.4 - TUNCATE
- Delete Versus Truncate
Screenshots
Price History
- Today: $4.99
- Minimum: $1.99
- Maximum: $7.99
Track prices
Developer
- Paulo Narra
- Platforms: iOS Apps (8) macOS Apps (3)
- Lists: 1 + 0
- Points: 2 + 3 ¡
- Rankings: 0
- Reviews: 0
- Discounts: 0
- Videos: 0
- RSS: Subscribe
Points
☹️
Rankings
☹️
Lists
☹️
Reviews
Be the first to review 🌟
Additional Information
- Version: 3
- ID: com.pmbNarra.MySql
- Category:
macOS Apps›Developer Tools - OS:
iPad,iPhone,macOS,macOS 13.0 and up - Size:
22 Mb - Supported Languages:
Chinese,English,Portuguese,Spanish - Content Rating:
4+ - Mac App Store Rating:
1.0(1) - Updated:
- Release Date:
Contacts
- Website:
https://pmbnarra.wixsite.com/mysql
«Learn SQL for MySQL» is a Developer Tools app for macOS, developed by «Paulo Narra». It was first released on and last updated on . The lowest historical price was $1.99 on , and the highest was $7.99 on . This app has not yet received any ratings or reviews on AppAgg. On Mac App Store, the current store rating is 1.0 based on 1 votes. Available languages: Chinese, English, Portuguese, Spanish. AppAgg continuously tracks the price history, ratings, and user feedback for «Learn SQL for MySQL». Subscribe to this app or follow its RSS feed to get notified about future discounts or updates.
You may also like
-
- MySQL Database Optimizer
- macOS Apps: Developer Tools By: Global Web SRL
- $5.99
- Lists: 0 + 0 Rankings: 0 Reviews: 0
- Points: 0 + 0 Version: 1.9.2 MySQL / MariaDB Optimizer is an effective app that gives you recommendations to optimize MySQL / MariaDB databases. The app provides a graphical interface simplify the process of ... ⥯
-
- SQL Studio
- macOS Apps: Developer Tools By: codeBuilder
- $5.99
- Lists: 0 + 0 Rankings: 0 Reviews: 0
- Points: 0 + 0 Version: 1.25 SQL Studio is the simplest way to access your Microsoft SQL Servers natively from your Mac. With SQL Studio you can:- - Attach to multiple servers - Authenticate with SQL or Windows ... ⥯
-
- MySQL Commander
- macOS Apps: Developer Tools By: Niklas Saers
- $9.99
- Lists: 0 + 0 Rankings: 0 Reviews: 0
- Points: 0 + 0 Version: 1.4.0 Powerful MySQL client for Mac Great SQL query editor with syntax highlighting and fast query editing Queries are saved across devices using iCloud Work with and see multiple SQL ... ⥯
-
- Learn Python (Step By Step)
- macOS Apps: Developer Tools By: Paulo Narra
- $4.99
- Lists: 1 + 0 Rankings: 0 Reviews: 0
- Points: 1 + 2 (3.5) Version: 1.21 Want to learn Python the easy way? Do you want to remember the syntax and result of an statement? Developed so that students or teachers can easily learn the Python language More than ... ⥯
-
- Chat-SQL
- macOS Apps: Developer Tools By: Pannous
- $1.99
- Lists: 0 + 0 Rankings: 0 Reviews: 0
- Points: 3 + 0 Version: 1.0 Chat SQL allows you to naturally talk to your databases. Tell it what you want to know, change or do and it will transform your English input into SQL using OpenAI's GPT. Chat SQL ... ⥯
-
- SQLPro for MySQL
- macOS Apps: Developer Tools By: Hankinsoft Development Inc
- * Free
- Lists: 3 + 0 Rankings: 0 Reviews: 0
- Points: 2 + 0 Version: 2025.50 SQLPro for MySQL is a powerful MySQL & MariaDB database client which allows quick and simple access to MySQL Servers, including (but not limited to) those hosted in Amazon RDS and ... ⥯
-
- Python & SQL
- macOS Apps: Developer Tools By: Fedor Obraztsov
- * Free
- Lists: 1 + 1 Rankings: 0 Reviews: 0
- Points: 0 + 83 (4.7) Version: 3.01 Learn programming with the best code recipes. Python: - How to get a substring? - How to declare a generalized method? - How to perform a database query? SQL: - How to combine multiple ⥯
-
- Navicat 17 for MySQL
- macOS Apps: Developer Tools By: PremiumSoft CyberTech Ltd.
- * Free
- Lists: 0 + 0 Rankings: 0 Reviews: 0
- Points: 0 + 0 Version: 17.3.4 Navicat for MySQL is a complete package designed for the unified management and development of MySQL and MariaDB databases. It features visual designers for database modeling and data ... ⥯
-
- DBManage-mysql postgres mssql
- macOS Apps: Developer Tools By: 著显 朱
- Free
- Lists: 1 + 0 Rankings: 0 Reviews: 0
- Points: 1 + 0 Version: 3.73 Database manage tool for MySQL MSSQL PostgreSQL Oracle SQLite SQLServer ETCD Redis mongodb 1.connect database with ip port username password 2.show all database 3.chose database show ... ⥯
-
- HY SQL Query
- macOS Apps: Developer Tools By: HY System CO. Limited
- Free
- Lists: 0 + 0 Rankings: 0 Reviews: 0
- Points: 0 + 0 Version: 1.6.1 This simple Tools is for connect Database system to submit SQL Query and export the Result set to Excel file The below Database System: Microsoft SQL Server Microsoft Azure SQL Server ... ⥯
-
- Sqlman - MySQL SQLite Database
- macOS Apps: Developer Tools By: 强 李
- * Free
- Lists: 1 + 1 Rankings: 0 Reviews: 0
- Points: 3 + 0 Version: 1.1.3 Sqlman is a next-generation, sleek MySQL and SQLite GUI. Focused on quick queries. Native development, small installation package, and rapid response. ⥯
-
- Code School for Xcode Free -Learn How to Make Apps
- macOS Apps: Developer Tools By: Best App Limited
- Free
- Lists: 1 + 1 Rankings: 0 Reviews: 0
- Points: 1 + 0 Version: 1.1.3 ** FREE IOS APP DEVELOPMENT COURSE ** Learn Xcode and How to Make Apps for iPhone and iPad Using Swift ** Includes Step-by-Step Video Tutorials, Sample Codes, and Important Reference ... ⥯
-
- OCaml: Learn & Code
- macOS Apps: Developer Tools By: Groupe MINASTE
- Free
- Lists: 0 + 1 Rankings: 0 Reviews: 0
- Points: 0 + 16 (4.6) Version: 1.2.9 The all-in-one OCaml bundle for iOS, iPadOS and macOS! Learn the language and practice with a powerful editor and interactive top level available in the app, working offline. CODE - ... ⥯
-
- DevTutor: Learn Swift, SwiftUl
- macOS Apps: Developer Tools By: 楚江 王
- * Free
- Lists: 0 + 1 Rankings: 0 Reviews: 0
- Points: 1 + 2 (5.0) Version: 1.29.0 "DevTutor" is an application designed to assist developers in creating exceptional apps using SwiftUI. It offers replicable code samples and corresponding UI previews to streamline ... ⥯