scwebd
4/18/2019 - 10:13 PM

FT Week 9 Links

==== @channel A Few Resources and One Lonely Video Walkthrough from Today’s Activities: =========================

The SQL vs NoSQL Difference: MySQL vs MongoDB: https://medium.com/xplenty-blog/the-sql-vs-nosql-difference-mysql-vs-mongodb-32c9980e67b2

Relational databases vs Non-relational databases: http://www.jamesserra.com/archive/2015/08/relational-databases-vs-non-relational-databases/

What is BSON? http://bsonspec.org/

All MongoDB Collection Methods: https://docs.mongodb.com/manual/reference/method/js-collection/

MongoDB Query Operators ($in, $gt, $or, etc): https://docs.mongodb.com/manual/reference/operator/query/

MongoDB Basics Cheatsheet: https://www.opentechguides.com/how-to/article/mongodb/118/mongodb-cheatsheat.html

Mongo Shell Basics Video Walkthrough: https://www.youtube.com/watch?v=Ci1bui7w75k&list=PLgJ8UgkiorCk7zT1kKGwSogEcJbVBzzH8&index=1

(Note: see attached the Career Services slideshow I walked through this afternoon.)
==== @channel A Few MongoDB/Mongoose and IndexedDB Resources: =========================

Mongoose Validations: https://mongoosejs.com/docs/validation.html#built-in-validators

Mongoose Queries: https://mongoosejs.com/docs/queries.html

Mongoose Populate (similar to SQL joins; allows you to inject related data from another model): https://mongoosejs.com/docs/populate.html

The Starter Tutorial for Browser Database IndexedDB: https://www.tutorialdocs.com/article/indexeddb-tutorial.html

Working with IndexedDB (Google tutorial): https://developers.google.com/web/ilt/pwa/working-with-indexeddb

Atomicity in Databases: https://en.wikipedia.org/wiki/Atomicity_(database_systems)
==== @channel A Few IndexedDB and App Optimization Resources: =========================

The Starter Tutorial for Browser Database IndexedDB: https://www.tutorialdocs.com/article/indexeddb-tutorial.html

Working with IndexedDB (Google tutorial): https://developers.google.com/web/ilt/pwa/working-with-indexeddb

Atomicity in Databases: https://en.wikipedia.org/wiki/Atomicity_(database_systems)

Gulp vs Grunt - Comparing Both Automation Tools (tools for compressing/minifying files and images and running other automated processes):  https://www.keycdn.com/blog/gulp-vs-grunt

Ensure text remains visible during webfont load: https://web.dev/font-display/?utm_source=lighthouse&utm_medium=devtools

Other optimizations to consider: https://web.dev/lighthouse-performance/#opportunities

Measuring Resource Loading Times in Chrome: https://developers.google.com/web/tools/chrome-devtools/network/resource-loading?utm_campaign=2016q3&utm_medium=redirect&utm_source=dcc#network-panel-overview

Loading Images on Demand: https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps/Loading#Loading_on_demand
==== @channel A Few PWA and App Optimization Resources: =========================

Gulp vs Grunt - Comparing Both Automation Tools (tools for compressing/minifying files and images and running other automated processes):  https://www.keycdn.com/blog/gulp-vs-grunt

Ensure text remains visible during webfont load: https://web.dev/font-display/?utm_source=lighthouse&utm_medium=devtools

Other optimizations to consider: https://web.dev/lighthouse-performance/#opportunities

Measuring Resource Loading Times in Chrome: https://developers.google.com/web/tools/chrome-devtools/network/resource-loading?utm_campaign=2016q3&utm_medium=redirect&utm_source=dcc#network-panel-overview

Loading Images on Demand: https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps/Loading#Loading_on_demand

The Web App Manifest: https://developers.google.com/web/fundamentals/web-app-manifest

Google’s Introduction to Service Worker: https://developers.google.com/web/ilt/pwa/introduction-to-service-worker

Service Worker Global Scope: https://developer.mozilla.org/en-US/docs/Web/API/ServiceWorkerGlobalScope

Using the Fetch API: https://developer.mozilla.org/en-US/docs/Web/API/Fetch_API/Using_Fetch

Recursion, Recursion, Recursion: https://www.freecodecamp.org/news/recursion-recursion-recursion-4db8890a674d/
==== @channel A Few Webpack Resources: =========================

Why Webpack?  https://webpack.js.org/concepts/why-webpack/

What is tree shaking and how does it work? https://bitsofco.de/what-is-tree-shaking/

Babel Repl (allows you to see how Babel converts ES6+ code to ES5):  https://babeljs.io/repl/

More info on how Babel works with Webpack: https://babeljs.io/docs/en/babel-preset-env

Files with .mjs extension for JavaScript modules: https://medium.com/passpill-project/files-with-mjs-extension-for-javascript-modules-ced195d7c84a

How to debug a webpack app in the browser: https://blog.jakoblind.no/debug-webpack-app-browser/
*==== @channel A Few Resources and One Lonely Video Walkthrough from Today’s Activities: =========================*
_(please visit it... it’s so lonely!)_

*The SQL vs NoSQL Difference: MySQL vs MongoDB:* https://medium.com/xplenty-blog/the-sql-vs-nosql-difference-mysql-vs-mongodb-32c9980e67b2

*Relational databases vs Non-relational databases:* http://www.jamesserra.com/archive/2015/08/relational-databases-vs-non-relational-databases/

*What is BSON and exactly how is it different from JSON?* https://stackoverflow.com/questions/12438280/what-is-bson-and-exactly-how-is-it-different-from-json

*All MongoDB Collection Methods:* https://docs.mongodb.com/manual/reference/method/js-collection/

*MongoDB Basics Cheatsheet:* http://tech.joshegan.com/posts/yr2017/mongodb-cheatsheet

*Mongo Shell Basics Video Walkthrough:* https://www.youtube.com/watch?v=Ci1bui7w75k&list=PLgJ8UgkiorCk7zT1kKGwSogEcJbVBzzH8&index=1
*==== @channel A Few Video Walkthroughs and a Whiteboarding Strategy Guide: =========================*

*MongoJS and the Front-End Video Walkthrough:* https://www.youtube.com/watch?v=VFv8J8WbvZM

*Scraping Into Your Database Video Walkthrough:* https://www.youtube.com/watch?v=7dTBxMlEVgc

*When it comes to whiteboard coding interviews, remember to PREP:* https://www.freecodecamp.org/news/before-you-code-remember-to-prep-for-your-coding-interview-2ccfb58147db/
_(^^^ avoid the deer-in-the-headlights look in your whiteboarding interviews by practicing with this strategy! ^^^)_