Learn SQL

Learn SQL

學習SQL - 帶有查詢和示例的結構化查詢語言(SQL)

應用信息


1.24
February 24, 2024
83,520
Android 4.4+
Everyone
Get Learn SQL for Free on Google Play

Advertisement

應用描述


Android應用分析和審查:Learn SQL,由Darshan University開發。在教育類別中列出。當前版本為1.24,在 24/02/2024 上更新。根據用戶在Google Play上的評論:Learn SQL。超過84 千的安裝。 Learn SQL目前有258評論,平均評分為3.9星

Learn SQL 是一款用於學習查詢語言的基本命令的應用程序。使用示例查詢瀏覽 SQL 主題。 App為開發數據庫的初學者提供了SQL教程。


新增功能:
> 面試題
> 用於練習的複雜查詢
> SQL 測驗


應用程序涵蓋的主題是
> SQL 基本術語
- 基本條款
- 表和列命名規則

> SQL工具
- 微軟 SQL 服務器,
- MySQL
- 甲骨文
- PostgreSQL
- SQLite
- MongoDB

> SQL 組件
- 數據定義語言 (DDL)
- 數據操作語言 (DML)
- 數據查詢語言 (DQL)
- 數據控制語言 (DCL)
- 事務控制語言 (TCL)

> 數據類型
- SQL 數據類型
- TinyInt、SmallInt、Int、BigInt之間的比較
- Char、NChar、Varchar、NVarchar之間的比較
- 文本數據類型的缺點

> 基本主題
- SQL 創建數據庫
- SQL DROP 數據庫
- SQL 創建表
- SQL 從現有表中創建表
- SQL 插入到選擇中
- SQL 選擇
- SQL WHERE 子句
- SQL 選擇不同的
- SQL TOP 子句
- SQL 更新
- SQL 刪除
- SQL 截斷
- SQL 刪除與截斷
- SQL 改變
- ALTER語句的規則
- SQL 重命名(表)
- SQL 重命名(列)
- SQL 刪除
- 下降與截斷

> 高級主題
- SQL 與、或、非
- SQL 組合 AND、OR、NOT
- SQL 之間
- SQL 排序依據
- SQL 輸入
- SQL 不在
- SQL 喜歡
- SQL 空
- SQL 案例
- SQL EXISTS 運算符
- SQL ALL & ANY 運算符
- SQL 命令
- SQL 聚合函數
- SQL 分組依據
-SQL有
- SQL WHERE 與 HAVING
- SQL 數字函數
- SQL 字符串函數
- SQL 日期函數
- SQL 高級函數
- SQL SET 運算符
- SQL 自動遞增
- SQL 身份插入開/關
- SQL 別名
- SQL 連接
- SQL 笛卡爾連接
- SQL 內連接
- SQL 左連接
- SQL 右連接
- SQL 全連接
- SQL 自連接
- SQL JOIN 與 UNION
- SQL 唯一鍵
- SQL 主鍵
- SQL 外鍵
- 主鍵與唯一鍵與外鍵
- SQL CHECK 約束
- SQL 默認約束
- SQL 子查詢
- SQL 相關子查詢
- SQL 子查詢與相關
- SQL 提交/回滾
- SQL 授予/撤銷

該應用的主要特點是
> 50 多個結構化查詢語言 (SQL) 主題
> 50 多個示例查詢供您推薦
> 免費學習 SQL 語言
> 易於使用的用戶界面
> 您可以與您的朋友和家人分享該應用程序。
---------------------------------------------- ---------------------------------------------- ------------------------------------------
此應用程序由 CE 第六學期學生 Arik Kantesaria (190540107099) 在 ASWDC 開發。 ASWDC 是拉傑果德達山大學的應用程序、軟件和網站開發中心,由計算機科學與工程系的學生和教職員工運營。

致電我們:+91-97277-47317

寫信給我們:[email protected]
訪問:http://www.aswdc.in http://www.darshan.ac.in

在 Facebook 上關注我們:https://www.facebook.com/DarshanUniversity
在 Twitter 上關注我們:https://twitter.com/darshanuniv
在 Instagram 上關注我們:https://www.instagram.com/darshanuniversity/
我們目前正在提供1.24版本。這是我們最新,最優化的版本。它適用於許多不同的設備。從Google Play商店或我們託管的其他版本中免費下載Apk。此外,您可以在不註冊的情況下下載且無需登錄。

我們擁有超過2000+的Samsung, Xiaomi, Huawei, Oppo, Vivo, Motorola, LG, Google, OnePlus, Sony, Tablet ...設備,並提供了許多選項,您可以輕鬆選擇適合您設備的遊戲或軟件。

如果在Google App Store上有任何國家限製或設備側面的任何限制,它可能會派上用場。

什麼是新的


Improve Performance

在Google Play商店進行評分和審查


3.9
258 全部的
5 62.6
4 6.2
3 0
2 18.7
1 12.5

安裝總數(*估計)

估計Google Play上安裝總數, 近似於評級數和在Google Play上達到的安裝界限.

最近的評論

user
Cherie

This app has a lot of suspicious reviews all saying the same things, nothing specific (like you'd say if you actually used it to learn) and many around the same dates. It doesn't have very much information at all, and most of it is not adequately explained. Terms are used that have never been defined. Interface is nice, but it's not worth the download for so little information. Not well-thought out at all.

user
Modin Khan

Sir when you want to earn money there is lot of other ways u can earn, but by using education app platform and showing ads on everytime a person clicks back button or goes to different page/topic is not the right way. People will tend to loose intrest on the subject as an whole which is far more disastrous to an individual and to the country as an whole. Net net : just reduce the number of adsthat pops up from nowhere while focusing on the subject. Use quick tutorial to help navigate in tool

user
A Google user

Probably the best purely informational app I've seen of the dozen or so SQL apps I've used. Well layed out app and good variation of query formats shown. Explains many key conceots at a basic level. My only issue relates to a vagueness on some facts stated, ie. 8 character length database name limit - this isnt clear what type of SQL is being referenced, MS SQL (the assumed standard) 2008 has an 128 limit so this is far from accurate without being defined clearer.

user
Umair Arif

I tend to use that app while I was learning SQL and found it excellent for beginners, in terms of content and easy to navigate .... however during the last few months, the ap keeps crashing. I uninstall and install it again but it didn't work ....can you please look into it.

user
A Google user

Offline contents is not available. Please make it as offline. The new version has many problem. Older version is good because it is offline and don't require storage permission. While using the new version if there is no internet immediately crashes. Zero star for new version.

user
Satish Sapariya

"I recently started using this app to learn SQL and I am blown away by its functionality and ease of use. The user interface is clean and intuitive, making it easy for me to navigate. The lessons are well-structured and cover all the important concepts in an easy to understand manner. The interactive exercises and quizzes provide a great way to test my knowledge and track my progress. It's really help me a lot.

user
Keval Gadara

This application is best for learner of any kind of people like students,professors and anyother who have already passed out this subject in past and they are now working in software field....So Great App for all the features which are involve for us to solve dbms queries for placement preparation....

user
A Google user

primary and foreign key articles should be inside the basic directory because normally when you create a table you would require a primary key also most of the times people need to use multiple tables and find relationships among them. Also it would be nice to see documentation to specific sql servers like pl/sql in oracle 12 c as an example.