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.