TechSchoool
13K subscribers
4.22K photos
10 files
4.67K links
Download Telegram
Basic LinkedIn hacks to find jobs :-
1. Connecting With The Recruiters:
Having the right connections is important. Send a connection request to recruiters from your current field or the field you aspire to get into. Many recruiters make use of Linkedin to post job listings through their personal account.
2. Salary Expectation:
Understanding your worth can be the most confusing thing to do, but with LinkedIn Salary Insights, you have information at your fingertips. This tools helps you to get a better understanding of what others are being paid in your field. You can filter the information based on the location, experience, and industries
3. Use Correct Keywords:
To be found in a list of relevant candidates, your profile needs to include the details a relevant candidate would have. Make use of the right keywords used by recruiters for profile search in job postings you are interested in. These keywords would include phrases from a job description, relevant skillsets that you would hold, or certifications that a recruiter is looking for.
4. Ask for a referral:
Job applicants who are referred by an employee are 9x more likely to get hired. Getting a referral is easy. If you have a connection who works at the company youโ€™re interested in, simply tap the โ€˜Ask for a referralโ€™ button just under the Job Description. Because good things come to those who ask, right?
5. Make Use Of The BOOLEAN Search:
Linkedin has millions of registered users. With such a huge database, it can be difficult to find the exact information you are looking for. This is the time when BOOLEAN operators such as AND, OR, NOT Parentheses and Quotes can help you to narrow down your search and find the desired results.
๐Ÿ‘1
Sql projects to boost your resume

What I would do is:

โ€ข Check out Registry of Open Data on AWS and find a dataset that you find interesting. I would pick something thatโ€™s easy to understand though so that the folks reviewing your resume can understand whatโ€™s going on without a masters degree. Letโ€™s use the Common Crawl dataset as an example.

โ€ข Setup a public GitHub repository for the code youโ€™re going to write for this project

โ€ข Write some code to import part or all of the data into your favorite RDBMS

โ€ข Figure out 3-5 โ€œInsightsโ€ to pull out of the dataset

โ€ข Write some code to extract those insights sliced by various dimensions like time, site, etc.

โ€ข Commit all of this code to your GitHub repository
Most importantly, create some sort of visualization or visual work product to showcase the end result.

. People (Yes, even engineers) hate reading so give them a pretty picture to grab their attention so theyโ€™re interested enough to review your code.

โ€ข And for bonus points, you could setup a GitHub Page (GitHub Pages ) to showcase all of this so that you can include that URL in your resume.

Good luck!

Follow for more
๐Ÿ‘2
Learning SQL in seven days can be a challenging but achievable goal if youโ€™re dedicated and focused. Hereโ€™s a structured plan to help you get started:

๐Ÿ“ŒDay 1: Introduction to SQL

- Start by understanding what SQL is and why itโ€™s important.
- Learn about different database management systems (DBMS) like MySQL, PostgreSQL, or SQL Server.
- Install a DBMS of your choice and a SQL client if needed.

๐Ÿ“ŒDay 2: Basic SQL Queries
- Learn the basic SQL syntax for querying data using SELECT statements.
- Practice retrieving data from a single table.
- Understand the WHERE clause for filtering data.

๐Ÿ“ŒDay 3: Advanced SQL Queries
- Explore more complex queries with JOIN operations to combine data from multiple tables.
- Learn about GROUP BY and aggregate functions like COUNT, SUM, AVG.
- Practice sorting data with ORDER BY.

๐Ÿ“ŒDay 4: Data Modification
- Study how to insert, update, and delete data using SQL.
- Understand the importance of transactions and how to use them.

๐Ÿ“ŒDay 5: Database Design
- Learn the fundamentals of database design, including tables, columns, and data types.
- Explore normalization concepts to ensure data integrity.

๐Ÿ“ŒDay 6: Advanced SQL Topics
- Dive into subqueries and derived tables.
- Study SQL views, indexes, and stored procedures.
- Familiarize yourself with common SQL functions like DATE and STRING functions.

