Kom i gang. Det er Gratis
eller tilmeld med din email adresse
SQL af Mind Map: SQL

1. Greinar

1.1. 10 mistök sem gott er að forðast í gerð gagnagrunna.

2. W3Schools

2.1. skipanir

2.1.1. SELECT

2.1.1.1. SELECT DISTINCT

2.1.1.2. SELECT TOP

2.1.1.3. SELECT INTO

2.1.2. FROM

2.1.2.1. VIEWS

2.1.2.2. JOIN

2.1.2.2.1. INNER JOIN

2.1.2.2.2. LEFT OUTER JOIN

2.1.2.2.3. RIGHT OUTER JOIN

2.1.2.2.4. FULL OUTER JOIN

2.1.3. GROUP BY

2.1.4. WHERE

2.1.4.1. LIKE

2.1.4.2. BETWEEN

2.1.4.3. AND

2.1.4.4. OR

2.1.4.5. IN

2.1.4.6. EXISTS

2.1.5. COUNT

2.1.6. ORDER BY

2.1.7. HAVING

2.1.8. INSERT INTO

2.1.8.1. INSERT INTO SELECT

2.1.9. UPDATE

2.1.10. DELETE

2.1.11. AS (Aliases)

2.1.12. UNION

2.1.13. CREATE

2.1.13.1. CREATE database

2.1.13.2. CREATE table

2.1.13.3. auto increment

2.1.13.4. CREATE VIEW

2.1.13.5. constraints

2.1.13.5.1. NOT NULL

2.1.13.5.2. UNIQUE

2.1.13.5.3. PRIMARY KEY

2.1.13.5.4. FOREIGN KEY

2.1.13.5.5. CHEACK

2.1.13.5.6. DEFAULT

2.1.14. CREATE INDEX

2.1.15. DROP

2.1.16. ALTER

2.1.17. aðgerðir

2.1.17.1. AVG

2.1.17.2. COUNT

2.1.17.3. FIRST

2.1.17.4. LAST

2.1.17.5. MAX

2.1.17.6. MIN

2.1.17.7. SUM

2.1.17.8. UCASE

2.1.17.9. LCASE

2.1.17.10. MID

2.1.17.11. LEN

2.1.17.12. ROUND

2.1.17.13. NOW

2.1.17.14. FORMAT

2.2. Subqueries

2.3. Uppbygging á SQL skipununum (syntax)

2.4. Hvað er SQL

2.5. injection

2.6. wildcards

2.7. dates

2.8. NULL

2.8.1. NULL functions

2.8.2. NULL values

2.9. data týpur

2.9.1. general

2.9.2. database

2.10. próf

2.11. Quick reference

3. Útskýringarmyndbönd á Íslensku

3.1. skipanir/hugtök

3.1.1. SELECT

3.1.2. FROM

3.1.2.1. INNER JOIN

3.1.2.2. VIEWS

3.1.2.3. LEFT OUTER JOIN

3.1.3. GROUP BY

3.1.4. WHERE

3.1.4.1. LIKE

3.1.4.2. BETWEEN

3.1.4.3. AND

3.1.4.4. OR

3.1.4.5. IN

3.1.4.6. EXISTS

3.1.5. ORDER BY

3.1.6. HAVING

3.1.7. Subqueries

3.1.8. INSERT INTO

3.1.9. CREATE table

3.1.10. functions

3.1.10.1. COUNT, SUM, MAX, MIN, AVG

4. The New Boston Education (myndbönd)

4.1. Kynning á SQL - 01

4.2. Setja upp SQL server - 02

4.3. CREATE database (ekki gagnleg aðferð) og import töflur - 03

4.4. SHOW og SELECT - 04

4.5. Grunnreglur í SQL - 05

4.6. Vinna með marga dálka - 06

4.7. DISTINCT og LIMIT - 07

4.8. Fullt nafn á dálkum og ORDER BY - 08

4.9. ORDER BY og í hvaða röð á að raða

4.10. WHERE - 10

4.11. AND og OR - 11

4.12. IN og NOT IN - 12

4.13. LIKE - 13

4.14. LIKE framhald - 14

4.15. CONCAT og AS - 15

4.16. Regular Expressions - 16

4.17. functions - 17

4.18. Aggregate Functions - 18

4.19. GROUP BY - 19

4.20. subqueires - 20

4.21. Meira um subqueires - 21

4.22. Tengja töflur saman með WHERE (ekki góð aðferð) - 22

4.23. OUTER JOIN - 23

4.24. UNION - 24

4.25. Full-text searching - 25

4.26. INSERT INTO - 26

4.27. INSERT INTO setja margar raðir inn í einu - 27

4.28. UPDATE og DELETE - 28

4.29. CREATE TABLE - 29

4.30. NOT NULL og Auto increment - 30

4.31. ALTER, DROP og RENAME table

4.32. VIEWS

4.33. Lokamyndbandið

5. SQLCourse.com

5.1. SQLCourse01

5.1.1. Hvað er SQL

5.1.2. Table basics

5.1.3. SELECT

5.1.4. CREATE

5.1.5. INSERT

5.1.6. UPDATE

5.1.7. DELETE

5.1.8. DROP

5.2. SQLCourse02

5.2.1. Kynning

5.2.2. SELECT

5.2.3. aggregat function

5.2.4. GROUP BY

5.2.5. HAVING

5.2.6. ORDER BY

5.2.7. Boolean

5.2.8. IN & BETWEEN

5.2.9. stærðfræðiaðgerðir

5.2.10. joins

5.2.11. SQL interpreter