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: mysql valor acumulado union, manual avanzado de sql libros, descarga gratis manual avanzado de sql, connect2sql como se utliz, 4.como se usa la clausula between, sql acumular valor linha anterior, criar tabela com valor default e auto incremento no, tutorial sql avancé, joe.de, clausula in sql avanzado.

Comments and ratings for Advanced SQL

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