๐Ÿ“ŒDay 7: Practice and Review
- Spend the final day practicing what youโ€™ve learned.
- Work on sample SQL exercises and projects.
- Review your understanding of SQL concepts and seek clarification where needed.

Here are free resources which I relayed on ๐Ÿ‘‡๐Ÿ‘‡๐Ÿ‘‡

๐Ÿš€YouTube channel: intellipaat one of the best YouTube channel to learn sql if you are beginner at the end they will also help you in interview preparation
https://youtu.be/wkOD6mbXc2M?si=E338FokIgZM5GZav
The clickable link will be in my telegram channel which is there in my bio

โœ…Practice on HackerRank

โœ… for projects you can check my Coursera video how you can do free projects less than 2 hours and get certificate to add in your resume
If you want to know more feel free to use the comment section ๐Ÿ˜Š
For more such informative videos do follow
๐Ÿ‘6โค1
Are you missing on JAVA ? Check this out

Day 1-2:
- Day 1: Introduction to Java
- Day 2: Setting up Java Development Environment
(JDK, IDE)

Day 3-5:
- Day 3: Basic Syntax and Variables
- Day 4: Data Types and Operators
- Day 5: Control Statements (if-else, switch)

Day 6-7:
- Day 6: Loops (for, while, do-while)
- Day 7: Arrays and Array List

Day 8-10:
- Day 8: Classes and Objects
- Day 9: Constructors and Methods
- Day 10: Inheritance and Polymorphism

Day 11-14:
- Day 11: Encapsulation and Access Modifiers
- Day 12: Abstract Classes and Interfaces
- Day 13: Exception Handling
- Day 14: File I/O

Day 15-18:
- Day 15: Collections Framework (List, Set, Map)
- Day 16: Generics
- Day 17: Multithreading Basics
- Day 18: Synchronization and Concurrency

Day 19-21:
- Day 19: Lambda Expressions
- Day 20: Streams API
- Day 21: JDBC (Database Connectivity)

Day 22-24:
- Day 22: Introduction to GUI (Swing or JavaFX)
- Day 23: Event Handling in GUI
- Day 24: Building a Simple GUI Application

Day 25-28:
- Day 25: Introduction to Web Development (Servlets and JSP)
- Day 26: Building a Basic Web Application
- Day 27: Introduction to Spring Framework (optional)
- Day 28: Building a Spring-based Web Application (optional)

Day 29-30:
- Day 29: Java Best Practices and Code Optimization
- Day 30: Recap and Personal Project (apply what youโ€™ve learned)
๐Ÿ‘8
Courses I regret doing in 2023

1. Google Digital Garage: Fundamentals of Digital Marketing
Course Link: https://learndigital.withgoogle.com/ digitalgarage/course/digital-marketing

2. Facebook Blueprint: Social Media Marketing
Course Link: https://www.facebook.com/blueprint

3. Microsoft Learn: Introduction to Python
- & Course Link: https://docs.microsoft.com/en-us/ learn/paths/python-first-steps/

4. Amazon Web Services (AWS) Training and Certification: AWS Cloud Practitioner Essentials
- & Course Link: https://aws.amazon.com/training/ course-descriptions/cloud-practitioner-essentials/

5. IBM Skills: Introduction to Artificial Intelligence (Al)
- & Course Link: https://www.ibm.com/training/ badge/ea9f8f2d-281-412a-8c73-38ed6ffbaldd

6. Adobe Creative Cloud Tutorials: Graphic Design
Basics
- & Course Link: https://helpx.adobe.com/creative-cloud/tutorials-explore.html

7. HubSpot Academy: Inbound Marketing
Certification
- Course Link: https://academy.hubspot.com/ courses/inbound-marketing

8. LinkedIn Learning: Excel Essentials for the Real World (by Microsoft)
- Course Link: https://www.linkedin.com/learning/ excel-essentials-for-the-real-world-2

9. Cisco Networking Academy: Introduction to
Cybersecurity
- & Course Link: https://www.netacad.com/courses/ cybersecurity/introduction-cybersecurity

10. Coursera: Machine Learning (by Stanford
University)
- Course Link: https://www.coursera.org/learn/ machine-learning

