sql pdf book notes download for free


About Book

This book has 100+ pages that cover the basic to advanced topic of SQL with practical program and code examples. if you want to learn SQL then this book is for you. this book is developed by professional programmers for educational purposes.


Book contents

  1. Getting started with SQL
  2. identifier
  3. data types
  4. null
  5. example databases and tales
  6. select
  7. group by
  8. order by
  9. and & or operators
  10. case
  11. like operator
  12. in clause
  13. filter results using where and having
  14. skip take
  15. except
  16. explain and describe
  17. exists clause
  18. join
  19. update
  20. create database
  21. create table
  22. create function
  23. try-catch
  24. union union all
  25. alter table
  26. insert
  27. merge
  28. cross apply outer apply
  29. delete
  30. truncate
  31. drop table
  32. drop or delete database
  33. cascading delete
  34. grant and revoke
  35. XML
  36. primary keys
  37. indexes
  38. row number
  39. SQL group by vs distinct
  40. string functions
  41. functions
  42. functions scalar single row
  43. functions analytic
  44. window functions
  45. common table expressions
  46. views
  47. materialized views
  48. comments
  49. foreign keys
  50. sequence
  51. subqueries
  52. execution blocks
  53. stored procedures
  54. triggers
  55. transactions
  56. table design
  57. synonyms
  58. information schema
  59. order of execution
  60. clean code in SQL
  61. SQL injection