Justin Choi jcsnorlax97

SQL languages

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.

DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such INSERT, UPDATE, DELETE etc, and it is used to store, modify, delete and update data in database.

DQL is short name of Data Query Language which used for performing queries on the data within schema objects. The purpose of the DQL Command is to get some schema relation based on the query passed to it. SELECT statement is used to retrieve data from the database.

Setup Travis and Heroku CICD: Point-n-Click

Continuous Integration with Travis CI

Configure travis.yml

Run npm test to ensure tests are working correctly locally
Create .travis.yml file in repo
Add the following to configure for node

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database

Terminal - Remove MySQL completely

Open the Terminal
Use mysqldump to backup your databases
Check for MySQL processes with: ps -ax | grep mysql
Stop and kill any MySQL processes
Analyze MySQL on HomeBrew:

brew remove mysql

Java expression evaluated at run time.

Prototype

<%=     %>

	node: Platform built on V8 to build network applications
	git: Distributed revision control system
	wget: Internet file retriever
	yarn: JavaScript package manager
	python3: Interpreted, interactive, object-oriented programming language
	coreutils: GNU File, Shell, and Text utilities
	pkg-config: Manage compile and link flags for libraries
	chromedriver: Tool for automated testing of webapps across many browsers
	awscli: Official Amazon AWS command-line interface
	automake: Tool for generating GNU Standards-compliant Makefiles