Learn SQL Programming vs Excel formulas

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 Ayushi Ghoniya (160540107048), 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

Move from reading a function to understanding how its inputs affect a result. Excel formulas combines illustrated spreadsheet lessons, an editable formula playground and a chart workspace with tools that help you return to your studies. A reference you can explore at your own pace Start with logical, text or mathematical functions, or follow topics such as dates, lookups and statistical summaries. Fourteen function families also include financial, database, engineering, information, compatibility, cube, web and add-in lessons. Browse a category or search by a function name, a use case or an interview question. Each formula lesson presents an explanation and syntax with examples. Previous and Next controls let you move through a topic without returning to the list. Save a formula for later and mark a lesson complete when you have reviewed it. The reference topics explain spreadsheet functionality; they do not imply that every function can run inside the practice grid. Learn by changing the inputs Use Formula Playground to edit values in a small worksheet and enter a supported expression. Its result display responds as the formula or grid changes, making it easier to compare the calculation with the example you are reading. Where a lesson offers Try It, open the selected example with its formula and sample data already prepared. The quick input toolbar provides formula symbols for mobile typing. Practice with conditions, totals, averages and cell ranges, then use the lesson to check what each argument means. The playground implements a selection of functions and serves as a focused learning workspace. Create a visual from your data Enter labels and numeric series in the chart worksheet, adjust its rows and columns and give the chart a title. Select from column, bar, line, area, pie, doughnut, scatter and radar styles. The preview shows both the chart and the source data table, so you can review what you entered before exporting. Save the chart as a PNG image, create a PDF or share an image using your device's sharing options. Keep an illustration from a study exercise or share a comparison with another learner. Keep track of what you study Home brings together a daily formula, saved lessons and recently viewed items. Continue learning returns you to the formula you were studying. Marking lessons complete updates category progress and the beginner, intermediate and advanced paths in the Learning Hub. The daily formula also contributes to a learning streak and a 30-day challenge. Enable the optional daily reminder if you would like a prompt to study, subject to notification permission. Favorites and progress are kept locally on your device, letting the app remember your learning activity between sessions. More ways to review Use keyboard shortcut references, practical tips and interview questions with answers to support your preparation. Timed quizzes offer Bronze, Silver, Gold and Diamond levels, results and attempt history. Reach the required score for a level to unlock an in-app certificate that can be saved or shared. These certificates record app practice and are not professional accreditation. Choose a light, dark or system theme. Designed for students, independent learners and people revising spreadsheet skills for work, the app supports both quick reference visits and longer practice sessions. It contains advertising. Excel formulas is independently developed and is not affiliated with or endorsed by Microsoft.