Learn SQL
8.1 19
v1.24 by Darshan University
About learnsql
learnsql (Package Name: com.aswdc_dbms) is developed by Darshan University and the latest version of Learn SQL 1.24 was updated on March 1, 2024. Learn SQL is in the category of Education. You can check all apps from the developer of Learn SQL and find 107 alternative apps to Learn SQL on Android. Currently this app is for free. This app can be downloaded on Android 4.4+ on APKFab or Google Play. All APK/XAPK files on APKFab.com are original and 100% safe with fast download.
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.
Newly added features:
> Interview Questions
> Complex Queries for practice
> SQL Quiz
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 Arik Kantesaria (190540107099), 6th-semester CE Student. ASWDC is Apps, Software, and Website Development Center @ Darshan University, Rajkot run by students & staff of Computer Science and Engineering Department.
Call us: +91-97277-47317
Write to us: aswdc@darshan.ac.in
Visit: http://www.aswdc.in http://www.darshan.ac.in
Follow us on Facebook: https://www.facebook.com/DarshanUniversity
Follows us on Twitter: https://twitter.com/darshanuniv
Follows us on Instagram: https://www.instagram.com/darshanuniversity/
Newly added features:
> Interview Questions
> Complex Queries for practice
> SQL Quiz
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 Arik Kantesaria (190540107099), 6th-semester CE Student. ASWDC is Apps, Software, and Website Development Center @ Darshan University, Rajkot run by students & staff of Computer Science and Engineering Department.
Call us: +91-97277-47317
Write to us: aswdc@darshan.ac.in
Visit: http://www.aswdc.in http://www.darshan.ac.in
Follow us on Facebook: https://www.facebook.com/DarshanUniversity
Follows us on Twitter: https://twitter.com/darshanuniv
Follows us on Instagram: https://www.instagram.com/darshanuniversity/
learnsql 1.24 Update
Improve Performance
Read More
learnsql Features
Related Videos
Previous Versions
More
Requires Android: Android 4.4+
Architecture: arm64-v8a
Screen DPI: 160-640dpi
SHA1: aa54763871615d5978619b0d3afcab717ec02830
Size: 26.06 MB
What's New:
Improve Performance
Requires Android: Android 4.4+
Architecture: arm64-v8a
Screen DPI: 160-640dpi
SHA1: ec2991c07a55e034f8a06cf2a5914f2a92e8e2dc
Size: 36.41 MB
What's New:
Improve Performance
Requires Android: Android 4.4+
Architecture: arm64-v8a
Screen DPI: 160-640dpi
SHA1: 0fa69d9be415a90a5c12ca22ab5b756cde8ee2f8
Size: 26.03 MB
What's New:
Improve Performance
Requires Android: Android 4.4+
Architecture: arm64-v8a
Screen DPI: 160-640dpi
SHA1: 301c435396799749d55e8a7b3437d0aba7eadf8b
Size: 26.28 MB
What's New:
* Updated UI
* Bugs Fixes
* Bugs Fixes
More Information
Package Name:
Update Date:
2024-03-01
Latest Version:
1.24
Need Update:
Available on:
Requirements:
Android 4.4+
Report:
Safe to Download
APKFab.com and the download link of this app are 100% safe. All download links of apps listed on APKFab.com are from Google Play Store or submitted by users. For the app from Google Play Store, APKFab.com won't modify it in any way. For the app submitted by users, APKFab.com will verify its APK signature safety before release it on our website.