Topics:
➊ Introduction to RDBMS
➋ Normalisation
➌ Introduction to SQL
➍ Tables and Fields
➎ Constraints
➏ DDL
➐ DML & DQL
➑ Joins
75+ SQL Interview Questions
⇩
Topics:
➊ Introduction to RDBMS
➋ Normalisation
➌ Introduction to SQL
➍ Tables and Fields
➎ Constraints
➏ DDL
➐ DML & DQL
➑ Joins
➀ 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?
➀ What is Normalisation?
➁ Why is Normalisation necessary?
➂ What are the disadvantages of not performing Normalisation?
➃ What are different Normal Forms (NF)?
➄ What is Denormalisation?
➀ 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?
➀ What is a Table?
➁ What is a field in a Table?
➂ Write a SQL command to create a Table.
➃ How to change the name of a Table?
➄ How to truncate a table?
➅ How to drop a table?
➀ What is a constraint?
➁ What are different levels of constraints?
➂ Give examples of various constraints?
➃ What is a primary key?
➄ What is a unique key?
➆ What is a foreign key?
➇ What is NULL value?
➈ What is NOT NULL constraint?
➉ Is blank space or Zero (0) same as NULL?
➀ Give some examples of DDL commands
➁ Write the syntax of creating a table
➂ How to specify the default value for a column?
➃ How to specify a foreign key?
➄ How to specify a unique key?
➅ How to specify multiple columns as the primary key?
➇ How to create a copy of a table? (both structure and, data)
➈ You have 'n' tables and asked to create a separate table which will contain a few columns from these tables with data being copied.
➀➀ Difference between ALTER and RENAME
➀➁ Can a previously nullable column be altered to a NOT NULL column? If yes, explain the steps.
➀ How to insert rows into a table?
➁ What are different syntaxes for inserting records into a table?
➂ What is the syntax to insert multiple records at a time?
➃ How to update data in a table?
➄ How to delete a row in a table?
➆ Explain how DML operations are performed on a View.
Or,
➇ Are Views used only for SELECT queries?
➈ How to fetch rows of a table?
➉ What is a query condition? How to write it in SQL?
➀➀ How to sort the fetched records?
➀➂ How to find how many records are being fetched?
➀➃ How to find the maximum and minimum value for a field in fetched records?
➀➄ How to sum values in a field for all records?
➀ What is a join in SQL?
➁ What are the different types of joins?
➂ What is Inner Join?
➃ What is Left Outer Join?
➄ What is Right Outer Join?
➅ What is Full Outer Join?
➆ What is Cross Join?
➈ What is Equi Join?
➉ What is Natural Join?
➀➀ Given a query in Cross Join, convert it into an Inner Join.
➀➁ Given a query in Right Outer Join, convert it into a Left Outer Join.
Or,
➀➃ What is required to convert an Inner Join into an Equi Join?
➀➄ What should be taken care of to improve the performance of queries containing Joins.
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.
More from Webdev
23 FREE SVG Icon Libraries For Front-End Developers
Mega Thread 🧵👇
1️⃣ Ionicons: The premium icon pack for Ionic Framework
Ionicons is an open-sourced and MIT-licensed icon pack.
2️⃣ 700+ CSS Icons, Customizable, Retina Ready & API
Pure CSS icons library, Customizable & Retina-Ready built 100% in pure CSS, SVG, SVG Sprite, styled components, Figma, and Adobe XD. Easy integration: Embed, NPM & API
3️⃣ SVG Repo - Free SVG Vectors and Icons
Free Vectors and Icons in SVG format. Download free mono or multi-color vectors for commercial use. Search in 300.000+ Free SVG Vectors and Icons.
https://t.co/2Ht2sI23TE
4️⃣ Feather – Simply beautiful open source icons
Feather is a collection of simply beautiful open source icons. Each icon is designed on a 24x24 grid with an emphasis on simplicity, consistency, and readability.
Mega Thread 🧵👇
1️⃣ Ionicons: The premium icon pack for Ionic Framework
Ionicons is an open-sourced and MIT-licensed icon pack.
2️⃣ 700+ CSS Icons, Customizable, Retina Ready & API
Pure CSS icons library, Customizable & Retina-Ready built 100% in pure CSS, SVG, SVG Sprite, styled components, Figma, and Adobe XD. Easy integration: Embed, NPM & API
3️⃣ SVG Repo - Free SVG Vectors and Icons
Free Vectors and Icons in SVG format. Download free mono or multi-color vectors for commercial use. Search in 300.000+ Free SVG Vectors and Icons.
https://t.co/2Ht2sI23TE
4️⃣ Feather – Simply beautiful open source icons
Feather is a collection of simply beautiful open source icons. Each icon is designed on a 24x24 grid with an emphasis on simplicity, consistency, and readability.
You May Also Like
Trending news of The Rock's daughter Simone Johnson's announcing her new Stage Name is breaking our Versus tool because "Wrestling Name" isn't in our database!
Here's the most useful #Factualist comparison pages #Thread 🧵
What is the difference between “pseudonym” and “stage name?”
Pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie stars,” while stage name is “the pseudonym of an entertainer.”
https://t.co/hT5XPkTepy #english #wiki #wikidiff
People also found this comparison helpful:
Alias #versus Stage Name: What’s the difference?
Alias means “another name; an assumed name,” while stage name means “the pseudonym of an entertainer.”
https://t.co/Kf7uVKekMd #Etymology #words
Another common #question:
What is the difference between “alias” and “pseudonym?”
As nouns alias means “another name; an assumed name,” while pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie
Here is a very basic #comparison: "Name versus Stage Name"
As #nouns, the difference is that name means “any nounal word or phrase which indicates a particular person, place, class, or thing,” but stage name means “the pseudonym of an
Here's the most useful #Factualist comparison pages #Thread 🧵
What is the difference between “pseudonym” and “stage name?”
Pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie stars,” while stage name is “the pseudonym of an entertainer.”
https://t.co/hT5XPkTepy #english #wiki #wikidiff
People also found this comparison helpful:
Alias #versus Stage Name: What’s the difference?
Alias means “another name; an assumed name,” while stage name means “the pseudonym of an entertainer.”
https://t.co/Kf7uVKekMd #Etymology #words
Another common #question:
What is the difference between “alias” and “pseudonym?”
As nouns alias means “another name; an assumed name,” while pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie
Here is a very basic #comparison: "Name versus Stage Name"
As #nouns, the difference is that name means “any nounal word or phrase which indicates a particular person, place, class, or thing,” but stage name means “the pseudonym of an
