MyElectricSheep

Vanilla NodeJS

Create a folder exercises_vanilla then go to this folder in your terminal and execute:

npm init -y

Exercise 0 (Help - NPM)

MyElectricSheep

SQL Bolt

Exercises from http://sqlbolt.com/

Lesson 1: SELECT queries 101

SELECT title 
FROM movies;

MyElectricSheep

SQL ZOO

There's a cheat mode in SQL Zoo!

To activate it; use ?answer=1 at the end of a URL e.g.: https://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial?answer=1

SELECT_from_WORLD

1/

MyElectricSheep

[{
		"name": "Abguss-Sammlung Antiker Plastik",
		"neighborhood": "Charlottenburg",
		"borough": "Charlottenburg-Wilmersdorf",
		"type": "Art",
		"summary": "Part of the Free University of Berlin, plaster casts of sculptures from Ancient Greece, Rome, and the Byzantine Empire"
	},
	{
		"name": "Academy of Arts, Berlin",
		"image": "https://upload.wikimedia.org/wikipedia/commons/thumb/0/08/Akademie_der_K%C3%BCnste_Berlin.jpg/800px-Akademie_der_K%C3%BCnste_Berlin.jpg",

MyElectricSheep

1)  justify-content: flex-end;

2)  justify-content: center;

3)  justify-content: space-around;

4)  justify-content: space-between;

5)  align-items: flex-end;

MyElectricSheep

1. 
justify-content: center;

2. 
justify-content: flex-end; 

justify-content: center; 

justify-content: flex-end; 

MyElectricSheep

# https://flukeout.github.io/ #
~30-45 mins

01. plate
02. bento
03. #fancy
04. plate apple
05. #fancy pickle
06. .small
07. orange.small

MyElectricSheep

#include <stdio.h>
#include <cs50.h>
#include <math.h>
#include <stdlib.h>

bool check_cc_length(long cc_number);
bool get_condition(int i);
long get_length(long number);
long cc_number_length = 0;

MyElectricSheep

-- SELECT * FROM parts
-- LIMIT 10;

-- ALTER TABLE parts
-- ALTER COLUMN code
-- SET NOT NULL;

-- ALTER TABLE parts
-- ADD UNIQUE (code);

MyElectricSheep

-- QUERIES

-- Find all employees

-- Find all clients

-- Find all employees, ordered by lower salary first
-- https://www.w3schools.com/sql/sql_orderby.asp

-- Find all employees ordered by sex, then name