Learn SQL APK

Version 1.11 - com.aswdc_dbms
Last updated: 2020-06-26
aswdc_dbms,education,learn

Learn SQL apk

APP Information

Download Version 1.11 (12)
Apk Size5.70 MB
App DeveloperDarshan Institute of Engineering & Technology
Malware CheckTRUSTED
Install on Android4.4.x and up
App Packagecom.aswdc_dbms.apk
MD538b11eb3864c880773a27867e4bb77f7
Rate5
Website http://www.darshan.ac.in/DIET

Download Learn SQL 1.11 APK

App Description

Learn SQL is aswdc_dbms,education,learn, content rating is Everyone (PEGI-3). This app is rated 5 by 1 users who are using this app. To know more about the company/developer, visit Darshan Institute of Engineering & Technology website who developed it. com.aswdc_dbms.apk apps can be downloaded and installed on Android 4.4.x and higher Android devices. The Latest Version of 1.11 Available for download. Download the app using your favorite browser and click Install to install the application. Please note that we provide both basic and pure APK files and faster download speeds than APK Mirror. This app APK has been downloaded 21+ times on store. You can also download com.aswdc_dbms APK and run it with the popular Android Emulators.

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 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
 

App ChangeLog

  • - Added Interview Questions
  • - Added Complex Queries
  • - Added Quiz

App Screens

Learn SQL App Screen 1Learn SQL App Screen 2Learn SQL App Screen 3Learn SQL App Screen 4Learn SQL App Screen 5Learn SQL App Screen 6Learn SQL App Screen 7Learn SQL App Screen 8Learn SQL App Screen 9Learn SQL App Screen 10Learn SQL App Screen 11Learn SQL App Screen 12Learn SQL App Screen 13Learn SQL App Screen 14Learn SQL App Screen 15Learn SQL App Screen 16

Permissions

requires following permissions on your android device.

android.permission.ACCESS_NETWORK_STATE
android.permission.INTERNET
android.permission.WAKE_LOCK
android.permission.WRITE_EXTERNAL_STORAGE
com.google.android.c2dm.permission.RECEIVE
com.google.android.finsky.permission.BIND_GET_INSTALL_REFERRER_SERVICE
android.hardware.faketouch
android.hardware.screen.portrait
view network connections
Allows the app to view information about network connections such as which networks exist and are connected.

full network access
Allows the app to create network sockets and use custom network protocols. The browser and other applications provide means to send data to the internet, so this permission is not required to send data to the internet.

prevent phone from sleeping
Allows the app to prevent the phone from going to sleep.

modify or delete the contents of your SD card
Allows the app to write to the SD card.

receive data from Internet
Allows apps to accept cloud to device messages sent by the app's service. Using this service will incur data usage. Malicious apps could cause excess data usage.

Older Versions

More Android Apps to Consider

