TOC: MongoDB

• Overview
  1. MongoDB ("humongous") (= huge; enormous.)
  2. 5 types of NoSQL databases
  3. Languages
  4. Documentation
  5. Features
  6. Limitations
  7. Performance
  8. Auto-sharding
  9. Sharding
  10. Picking a Shard Key
  11. Replica set - high availability and data duability
  12. Write concern
  13. Storage Engines
  14. MongoDB Data format
  15. Driver Responsibility
• First steps
  1. SQL to MongoDB terms
  2. Embedded documents
  3. GUI client for MongoDB
  4. Atlas hosted environment
  5. Command line tools
  6. MongoDB on the command line
  7. insert
  8. insert more
  9. Pretty printing in the MongoDB shell
  10. find
  11. update a document
  12. Update modifiers for fields
  13. update - add values using $set
  14. update - add array using $set
  15. remove value from document
  16. transaction in a document
  17. push
  18. Update modifiers for arrays
  19. Update array element
  20. Remove array element
  21. _id is unique in a collection
  22. update and save
  23. save()
  24. Remove (delete) document
  25. Count documents
  26. Find deeply
  27. sort()
  28. push
  29. Update modifiers
  30. Conditional Operators
  31. Indexes
  32. Creat Indexes
  33. Unique Index
  34. Sparse index
  35. Index embedded document (or subkey)
  36. Insert complex data structure
  37. Display complex data structure
  38. Rename embedded document
  39. Remove ($unset) embedded document
  40. Change element of array
  41. Add embedded document
  42. Remove elements of an array by value
  43. Remove elements of an array by index (trick)
  44. Append one element to an array
  45. Append multiple elements to an array
  46. Insert multiple elements in an array
  47. Drop collection
  48. Drop database
  49. MongoDB shell tools
  50. Resources
  51. Projection
• Aggregation
  1. Aggregation framework
  2. A Processing Pipeline
  3. Pipeline Operators
  4. Example: Insert data
  5. Show data
  6. Group by name and sum - $sum
  7. Group by name and caluclate average $avg
  8. Group by name $max, $min
  9. Group by name and count
  10. All the elements - sum
  11. All the elements - sum
  12. $match (filter)
  13. $match (filter) and the total
  14. $match with $gt
  15. $group with $push
  16. New data set
  17. New data set
  18. $unwind
  19. $unwind and $group
  20. $unwind and $group and $sort
  21. $match
  22. $match and $unwind and $group
• Mailbox analyzing
  1. Email messages
  2. find
  3. Find by date
  4. Messages that have CC field
  5. Large messages
  6. List the 10 biggest messages
  7. The total size of the messages - aggregate
  8. The total size of the messages - mapReduce
• MongoDB with Perl
  1. Simple
  2. Update
  3. Unique
  4. Increment
  5. Phonebook
• MongoDB with Python
  1. Simple