Learn SQL - Offline Tutorial

by ONAN Mobile Software

free


not available



Learn SQL - offline tutorial. Read SQL concepts and Easy to understandThis App enables reading concepts Offline (without the internet). Download our App and read it whenever you feel like. No internet connection is required.
This App lets developers or CS students or Engineering students or anyone who is interested in learning SQL from theory, implementation. If you are a programmer looking for your first programming job and preparing for coding interviews, or a student who is preparing for exams about Database related or SQL cases, this app could be a right fit for you
All the concepts are explained easily.
There is a favorite option to bookmark your favorites. Also, you can track which concept you read and which are unread
Currently, we are covering following topics:
SQL Basics SQL Functions SQL Advanced concepts
Under SQL Basics section following concepts are covered :
SQL IntroSQL SyntaxSQL SELECTSQL DISTINCTSQL WHERESQL AND & ORSQL ORDER BYSQL INSERTSQL UPDATESQL DELETE
Under SQL Advanced following concepts are covered:
SQL TopSQL LIKESQL WILDCARDSSQL INSQL BETWEENSQL ALIASSQL JOINSQL INNER JOINSQL LEFT JOINSQL RIGHT JOINSQL UNIONSQL SELECT INTOSQL CONSTRAINTSSQL NOT NULL CONSTRAINTSQL UNIQUE CONSTRAINTSQL PRIMARY KEY CONSTRAINTSQL FOREIGN KEY CONSTRAINTSQL CHECKSQL DEFAULTSQL CREATE INDEXSQL DROPSQL ALTERSQL INCREMENTSQL VIEWSSQL DATESSQL NULLSQL ISNULLSQL DATA TYPES
Under SQL Functions section following concepts are covered:
SQL avg()SQL count()SQL first()SQL last()SQL max()SQL min()SQL sum()SQL Group BySQL HavingSQL ucase()SQL lcase()SQL mid()SQL len()SQL round()SQL now()SQL format()SQL Quick ReferenceSQL Hosting
If you want us to add any new topics please Write to Us using the "Feedback/Suggestions" option in our App.
Learn SQL concepts in a very easy way without connecting to the internet is the main objective. We will also add the SQL interview questions in our next update. Please stay tuned for the next update