SQL

1. W3Schools

1.1. skipanir

1.1.1. SELECT

1.1.1.1. SELECT DISTINCT

1.1.1.2. SELECT TOP

1.1.1.3. SELECT INTO

1.1.2. FROM

1.1.2.1. VIEWS

1.1.2.2. JOIN

1.1.2.2.1. INNER JOIN

1.1.2.2.2. LEFT OUTER JOIN

1.1.2.2.3. RIGHT OUTER JOIN

1.1.2.2.4. FULL OUTER JOIN

1.1.3. GROUP BY

1.1.4. WHERE

1.1.4.1. LIKE

1.1.4.2. BETWEEN

1.1.4.3. AND

1.1.4.4. OR

1.1.4.5. IN

1.1.4.6. EXISTS

1.1.5. COUNT

1.1.6. ORDER BY

1.1.7. HAVING

1.1.8. INSERT INTO

1.1.8.1. INSERT INTO SELECT

1.1.9. UPDATE

1.1.10. DELETE

1.1.11. AS (Aliases)

1.1.12. UNION

1.1.13. CREATE

1.1.13.1. CREATE database

1.1.13.2. CREATE table

1.1.13.3. auto increment

1.1.13.4. CREATE VIEW

1.1.13.5. constraints

1.1.13.5.1. NOT NULL

1.1.13.5.2. UNIQUE

1.1.13.5.3. PRIMARY KEY

1.1.13.5.4. FOREIGN KEY

1.1.13.5.5. CHEACK

1.1.13.5.6. DEFAULT

1.1.14. CREATE INDEX

1.1.15. DROP

1.1.16. ALTER

1.1.17. aðgerðir

1.1.17.1. AVG

1.1.17.2. COUNT

1.1.17.3. FIRST

1.1.17.4. LAST

1.1.17.5. MAX

1.1.17.6. MIN

1.1.17.7. SUM

1.1.17.8. UCASE

1.1.17.9. LCASE

1.1.17.10. MID

1.1.17.11. LEN

1.1.17.12. ROUND

1.1.17.13. NOW

1.1.17.14. FORMAT

1.2. Subqueries

1.3. Uppbygging á SQL skipununum (syntax)

1.4. Hvað er SQL

1.5. injection

1.6. wildcards

1.7. dates

1.8. NULL

1.8.1. NULL functions

1.8.2. NULL values

1.9. data týpur

1.9.1. general

1.9.2. database

1.10. próf

1.11. Quick reference

2. SQLCourse.com

2.1. SQLCourse01

2.1.1. Hvað er SQL

2.1.2. Table basics

2.1.3. SELECT

2.1.4. CREATE

2.1.5. INSERT

2.1.6. UPDATE

2.1.7. DELETE

2.1.8. DROP

2.2. SQLCourse02

2.2.1. Kynning

2.2.2. SELECT

2.2.3. aggregat function

2.2.4. GROUP BY

2.2.5. HAVING

2.2.6. ORDER BY

2.2.7. Boolean

2.2.8. IN & BETWEEN

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

2.2.10. joins

2.2.11. SQL interpreter

3. Greinar

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

4. Útskýringarmyndbönd á Íslensku

4.1. skipanir/hugtök

4.1.1. SELECT

4.1.2. FROM

4.1.2.1. INNER JOIN

4.1.2.2. VIEWS

4.1.2.3. LEFT OUTER JOIN

4.1.3. GROUP BY

4.1.4. WHERE

4.1.4.1. LIKE

4.1.4.2. BETWEEN

4.1.4.3. AND

4.1.4.4. OR

4.1.4.5. IN

4.1.4.6. EXISTS

4.1.5. ORDER BY

4.1.6. HAVING

4.1.7. Subqueries

4.1.8. INSERT INTO

4.1.9. CREATE table

4.1.10. functions

4.1.10.1. COUNT, SUM, MAX, MIN, AVG

5. The New Boston Education (myndbönd)

5.1. Kynning á SQL - 01

5.2. Setja upp SQL server - 02

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

5.4. SHOW og SELECT - 04

5.5. Grunnreglur í SQL - 05

5.6. Vinna með marga dálka - 06

5.7. DISTINCT og LIMIT - 07

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

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

5.10. WHERE - 10

5.11. AND og OR - 11

5.12. IN og NOT IN - 12

5.13. LIKE - 13

5.14. LIKE framhald - 14

5.15. CONCAT og AS - 15

5.16. Regular Expressions - 16

5.17. functions - 17

5.18. Aggregate Functions - 18

5.19. GROUP BY - 19

5.20. subqueires - 20

5.21. Meira um subqueires - 21

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

5.23. OUTER JOIN - 23

5.24. UNION - 24

5.25. Full-text searching - 25

5.26. INSERT INTO - 26

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

5.28. UPDATE og DELETE - 28

5.29. CREATE TABLE - 29

5.30. NOT NULL og Auto increment - 30

5.31. ALTER, DROP og RENAME table

5.32. VIEWS

5.33. Lokamyndbandið