Learn SQL
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: [email protected]
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
Category : Education
Reviews (28)
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.
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.
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.
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.
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....
In the description it doesn't say that it contains ads. But the app shows ads. Otherwise a good app.
Every 5 seconds there is an ad for 5sec. I mean I can't study for more than 5 sec then what is the use of this app. Such a waste of time.
A concept is too good. And a very useful app for the begginers to learn the basics of SQL.
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
This is a great tool for beginners to learn SQL and is a good refresher for those who are rusty.
It is a very good application to learn sql. All topic cover in aplication like identity insert on off, cartisian join , Commit/rollback
New update is very bad. Didn't support my device. Please, fix it immediately.
Keeps crashing. Not able to use it at all even once.
Cannot open the menu and keep force closed using latest app. Can u help to check?
Amazing app for a beginner trying to learn sql.. every step is given clearly concept-wise..
Worked for a few weeks. Now, it only crashes whenever I try to use it.
Too much ads, i have 2 options either i watch ads or learn SQL but i choose DROP APP Learn SQL;
Best app to learn SQL and from scratch to advance and to practice for complex query
best to learn query and more very helpful app for education.
More ads ..it wont allow to. Read content
Thank You Senior.... This App Is Very Usefull For Juniors Like Me.... Love From DIETā¤....
Very nice app to learn basics of SQL.
Useful app, and thi app is very easy to learn SQL
It's a good app for basic and advanced to learnt
I didn't like because only theory part is given not practical part is given for SQL.
best way to learn SQL
extreamly amazing app to learn SQL.
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