Learn SQL APK

Version 1.4 - com.aswdc_dbms
Last updated: 2019-08-17 17:16:36
aswdc_dbms,education,learn

Learn SQL - Structured Query Language (SQL) with Queries and Examples

Learn SQL apk

APP Information

App Download Version1.4 (5)
Updated2019-08-17 17:16:36
Apk Size5.11 MB
App DeveloperDarshan Institute of Engineering & Technology
Malware CheckTRUSTED
Install on Android4.1.x and up
App Packagecom.aswdc_dbms.apk
MD5551d144065fd5fa4680caa623c5901fe
Rate0
Websitehttp://www.darshan.ac.in/DIET

Download Learn SQL 1.4 APK

App Description

Learn SQL is aswdc_dbms,education,learn, content rating is Everyone (PEGI-3). This app is rated 0 by 0 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.1.x and higher Android devices. The Latest Version of 1.4 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 Learn SQL APK Mirror. This app APK has been downloaded 2+ 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.

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

App Screens

Learn SQL Screenshot 1Learn SQL Screenshot 2Learn SQL Screenshot 3Learn SQL Screenshot 4Learn SQL Screenshot 5Learn SQL Screenshot 6Learn SQL Screenshot 7Learn SQL Screenshot 8Learn SQL Screenshot 9Learn SQL Screenshot 10

Apk scan results

Apk Scaned By TotalVirus Antivirus,com.aswdc_dbms.apk Was Pure And Safe.
Scan Stats:failure:0|harmless:0|malicious:0|suspicious:0|timeout:0|type-unsupported:11|undetected:60|
Name:9D4AfE5sX2gPWzo_zs9-20190725-40089-azj7cp
SHA-1:e30dfa7207c0ad960e9a4a9edaf7045b8f3546ee
SHA-256:0c5c6f2c251de570a3708b7d0cdd437010d70f8d17d5d9441a1bbee831c659ef
SSDEEP:98304:jmkZ8BMhe4ecdx3htSG3sZkOwLXdF+t5u5A0HlF8AV/OLdr74FvkchiOmm10S:jmE5neu3DSG3dOtg5AKFdtOLJodhiQ
File type:Android
Magic:Zip archive data
File size:5355091
Uncompressed Size:11056311
Contained Files	:681
Contained Files By Type:MF:1,RSA:1,SF:1,db:1,dex:1,gz:1,jpg:1,png:330,ttf:1,xml:282,

Permissions

requires following permissions on your android device.

android.permission.ACCESS_NETWORK_STATE
android.permission.INTERNET
android.permission.WAKE_LOCK
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.

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.

Certificate

Certificate Issuer:C:91, CN:Darshan Institute of engineering and technology, L:Rajkot, O:Darshan Institute of engineering and technology, ST:Gujarat, OU:Computer Department
Certificate Subject:C:91, CN:Darshan Institute of engineering and technology, L:Rajkot, O:Darshan Institute of engineering and technology, ST:Gujarat, OU:Computer Department

Activities

aswdc_dbms.com.dbms.design.activity.ActivitySplash
aswdc_dbms.com.dbms.design.activity.ActivityCategoryList
aswdc_dbms.com.dbms.design.activity.ActivityTopicsList
aswdc_dbms.com.dbms.design.activity.ActivityWebView
aswdc_dbms.com.dbms.design.activity.ActivityFavoriteList
aswdc_dbms.com.dbms.design.activity.DeveloperActivity
aswdc_dbms.com.dbms.design.activity.ActivityFeedback
com.google.android.gms.ads.AdActivity
com.google.android.gms.common.api.GoogleApiActivity

Providers

com.crashlytics.android.CrashlyticsInitProvider
com.google.android.gms.ads.MobileAdsInitProvider
com.google.firebase.provider.FirebaseInitProvider

Services

com.google.android.gms.measurement.AppMeasurementService
com.google.android.gms.measurement.AppMeasurementJobService
com.google.firebase.components.ComponentDiscoveryService

Receivers

com.google.android.gms.measurement.AppMeasurementReceiver
com.google.android.gms.measurement.AppMeasurementInstallReferrerReceiver
com.google.firebase.iid.FirebaseInstanceIdReceiver

Interesting Strings

