@mike_dane via @freeCodeCamp
➤ SQL Tutorial for Beginners
https://t.co/sf5nVEBJ1S
30+ resources to learn
❍ SQL
❍ PL/SQL
❍ NoSQL
⇩
@ChrisRSaxon
➤ Complete SQL Tutorial
➤ Magic Tricks
➤ SQL Query Tuning
https://t.co/uOzHM0hWu3
➀ Learning SQL
↦ Alan Beaulieu
➁ Head First SQL
↦ Lynn Beighley
➂ SQL Quickstart Guide
↦ Clydebank Technology
➃ SQL Practice Problems
↦ Sylvia Moestl Vasilik
↦ John Viescas
↦ Michael J. Hernandez
➅ Database Design for Mere Mortals
↦ Michael J. Hernandez
➆ SQL Antipatterns
↦ Bill Karwin
➇ Beginning Database Design Solutions
↦ Rod Stephens
↦ Alex Petrov
➉ NoSQL for Mere Mortals
↦ Dan Sullivan
➀➀ MongoDB: The Definitive Guide
↦ Shannon Bradshaw
More questions will be shared in the coming days.
https://t.co/vRRql42ZFp
75+ SQL Interview Questions
— Swapna Kumar Panda (@swapnakpanda) June 23, 2022
\u21e9
More questions will be shared in the coming days.
https://t.co/vRRql42ZFp
75+ SQL Interview Questions
— Swapna Kumar Panda (@swapnakpanda) June 23, 2022
\u21e9
More from Swapna Kumar Panda
🛣 Beginner's Roadmap for Front-End
HTML & CSS → 👩💻 → JavaScript → 👩💻
↓
👩💻 ← React* ← 👩💻 ← Tailwind*
↓
TypeScript → 👩💻 → Next.js* → 👩💻 → 🏁
⇩
What would we cover?
➊ HTML & CSS
➋ JavaScript
➌ CSS Frameworks
➍ UI Frameworks
➎ TypeScript
➏ Server-side Frameworks
➐ Practice, Practice and, Practice
➑ Other Skills
➒ Frequently Asked Questions
➊ HTML & CSS
⬘ Your Front-End journey shall always start from HTML & CSS and, ends with these as well.
⬗ Don't over burden yourself to learn everything at once. It's a continuous subject.
⬙ Do not separate HTML from CSS. That's
➋ JavaScript
JavaScript is essential. You should start with basics and move to complex subjects.
❍ JavaScript Syntaxes
(preferably ES6 onwards)
❍ HTML DOM API
❍ Event Handling
❍ Fetch
➌ CSS Frameworks
CSS Framework is necessary if you are planning to be a professional developer.
There are so many options available.
❍ Tailwind CSS
❍ Bootstrap
❍ Chakra
❍ Bulma
❍ Foundation
❍ Skeleton
❍ Pure CSS
Start with anything. You can switch any time.
HTML & CSS → 👩💻 → JavaScript → 👩💻
↓
👩💻 ← React* ← 👩💻 ← Tailwind*
↓
TypeScript → 👩💻 → Next.js* → 👩💻 → 🏁
⇩
What would we cover?
➊ HTML & CSS
➋ JavaScript
➌ CSS Frameworks
➍ UI Frameworks
➎ TypeScript
➏ Server-side Frameworks
➐ Practice, Practice and, Practice
➑ Other Skills
➒ Frequently Asked Questions
➊ HTML & CSS
⬘ Your Front-End journey shall always start from HTML & CSS and, ends with these as well.
⬗ Don't over burden yourself to learn everything at once. It's a continuous subject.
⬙ Do not separate HTML from CSS. That's
Beginner's Roadmap for HTML & CSS
— Swapna Kumar Panda \uea00 (@swapnakpanda) April 18, 2022
\u21e9
➋ JavaScript
JavaScript is essential. You should start with basics and move to complex subjects.
❍ JavaScript Syntaxes
(preferably ES6 onwards)
❍ HTML DOM API
❍ Event Handling
❍ Fetch
\U0001f6e3 Roadmap for JavaScript Absolute Beginners
— Swapna Kumar Panda \uea00 (@swapnakpanda) March 29, 2022
\u21e9
➌ CSS Frameworks
CSS Framework is necessary if you are planning to be a professional developer.
There are so many options available.
❍ Tailwind CSS
❍ Bootstrap
❍ Chakra
❍ Bulma
❍ Foundation
❍ Skeleton
❍ Pure CSS
Start with anything. You can switch any time.
You May Also Like
A brief analysis and comparison of the CSS for Twitter's PWA vs Twitter's legacy desktop website. The difference is dramatic and I'll touch on some reasons why.
Legacy site *downloads* ~630 KB CSS per theme and writing direction.
6,769 rules
9,252 selectors
16.7k declarations
3,370 unique declarations
44 media queries
36 unique colors
50 unique background colors
46 unique font sizes
39 unique z-indices
https://t.co/qyl4Bt1i5x
PWA *incrementally generates* ~30 KB CSS that handles all themes and writing directions.
735 rules
740 selectors
757 declarations
730 unique declarations
0 media queries
11 unique colors
32 unique background colors
15 unique font sizes
7 unique z-indices
https://t.co/w7oNG5KUkJ
The legacy site's CSS is what happens when hundreds of people directly write CSS over many years. Specificity wars, redundancy, a house of cards that can't be fixed. The result is extremely inefficient and error-prone styling that punishes users and developers.
The PWA's CSS is generated on-demand by a JS framework that manages styles and outputs "atomic CSS". The framework can enforce strict constraints and perform optimisations, which is why the CSS is so much smaller and safer. Style conflicts and unbounded CSS growth are avoided.
Legacy site *downloads* ~630 KB CSS per theme and writing direction.
6,769 rules
9,252 selectors
16.7k declarations
3,370 unique declarations
44 media queries
36 unique colors
50 unique background colors
46 unique font sizes
39 unique z-indices
https://t.co/qyl4Bt1i5x
PWA *incrementally generates* ~30 KB CSS that handles all themes and writing directions.
735 rules
740 selectors
757 declarations
730 unique declarations
0 media queries
11 unique colors
32 unique background colors
15 unique font sizes
7 unique z-indices
https://t.co/w7oNG5KUkJ
The legacy site's CSS is what happens when hundreds of people directly write CSS over many years. Specificity wars, redundancy, a house of cards that can't be fixed. The result is extremely inefficient and error-prone styling that punishes users and developers.
The PWA's CSS is generated on-demand by a JS framework that manages styles and outputs "atomic CSS". The framework can enforce strict constraints and perform optimisations, which is why the CSS is so much smaller and safer. Style conflicts and unbounded CSS growth are avoided.
So it's now October 10, 2018 and....Rod Rosenstein is STILL not fired.
He's STILL in charge of the Mueller investigation.
He's STILL refusing to hand over the McCabe memos.
He's STILL holding up the declassification of the #SpyGate documents & their release to the public.
I love a good cover story.......
The guy had a face-to-face with El Grande Trumpo himself on Air Force One just 2 days ago. Inside just about the most secure SCIF in the world.
And Trump came out of AF1 and gave ol' Rod a big thumbs up!
And so we're right back to 'that dirty rat Rosenstein!' 2 days later.
At this point it's clear some members of Congress are either in on this and helping the cover story or they haven't got a clue and are out in the cold.
Note the conflicting stories about 'Rosenstein cancelled meeting with Congress on Oct 11!"
First, rumors surfaced of a scheduled meeting on Oct. 11 between Rosenstein & members of Congress, and Rosenstein just cancelled it.
He's STILL in charge of the Mueller investigation.
He's STILL refusing to hand over the McCabe memos.
He's STILL holding up the declassification of the #SpyGate documents & their release to the public.
I love a good cover story.......
The guy had a face-to-face with El Grande Trumpo himself on Air Force One just 2 days ago. Inside just about the most secure SCIF in the world.
And Trump came out of AF1 and gave ol' Rod a big thumbs up!
And so we're right back to 'that dirty rat Rosenstein!' 2 days later.
At this point it's clear some members of Congress are either in on this and helping the cover story or they haven't got a clue and are out in the cold.
Note the conflicting stories about 'Rosenstein cancelled meeting with Congress on Oct 11!"
First, rumors surfaced of a scheduled meeting on Oct. 11 between Rosenstein & members of Congress, and Rosenstein just cancelled it.
Rep. Andy Biggs and Rep. Matt Gaetz say DAG Rod Rosenstein cancelled an Oct. 11 appearance before the judiciary and oversight committees. They are now calling for a subpoena. pic.twitter.com/TknVHKjXtd
— Ivan Pentchoukov \U0001f1fa\U0001f1f8 (@IvanPentchoukov) October 10, 2018
