About Advanced SQL
Course of advanced SQL, explained step by step, in 40 lessons:A. - SQL TOP: TOP is used to specify the number of rows to display in the result.2. - SQL Lite: LIKE is used in the WHERE clause to search for a pattern.3. -...
Course of advanced SQL, explained step by step, in 40 lessons:A. - SQL TOP: TOP is used to specify the number of rows to display in the result.2. - SQL Lite: LIKE is used in the WHERE clause to search for a pattern.3. - SQL Wildcards: Wildcards (wildcards) are special characters that are used to perform special searches.4. - SQL IN: IN to select multiple values ​​in a WHERE clause.5. - SQL BETWEEN: BETWEEN is used in the WHERE clause to select values ​​from a range of data.6. - SQL ALIAS is used to rename a table or column.7. - SQL JOINS: JOINs can query data from 2 or more tables.8. - SQL INNER JOIN: INNER JOIN is used to combine each row in a table with each row in another table.9. - SQL LEFT JOIN: LEFT JOIN is used to combine the values ​​of the first table with the values ​​of the second table.10. - SQL RIGHT JOIN: RIGHT JOIN is used to combine the values ​​of the first table with the values ​​of the second table.11. - SQL FULL JOIN: FULL JOIN is used to combine the values ​​of the first table with the values ​​of the second table.12. - SQL UNION: UNION is used to accumulate the results of two SELECT statements.13. - SQL UNION ALL: SQL UNION ALL is used to accumulate the results of two SELECT statements.14. - SQL SELECT INTO: SELECT INTO is used to copy data from one table to another table.15. - SQL CREATE DATABASE: CREATE DATABASE is used to create databases.16. - SQL RESTRICTIONS: Restrictions are used to limit the data type of a column.17. - SQL NOT NULL: NOT NULL is used to specify that a column does not accept NULL.18. - SQL UNIQUE: UNIQUE is used to uniquely identify each row in a table.19. - UNIQUE SQL ALTER TABLE: ALTER TABLE to add UNIQUE UNIQUE to a column of a table, after being created.20. - SQL PRIMARY KEY: PRIMARY KEY is used to uniquely identify each row in a table.21. - SQL FOREIGN KEY: FOREIGN KEY is used to identify a column that is primary key in another table.22. - SQL CHECK: CHECK to limit the range of values ​​in a column.23. - SQL DEFAULT: DEFAULT default value for a column24. - SQL CREATE INDEX: CREATE INDEX to create an index on a table.25. - SQL DROP: DROP serves to remove any item (index, table or database).26. - SQL TRUNCATE: TRUNCATE is used to erase the data (not structure) of a table27. - SQL ALTER: ALTER is used to modify the definition of a column in a table.28. - SQL AUTO INCREMENT: AUTO INCREMENT generating auto-incrementing number for a column in a table.29. - SQL VIEWS: VIEWS serves to create a virtual table (not an actual table) with the results of a query.30. - SQL DATES: DATE defines different data types for dates and times.31. - SQL NULL VALUES: NULL represents an undefined value.32. - FUNCTIONS SQL NULL: NULL FUNCTIONS used to use NULL values.33. - SQL DATA TEXT MySQL: MySQL TEXT DATA defines the different formats of text fields for MySQL.34. - SQL NUMERIC MySQL: MySQL NUMERICAL DATA defines the different formats of numeric fields for MySQL.35. - SQL DATA DATE MySQL: MySQL DATE DATA defines the different formats for date fields MySQL.ADVANCED SQL is a manual very complete.Try it! It's free!
Previous Versions
Here you can find the changelog of Advanced SQL since it was posted on our website on 2013-08-21 15:34:15.
The latest version is 4.0 and it was updated on 2024-04-22 23:18:40. See below the changes in each version.
Advanced SQL version 4.0
Updated At: 2013-02-21
Changes: Several fixes and updates
Advanced SQL version 4.0
Updated At: 2013-02-21
Disclaimer
Official Google Play Link
We do not host Advanced SQL on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by Google and passed their terms and conditions to be listed there. We recommend caution when installing it.
The Google Play link for Advanced SQL is provided to you by apps112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of apps112.com contact us.