11. HubSpot Academy: Inbound Marketing - Learn the fundamentals of inbound marketing, including content creation, social media promotion, and lead nurturing.
Course Link: https://academy.hubspot.com/ courses/inbound-marketing
๐Ÿ‘4
*Job's in tech field*

1.Name of company - WsCube Tech

Role - Sr. React.js Developer

Location - jodhpur , Rajasthan

Stipend - 16L per year

Link - https://www.linkedin.com/jobs/view/3733059696

2. Name of company - Owebest Technologies

Role - Web designer

Location - Jaipur, Rajasthan

Stipend - 10L per year

Link - http://surl.li/mdiek

3. Name of company - Tech Mahindra

Role - Sr. Network engineer -IP

Location - Noida

Stipend - 13L per year

Link - https://www.linkedin.com/jobs/view/3733059696

4. Name of company - neXjob

Role - Network support Engineer

Location - New Delhi, Delhi

Stipend - 13L per year

Link - https://www.linkedin.com/jobs/view/3739030045

5. Name of company - Futurense Technologies

Role - Java Backgend support Engineer

Location - New Delhi, Delhi

Stipend - 7L per year

Link - http://surl.li/mdxlo
โค2๐Ÿ‘1
*Job's in tech field*

1. NAME of company - shorthills Tech pvt. Ltd.

Role - senior Net developer - SQL server

Location - gurugram

Link - https://www.hirist.com/j/shorthills-tech-senior-net-developer-sql-server-visual-studio-6-10-yrs-1256256.html?utm_campaign=google_jobs_apply&utm_source=google_jobs_apply&utm_medium=organic

2. NAME of company - kadel labs Pvt Ltd..

Role - Software Engineer

Location - Jaipur

Link - https://www.linkedin.com/jobs/view/3726500213

3. NAME of company - Tax2Win

Role - Senior PHP developer

Stipend - 15L to 22L

Location - Bangalore

Link - https://wellfound.com/jobs/212606-senior-php-developer?utm_campaign=google_jobs_apply&utm_source=google_jobs_apply&utm_medium=organic

4. NAME of company - Trademo

Role - Frontend developer

Location - gurugram

Link - https://www.linkedin.com/jobs/view/3741876867

5. NAME of company - ESDS Software Solution Limited

Role - Business Analyst

Location - New Delhi

Link - https://www.linkedin.com/jobs/view/3740805550
๐Ÿ‘3
Job's for data analyst

1. NAME of company - Confidential

Role - Data Analyst and strategic insights analyst

Location - New Delhi

Link - https://www.linkedin.com/jobs/view/3744578846

2. NAME of company - Worldline

Role - Data Analyst and associate consultant

Location - New Delhi

Link - https://careers.worldline.com/en/job/-/-/35538/55946935440?jobPipeline=Indeed

3. NAME of company - Divya Interprises

Role - Data Analyst

Location - Remote

Link - https://www.linkedin.com/jobs/view/3743252600

4. NAME of company - UD Trucks

Role - Data Analyst

Location - Bengaluru , Karnataka

Link - https://www.linkedin.com/jobs/view/3734560535

5. NAME of company - Malavita Co Inc

Role - Data Analyst

Location - New Delhi

Link - https://bit.ly/407dfTb
๐Ÿ‘3โค2
*Remote job's for tech students*

1. NAME of company - Nestle

Role - Tech Lead

Location - gurugram

Link - https://www.linkedin.com/jobs/view/3743695787

2. NAME of company - IT by Design

Role - International Tech Support

Location - Chandigarh

Link - https://m5.apply.indeed.com/beta/indeedapply/form/contact-info

3. NAME of company - IGT Solutions

Role - system Engineer

Location - Gurugram

Link - https://www.linkedin.com/jobs/view/3718933140

4. NAME of company - LimeRoad

Role - Engineering Manager

Location - Gurugram

Link - https://bit.ly/3s5xKDf

5. NAME of company - Sumati Group

Role - Senior Software developer

Location - Gurugram

