Description

Learn SQL - offline tutorial. Read SQL concepts and Easy tounderstand This App enables reading concepts Offline (without theinternet). Download our App and read it whenever you feel like. Nointernet connection is required. This App lets developers or CSstudents or Engineering students or anyone who is interested inlearning SQL from theory, implementation. If you are a programmerlooking for your first programming job and preparing for codinginterviews, or a student who is preparing for exams about Databaserelated or SQL cases, this app could be a right fit for you All theconcepts are explained easily. There is a favorite option tobookmark your favorites. Also, you can track which concept you readand which are unread Currently, we are covering following topics:SQL Basics SQL Functions SQL Advanced concepts SQL Basic QuestionsSQL Interview Questions Under SQL Basics section following conceptsare covered : SQL Intro SQL Syntax SQL SELECT SQL DISTINCT SQLWHERE SQL AND & OR SQL ORDER BY SQL INSERT SQL UPDATE SQLDELETE Under SQL Advanced following concepts are covered: SQL TopSQL LIKE SQL WILDCARDS SQL IN SQL BETWEEN SQL ALIAS SQL JOIN SQLINNER JOIN SQL LEFT JOIN SQL RIGHT JOIN SQL UNION SQL SELECT INTOSQL CONSTRAINTS SQL NOT NULL CONSTRAINT SQL UNIQUE CONSTRAINT SQLPRIMARY KEY CONSTRAINT SQL FOREIGN KEY CONSTRAINT SQL CHECK SQLDEFAULT SQL CREATE INDEX SQL DROP SQL ALTER SQL INCREMENT SQL VIEWSSQL DATES SQL NULL SQL ISNULL SQL DATA TYPES Under SQL Functionssection following concepts are covered: SQL avg() SQL count() SQLfirst() SQL last() SQL max() SQL min() SQL sum() SQL Group By SQLHaving SQL ucase() SQL lcase() SQL mid() SQL len() SQL round() SQLnow() SQL format() SQL Quick Reference SQL Hosting SQL BasicInterview Questions Section: At present we have added the 22interview questions. 1 What is a primary key? 2 What is a foreignkey? 3 What is view in SQL? 4 What is an Index in SQL? 5 What isClustered Index in SQl? 6 What is NonClustered Index in SQL? 7 Whatis the difference between clustered and non clustered index in SQL?8 Is it possible to sort a column using a column alias? 9 What isthe difference between BETWEEN and IN condition operators? 10 Whatis the difference between DELETE and TRUNCATE statement in SQL? 11What is the difference among NULL value, zero and blank space? 12What is subquery? 13 What are the types of subquery? 14 What is astored procedure? 15 What is Auto Increment? 16 What is Self-Join?17 What is user defined functions? 18 What are all types of userdefined functions? 19 What is collation? 20 Advantages andDisadvantages of Stored Procedure? 21 What is Union, minus andInteract commands? 22 What are the types of join and explain each?SQL Interview Questions Section: At present we have added the 38interview questions. For these questions please check in our app Ifyou want us to add any new topics please Write to Us using the"Feedback/Suggestions" option in our App. Learn SQL concepts in avery easy way without connecting to the internet is the mainobjective. We will also add the SQL interview questions in our nextupdate. Please stay tuned for the next update