Total: 67327 apps , New today: 0 , Updated today: 0 Sign in with a Google Account


Home  »  Books & Reference  »  Advanced SQL

Advanced SQL image

Advanced SQL - FREE

by Android mob, Version: 4.0 , 91 KB  

Package name: sql.com.sql_avanzado , Last Update: 2013-06-11 00:10:41


14 ratings (3.071 average)

10,000-50,000 downloads


What's new in this version (4.0):

Description

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!

Advanced SQL screenshot 1

Apps from the same developer

Bluetooth CHAT This application allows two Android devices in a conversation via Bluetooth. It also allows searching for other pho ...
Paint This game lets you draw, color and paint with different colors, textured paint, faded paint, spray p ...
Painting Game This game allows finger painting with different colors, textured paint, faded paint, spray paint, cl ...
Paint game Paint is a fun game to paint and draw. Enjoys painting on the screen of your mobile phone with your fingers. T ...
Money This program helps you calculate your mortgage payments or loans by the amount and interest rate.

Related Android Apps

tWareki This is software that converts the Japanese era to the Gregorian calendar year.
MySci Pubs Get the best knowledge in the agronomy, crop, and soil sciences. Search thousands of peer-reviewed j ...
American Idioms and Verbs American Idioms and Phrasal Verbs with 24,000 entries and 27,000 senses.
Spanish Criminal Procedure Law Spanish Criminal Procedure Law, version 2011-10-11 (spanish language).   For lawyers, ...
Arie Baal Guf אריה בעל גוף The book "Arie Baal Guf" by Hayim Nahman Bialik


Find more Android apps and games

Androlicious.com is a website that shows applications and games from Android Market. You can download and install apps and games directly from Android Market using an Android phone or by using WebConnect mobile application.