Link - https://bit.ly/3s4u6to
React.js 30 Days Roadmap & Free Learning Resource ๐Ÿ“๐Ÿ‘‡

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 1-7: Introduction and Fundamentals

๐Ÿ“Day 1: Introduction to React.js

What is React.js?
Setting up a development environment
Creating a basic React app

๐Ÿ“Day 2: JSX and Components

Understanding JSX
Creating functional components
Using props to pass data

๐Ÿ“Day 3: State and Lifecycle

Component state
Lifecycle methods (componentDidMount, componentDidUpdate, etc.)
Updating and rendering based on state changes

๐Ÿ“Day 4: Handling Events

Adding event handlers
Updating state with events
Conditional rendering

๐Ÿ“Day 5: Lists and Keys

Rendering lists of components
Adding unique keys to components
Handling list updates efficiently

๐Ÿ“Day 6: Forms and Controlled Components

Creating forms in React
Handling form input and validation
Controlled components

๐Ÿ“Day 7: Conditional Rendering

Conditional rendering with if statements
Using the && operator and ternary operator
Conditional rendering with logical AND (&&) and logical OR (||)

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 8-14: Advanced React Concepts

๐Ÿ“Day 8: Styling in React

Inline styles in React
Using CSS classes and libraries
CSS-in-JS solutions

๐Ÿ“Day 9: React Router

Setting up React Router
Navigating between routes
Passing data through routes

๐Ÿ“Day 10: Context API and State Management

Introduction to the Context API
Creating and consuming context
Global state management with context

๐Ÿ“Day 11: Redux for State Management

What is Redux?
Actions, reducers, and the store
Integrating Redux into a React application

๐Ÿ“Day 12: React Hooks (useState, useEffect, etc.)

Introduction to React Hooks
useState, useEffect, and other commonly used hooks
Refactoring class components to functional components with hooks

๐Ÿ“Day 13: Error Handling and Debugging

Error boundaries
Debugging React applications
Error handling best practices

๐Ÿ“Day 14: Building and Optimizing for Production

Production builds and optimizations
Code splitting
Performance best practices

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 15-21: Working with External Data and APIs

๐Ÿ“Day 15: Fetching Data from an API

Making API requests in React
Handling API responses
Async/await in React

๐Ÿ“Day 16: Forms and Form Libraries

Working with form libraries like Formik or React Hook Form
Form validation and error handling

๐Ÿ“Day 17: Authentication and User Sessions

Implementing user authentication
Handling user sessions and tokens
Securing routes

๐Ÿ“Day 18: State Management with Redux Toolkit

Introduction to Redux Toolkit
Creating slices
Simplified Redux configuration

๐Ÿ“Day 19: Routing in Depth

Nested routing with React Router
Route guards and authentication
Advanced route configuration

๐Ÿ“Day 20: Performance Optimization

Memoization and useMemo
React.memo for optimizing components
Virtualization and large lists

๐Ÿ“Day 21: Real-time Data with WebSockets

WebSockets for real-time communication
Implementing chat or notifications

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 22-30: Building and Deployment

๐Ÿ“Day 22: Building a Full-Stack App

Integrating React with a backend (e.g., Node.js, Express, or a serverless platform)
Implementing RESTful or GraphQL APIs

๐Ÿ“Day 23: Testing in React

Testing React components using tools like Jest and React Testing Library
Writing unit tests and integration tests

๐Ÿ“Day 24: Deployment and Hosting

Preparing your React app for production
Deploying to platforms like Netlify, Vercel, or AWS

๐Ÿ“Day 25-30: Final Project

Plan, design, and build a complete React project of your choice, incorporating various concepts and tools you've learned during the previous days.

This roadmap provides a comprehensive overview of React.js, from the fundamentals to more advanced topics.
๐Ÿ‘5โค3๐Ÿ”ฅ1
Donโ€™t forget to share your response on this
Games to Learn Coding๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ป

1. CSS Diner๐Ÿ“
https://flukeout.github.io/

2. CheckIO๐Ÿ“
https://checkio.org/

3. CodeCombat๐Ÿ“
https://codecombat.com/

