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: [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
Show Less
