Are you preparing for a job interview as a developer?

If yes, you have come to the right place. This book contains a pool of 30 carefully selected SQL coding tasks, most often asked by recruiters. the book include deeply-explained, most commonly used data manipulation queries, relationships modeling, aggregation, sorting, table joins, index and other top topics to discuss during the job interview.

If you prepare yourself for a job interview with this book, there is no need to wish you good luck. Find yourself a dream job, and be happy.

Osoby które kupowały "Top 30 SQL Interview Coding Tasks with Winning Solutions", wybierały także:

• SQL. Kurs video. Kompendium wiedzy na podstawie MySQL 159,00 zÅ‚, (47,70 zÅ‚ -70%)
• PHP i MySQL. Kurs video. Tw 144,86 zÅ‚, (52,15 zÅ‚ -64%)
• MySQL. Kurs video. Od podstaw do zagadnieÅ„ zaawansowanych. Tworzenie i analizowanie baz danych 59,00 zÅ‚, (26,55 zÅ‚ -55%)
• MySQL. Jak zaprojektowa 129,00 zÅ‚, (64,50 zÅ‚ -50%)
• Wydajna praca z MySQL. Efektywne i bezpieczne zarz 89,00 zÅ‚, (44,50 zÅ‚ -50%)

Spis treści

Top 30 SQL Interview Coding Tasks with Winning Solutions eBook -- spis treści

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.