BC SQL
Saved by @cur10uslearner

30+ resources to learn

❍ SQL
❍ PL/SQL
❍ NoSQL

⇩

 ➊.➀ freeCodeCamp

@mike_dane via @freeCodeCamp

➤ SQL Tutorial for Beginners
https://t.co/sf5nVEBJ1S
➊.➁ Web Dev Simplified (WDS)

@DevSimplified

➤ Learn SQL in 60 Minutes
https://t.co/SWM2WxZAxJ
➊.➂ Programming with Mosh

@moshhamedani

➤ MySQL Tutorial for Beginners
https://t.co/KWf6zO4qUU
➊.➃ Kevin Stratvert

@kevstrat

➤ SQL Tutorial for Beginners
https://t.co/EWbVoQ1UHA
➊.➄ Joey Blue

➤ Basic SQL Training
https://t.co/mHzFHm7ZFv
➊.➅ The Magic of SQL

@ChrisRSaxon

➤ Complete SQL Tutorial
➤ Magic Tricks
➤ SQL Query Tuning
https://t.co/uOzHM0hWu3
➊.➆ techTFQ

@techTFQ

➤ SQL Tutorial
➤ Practice SQL Interview Questions
https://t.co/46pwQ4m52D
➊.➇ Bert Wagner (Data with Bert)

@bertwagner

➤ SQL Lessons
https://t.co/qoXImbJTGD
➊.➈ Alex The Analyst

➤ Intermediate SQL Tutorials
https://t.co/3zOarOjaFM
➊.➉ edureka!

@edurekaIN

➤ SQL Full Course
https://t.co/82YBgzKEDB
➊.➀➀ Micro Solution (Hindi)

➤ SQL Tutorial for Beginners (Hindi)
https://t.co/yswQyOLMJh
➊.➀➁ Practically Perfect PL/SQL

@sfonplsql

➤ PL/SQL Tutorial
https://t.co/8jk4iYarSJ
➊.➀➂ freeCodeCamp

@ania_kubow via @freeCodeCamp

➤ NoSQL Database Tutorial
https://t.co/fsqb08rBeO
➊.➀➃ MongoDB

@MongoDB

➤ MongoDB Jumpstart
https://t.co/rdP4fV5ufq
➋ Books

➀ Learning SQL
↦ Alan Beaulieu

➁ Head First SQL
↦ Lynn Beighley

➂ SQL Quickstart Guide
↦ Clydebank Technology

➃ SQL Practice Problems
↦ Sylvia Moestl Vasilik
➄ SQL Queries for Mere Mortals
↦ John Viescas
↦ Michael J. Hernandez

➅ Database Design for Mere Mortals
↦ Michael J. Hernandez

➆ SQL Antipatterns
↦ Bill Karwin

➇ Beginning Database Design Solutions
↦ Rod Stephens
➈ Database Internals
↦ Alex Petrov

➉ NoSQL for Mere Mortals
↦ Dan Sullivan

➀➀ MongoDB: The Definitive Guide
↦ Shannon Bradshaw
➌ Blogs/Articles

➀ Programiz
➁ GeeksForGeeks
➂ Oracle Live SQL
➃ FreeCodeCamp
➍ Online Editor for SQL

➀ Programiz
➁ MyCompiler
➂ JDoodle
➃ Oracle Live SQL
➄ W3Schools
➎ Twitter Threads/Cheat Sheets

https://t.co/9na4g8DgjX
➏ Interview Questions

More questions will be shared in the coming days.

https://t.co/vRRql42ZFp
➐ Practice Questions

More questions will be shared in the coming days.

https://t.co/vRRql42ZFp
Hey 👋

I am a Tech Educator and, Mentor from India 🇮🇳

I am sharing Tutorials, Infographics, Cheat Sheets, Practice Questions, Project Ideas and Roadmaps on Web Development, DSA and, Databases.

To never miss anything, Follow Me ✅

