Dezvoltator: Paulo Narra (12)
Preț: $4.99
Clasificări: 0 
Recenzii: 0 Scrie o recenzie
Liste: 0 + 0
Punctele: 0 + 1 (1.0) ¡
Mac App Store

Descriere

Learn SQL for MySQL
Will you start learning SQL in MySQL?
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
Mai multe ↓

Capturi de ecran

#1. Learn SQL for MySQL (macOS) De: Paulo Narra
#2. Learn SQL for MySQL (macOS) De: Paulo Narra
#3. Learn SQL for MySQL (macOS) De: Paulo Narra
#4. Learn SQL for MySQL (macOS) De: Paulo Narra
#5. Learn SQL for MySQL (macOS) De: Paulo Narra
#6. Learn SQL for MySQL (macOS) De: Paulo Narra
#7. Learn SQL for MySQL (macOS) De: Paulo Narra
#8. Learn SQL for MySQL (macOS) De: Paulo Narra
#9. Learn SQL for MySQL (macOS) De: Paulo Narra
#10. Learn SQL for MySQL (macOS) De: Paulo Narra

Ce este nou

  • Versiune: 3
  • Actualizată:
  • App update to support new IOS

Preț

  • Azi: $4.99
  • Minim: $1.99
  • Maxim: $7.99
  
Urmăriți prețurile

Dezvoltator

Punctele

0 ☹️

Clasificări

0 ☹️

Liste

0 ☹️

Recenzii

Fii primul care a revizuit 🌟

Informații suplimentare

Learn SQL for MySQLLearn SQL for MySQL Adresă URL scurtă: Copiate!
  • 🌟 Trimite
  • Mac App Store

S-ar putea sa-ti placa si

    • MySQL Database Optimizer
    • macOS Aplicații: Instrumente  De: Global Web SRL
    • $5.99  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 0  Versiune: 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 Aplicații: Instrumente  De: codeBuilder
    • $5.99  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 0  Versiune: 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 Aplicații: Instrumente  De: Niklas Saers
    • $9.99  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 0  Versiune: 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 Aplicații: Instrumente  De: Paulo Narra
    • $4.99  
    • Liste: 1 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 1 + 2 (3.5)  Versiune: 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 Aplicații: Instrumente  De: Pannous
    • $1.99  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 3 + 0  Versiune: 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 Aplicații: Instrumente  De: Hankinsoft Development Inc
    • * Gratuit  
    • Liste: 2 + 1  Clasificări: 0  Recenzii: 0
    • Punctele: 2 + 0  Versiune: 2025.75   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 Aplicații: Instrumente  De: Fedor Obraztsov
    • * Gratuit  
    • Liste: 1 + 1  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 83 (4.7)  Versiune: 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
        ⥯ 
    • Sqlman - MySQL Database GUI
    • macOS Aplicații: Instrumente  De: 强 李
    • * Gratuit  
    • Liste: 0 + 2  Clasificări: 0  Recenzii: 0
    • Punctele: 3 + 0  Versiune: 1.1.7   Sqlman is a MySQL database client GUI focused on fast querying. It allows quick switching between multiple table queries, keeps query history, and makes it easy to reopen past queries.
        ⥯ 
    • Navicat 17 for MySQL
    • macOS Aplicații: Instrumente  De: PremiumSoft CyberTech Ltd.
    • * Gratuit  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 0  Versiune: 17.3.8   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 Aplicații: Instrumente  De: 著显 朱
    • Gratuit  
    • Liste: 0 + 1  Clasificări: 0  Recenzii: 0
    • Punctele: 1 + 0  Versiune: 3.79   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 Aplicații: Instrumente  De: HY System CO. Limited
    • Gratuit  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 0  Versiune: 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 ...
        ⥯ 
    • InsertSmith: TSV to SQL Insert
    • macOS Aplicații: Instrumente  De: Jesse Benjamin
    • $4.99  
    • Liste: 0 + 0  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 0  Versiune: 1.0   What it does: Paste TSV data (from SSMS, Azure Data Studio, Excel, or any export), enter your destination table name, and get clean SQL INSERT statements with proper escaping, type ...
        ⥯ 
    • OCaml: Learn & Code
    • macOS Aplicații: Instrumente  De: Groupe MINASTE
    • Gratuit  
    • Liste: 0 + 1  Clasificări: 0  Recenzii: 0
    • Punctele: 0 + 16 (4.6)  Versiune: 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 - ...
        ⥯ 

S-ar putea sa-ti placa si

Operatorii de căutare pe care îi poți folosi cu AppAgg
Adăugați la AppAgg
AppAgg
Începeți - este gratis.
Înregistrare
Conectați-vă