Google Play Reviews

  1. Mihir Chakma-avatar

    New update is very bad. Didn't support my device. Please, fix it immediately.

  2. newuser_123-avatar

    great app to learn sql without browsing!

  3. Allison Garza-avatar

    Worked for a few weeks. Now, it only crashes whenever I try to use it.

  4. Dilip Dholakiya-avatar

    Dilip Dholakiya

    2020-03-09T06:06:06.848Z

    Superup app to learn sql from scratch

  5. Umesh Thoriya-avatar

    Amazing app to learn SQL

  6. Praveen Rathinavel-avatar

    Praveen Rathinavel

    2020-03-17T02:37:46.132Z

    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.

  7. David McMonagle-avatar

    David McMonagle

    2019-09-26T06:05:05.166Z

    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.

  8. Afsar Ahmed-avatar

    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.

  9. Shalini shalini-avatar

    Shalini shalini

    2020-01-13T05:06:42.658Z

    Please fix, app always crash and my mobile hanging down.

  10. Dhruv Shingala-avatar

    A concept is too good. And a very useful app for the begginers to learn the basics of SQL.

  11. Rob Kohutek-avatar

    This is a great tool for beginners to learn SQL and is a good refresher for those who are rusty.

  12. Ankur Kaneriya-avatar

    Easy to learn sql also handy app for sql basic & advance topic, also include SQL Tool Setup. App work smoothly on Android Pie (9.1). Thanks ASWDC Developer team

  13. Manmath Bagali-avatar

    In the description it doesn't say that it contains ads. But the app shows ads. Otherwise a good app.

  14. Meghna Biswas-avatar

    Amazing app for a beginner trying to learn sql.. every step is given clearly concept-wise..

  15. Krupesh Bhatgaonkar-avatar

    Krupesh Bhatgaonkar

    2019-10-29T10:30:20.691Z

    I didn't like because only theory part is given not practical part is given for SQL.

  16. asalam khan-avatar

    It's a good app for basic and advanced to learnt

  17. Mayur Padia-avatar

    Very nice app to learn basics of SQL.

  18. Mital Vadolia-avatar

    nice and easy app to learn sql good work

  19. A Google user-avatar

    Best and Useful app to learn SQL

  20. Vasudev Ratanpara-avatar

    Vasudev Ratanpara

    2019-03-30T01:35:35.730Z

    One of the best app for learning sql

  21. mohil trambadiya-avatar

    mohil trambadiya

    2019-03-29T12:54:52.556Z

    Excellent app for... Learning SQL

  22. Aman Vadagama-avatar

    extreamly amazing app to learn SQL.

  23. Bhagyesh Aghera-avatar

    Bhagyesh Aghera

    2019-03-29T04:31:21.418Z

    best app for learn SQL data query...

  24. Naimish Patel-avatar

    very good app to learn sql

  25. firoz sherasiya-avatar

    firoz sherasiya

    2019-03-31T12:24:39.610Z

    superup app to learn sql with example

  26. muder k-avatar

    V. Nice app to understand the command's basics.

  27. M.K. PATEL-avatar

    its awesome app for learning SQL 👌

  28. Remish Varsani-avatar

    Good App For interview

  29. ayushi ghoniya-avatar

    Nice app for learn SQL

  30. Masti Unlimited-avatar

    Masti Unlimited

    2019-04-03T05:38:43.627Z

    best to learn query and more very helpful app for education.

  31. VASOYA CHINTAN-avatar

    Nice app learn for SQL.

  32. Sai Diesel-avatar

    It helps me a lot in interview

  33. Arjun Bala-avatar

    best app to learn SQL👌

  34. site holders-avatar

    best app to crash interview

  35. Ashik Reji-avatar

    Really awesome app.

  36. Pandya Vatsal-avatar

    best app for learning

  37. Dhaval Vadgama-avatar

    useful app... very nice

  38. Parag Sanchaniya-avatar

    Parag Sanchaniya

    2019-04-03T05:36:23.651Z

    best way to learn SQL

  39. Sharbudin-avatar

    Good learning app

  40. Aditya Parmar-avatar

    very good app.

  41. Cabdiraxmaan Khaliif Tahliil-avatar

    Cabdiraxmaan Khaliif Tahliil

    2019-07-18T07:10:42.814Z

    you can learn database easily

  42. Bhavana Sanchaniya-avatar

    Bhavana Sanchaniya

    2019-04-04T13:16:11.826Z

    very useful app

  43. Muhsin Salam-avatar

    saved my time!

  44. Joshi Kaushik-avatar

    Nice app for computer engineering students

  45. Aryan Dodiya-avatar

    best learning app.

  46. Shubh`s Space-avatar

    very interesting app

  47. jayesh vagadiya-avatar

    jayesh vagadiya

    2019-04-02T14:00:05.198Z

    very good app

  48. manoj kagadiya-avatar

    Nice application

  49. Parag Sanchaniya-avatar

    Parag Sanchaniya

    2019-05-24T14:13:54.873Z

    best app

  50. Vimal Gajjar-avatar

    good app

  51. Kunjan Vadgama-avatar

    Amazing app

  52. A Google user-avatar

    best app.....

  53. vinod sanchaiya-avatar

    vinod sanchaiya

    2019-03-29T09:27:07.960Z

    nice app

  54. A Google user-avatar

    amazing app

  55. A Google user-avatar

    very useful

  56. VINODBHAI SANCHANIYA-avatar

    VINODBHAI SANCHANIYA

    2019-08-03T07:49:33.233Z

    amazing app

  57. shubh patel-avatar

    nice app