Shalini Tewari Profile picture
Software, full stack developer | Simplifying web development and programming for you 🚀
Kolusu_Trinadh Profile picture 1 subscribed
Jun 12 7 tweets 2 min read
How to present your personal projects in an interview the right way: 1. Start with a Clear Introduction:
Begin by introducing your project in a concise and engaging manner. Clearly state the problem you aimed to solve or the goal you wanted to achieve with your project.

Eg: "Thank you for the opportunity to discuss my project. I developed a [name & motive] "
Jun 11 4 tweets 3 min read
Strings and Conditional Statements in JavaScript explained:

Day 13 of #60daysofMERN Strings:

Strings are a sequence of characters used to represent text. Strings can be created using single quotes ('), double quotes ("), or backticks (`) for template literals.

Creating String:
// Using single quotes
let singleQuoteString = 'Hello, World!';

// Using double quotes
let doubleQuoteString = "Hello, World!";

// Using backticks (template literals)
let templateLiteralString = `Hello, World!`;

Common String Methods:

1. length: Returns the length of the string.

2. charAt(index): Returns the character at the specified index.

3. charCodeAt(index): Returns the Unicode of the character at the specified index.

4. concat(...strings): Combines the text of two or more strings and returns a new string.

5. includes(searchString, position): Checks if the string contains the specified string.

6. endsWith(searchString, length): Checks if the string ends with the specified string.

7. indexOf(searchValue, fromIndex): Returns the position of the first occurrence of a specified value in a string.

8. lastIndexOf(searchValue, fromIndex): Returns the position of the last occurrence of a specified value in a string.

9. match(regexp): Searches a string for a match against a regular expression.

10. repeat(count): Returns a new string with a specified number of copies of the original string.

11. replace(searchValue, newValue): Searches for a specified value and replaces it with a new value.

12. search(regexp): Searches a string for a match against a regular expression and returns the index of the match.

13. slice(beginIndex, endIndex): Extracts a part of a string and returns a new string.

14. split(separator, limit): Splits a string into an array of substrings.

15. startsWith(searchString, position): Checks if the string starts with the specified string.

16. substring(startIndex, endIndex): Extracts the characters from a string between two specified indices.

17. toLowerCase(): Converts the string to lowercase.

18. toUpperCase(): Converts the string to uppercase.

19. toString(): Returns a string representing the specified object.

20. valueOf(): Returns the primitive value of a String object.Image
May 26 5 tweets 1 min read
Got a handle on JavaScript concepts and starting with projects? Here's what to avoid: 1. Read what the console is displaying, especially if you're getting error messages:
Don't ignore the console messages, they're like clues telling you what's wrong with your code. Take a moment to understand them, and you'll fix issues faster.

2. Are you working with the right type of variables? Which is the right choice?
Think of variables like tools. Make sure you're using the right one for the job. Mixing them up can mess things up, so double-check your choices.
May 23 6 tweets 2 min read
Master these Git commands for daily use: Initializing and Cloning Repositories

1. Initialize a New Repository
- git init
Sets up a new Git repository in the current directory by creating a .git subdirectory to store repository metadata.

2. Clone an Existing Repository
- git clone
Makes a local copy of an existing repository, including all its history and branches.
May 14 8 tweets 2 min read
You're in an interview and the interviewer concludes by saying,

"Do you have any questions for us?"

Here is how you can answer: 1. Team Dynamics and Collaboration:

"Could you tell me more about the team dynamics and collaboration within the company?"

- This question shows that you value teamwork and want to understand how teams work together within the company.
- It can provide insights into whether the company encourages collaboration and open communication, or if it operates more independently.
May 10 7 tweets 2 min read
You're in an interview, and the interviewer asks,

"Can you tell me about yourself?"/ "Tell me something about yourself."

Here is how you can answer: 1. Start with a Brief Introduction:

When asked about yourself in an interview, start by giving a brief introduction. Mention your name, where you're from, and a bit about your educational background. Keep it concise and relevant to the job you're applying for.

For example, "My name is [Your Name]. I grew up in [Your City/Town] and recently graduated with a degree in [Your Field]."
May 4 5 tweets 2 min read
Day 6 of #10daysofSQL

Topics covered:
- SQL functions
- Aggregate functions
- LIKE operator What are SQL functions?

SQL functions are predefined operations that can be invoked with specific arguments to perform computations, manipulate data, or return specific results. These functions can be categorized into several types based on their purpose:

1. Scalar Functions: These functions operate on a single value and return a single value.
eg: LEN(), CAST() etc.

2. Aggregate Functions: These functions operate on a set of values and return a single value summarizing that set.
eg: SUM(), AVG() etc.

3. Analytic Functions (Window Functions): These functions perform calculations across a set of rows related to the current row.
eg: ROW_NUMBER() etc.

4. Table-Valued Functions: Unlike scalar functions, table-valued functions return a table as a result. They can accept parameters and perform complex processing to generate the output table.
May 2 4 tweets 2 min read
Day 5 of #10daysofSQL 🚀

Topics covered:
- Data control language
- Transaction control language DCL (Data Control Language)
DCL includes commands such as GRANT and REVOKE which mainly deal with the rights, permissions, and other controls of the database system.

DCL commands:

1. GRANT:
This command gives users access privileges to the database.

Syntax:

GRANT SELECT, UPDATE ON MY_TABLE TO SOME_USER, ANOTHER_USER;

2. REVOKE:
This command withdraws the user’s access privileges given by using the GRANT command.

Syntax:

REVOKE SELECT, UPDATE ON MY_TABLE FROM USER1, USER2;
Apr 22 6 tweets 2 min read
Day 4 of #10daysofSQL 🚀

Topics covered:
- Data manipulation language
- Sorting data with ORDER BY
- Limiting results with LIMIT Data Manipulation Language 🔎

DML (Data Manipulation Language) in SQL is all about managing the data within a database. It includes commands that allow you to interact with the data.

- INSERT:
Adds new rows of data into a table, enabling the addition of new records.

- UPDATE:
Modifies existing data in a table, enabling changes to existing records.

- DELETE:
Removes rows of data from a table, effectively deleting specific records.

These commands form the backbone of interaction with a database's data. They enable querying, addition, modification, and deletion of data within database tables. Their usage is essential for managing and maintaining the data integrity and structure of a database.Image
Apr 21 4 tweets 4 min read
Day 3 of #10daysofSQL 🚀

Topics covered:
- Data definition language
- Filtering data with WHERE clause (AND, OR, IN, BETWEEN)

Data Definition Language in SQL :

DDL (Data Definition Language) commands in SQL are used to define, manage, and manipulate the structure of database objects. These commands handle the creation, modification, and deletion of database objects like tables, indexes, views, etc.

- CREATE:
The CREATE command is used to create new database objects like tables, indexes, views, stored procedures, and more.

Usage:
- CREATE TABLE is used to create a new table with defined columns and data types.

- CREATE INDEX is used to create an index on a table for faster data retrieval.

- CREATE VIEW is used to create a virtual table based on the result-set of a SELECT statement.

- ALTER:
The ALTER command is used to modify existing database objects.

Usage:
- ALTER TABLE allows you to add, modify, or drop columns, constraints, etc., in an existing table.

- ALTER INDEX is used to modify an index (e.g., to add or remove columns from an existing index).

-ALTER VIEW enables you to modify the definition of an existing view.

Changes existing things in the database, such as adding a column to a table.

- DROP:
The DROP command is used to delete database objects.

Usage:
- DROP TABLE is used to delete an entire table and its data.

- DROP INDEX is used to remove an index from a table.

- DROP VIEW deletes a view from the database.

Deletes things, like tables or indexes, entirely from the database.

- TRUNCATE:
The TRUNCATE command removes all records from a table.

Usage:
- Unlike DELETE, TRUNCATE empties a table completely but does not log individual row deletions. It's faster than DELETE for large tables.

Quickly removes all the data from a table, but keeps the table itself.Image Filtering data with WHERE clause (AND, OR, IN, BETWEEN):

1. The Basics of WHERE Clause:

- The WHERE clause acts as a filter, allowing you to selectively retrieve rows from a table based on specified conditions.

- It follows the SELECT statement and precedes any optional clauses like ORDER BY or LIMIT.

- Example: SELECT * FROM employees WHERE department = 'SDE';

2. Using AND for Multiple Conditions:

- The AND operator allows you to combine multiple conditions, ensuring that all conditions must be true for a row to be included in the result set.

- Example: SELECT * FROM products WHERE category = 'Desktop' AND price > 50000;

3. Employing OR for Alternative Conditions:

- The OR operator provides flexibility by allowing you to specify alternative conditions, where only one condition needs to be true for a row to be included in the result set.
- Example: SELECT * FROM customers WHERE country = 'India' OR country = 'Nepal';

4. Using IN for Multiple Values:

- The IN operator simplifies queries with multiple OR conditions, allowing you to specify a list of values to match against a single column.

- Example: SELECT * FROM orders WHERE status IN ('Pending', 'Processing');

5. Leveraging BETWEEN for Range Queries:

- The BETWEEN operator is handy for specifying a range of values for a column, inclusive of both endpoints.
Example: SELECT * FROM employees WHERE salary BETWEEN 50000 AND 80000;
Apr 20 4 tweets 2 min read
Day 2 of #10daysofSQL 🚀

Topics covered:
- Components of SQL
- Retrieving specific columns with SELECT
- Using aliases for column names

Components of SQL:

- Data Definition Language (DDL):
Used for defining and modifying the structure of the database schema.
Includes commands like CREATE, ALTER, DROP, TRUNCATE.

- Data Manipulation Language (DML):
Used for manipulating data within the database.
Includes commands like SELECT, INSERT, UPDATE, DELETE.

- Data Control Language (DCL):
Used for controlling access to data within the database.
Includes commands like GRANT and REVOKE.

- Transaction Control Language (TCL):
Used for managing transactions within the database.
Includes commands like COMMIT, ROLLBACK, SAVEPOINT.

- Data Query Language (DQL):
Primarily used for querying data from the database.
Includes commands like SELECT.Image Retrieving Specific Columns with SELECT:

- The SELECT statement is used to retrieve data from one or more tables in a database.
- You can specify the columns you want to retrieve by listing them after the SELECT keyword.
- Example: SELECT column1, column2 FROM tablename;
- This allows you to retrieve only the relevant data you need, which can improve query performance.

Using Aliases for Column Names:

- Aliases provide alternative names for columns in the result set, making it easier to understand and manipulate the data.
- You can assign aliases using the AS keyword or by simply providing a new name after the column.
- Example: SELECT column1 AS alias1, column2 alias2 FROM tablename;
- Aliases are especially useful when working with calculated fields or when joining tables.
Apr 19 4 tweets 2 min read
Day 1 of #10daysofSQL

Topics covered:
- Introduction to Databases and SQL
- Basic Sql syntax
- Connecting to a sample database

What are Databases?

- Databases are structured collections of data that are organized for efficient storage, retrieval, and manipulation.
- They serve as a central repository for information, allowing users to store and access data in a structured manner.
- Common types of databases include relational databases (e.g., MySQL, PostgreSQL), NoSQL databases (e.g., MongoDB, Cassandra), and object-oriented databases (e.g., MongoDB).

Types of Databases:

- Relational databases: Organize data into tables consisting of rows and columns, with relationships established between tables.

- NoSQL databases: Designed for storing and retrieving unstructured or semi-structured data, offering flexibility and scalability for modern applications.

- Object-oriented databases: Store data as objects, enabling complex data structures and relationships to be represented.Image Introduction to SQL:

- SQL (Structured Query Language) is a standard language for interacting with relational databases.

- It provides a set of commands for querying, updating, and managing databases.

- SQL is widely used across various industries for data manipulation and analysis tasks.

Basic SQL Syntax (we will cover all of it in detail):

- SELECT: Used to retrieve data from one or more tables.

- INSERT: Adds new rows of data into a table.

- UPDATE: Modifies existing data in a table.

- DELETE: Removes rows of data from a table.

Understanding SQL Queries:
- SQL queries are structured statements that specify the data to be retrieved from a database.
- The SELECT statement is the primary SQL command for retrieving data, allowing users to specify the columns and conditions for filtering rows.
Apr 15 4 tweets 2 min read
REST API explained: A REST API, or Representational State Transfer Application Programming Interface, is a set of rules and conventions for building and interacting with web services. It is a popular architectural style for designing networked applications, particularly web services.

In simpler words, think of web services as a way for different computer programs or systems to talk to each other over the internet. For example, when you use a weather app on your phone to get the weather forecast, it's talking to a web service to get that information. So, this set of rules (REST API) helps developers create these web services and make sure they work well together. It's like a common language that different programs can understand and use to share data.Image
Apr 14 6 tweets 2 min read
How can you make an ATS friendly resume:
(free platforms also shared) These days, nobody sits and checks your resume to decide whether you are the perfect fit for the company or not. When you apply for a job, your resume typically goes directly into an ATS database. The problem is, if your resume isn’t optimized for an ATS, it might never be seen by a hiring manager.
Apr 12 6 tweets 2 min read
API Architecture styles explained: Image
Apr 10 7 tweets 2 min read
The fundamental HTML, CSS, and JavaScript topics you should grasp before delving into any fancy frontend libraries or frameworks: HTML -
1. Learn how to structure web pages with HTML elements.
2. Master common HTML tags like headings, paragraphs, lists, and links.
3. Understand how to create forms to collect user input.
Apr 2 7 tweets 2 min read
If you want to start with Backend development, Open this: Step 1 → Master a Programming Language
Step 2 → Understand Version Control Systems
Step 3 → Dive into Backend Frameworks
Step 4 → Learn Databases
Step 5 → Implement Authentication and Authorization
Step 6 → Explore Caching Strategies
Step 7 → Understand Testing (Optional)
Step 8 → Embrace DevOps Principles

If you know frontend development as well:
Step 9 → Build Full Stack Projects
Step 10 → Host Your Projects

Step 11 → Continuous Learning and Skill Enhancement
Mar 27 6 tweets 2 min read
Structured way to learn JavaScript: EASY
- What is JavaScript and its role in web development?
- Brief history and evolution of JavaScript.
- Basic syntax and structure of JavaScript code.
- Understanding variables, constants, and their declaration.
- Data types: numbers, strings, boolean, and null/undefined.
- Arithmetic, assignment, comparison, and logical operators.
- Combining operators to create expressions.
- Conditional statements (if, else if, else) for decision making.
- Loops (for, while) for repetitive tasks.
- Switch statements for multiple conditional cases.
Mar 26 8 tweets 2 min read
You're in an interview, and the interviewer asks,

"Why you left your previous company?"

Here is how you can answer: The interviewer's a mind reader, right? Wrong!
They don't know why you left your last company. This is your chance to frame the narrative and showcase what you're looking for in a new opportunity.
Mar 24 7 tweets 2 min read
If starting with SQL, don't miss these essential topics: 1. SQL Basics
- SELECT Statement:
It's like asking the database for specific information.
- FROM Clause:
Tells the database where to look for that information.
- WHERE Clause:
Filters out the stuff you don't need.
- ORDER BY Clause:
Arranges the results in a specific order.

2. Data Manipulation
- INSERT: Adds new data.
- UPDATE: Changes existing data.
- DELETE: Removes data.
- MERGE: Combines these actions.

3. Data Definition
- CREATE TABLE: Makes a new table.
- ALTER TABLE: Edits an existing table.
- DROP TABLE: Deletes a table.
- INDEXES: Helps with finding data quickly.
Mar 23 5 tweets 2 min read
We often check the "Accept all cookies" option. Do you know what these "cookies" mean?

Here is the explanation: What are cookies?

Cookies are small text files that websites store on your computer or device when you visit them. These files contain information about your interactions with the site and are designed to enhance your browsing experience.

There are different types of cookies:

1. Session Cookies:
Temporary cookies that are erased when you close your browser.

2. Persistent Cookies:
These cookies remain on your device for a set period (days, months, or years).

3. First-party Cookies:
Set by the website you are currently visiting. Essential for the site's functionality, remembering user preferences, and providing a personalized experience.

4. Third-party Cookies:
Set by domains other than the one you're currently visiting. These are often used for tracking and advertising. For example, when you see ads related to your interests on various websites.