4. Elevator Saga๐Ÿ“
https://play.elevatorsaga.com/

5. Robocode๐Ÿ“
https://robocode.sourceforge.io/

6. Codingame๐Ÿ“
https://www.codingame.com/start/

7. Codewars๐Ÿ“
https://www.codewars.com/

Do not forget to React to this Message for More Content Like this
๐Ÿ‘‡


Thanks For Joining All๐Ÿ’™
๐ŸŽ‰2
๐…๐ซ๐ž๐ฌ๐ก๐ž๐ซ'๐ฌ ๐ ๐ฎ๐ข๐๐ž ๐ญ๐จ ๐ฌ๐ญ๐š๐ซ๐ญ๐ข๐ง๐  ๐š ๐œ๐š๐ซ๐ž๐ž๐ซ ๐ข๐ง ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ญ๐ข๐œ๐ฌ | FREE Online Live Webinar

Understand Data Analytics domain, job opportunties and the skills needed as a recent graduate

๐—˜๐—น๐—ถ๐—ด๐—ถ๐—ฏ๐—ถ๐—น๐—ถ๐˜๐˜†:- (BE/BTech/BSc/BCA/BBA/BCom)  passed out in 2021,2022 & 2023

๐—ฅ๐—ฒ๐—ด๐—ถ๐˜€๐˜๐—ฒ๐—ฟ ๐—™๐—ผ๐—ฟ ๐—™๐—ฟ๐—ฒ๐—ฒ ๐Ÿ‘‡:- 

https://bit.ly/3s4n8EP

( Only a few slots left ) 

Date & Time:- Thu, 02 Nov 2023, 06:00PM IST

๐ˆ๐ฆ๐ฉ ๐๐จ๐ญ๐ž:-  Only Candidates From Hyderabad/Telangana, Chennai/Tamilnadu, Bangalore/Karnataka, Pune/Maharashtra are eligible
โค2๐Ÿ‘1
๐Ÿ“Œ Mini Projects using HTML CSS and JavaScript

โœ… Source Code ๐Ÿ‘‡๐Ÿป๐Ÿ‘‡๐Ÿป๐Ÿ‘‡๐Ÿป
๐Ÿ”— https://www.geekshelp.in/p/mini-projects-using-html-css-and.html
๐Ÿ‘1
JavaScript 30 Days Roadmap๐Ÿ‘‡

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 1-7: JavaScript Fundamentals

๐Ÿ“Day 1: Introduction to JavaScript

What is JavaScript?
JavaScript in the browser
Basic syntax and comments

๐Ÿ“Days 2-3: Variables and Data Types

Variables (var, let, const)
Data types (string, number, boolean, undefined, null)

๐Ÿ“Day 4: Operators and Expressions

Arithmetic operators (+, -, *, /, %)
Comparison operators (==, ===, !=, !==, >, <)
Logical operators (&&, ||, !)

๐Ÿ“Day 5: Control Structures

if, else if, else statements
switch statement
Ternary (conditional) operator

๐Ÿ“Day 6: Loops

for loop
while loop
do...while loop
Iterating through arrays

๐Ÿ“Day 7: Functions

Declaring and calling functions
Function parameters and return values
Function expressions
Arrow functions

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 8-14: DOM Manipulation

๐Ÿ“Day 8: Introduction to the DOM

What is the Document Object Model (DOM)?
Selecting and manipulating elements

๐Ÿ“Day 9: Event Handling

Adding event listeners
Event objects and event types
Removing event listeners

๐Ÿ“Day 10: Changing HTML and CSS

Modifying text and attributes
Styling elements dynamically

๐Ÿ“Day 11: Creating and Modifying Elements

Creating elements with createElement
Appending and removing elements
Cloning nodes

๐Ÿ“Day 12: Local Storage

Storing and retrieving data with localStorage
JSON and parsing data

๐Ÿ“Day 13: Form Handling

Form elements and submission
Validating form input

๐Ÿ“Day 14: Mini Project

Create a simple interactive web page using JavaScript and the DOM

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 15-21: Advanced JavaScript Concepts

