Learn SQL

Learn SQL的描述

Learn SQL is an app to learn the basics commands of the query language. Browse through SQL topics with sample query. App provides SQL tutorial for the beginner in developing databases.

Topics covered in the app are:
> Basic Terms of SQL
- Basic Terms
- Table & Column Naming Rules

> Tools of SQL
- Microsoft SQL Server,
- MySQL
- Oracle
- Postgre SQL
- SQLite
- MongoDB

> Components of SQL
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Data Query Language (DQL)
- Data Control Language (DCL)
- Transaction Control Language (TCL)

> Data Types
- SQL data types
- Comparison between TinyInt, SmallInt, Int, BigInt
- Comparison between Char, NChar, Varchar, NVarchar
- The disadvantage of text datatype

> Basic Topics
- SQL CREATE Database
- SQL DROP Database
- SQL CREATE Table
- SQL CREATE Table from an Existing Table
- SQL INSERT INTO SELECT
- SQL SELECT
- SQL WHERE Clause
- SQL SELECT DISTINCT
- SQL TOP Clause
- SQL UPDATE
- SQL DELETE
- SQL TRUNCATE
- SQL DELETE vs TRUNCATE
- SQL ALTER
- Rules of ALTER Statement
- SQL RENAME (Table)
- SQL RENAME (Column)
- SQL DROP
- DROP vs TRUNCATE

> Advance Topics
- SQL AND, OR, NOT
- SQL Combined AND, OR, NOT
- SQL BETWEEN
- SQL ORDER BY
- SQL IN
- SQL NOT IN
- SQL LIKE
- SQL NULL
- SQL CASE WHEN
- SQL EXISTS Operator
- SQL ALL & ANY Operator
- SQL COMMANDS
- SQL AGGREGATE Functions
- SQL GROUP BY
- SQL HAVING
- SQL WHERE vs HAVING
- SQL NUMERIC Functions
- SQL STRING Functions
- SQL DATE Functions
- SQL ADVANCED Functions
- SQL SET Operators
- SQL AUTO INCREMENT
- SQL IDENTITY INSERT ON/OFF
- SQL ALIAS
- SQL JOINS
- SQL CARTESIAN JOIN
- SQL INNER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL JOIN
- SQL SELF JOIN
- SQL JOIN vs UNION
- SQL UNIQUE KEY
- SQL PRIMARY KEY
- SQL FOREIGN KEY
- Primary Key vs Unique Key vs Foreign Key
- SQL CHECK Constraint
- SQL DEFAULT Constraint
- SQL SUBQUERY
- SQL CORRELATED SUBQUERY
- SQL SUBQUERY vs CORRELATED
- SQL COMMIT/ROLLBACK
- SQL GRANT/REVOKE

Key features of the app are:
> 50+ topics of Structured Query Language (SQL)
> 50+ sample query for your referral
> Learn SQL language for free
> Easy to use User Interface
> You can share the app with your friends and family members.
----------------------------------------------------------------------------------------------------------------------------------------------
This App is developed at ASWDC by Parag Sanchaniya (160540107134), 6th-semester CE Student. ASWDC is Apps, Software, and Website Development Center @ Darshan Institute of Engineering & Technology, Rajkot run by Students & Staff of Computer Engineering Department

Call us: +91-9727747317

Write to us: aswdc@darshan.ac.in
Visit: http://www.darshan.ac.in http://www.darshan.ac.in/aswdc

Follow us on Facebook: https://www.facebook.com/DarshanInstitute.Official
Follows us on Twitter: https://twitter.com/darshan_inst
学习SQL是一个学习查询语言基础命令的应用程序。使用示例查询浏览SQL主题。 App为开发人员开发数据库提供了SQL教程。

应用中涵盖的主题：
> SQL的基本术语
     - 基本条款
     - 表和列命名规则

> SQL工具
     - Microsoft SQL Server，
     - MySQL
     - 甲骨文
     - Postgre SQL
     - SQLite
     - MongoDB

> SQL的组件
     - 数据定义语言（DDL）
     - 数据操作语言（DML）
     - 数据查询语言（DQL）
     - 数据控制语言（DCL）
     - 交易控制语言（TCL）

>数据类型
     - SQL数据类型
     - TinyInt，SmallInt，Int，BigInt之间的比较
     - Char，NChar，Varchar，NVarchar之间的比较
     - text数据类型的缺点

>基本主题
     - SQL CREATE数据库
     - SQL DROP数据库
     - SQL CREATE表
     - 现有表中的SQL CREATE表
     - SQL INSERT INTO SELECT
     - SQL SELECT
     - SQL WHERE子句
     - SQL SELECT DISTINCT
     - SQL TOP条款
     - SQL更新
     - SQL DELETE
     - SQL TRUNCATE
     - SQL DELETE与TRUNCATE
     - SQL ALTER
     - ALTER声明规则
     - SQL RENAME（表）
     - SQL RENAME（列）
     - SQL DROP
     - DROP vs TRUNCATE

>高级主题
     - SQL AND，OR，NOT
     - SQL组合AND，OR，NOT
     - SQL BETWEEN
     - SQL ORDER BY
     - SQL IN
     - SQL NOT IN
     - SQL LIKE
     - SQL NULL
     - SQL CASE WHEN
     - SQL EXISTS运算符
     - SQL ALL＆ANY Operator
     - SQL命令
     - SQL AGGREGATE函数
     - SQL GROUP BY
     - SQL HAVING
     - SQL WHERE vs HAVING
     - SQL NUMERIC函数
     - SQL STRING函数
     - SQL DATE函数
     - SQL ADVANCED函数
     - SQL SET运算符
     - SQL自动增量
     - SQL IDENTITY INSERT ON / OFF
     - SQL ALIAS
     - SQL JOINS
     - SQL CARTESIAN JOIN
     - SQL INNER JOIN
     - SQL LEFT JOIN
     - SQL RIGHT JOIN
     - SQL FULL JOIN
     - SQL SELF JOIN
     - SQL JOIN vs UNION
     - SQL UNIQUE KEY
     - SQL PRIMARY KEY
     - SQL FOREIGN KEY
     - 主键与唯一键与外键
     - SQL CHECK约束
     - SQL DEFAULT约束
     - SQL SUBQUERY
     - SQL CORRELATED SUBQUERY
     - SQL SUBQUERY与CORRELATED
     - SQL COMMIT / ROLLBACK
     - SQL GRANT / REVOKE

该应用的主要功能：
> 50多个结构化查询语言主题（SQL）
> 50以上的推荐样本查询
>免费学习SQL语言
>易于使用的用户界面
>您可以与您的朋友和家人分享该应用程序。
-------------------------------------------------- -------------------------------------------------- ------------------------------------------
此应用程序由ASWDC由Parag Sanchaniya（160540107134），第六学期CE学生开发。 ASWDC是应用程序，软件和网站开发中心@Darshan工程技术研究所，Rajkot由计算机工程系的学生和工作人员运营

致电我们：+ 91-9727747317

写信给我们：aswdc@darshan.ac.in
访问：http：//www.darshan.ac.in http://www.darshan.ac.in/aswdc

在Facebook上关注我们：https：//www.facebook.com/DarshanInstitute.Official
在Twitter上关注我们：https：//twitter.com/darshan_inst