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 column
24. 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 table
27. SQL ALTER: ALTER is used to modify the definition of a column in a table.
28. SQL AUTO INCREMENT: AUTO INCREMENT generating autoincrementing 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 It39;s free