๐Ÿ“Day 15: Scope and Closures

Global scope and function scope
Closure concept

๐Ÿ“Day 16: Objects and Object-Oriented Programming

Creating and working with objects
Constructor functions and classes
Inheritance and prototypes

๐Ÿ“Day 17: Arrays and Array Methods

Array methods (forEach, map, filter, reduce, etc.)
Iterating and manipulating arrays

๐Ÿ“Day 18: Asynchronous JavaScript

Callback functions
Promises
Async/await

๐Ÿ“Day 19: Fetch API

Making HTTP requests
Handling API responses
Error handling

๐Ÿ“Day 20: Error Handling

Try...catch statements
Custom error handling
Handling promise rejections

๐Ÿ“Day 21: Modular JavaScript

ES6 modules
Importing and exporting modules
Building a modular application

๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ปDays 22-30: JavaScript Frameworks and Libraries

๐Ÿ“Day 22: Introduction to JavaScript Frameworks

Overview of popular JavaScript frameworks (e.g., React, Angular, Vue)

๐Ÿ“Day 23-24: Building a Mini Project with a Framework

Choose a framework (e.g., React, Angular, or Vue)
Build a small project or component

๐Ÿ“Day 25-26: AJAX and API Integration

Fetching and displaying data from a real API
Integration with third-party APIs

๐Ÿ“Day 27-28: Advanced Framework Concepts

Advanced features of the chosen framework
State management, routing, or component lifecycle

๐Ÿ“Day 29: Debugging and Performance Optimization

Debugging tools and techniques
Performance optimization tips

๐Ÿ“Day 30: Final Project

Create a more complex web application using JavaScript and a chosen framework or library

This roadmap provides a comprehensive overview of JavaScript, from the basics to more advanced topics. Adjust the pace according to your learning style, and make sure to practice by working on projects throughout your learning journey.

Do not forget to React to this Message for More Content Like this
๐Ÿ‘‡

Thanks For Joining All๐Ÿ’™
โค2
Games to Learn Coding๐Ÿ‘จ๐Ÿปโ€๐Ÿ’ป

1. CSS Diner๐Ÿ“
https://flukeout.github.io/

2. CheckIO๐Ÿ“
https://checkio.org/

3. CodeCombat๐Ÿ“
https://codecombat.com/

4. Elevator Saga๐Ÿ“
https://play.elevatorsaga.com/

5. Robocode๐Ÿ“
https://robocode.sourceforge.io/

6. Codingame๐Ÿ“
https://www.codingame.com/start/

7. Codewars๐Ÿ“
https://www.codewars.com/

Thanks For Joining All๐Ÿ’™
Job openings for freshers and experienced ๐Ÿ‘‰๐Ÿ‘‰


1.Name of company - IBM

Role - Associate System Engineer

Salary - INR 4.50 LPA+

Location - Mumbai, Pune, New Delhi,Hyderabad, Chennai

Link : https://careers.ibm.com/job/19344653/associate-system-engineer-remote/?codes=WEB_SEARCH_INDIA&sf183355623=1


2.Name of company - Accenture

Role - Application Development Associate

Salary - Rs 4.61 LPA

Location - Bangalore, Hyderabad, Chennai, Mumbai, Pune, Gurgaon, Kolkata

Link : https://indiacampus.accenture.com/myzone/accenture/1/jobs/2201/job-details

3.Name of company - MountBlue

Role - Software Engineer Trainee

Salary - Rs.4 LPA+

Location - Bangalore

Link : https://careers.mountblue.io/trainee

4.Name of company - SOLERA

Role - Associate Analyst

Location - Hyderabad

Link : https://solera.wd5.myworkdayjobs.com/en-US/Global_Career_Site/job/Hyderabad/Associate-Analyst---Review-Ops_JR-016280

5.Name of company - Baker Hughes

Role - Early Career Trainee


Location - Mumbai

Link: https://careers.bakerhughes.com/global/en/job/BAHUGLOBALR97205/Early-Career-Program-ASPIRE-Engineering-Technology-India-2023?utm_source=linkedin&utm_medium=phenom-feeds