SQL & MySQL - Learn Databases [iPad]

SQL & MySQL - Learn Databases

Rodrigo Gomez U 無料 iPhone / iPad対応開発ツール教育 64bit

Trend

AppStoreでチェック！

iPhone
iPad

Rodrigo Gomez Uの開発ツールアプリ

「SQL & MySQL」は、Rodrigo Gomez Uが配信する開発ツールアプリです。

開発ツール教育

このアプリの話題とニュース

新バージョン1.0.8が配信開始。新機能や改善アップデートがされています。(5/2)
2023年4月4日(火)にiPhoneとiPad両対応のユニバーサルアプリとしてリリース！

使い方や遊び方

Learn SQL Databases

Learn SQL in a simple way, at any time. This application can be used by beginners or advanced in the database environment, to learn the syntax, learn how to insert, update, delete and extract records from a database, among many other functions.

In addition, SQL - Databases is ideal for refreshing concepts and the syntax of the sentences of this programming language.

Characteristics:

1. A simple design to use the application.

2. Instant information on the various statements of the SQL language.

3. Information of all kinds of the SQL programming environment, examples of use of the SELECT, DISTINCT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, BETWEEN statements, among many other SQL functionalities for Databases.

Learn SQL Databases, it incorporates various sections and in each of the menu options a breakdown of the topics to be covered:

Commands:

-SELECT
-DISTINCT
- WHERE
- AND / OR
-IN
- BETWEEN
-LIKE
-ORDER BY
- FUNCTIONS
-COUNT
-GROUP BY
-HAVING
- ALIAS
-JOIN
-OUTER JOIN
- CONCATENATE
-SUBSTRING
-TRIM

Table Manipulation:

-INSERT INTO
-UPDATE
- DELETE
-CREATE TABLE
-CONTRAINT
- Primary Key
- Foreign Key
-CREATE VIEW
-CREATE INDEX
-ALTER TABLE
-DROP TABLE
-TRUNCATE TABLE

Advanced SQL:

- UNION
- UNION ALL
- INTERSECT
- MINUS
- SUBQUERY
- EXISTS
- CASE
- Many more statements of this wonderful world of SQL programming.