⛳️SQL CLAUSES:
SQL clause helps us to retrieve a set or bundles of records from the table.
SQL clause helps us to specify a condition on the columns or the records of a table.
There are generally five kinds of SQL Clauses . They are listed as follows:
1-WHERE Clause
2-ORDER BY clause
3-HAVING Clause
4-TOP Clause
5-GROUP BY Clause
1. SQL WHERE Clause:
we use the SQL SELECT statement to select data from a table in the database. Here, the WHERE clause allows filtering certain records that exactly match a specified condition. Thus, it helps us to fetch only the necessary data from the database that satisfies the given expressional conditions. The WHERE clause is used with SELECT statement as well as with UPDATE, DELETE type statements and aggregate functions to restrict the no. of records to be retrieved by the table. We can also use logical or comparison operators such as LIKE,<,>,=, etc. with WHERE clause to fulfill certain conditions.
Query:
SELECT BookName, Price, Lang From Books WHERE CatID >1;
2. SQL ORDER BY Clause:
The ORDER BY clause is used in SQL for sorting records. It is used to arrange the result set either in ascending or descending order. When we query using SELECT statement the result is not in an ordered form. Hence, the result rows can be sorted when we combine the SELECT statement with the ORDER BY clause.
Query:
SELECT BookName, Price From Books ORDER BY Price ASC;
3. SQL GROUP BY Clause:
The GROUP BY clause is used to group rows that have the same values in the result set. Like if we find the names of books from the table grouped by CatID.
Query:
SELECT COUNT(BookName), CatID From Books GROUP BY CatID;
This clause is generally used with aggregate functions that allow grouping the query result rows by multiple columns. The aggregate functions are COUNT, MAX, MIN, SUM, AVG, etc.
4. SQL HAVING Clause:
Actually, this clause is introduced to apply functions in the query with the WHERE clause. In SQL, the HAVING clause was added because the WHERE clause could not be applied with aggregate functions.
Query:
SELECT COUNT (CatID), Lang From Books GROUP BY Lang HAVING COUNT(CATID) <3;
5. SQL TOP Clause:
The TOP clause is used to determine the number of record rows to be shown in the result. This TOP clause is used with SELECT statement specially implemented on large tables with many records. But the clause is not supported in many database systems, like MySQL supports the LIMIT clause to select limited no. of rows and in Oracle ROWNUM is used.
Query:
SELECT TOP 3 * FROM Books;
SELECT * FROM Books LIMIT 3;
SELECT * FROM Books WHERE ROWNUM <= 3;
SQL clause helps us to retrieve a set or bundles of records from the table.
SQL clause helps us to specify a condition on the columns or the records of a table.
There are generally five kinds of SQL Clauses . They are listed as follows:
1-WHERE Clause
2-ORDER BY clause
3-HAVING Clause
4-TOP Clause
5-GROUP BY Clause
1. SQL WHERE Clause:
we use the SQL SELECT statement to select data from a table in the database. Here, the WHERE clause allows filtering certain records that exactly match a specified condition. Thus, it helps us to fetch only the necessary data from the database that satisfies the given expressional conditions. The WHERE clause is used with SELECT statement as well as with UPDATE, DELETE type statements and aggregate functions to restrict the no. of records to be retrieved by the table. We can also use logical or comparison operators such as LIKE,<,>,=, etc. with WHERE clause to fulfill certain conditions.
Query:
SELECT BookName, Price, Lang From Books WHERE CatID >1;
2. SQL ORDER BY Clause:
The ORDER BY clause is used in SQL for sorting records. It is used to arrange the result set either in ascending or descending order. When we query using SELECT statement the result is not in an ordered form. Hence, the result rows can be sorted when we combine the SELECT statement with the ORDER BY clause.
Query:
SELECT BookName, Price From Books ORDER BY Price ASC;
3. SQL GROUP BY Clause:
The GROUP BY clause is used to group rows that have the same values in the result set. Like if we find the names of books from the table grouped by CatID.
Query:
SELECT COUNT(BookName), CatID From Books GROUP BY CatID;
This clause is generally used with aggregate functions that allow grouping the query result rows by multiple columns. The aggregate functions are COUNT, MAX, MIN, SUM, AVG, etc.
4. SQL HAVING Clause:
Actually, this clause is introduced to apply functions in the query with the WHERE clause. In SQL, the HAVING clause was added because the WHERE clause could not be applied with aggregate functions.
Query:
SELECT COUNT (CatID), Lang From Books GROUP BY Lang HAVING COUNT(CATID) <3;
5. SQL TOP Clause:
The TOP clause is used to determine the number of record rows to be shown in the result. This TOP clause is used with SELECT statement specially implemented on large tables with many records. But the clause is not supported in many database systems, like MySQL supports the LIMIT clause to select limited no. of rows and in Oracle ROWNUM is used.
Query:
SELECT TOP 3 * FROM Books;
SELECT * FROM Books LIMIT 3;
SELECT * FROM Books WHERE ROWNUM <= 3;
👍1
🔥𝐒𝐎𝐑𝐓𝐈𝐍𝐆 𝐀𝐋𝐆𝐎𝐑𝐈𝐓𝐇𝐌𝐒 𝐂𝐎𝐌𝐏𝐋𝐄𝐗𝐈𝐓𝐘 𝐂𝐇𝐄𝐀𝐓𝐒𝐇𝐄𝐄𝐓🚀
Excited to share this handy cheatsheet on Sorting Algorithms' Time Complexity! 🔍 Whether you're a coding enthusiast or a tech professional, understanding sorting algorithms' efficiency is key.⚡️ Here's a quick reference guide to help you navigate through different algorithms and their time complexitie.🙌
📝 Here's a detailed cheatsheet to help you grasp the time complexities of various sorting algorithms:
📌 𝗕𝘂𝗯𝗯𝗹𝗲 𝗦𝗼𝗿𝘁 🫧
🔹Best Case: O(n)
🔹Average Case: O(n^2)
🔹Worst Case: O(n^2)
📌 𝗜𝗻𝘀𝗲𝗿𝘁𝗶𝗼𝗻 𝗦𝗼𝗿𝘁 💥
🔹Best Case: O(n)
🔹Average Case: O(n^2)
🔹Worst Case: O(n^2)
📌 𝗦𝗲𝗹𝗲𝗰𝘁𝗶𝗼𝗻 𝗦𝗼𝗿𝘁 ✅
🔹Best Case: O(n^2)
🔹Average Case: O(n^2)
🔹Worst Case: O(n^2)
📌 𝗠𝗲𝗿𝗴𝗲 𝗦𝗼𝗿𝘁 🤝
🔹Best Case: O(n log n)
🔹Average Case: O(n log n)
🔹Worst Case: O(n log n)
📌 𝗤𝘂𝗶𝗰𝗸 𝗦𝗼𝗿𝘁 ⚡️
🔹Best Case: O(n log n)
🔹Average Case: O(n log n)
🔹Worst Case: O(n^2)
📌 𝗛𝗲𝗮𝗽 𝗦𝗼𝗿𝘁 📚
🔹Best Case: O(n log n)
🔹Average Case: O(n log n)
🔹Worst Case: O(n log n)
📌 𝗥𝗮𝗱𝗶𝘅 𝗦𝗼𝗿𝘁 💫
🔹Best Case: O(nk)
🔹Average Case: O(nk)
🔹Worst Case: O(nk)
📌 𝗖𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝗦𝗼𝗿𝘁 📊
🔹Best Case: O(n + k)
🔹Average Case: O(n + k)
🔹Worst Case: O(n + k)
📌 𝗕𝘂𝗰𝗸𝗲𝘁 𝗦𝗼𝗿𝘁 🪣
🔹Best Case: O(n + k)
🔹Average Case: O(n + k)
🔹Worst Case: O(n^2)
📌 𝗖𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝗦𝗼𝗿𝘁 📊
🔹Best Case: O(n + k)
🔹Average Case: O(n + k)
🔹Worst Case: O(n + k)
📚Remember, each algorithm has its strengths and weaknesses. Depending on the size of your data and the specific use case, you can choose the most suitable sorting algorithm to ensure efficient code execution.💫
Excited to share this handy cheatsheet on Sorting Algorithms' Time Complexity! 🔍 Whether you're a coding enthusiast or a tech professional, understanding sorting algorithms' efficiency is key.⚡️ Here's a quick reference guide to help you navigate through different algorithms and their time complexitie.🙌
📝 Here's a detailed cheatsheet to help you grasp the time complexities of various sorting algorithms:
📌 𝗕𝘂𝗯𝗯𝗹𝗲 𝗦𝗼𝗿𝘁 🫧
🔹Best Case: O(n)
🔹Average Case: O(n^2)
🔹Worst Case: O(n^2)
📌 𝗜𝗻𝘀𝗲𝗿𝘁𝗶𝗼𝗻 𝗦𝗼𝗿𝘁 💥
🔹Best Case: O(n)
🔹Average Case: O(n^2)
🔹Worst Case: O(n^2)
📌 𝗦𝗲𝗹𝗲𝗰𝘁𝗶𝗼𝗻 𝗦𝗼𝗿𝘁 ✅
🔹Best Case: O(n^2)
🔹Average Case: O(n^2)
🔹Worst Case: O(n^2)
📌 𝗠𝗲𝗿𝗴𝗲 𝗦𝗼𝗿𝘁 🤝
🔹Best Case: O(n log n)
🔹Average Case: O(n log n)
🔹Worst Case: O(n log n)
📌 𝗤𝘂𝗶𝗰𝗸 𝗦𝗼𝗿𝘁 ⚡️
🔹Best Case: O(n log n)
🔹Average Case: O(n log n)
🔹Worst Case: O(n^2)
📌 𝗛𝗲𝗮𝗽 𝗦𝗼𝗿𝘁 📚
🔹Best Case: O(n log n)
🔹Average Case: O(n log n)
🔹Worst Case: O(n log n)
📌 𝗥𝗮𝗱𝗶𝘅 𝗦𝗼𝗿𝘁 💫
🔹Best Case: O(nk)
🔹Average Case: O(nk)
🔹Worst Case: O(nk)
📌 𝗖𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝗦𝗼𝗿𝘁 📊
🔹Best Case: O(n + k)
🔹Average Case: O(n + k)
🔹Worst Case: O(n + k)
📌 𝗕𝘂𝗰𝗸𝗲𝘁 𝗦𝗼𝗿𝘁 🪣
🔹Best Case: O(n + k)
🔹Average Case: O(n + k)
🔹Worst Case: O(n^2)
📌 𝗖𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝗦𝗼𝗿𝘁 📊
🔹Best Case: O(n + k)
🔹Average Case: O(n + k)
🔹Worst Case: O(n + k)
📚Remember, each algorithm has its strengths and weaknesses. Depending on the size of your data and the specific use case, you can choose the most suitable sorting algorithm to ensure efficient code execution.💫
👉What is Database Management System?
Data:
"Collection of quantitative and qualitative variables is known as data".
Type of Data:
1-Raw Data
2-Processed data(Information)
👉What is DBMS?
DBMS consist of two parts
1-Data base
2-Management System.
Database is a collection of interrelated files and the basic management operations are
Searching,
Addition,
Deletion,
Updation,
A DBMS consist of collection of related data and a set of programs to access and manipulate those data.
"The database management system is a general purpose software system that facilitates the process of defining, constructing, manipulating and sharing database among, various user and application".
The primary objective of DBMS is to provides an environment that is convenient and efficient to use in retrieving and storing data in database. The DBMS should use minimum set of computing resources to provides maximum throughout.
Basic terminology of DBMS .
🥇Field:
"fields are in the form of rows".
🥇Records:
"Data organized in meaningful way to known as Records".
🥇File:
"Collection of similar records is known as file".
🥇Database:
"collection of interrelated files is called database".
following are basic facilities provided by DBMS.
⚡creation,
⚡insertion,
⚡deletion,
⚡modification and
⚡retrieval,
⚡protecting of data and ⚡maintaining integrity,
⚡report generation,
⚡mathematical operation.
Subscribe my channel
👉@CoderBaba
https://www.youtube.com/coderbaba
Data:
"Collection of quantitative and qualitative variables is known as data".
Type of Data:
1-Raw Data
2-Processed data(Information)
👉What is DBMS?
DBMS consist of two parts
1-Data base
2-Management System.
Database is a collection of interrelated files and the basic management operations are
Searching,
Addition,
Deletion,
Updation,
A DBMS consist of collection of related data and a set of programs to access and manipulate those data.
"The database management system is a general purpose software system that facilitates the process of defining, constructing, manipulating and sharing database among, various user and application".
The primary objective of DBMS is to provides an environment that is convenient and efficient to use in retrieving and storing data in database. The DBMS should use minimum set of computing resources to provides maximum throughout.
Basic terminology of DBMS .
🥇Field:
"fields are in the form of rows".
🥇Records:
"Data organized in meaningful way to known as Records".
🥇File:
"Collection of similar records is known as file".
🥇Database:
"collection of interrelated files is called database".
following are basic facilities provided by DBMS.
⚡creation,
⚡insertion,
⚡deletion,
⚡modification and
⚡retrieval,
⚡protecting of data and ⚡maintaining integrity,
⚡report generation,
⚡mathematical operation.
Subscribe my channel
👉@CoderBaba
https://www.youtube.com/coderbaba
🎯 𝐅𝐫𝐨𝐧𝐭𝐞𝐧𝐝 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐦𝐞𝐧𝐭 𝐒𝐤𝐢𝐥𝐥𝐬 𝐟𝐨𝐫 𝐏𝐫𝐨𝐝𝐮𝐜𝐭 𝐁𝐚𝐬𝐞𝐝 𝐂𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 🔥
✅ A roadmap is the best way to kick-start your attempt to become a front-end developer.
📌 𝗕𝗮𝘀𝗶𝗰 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. Data types
2. Functions
3. Scope in JavaScript
4. Closure
5. Event loop
6. Prototype and prototype chain
7. Class and inheritance
8. DOM
9. bind/call/apply
10. Promise
11. WebAPI
12. Task queue
13. Call stack
14. Async/await
15. Generators
16. Typescript
📌 𝗕𝗮𝘀𝗶𝗰 𝗛𝗧𝗠𝗟 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. block element
2. import
3. etc - infinite questions
📌 𝗕𝗮𝘀𝗶𝗰 𝗖𝗦𝗦 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. Class and other selectors
2. Pseudo Classes
3. Box Model
4. Pseudo Elements
5. CSS type - flex, grid, normal
6. How to center
7. pseudo classes and elements
8. All element states - active, hover
9. Media queries
10. Pre-processors - SCSS or LESS
1. mixins
11. CSS constants
12. BEM
13. Import
📌 𝗕𝗮𝘀𝗶𝗰 𝗪𝗲𝗯 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. Page rendering cycle
2. HTTP / HTTPS / https2
3. CORS
4. Local storage/Session storage
5. Cookie
6. JWT
7. XHR
8. Micro Frontend
9. REST/GraphQL/Socket connection
10. Browser Concepts
11. Debugging Application
12. Chrome Dev Tool Features
📌 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. OOPs concept
2. Design Patterns
a. Singleton
b. Provider
c. Prototype
d. Observer
e. Module
f. HOC
3. Understanding V8 in-depth
a. JIT
b. Interpreter
c. Execution
d. Compiler
4. Currying
📌 𝗕𝗮𝘀𝗶𝗰 𝗥𝗲𝗮𝗰𝘁𝗝𝗦 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀 (bonus): -
1. Introduction JSX
2. React Component
3. Component State and Props
4. Adding Style (CSS)
5. Functional and Class components
6. React Lifecycle Methods
7. Virtual DOM
8. React Hooks
9. Custom Hooks
10. Context API
11. Synthetic Events
12. Routing
13. Data Flow (Redux/Flux)
14. Server-Side Rendering
15. Unit Testing
16. Jest & React Testing Library
17. Mocking Data
18. Understanding Webpack (Bundler)
19. Babel, env, prettier, linter
Follow @coder_baba
✅ A roadmap is the best way to kick-start your attempt to become a front-end developer.
📌 𝗕𝗮𝘀𝗶𝗰 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. Data types
2. Functions
3. Scope in JavaScript
4. Closure
5. Event loop
6. Prototype and prototype chain
7. Class and inheritance
8. DOM
9. bind/call/apply
10. Promise
11. WebAPI
12. Task queue
13. Call stack
14. Async/await
15. Generators
16. Typescript
📌 𝗕𝗮𝘀𝗶𝗰 𝗛𝗧𝗠𝗟 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. block element
2. import
3. etc - infinite questions
📌 𝗕𝗮𝘀𝗶𝗰 𝗖𝗦𝗦 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. Class and other selectors
2. Pseudo Classes
3. Box Model
4. Pseudo Elements
5. CSS type - flex, grid, normal
6. How to center
7. pseudo classes and elements
8. All element states - active, hover
9. Media queries
10. Pre-processors - SCSS or LESS
1. mixins
11. CSS constants
12. BEM
13. Import
📌 𝗕𝗮𝘀𝗶𝗰 𝗪𝗲𝗯 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. Page rendering cycle
2. HTTP / HTTPS / https2
3. CORS
4. Local storage/Session storage
5. Cookie
6. JWT
7. XHR
8. Micro Frontend
9. REST/GraphQL/Socket connection
10. Browser Concepts
11. Debugging Application
12. Chrome Dev Tool Features
📌 𝗔𝗱𝘃𝗮𝗻𝗰𝗲𝗱 𝗝𝗮𝘃𝗮𝗦𝗰𝗿𝗶𝗽𝘁 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀:
1. OOPs concept
2. Design Patterns
a. Singleton
b. Provider
c. Prototype
d. Observer
e. Module
f. HOC
3. Understanding V8 in-depth
a. JIT
b. Interpreter
c. Execution
d. Compiler
4. Currying
📌 𝗕𝗮𝘀𝗶𝗰 𝗥𝗲𝗮𝗰𝘁𝗝𝗦 𝗖𝗼𝗻𝗰𝗲𝗽𝘁𝘀 (bonus): -
1. Introduction JSX
2. React Component
3. Component State and Props
4. Adding Style (CSS)
5. Functional and Class components
6. React Lifecycle Methods
7. Virtual DOM
8. React Hooks
9. Custom Hooks
10. Context API
11. Synthetic Events
12. Routing
13. Data Flow (Redux/Flux)
14. Server-Side Rendering
15. Unit Testing
16. Jest & React Testing Library
17. Mocking Data
18. Understanding Webpack (Bundler)
19. Babel, env, prettier, linter
Follow @coder_baba
🧞♂How to Create Resume using ChatGPT
1. Gather Information: Before you start, collect all the necessary information for your resume, including your contact details, work experience, education, skills, and achievements.
2. Use ChatGPT for Content Generation:
- Begin by specifying the role or field you're targeting. For example, "I am seeking a [job title] position."
- Ask ChatGPT for help in creating content for your resume. For instance, "Can you provide a summary of my work experience?" or "Please list my skills and achievements related to [specific skill or project]."
3. Proofread and Edit: ChatGPT can generate content, but it might not always be perfect. Make sure to carefully review and edit the generated text for accuracy, clarity, and conciseness.
4. Resume Structure:
- Ensure your resume follows a standard structure, with sections for Contact Information, Summary or Objective, Work Experience, Education, Skills, and Additional Sections (e.g., certifications, awards, projects).
- Use bullet points to make information concise and easy to read.
5. Contact Information:
- Include your full name, phone number, email address, and LinkedIn profile (if applicable).
6. Summary or Objective:
- Craft a brief, impactful summary or objective statement highlighting your career goals and what you can bring to the role.
7. Work Experience:
- List your work experience in reverse chronological order (most recent job first).
- For each position, include the job title, company name, location, dates of employment, and a concise description of your key responsibilities and accomplishments.
8. Education:
- Include your educational background, listing degrees, institutions, dates, and any relevant honors.
9. Skills:
- Enumerate your skills, such as technical, soft skills, or certifications.
10. Additional Sections:
- Depending on your background, you might add sections for certifications, awards, volunteer work, or projects.
11. Formatting:
- Ensure consistent font, size, and formatting throughout the document.
- Use a professional and easily readable font.
12. Save and Share: Save your resume in a common format like PDF, which preserves formatting. You can then share it with potential employers.
Don't limit yourself to completing it solely through automated tools. Feel free to infuse your own variations and personal touch. Your individuality and creativity are what will truly make you stand out in the job market. Additionally, consider seeking feedback from professionals or a career counselor to further refine your resume.
Join @coder_baba for more free tips
ENJOY LEARNING 👍👍
1. Gather Information: Before you start, collect all the necessary information for your resume, including your contact details, work experience, education, skills, and achievements.
2. Use ChatGPT for Content Generation:
- Begin by specifying the role or field you're targeting. For example, "I am seeking a [job title] position."
- Ask ChatGPT for help in creating content for your resume. For instance, "Can you provide a summary of my work experience?" or "Please list my skills and achievements related to [specific skill or project]."
3. Proofread and Edit: ChatGPT can generate content, but it might not always be perfect. Make sure to carefully review and edit the generated text for accuracy, clarity, and conciseness.
4. Resume Structure:
- Ensure your resume follows a standard structure, with sections for Contact Information, Summary or Objective, Work Experience, Education, Skills, and Additional Sections (e.g., certifications, awards, projects).
- Use bullet points to make information concise and easy to read.
5. Contact Information:
- Include your full name, phone number, email address, and LinkedIn profile (if applicable).
6. Summary or Objective:
- Craft a brief, impactful summary or objective statement highlighting your career goals and what you can bring to the role.
7. Work Experience:
- List your work experience in reverse chronological order (most recent job first).
- For each position, include the job title, company name, location, dates of employment, and a concise description of your key responsibilities and accomplishments.
8. Education:
- Include your educational background, listing degrees, institutions, dates, and any relevant honors.
9. Skills:
- Enumerate your skills, such as technical, soft skills, or certifications.
10. Additional Sections:
- Depending on your background, you might add sections for certifications, awards, volunteer work, or projects.
11. Formatting:
- Ensure consistent font, size, and formatting throughout the document.
- Use a professional and easily readable font.
12. Save and Share: Save your resume in a common format like PDF, which preserves formatting. You can then share it with potential employers.
Don't limit yourself to completing it solely through automated tools. Feel free to infuse your own variations and personal touch. Your individuality and creativity are what will truly make you stand out in the job market. Additionally, consider seeking feedback from professionals or a career counselor to further refine your resume.
Join @coder_baba for more free tips
ENJOY LEARNING 👍👍