More from Swapna Kumar Panda

Swapna Kumar Panda \uea00
Swapna Kumar Panda ...
@swapnakpanda
🛣 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.
FRONTEND
Swapna Kumar Panda
Swapna Kumar Panda
@swapnakpanda
👩‍💻 75+ SQL Practice Questions

❍ Oracle
❍ MySQL
❍ SQL Server
❍ PostgreSQL
❍ SQLite

⇩

Topics covered:

➊ Table
➋ Constraints
➀ Primary Key
➁ Unique
➂ Not Null
➃ Default
➄ Check
➅ Foreign Key
➌ Insert, Update, Delete
➍ Select

➊ Table

➀ Create a Table with a few fields by specifying their data types.

➁ Add a field to an existing table.

➂ Modify a field's data type of a table.

➃ Rename a field's name.

➄ Remove a field from a table.

➅ Rename a table's name.

➆ Drop a table.

➋ Constraints

➀ Primary Key
➁ Unique
➂ Not Null
➃ Default
➄ Check
➅ Foreign Key

➋.➀ Primary Key

➤ Create a Table with
➀ a single field as the primary key
➁ 2 or, more fields as the primary key
...

➤ Add a primary key to an existing table
➂ for a single field
➃ for 2 or, more fields
...
SQLBASICS
Advertisement
Swapna Kumar Panda
Swapna Kumar Panda
@swapnakpanda
JavaScript First, Then React?
Or,
JavaScript ✛ React?

⇩

👩‍💻 Beginning Words

There are 3 approaches one can take to start React journey

➊ Complete JavaScript. Then, start React.

➋ Learn the essentials of JavaScript. Then, start React. Finally, learn advanced JavaScript.

➌ Start React. Learn JavaScript alongside.

💭 Why is this Thread?

⬘ JavaScript is a language while React is one JavaScript-based library.

⬗ Looking at the popularity of React, few people directly start learning React without much/prior knowledge of JavaScript. Is this a good idea?

⬙ Whichever approach you may take, it's important to know what JavaScript concepts will make your React journey effective and, smoother.

⬖ We will discuss those essential concepts in this thread.

📋 JavaScript Essentials for React

➊ Basics
➋ String Methods
➌ Array Methods
➍ Array Destructuring
➎ Array Spread
➏ Object Destructuring
➐ Object Spread
➑ Template Literals
➒ ES Modules
➓ APIs & Others
ALL
Swapna Kumar Panda
Swapna Kumar Panda
@swapnakpanda
🌆 60+ CSS Shorthand Properties: Cheat Sheet


💎 Direct Link for High-Resolution Image

If you liked this one, give a ⭐️ to this GitHub repo to support my work.

✧ Direct

What did we cover?

Here are those.

➀ all
➁ background
➂ background-position
➃ font
➄ text-align
➅ text-decoration
➆ text-emphasis
➇ list-style
➈ offset
➉ overflow

➀➀ inset
➀➁ inset-block
➀➂ inset-inline
➀➃ margin
➀➄ margin-block
➀➅ margin-inline
➀➆ padding
➀➇ padding-block
➀➈ padding-inline
20. overscroll-behavior
➁➀ scroll-margin
➁➁ scroll-padding

➁➂ border
➁➃ border-top
➁➄ border-right
➁➅ border-bottom
➁➆ border-left
➁➇ border-block
➁➈ border-block-start
30. border-block-end
➂➀ border-inline
➂➁ border-inline-start
➂➂ border-inline-end
CATAGORY JEE
Swapna Kumar Panda
Swapna Kumar Panda
@swapnakpanda
75+ SQL Interview Questions

⇩

Level: Beginner to Medium
Topics:

➊ Introduction to RDBMS
➋ Normalisation
➌ Introduction to SQL
➍ Tables and Fields
➎ Constraints
➏ DDL
➐ DML & DQL
➑ Joins

➊ Introduction to RDBMS