http://
http://localhost/
http://schemas.android.com/apk/res-auto
http://schemas.android.com/apk/res/android
http://www.darshan.ac.in
http://www.darshan.ac.in/DIET/ASWDC-Mobile-Apps/Privacy-Policy-General
http://www.example.com
http://www.google.com
https://
https://adservice.google.com/getconfig/pubvendors
https://app-measurement.com/a
https://csi.gstatic.com/csi
https://e.crashlytics.com/spi/v2/events
https://google.com/search?
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/native_ads.html
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/production/mraid/v3/mraid_app_banner.js
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/production/mraid/v3/mraid_app_expanded_banner.js
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/production/mraid/v3/mraid_app_interstitial.js
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/production/native_ads.js
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/production/sdk-core-v40-impl.html
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/production/sdk-core-v40-impl.js
https://googleads.g.doubleclick.net/mads/static/mad/sdk/native/sdk-core-v40-loader.html
https://imasdk.googleapis.com/admob/sdkloader/native_video.html
https://pagead2.googlesyndication.com/pagead/gen_204?id=gmob-apps
https://plus.google.com/
https://settings.crashlytics.com/spi/v2/platforms/android/apps/%s/settings
https://support.google.com/dfp_premium/answer/7160685#push
https://www.example.com
https://www.facebook.com/DarshanInstitute.Official
https://www.google.com
https://www.google.com/dfp/debugSignals
https://www.google.com/dfp/inAppPreview
https://www.google.com/dfp/linkDevice
https://www.google.com/dfp/sendDebugData
https://www.googleadservices.com/pagead/conversion/app/deeplink?id_type=adid&sdk_version=%s&rdid=%s&bundleid=%s
https://www.googleapis.com/auth/appstate
https://www.googleapis.com/auth/datastoremobile
https://www.googleapis.com/auth/drive
https://www.googleapis.com/auth/drive.appdata
https://www.googleapis.com/auth/drive.apps
https://www.googleapis.com/auth/drive.file
https://www.googleapis.com/auth/fitness.activity.read
https://www.googleapis.com/auth/fitness.activity.write
https://www.googleapis.com/auth/fitness.blood_glucose.read
https://www.googleapis.com/auth/fitness.blood_glucose.write
https://www.googleapis.com/auth/fitness.blood_pressure.read
https://www.googleapis.com/auth/fitness.blood_pressure.write
https://www.googleapis.com/auth/fitness.body.read
https://www.googleapis.com/auth/fitness.body.write
https://www.googleapis.com/auth/fitness.body_temperature.read
https://www.googleapis.com/auth/fitness.body_temperature.write
https://www.googleapis.com/auth/fitness.location.read
https://www.googleapis.com/auth/fitness.location.write
https://www.googleapis.com/auth/fitness.nutrition.read
https://www.googleapis.com/auth/fitness.nutrition.write
https://www.googleapis.com/auth/fitness.oxygen_saturation.read
https://www.googleapis.com/auth/fitness.oxygen_saturation.write
https://www.googleapis.com/auth/fitness.reproductive_health.read
https://www.googleapis.com/auth/fitness.reproductive_health.write
https://www.googleapis.com/auth/games
https://www.googleapis.com/auth/games.firstparty
https://www.googleapis.com/auth/games_lite
https://www.googleapis.com/auth/plus.login
https://www.googleapis.com/auth/plus.me

Older Versions

More Android Apps to Consider

Duolingo: Learn Languages Free
Learn English, Spanish, French, German, Italian and more languages for free..
SayHi Translate
Have a conversation in two languages and hear your voice translated instantly..
Hello English: Learn English
Free Spoken English App. Learn English speaking, reading, writing..
Learn Computer Repairing
Learn Basics about the computer Repairing.
Piano Chords, Scales, Progression Companion PRO
Find chord or music scale with couple touches. It's chord progression builder..
ISS Detector Satellite Tracker
See the International Space Station fly by..
Kids Launcher ( Kids Mode, Parental Control,No ad)
A cartoon safe interface for children with parental control..
Lumosity: #1 Brain Games & Cognitive Training App
Lumosity is the world's most popular brain training program..
Дорожные знаки 2017 Украина
Version 1.5 - com.vokrab.signsukraineexamlight.
Bass Guitar Tutor Pro
Version Love of Money - com.veitch.learntomaster.bgtp.