Advanced SQL

Advanced SQL

FREE

(3 stars)

(42)


Download for Android

10,000 - 50,000 downloads

Add this app to your lists
View bigger - Advanced SQL for Android screenshot
View bigger - Advanced SQL for Android screenshot
View bigger - Advanced SQL for Android screenshot
View bigger - Advanced SQL for Android screenshot
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 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!

Tags: manual avanzado de sql libros, mysql valor acumulado union, acumular valor em uma coluna no sql, sqlite caracteres especiales comodin, curso avanzado en, union em sql passo a passo, libro de sql de mysql avanzado, curso sql avanzado, o que é wildcards sql, database apps sql.

Comments and ratings for Advanced SQL

  • There aren't any comments yet, be the first to comment!