SQL Queries, English version
This course introduces us to the world of SQL queries. We will learn all the important and needed keywords like SELECT, FROM, WHERE, JOIN, GROUP BY, HAVING and so on.
-
1. SQL Server Express installation
Betekintés ingyen
-
2. Installation of the AdventureWorks database
Betekintés ingyen
-
3. Discovering of the query window
Betekintés ingyen
- 4. The most simple SQL Select queries in the world
- 5. How old are we? Let's do some math with the date functions
- 6. Our first queries on theAdventureWorks database
- 7. The use of the Query Designer for the creation of queries
- 8. The Select * from table command
- 9. Querying unique fields with Select
- 10. Combining some Strings
- 11. The LEFT() function
- 12. The CHARINDEX() function
- 13. The REVERSE() function
- 14. The DATEPART() function
- 15. The use of the Where condition in an SQL Select
- 16. Those problematic empty fields, the NULL values!
- 17. The ISNULL() function
- 18. Searching for a text based on textparts: the LIKE keyword
- 19. Smaller? Larger? The additional options of the Where condition.
- 20. Belonging to a list: the IN keyword
- 21. Borders: the BETWEEN keyword
- 22. The DISTINCT keyword
- 23. Sorting with the ORDER BY operation
- 24. Summaries with the aggregate functions
- 25. Grouping lines with the GROUP BY operation
- 26. Filtering groups with the use of the HAVING keyword
- 27. INNER JOIN query on a new testdatabase (with dogs)
- 28. OUTER JOIN for querying missing pairs
- 29. Filtering out alone standing lines with the WHERE condition from an OUTER JOIN
- 30. Embedded queries, correlated subquery
- 31. Everything with everything! The CROSS JOIN
- 32. Joining tables with Query Designer
- Example 1: Complex query with JOIN,GROUP BY and aggregates
- Example 2: Tricky JOIN conditions
- Example 3: The discovery of the AdventureWorks along keys
- Example 4: Connecting five tables with Design Queryvel
- Example 5: Five table query with aggregation
- Example 6: Math in a five table query
Az oktatóról
A NetAcademia alapítója, egyben oktatója vagyok immár 20 éve. Kedvenc témaköreim az adatbáziskezelés, ebben otthon is vagyok, valamint a webfejlesztés, amihez nem értek. Ezért készítek ebben a témában kezdő tanfolyamokat. Ezen felül minden érdekel, a mesterséges intelligencia éppúgy mint az abszulút hallás megtanulása. Azt vallom, mindent meg lehet tanulni. A világ megismerése tanulás, és nem bambulás, esetleg tiltakozás útján történik.
