Contents

Cover Title Colofon Preface Data-set 1. Get data from the database. 2. Get data from the database using a conditional statement. 3. Get data from the database using the IN operator. 4. Save data in the database. 5. Modify data in the database. 6. Remove data from the database. 7. Find rows which values are NULL. 8. Get list of unique values from table column. 9. Sort results. 10. Get results based on text pattern. 11. Create and use an index. 12. Create and use composite index. 13. Prepare inner, left outer, right outer, and full outer table joins. 14. Download aggregated data from the database. 15. Download aggregated results grouped by column. 16. Use a function in SQL query. 17. Create a table. 18. Modify database schema. 19. Reference integrity. 20. Design one-to-many relationship. 21. Design many-to-many relationship. 22. Copy data from one table to another table. 23. Combine the results of more than one SELECT statement. 24. Create and execute a stored procedure. 25. Create a view and get data from it. 26. Create and use a partition. 27. Create a query which allows pagination. 28. Create and use a sequence. 29. Create a database trigger. 30. Define a transaction.

Punkty orientacyjne