➀ What is a Database?
➁ What are different types of Databases?
➂ What is DBMS?
➃ What is difference between Database and DBMS?
➄ What is RDBMS?
➅ Which are popular RDBMS vendors?
➆ What is ACID property in Database?

➋ Normalisation

➀ What is Normalisation?
➁ Why is Normalisation necessary?
➂ What are the disadvantages of not performing Normalisation?
➃ What are different Normal Forms (NF)?
➄ What is Denormalisation?

➌ Introduction to SQL

➀ What is SQL?
➁ What is the use of SQL?
➂ Is SQL a programming language?
➃ What are the different parts of SQL?
Or,
➄ Group SQL commands in different parts.
➅ What is DDL?
➆ What is DML?
➇ What is DQL?
➈ What is DCL?
➉ What is TCL?
WEBDEV

You May Also Like

Anu Satheesh \U0001f1ee\U0001f1f3
Anu Satheesh 🇮🇳...
@AnuSatheesh5
Bhoga Lakshmi Narasimha Swamy Temple
#Devarayanadurga
#Karnatakatemples 🚩

Bhoga Yoga Narasimha Swamy Temple, Devarayanadurga is located near Tumkur of Karnataka. There are two temples are here for Narasimha Swamy, one is at the base of the hill which is Bhoga Narasimhar and 👇


the other on the top of  hill which is Yoga Narasimhar.

Bhoga Narasimha swamy Temple Prathista is said to be done by Maharshi Durvasa who did tapasya here. While doing tapasya Muni wished to bath in river Ganga and decided to travel to Ganga river bank,


At that time Ganga Devi appeared here and said she will remain here in the temple pond.

Yoga Narasimha swamy Prathista is believed to be done by Bhrama Deva who did tapasya here for many years.


Narasimhar appeared with Lakshmi Devi here to give darshan to Bhrama Deva here.

उग्रं वीरं महाविष्णुं ज्वलन्तं सर्वतोमुखम्।
नृसिंहं भीषणं भद्रं मृत्युमृत्युं नमाम्यहम् ॥

Om Shri Narasimha Murthaye Namah
🙏🕉🙏
ALL
David Rothkopf
David Rothkopf
@djrothkopf
Trump on climate: I don't believe it. Trump on Khashoggi: I don't believe it. Trump on Russia: I don't believe it. Idiocy? A canny game? Doesn't really matter as much as the underlying intellectual autocracy. In this administration only one opinion matters.

It's an assault on facts and reason. It's an assault on good governance. It's an assault on the bureaucracies that are being discounted. It's an assault on science and history. But it is also an assault on one of the underpinnings of democracy.

We live in a system that is grounded on the idea of collaborative government. Leaders may have a final word but even then, there are typically checks and balances. Hopefully, in this case, such checks and balances may work. But they also are being tested.

The president's position that he is smarter than all the world's scientists, than the entire intelligence community, than experts who have studied any issue all their lives, is, of course, asinine. But his belief that government turns solely on his opinion, is monarchic.

Louis XIV reportedly said, "L'etat est moi." That he was the state. Trump asserting that he knows better than all, discounts all advice, that his brain is enough to chart the course for America alone, is essentially saying the same thing.
POLITICS
Advertisement
Tinker \u274e
Tinker ❎
@TinkerSec
Singing the Blues:
Taking Down an Insider Threat

"I had all of the advantages. I was already inside the network. No one suspected me. But they found my hack, kicked me off the network...

...and physically hunted me down."


Many pentests start from the outside, wanting to see how the perimeter might be breached.

This pentest started from the inside. My client wanted to assume they had already been breached, and, if breached, how far could an attacker go.

Could they stop me once I was inside?

So they snuck me in. Disguised me as a new employee. Gave me a work computer, an ID badge, an account in their system... hell, I even had a cubicle w/my assumed name on it.

The only person who knew who I really was was their CISO. Everyone else thought I was Jeremy in Marketing.

