Skip to content

Instantly share code, notes, and snippets.

View iamlearning1's full-sized avatar
:octocat:
Focusing

Deepak Kumar iamlearning1

:octocat:
Focusing
  • Madrid
View GitHub Profile
@iamlearning1
iamlearning1 / index.css
Created October 11, 2022 19:07
Typing Animation
div {
width: 6ch;
white-space: nowrap;
overflow: hidden;
animation: typing 2s steps(6),
cursor 2s;
border-right: 3px solid black;
font-size: 40px;
margin: 20px auto;
}
@iamlearning1
iamlearning1 / index.css
Created October 5, 2022 15:43
Rotating Cards
.container {
position: relative;
width: 300px;
height: 360px;
margin: 20px auto;
}
.card {
perspective: 1500px;
width: 100%;
@iamlearning1
iamlearning1 / index.css
Last active October 5, 2022 11:22
Switch Component
:root {
--track-width: 60px;
--track-height: 30px;
--track-border-radius: 20px;
--switch-width: 25px;
--switch-height: 25px;
--switch-position-top: 2.5px;
--switch-position: 4px;
@iamlearning1
iamlearning1 / launch.json
Created May 1, 2020 09:45
launch.json for typescript
{
"version": "0.2.0",
"configurations": [
{
"type": "node",
"request": "launch",
"name": "Launch Program",
"program": "${workspaceFolder}/src/index.ts",
"preLaunchTask": "tsc: build - tsconfig.json",
"outFiles": ["${workspaceFolder}/build/**/*.js"]
@iamlearning1
iamlearning1 / App.css
Created March 12, 2020 07:54
React Refs
.inputs {
display: flex;
align-items: flex-end;
justify-content: center;
height: 500px;
}
input {
padding: 20px;
width: 14px;
@iamlearning1
iamlearning1 / tvdata.sql
Created January 14, 2020 04:35
sql many to many relations
SHOW DATABASES;
CREATE DATABASE imdb;
USE imdb;
CREATE TABLE reviewers
(
id INT auto_increment,
first_name VARCHAR(100),
@iamlearning1
iamlearning1 / joins.sql
Last active January 13, 2020 16:00
Joins for MySQL
SHOW DATABASES;
CREATE DATABASE relations;
USE relations;
CREATE TABLE customers
(
id INT auto_increment,
first_name VARCHAR(100),
@iamlearning1
iamlearning1 / aggregate.sql
Created January 13, 2020 06:25
aggregate queries for MySQL
USE learning_db;
SELECT Count(*)
FROM books;
SELECT Count(DISTINCT author_fname)
FROM books;
SELECT Count(DISTINCT author_fname, author_lname)
FROM books;
@iamlearning1
iamlearning1 / refine.sql
Created January 13, 2020 06:24
Refine queries for MySQL
SHOW DATABASES;
USE learning_db;
SHOW tables;
SELECT *
FROM books;
SELECT DISTINCT released_year

FWIW: I didn't produce the content presented here (the outline from Edmond Lau's book). I've just copy-pasted it from somewhere over the Internet, but I cannot remember what exactly the original source is. I was also not able to find the author's name, so I cannot give him/her the proper credits.


Effective Engineer - Notes

What's an Effective Engineer?