Posts Tagged with SQL

  • Console start
  • Basic Operators & Types
  • Jobs (Py)
  • Examples using PhpRedis

General notes on this course will write here. This course seems to be more difficult than MongoDB for devs,at least 3 hours of lectures vs 1 hour is a great difference!

  • Week1
  • Week2

In current project need to calc data stored in MongoDB with MapReduce algo in php Laravel (REST services). Ideas how to will publish here.

  • map-reduce operation
  • mapReduce prototype form
  • table SQL to noSQl MongDB MapReduce
  • Example1: Calculate RatingSnapshot and Total Quantity with Average Quantity Per Rating
  • Example2: Calc num_ratings
  • Example3: Places in each network
  • Example4: Pivot Data with Map reduce
  • php - MongoDB::command (Execute a database command) Examples

Coding new project using Laravel and MongoDB. Refreshing memories about noSQL syntax

Couldnot answer such questions on an interview, cheat sheet is needed. The database s c h e m a with specific functions found to work with each table described with real world examples.

  • wp_options
  • wp_users
  • wp_usermeta
  • wp_posts
  • wp_postmeta
  • wp_comments
  • wp_commentsmeta
  • wp_terms, wp_term_taxonomy, wp_term_relationships

Just preparing for the test on ANSI SQL, gathered all statements together.

  • SELECT
  • INSERT
  • UPDATE
  • CREATE
  • GRANT
  • ANY, IN, SOME, ALL
  • LIKE
  • Homework: Homework 4.1: queries that utilize index
  • Homework: Homework 4.2: explain index
  • Homework: Homework 4.3: add indexes to the blog
  • Homework: Homework 4.4: analyze a profile log
  • Homework: Homework 3.1: remove the lowest homework score for each student
  • Homework: Homework 3.2: Making blog accept posts
  • Homework: Homework 3.3: Making blog accept comments
  • find, find cursors, find lt & gt, find projection, find And Modify, findOne
  • import JSON, insert Array, insert Doc
  • Regex selector
  • remove
  • save
  • skip Limit Sort
  • update, update Single, update Multi
  • upsert