During most of the first morning, I completed onboarding, made introductions, and completed menial tasks.

But I had to act quick. I only had a week onsite. I had to hack their network while not raising suspicion.

So I set about it.

You have to understand... most "Internal Pentests" are straight forward. The hard part is breaching the network, but once you're inside, it's a target rich environment. End of Life computers, default passwords, everyone a Local Administrator...
TECH
\u0b85\u0bb8\u0bcd\u0ba4\u0bbf\u0ba9\u0bbe\u0baa\u0bc1\u0bb0\u0ba4\u0bcd\u0ba4\u0bc1 \u0b85\u0bb0\u0b9a\u0bbf\U0001f478
அஸ்தினாபுரத்து அரசி👸...
@SivaRoobini555
#தினம்_ஒரு_திருவாசகம்
தொல்லை இரும்பிறவிச் சூழும் தளை நீக்கி
அல்லல் அறுத்து ஆனந்தம் ஆக்கியதே – எல்லை
மருவா நெறியளிக்கும் வாதவூர் எங்கோன்
திருவாசகம் என்னும் தேன்

பொருள்:
1.எப்போது ஆரம்பித்தது என அறியப்படமுடியாத தொலை காலமாக (தொல்லை)

2. இருந்து வரும் (இரும்)


3.பிறவிப் பயணத்திலே ஆழ்த்துகின்ற (பிறவி சூழும்)

4.அறியாமையாகிய இடரை (தளை)

5.அகற்றி (நீக்கி),

6.அதன் விளைவால் சுகதுக்கமெனும் துயரங்கள் விலக (அல்லல் அறுத்து),

7.முழுநிறைவாய்த் தன்னுளே இறைவனை உணர்த்துவதே (ஆனந்த மாக்கியதே),

8.பிறந்து இறக்கும் காலவெளிகளில் (எல்லை)

9.பிணைக்காமல் (மருவா)

10.காக்கும் மெய்யறிவினைத் தருகின்ற (நெறியளிக்கும்),

11.என் தலைவனான மாணிக்க வாசகரின் (வாதவூரெங்கோன்)

12.திருவாசகம் எனும் தேன் (திருவா சகமென்னுந் தேன்)

முதல்வரி: பிறவி என்பது முன்வினை விதையால் முளைப்பதோர் பெருமரம். அந்த ‘முன்வினை’ எங்கு ஆரம்பித்தது எனச் சொல்ல இயலாது. ஆனால் ‘அறியாமை’ ஒன்றே ஆசைக்கும்,, அச்சத்துக்கும் காரணம் என்பதால், அவையே வினைகளை விளைவிப்பன என்பதால், தொடர்ந்து வரும் பிறவிகளுக்கு, ‘அறியாமையே’ காரணம்

அறியாமைக்கு ஆரம்பம் கிடையாது. நமக்கு ஒரு பொருளைப் பற்றிய அறிவு எப்போதிருந்து இல்லை? அதைச் சொல்ல முடியாது. அதனாலேதான் முதலடியில், ஆரம்பமில்லாத அஞ்ஞானத்தை பிறவிகளுக்குக் காரணமாகச் சொல்லியது. ஆனால் அறியாமை, அறிவின் எழுச்சியால், அப்போதே முடிந்து விடும்.
ALL
Tom Hirst
Tom Hirst
@tom_hirst
How to create a freelancing website that makes money.

Everything I've learned.

A thread.

As a freelancer,

Your website is everything.

First, prioritise its existence.

Second, prioritise its improvement.

The technology you use is irrelevant.

- WordPress
- Notion
- Carrd
- Wix

It doesn't matter which you choose,

What matters is you have a website.

Pick a platform that you're comfortable with.

If you can:

- Capture leads
- Add content easily
- Have a clear design

You're good.

If your website doesn't get leads,

It's not working.

Don't rest on a website that doesn't work for you.

Improve it until it does.
STARTUPS