AshishKapoor

MySQL

Getting started:

• http://www.sqlteaching.com/
• https://www.codecademy.com/courses/learn-sql

Related tutorials:

• MySQL-CLI
• Analyzing Business Metrics

AshishKapoor

{
  "meta": { "theme": "elegant" },
  "basics": {
    "name": "Ashish Kapoor",
    "label": "Senior Software Engineer",
    "picture": "https://avatars3.githubusercontent.com/u/5203107?s=400&u=a2ec71f26f786eef2d311a338d88cc02536f5fd2&v=4",
    "email": "[email protected]",
    "phone": "+91 9899 771 880",
    "website": "https://medium.com/@kapoor",
    "summary": "A process-oriented professional with over 6 years of experience in the software engineering discipline. Currently, a software consultant at Rill Data, former sr. software engineer at Quid, a science enthusiast, and sometimes a vocalist. Inclined towards solving problems in big data, automotive, and educational startups with extensive experience building technology platforms, apps, websites in many sectors, and holds a master's degree in computer applications. A machine learning, and music enthusiast. Also, the former organizer of the Swift Delhi meetup community.",

AshishKapoor

// Search letter wise in an array using JavaScript

var words = ['spray', 'limit', 'elite', 'exuberant', 'destruction', 'present'];

const result = words.filter(word => word.indexOf('des') !== -1);

console.log(result); // > Array ["destruction"]

AshishKapoor

// Reference: https://stackoverflow.com/a/18234552/7393218

const message=[];
const say = (someString) => {
    if (someString) {
        message.push(someString);
        return say
    }
    console.log(message.join(' '));
}

AshishKapoor

Docker Commands, Help & Tips

Show commands & management commands

$ docker

Docker version info

AshishKapoor

Tabs and Windows

Function	Shortcut
New Tab	⌘ + T
Close Tab or Window	⌘ + W (same as many mac apps)
Go to Tab	⌘ + Number Key (ie: ⌘2 is 2nd tab)
Go to Split Pane by Direction	⌘ + Option + Arrow Key
Cycle iTerm Windows	⌘ + backtick (true of all mac apps and works with desktops/mission control)

AshishKapoor

# /etc/hosts

# BEGIN WORK MACHINE BLOCK
0.0.0.0	facebook.com
::	facebook.com
0.0.0.0	linkedin.com
::	linkedin.com
0.0.0.0	amazon.in
::	amazon.in
0.0.0.0	instagram.com

AshishKapoor

#!/bin/bash
# Version 0.1 Tuesday, 07 May 2013
# Comments and complaints http://www.nicknorton.net
# GUI for mouse wheel speed using imwheel in Gnome
# imwheel needs to be installed for this script to work
# sudo apt-get install imwheel
# Pretty much hard wired to only use a mouse with
# left, right and wheel in the middle.
# If you have a mouse with complications or special needs,
# use the command xev to find what your wheel does.

AshishKapoor

Install kafka/zookeeper and start servers

$ brew install kafka
$ brew install zookeeper

$ zkServer start
$ kafka-server-start /usr/local/etc/kafka/server.properties

Create a topic

AshishKapoor

SQL BASICS


CREATE DATABASE local;

-- tell mysql which database to work with
USE local;

-- create a table with a column
create table test (