TechSchoool
13K subscribers
4.21K photos
10 files
4.66K links
Download Telegram
Learn Excel from JPMorgan Chase ๐Ÿ‘จโ€๐Ÿ’ป

This will take hardly 5-7hours but the best part is you will get the exact knowledge of excel what you want.
Thave also done this course, the best course I feel
You will also get the certificate once its complete which you can add in your resume.๐Ÿ“

The JPMorgan Chase & Co. Excel Skills program is an opportunity for you to develop your skills in Microsoft Excel.
In this program, you will be tasked with challenges that Through each task, you will learn and develop valuable Excel skills. At the end of each task, you will be able to compare your work to an example provided by JPMorgan Chase & Co. employees to learn from them directly.๐Ÿš€

๐Ÿ–‡Link:
https://www.theforage.com/virtual-internships/prototype/ XiuvjcwaWRaH9oy38/

Comment 'Yes' if you are interested!!๐Ÿ’•

Follow @techschoool for more such content..!!!๐Ÿ™Œ๐Ÿป
๐Ÿ“ 10 + best coding interview for site for your dream job๐Ÿ‘จโ€๐Ÿ’ป๐Ÿš€

1. LeetCode: Over 1,000 coding problems to help you prepare for technical interviews. ๐Ÿงฉ

2. HackerRank: Coding challenges and competitions to improve your coding skills. ๐Ÿ’ป

3. Codewars: Community-driven platform for practicing coding challenges. ๐Ÿค

4. Interview Cake: Comprehensive curriculum for coding interviews.๐Ÿฐ

5.TopCoder: Challenges and competitions to enhance skills and prep for interviews. ๐Ÿ†

6. GeeksforGeeks: Coding problems and tutorials for interview prep. ๐Ÿ‘จโ€๐Ÿ’ป

7.Project Euler: Challenging math and programming problems for problem-solving skills.๐Ÿ”ข

8.CodeSignal: Challenges and assessments for technical interviews.๐ŸŽฏ

9.Coderbyte: Challenges, tutorials, and courses to boost skills for interviews. ๐Ÿš€

10.CodeFights: Challenges and competitions for skill improvement and interviews. โš”๏ธ

Comment 'Yes' if you are interested!!

Follow @techschoool for more such content..!!!
๐Ÿ‘1
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 @techschoool
https://www.instagram.com/reel/C0obg5-vusT/?igshid=MzRlODBiNWFlZA==
๐Ÿ‘2
Learn sql basics tables and queries๐Ÿ‘จโ€๐Ÿ’ปโœ…๏ธ

1. Tables ๐Ÿ—ƒ๏ธ:
โ–ช๏ธCollection of data organized into rows and columns.
โ–ช๏ธRows represent individual records, while columns denote specific attributes.
โ–ช๏ธCreated using CREATE TABLE and modified using other SQL statements.

2. Queries ๐Ÿ“Š:
โ–ช๏ธRetrieving data from a database using SELECT statement.
โ–ช๏ธBasic syntax: SELECT column1, column2... FROM table_name;

3. WHERE Clause ๐ŸŽฏ:
โ–ช๏ธFilters query results based on specific conditions.
โ–ช๏ธSyntax: SELECT ... FROM ... WHERE condition;

4. JOIN Clause ๐Ÿค:
โ–ช๏ธMerges data from multiple tables using a common column.
โ–ช๏ธTypes: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN.


5. GROUP BY Clause ๐Ÿคนโ€โ™€๏ธ:
โ–ช๏ธGroups query results based on specified column(s).
โ–ช๏ธOften used with aggregate functions like COUNT, SUM, etc.

6.ORDER BY Clause ๐Ÿ”„:
โ–ช๏ธSorts query results in ascending or descending order.
โ–ช๏ธSyntax: SELECT ... FROM ... ORDER BY column [ASC|DESC];

Do not forget to React on this Message for More Content Like this ๐Ÿš€

Thanks For Joining All ๐Ÿ™Œ๐Ÿป๐Ÿ’•
๐Ÿ‘5
Free courses for Professional Development for all the techies out there: ๐ŸŽฏ

Free Courses ๐Ÿ‘จโ€๐Ÿ’ป

Learn for FREE :๐Ÿ™Œ๐Ÿป

โœ…๏ธPowerBI -> https://lnkd.in/

โœ…๏ธExcel -> https://lnkd.in/

โœ…๏ธSQL-> http://sqlbolt.com

โœ…๏ธCSS-> http://css-trick

โœ…๏ธAWS-> https://lnkd.in/

โœ…๏ธAzure -> http://learn.micr

โœ…๏ธGCP-+ https://Inkd.in/

โœ…๏ธDevOps->https://Inkd.in/

โœ…๏ธDocker->https://lnkd.in/e

โœ…๏ธSecurity -> http://tryhackme

Comment 'Yes' if you are interested!!๐Ÿ’•

Follow @techschoool for more such content..!!!โœจ๏ธ

#freecourses #powerbi #awscloud #azure
โค1๐Ÿ‘1
Cadence is Hiring

Position: Software Engineer

CTC: up to โ‚น 11 LPA

Degree: BE/BTech/ME/MTech

Branch: Any Branch

Experience: Fresher/Experienced

Location: Noida

Link: https://cadence.wd1.myworkdayjobs.com/External_Careers/job/NOIDA/Principal-Software-Engineer_R44766-3

Comment 'Yes' if you are interested!!

Follow @techschoool for more such content..!!!
๐Ÿ‘1
๐Ÿ“ŒMonth 1: Building a
Strong Foundation
- Choose a programming language: Python or Java are popular choices.
- Learn syntax, variables, data types, loops, and conditional statements.
- Use interactive coding platforms like Codecademy or freeCodeCamp.
- Study essential data structures: arrays, linked lists, stacks, queues, and trees.
- Learn basic algorithms: sorting, searching, and recursion.
- Leverage resources like GeeksforGeeks, LeetCode, and HackerRank for practice.

๐Ÿ“ŒMonth 2: Advanced Concepts and Problem
Solving
- Dive deeper into more complex data structures: hash tables, graphs, and heaps.
- Explore more intricate algorithms: dynamic programming, graph algorithms, etc.
- Continue practicing on coding platforms and solving problems.
- Understand system design principles: scalability, reliability, and trade-offs.
- Work on a personal coding project to apply your skills practically.
- Learn version control using Git and GitHub.

๐Ÿ“ŒMonth 3: Interview Preparation and Mock
Interviews
- Study the interview process for Google and Amazon.
- Solve company-specific coding challenges on their platforms.
- Review behavioral questions and practice answering them.
- Practice mock coding interviews regularly.
- Focus on efficient problem-solving techniques and clear explanations.
- Revise weak areas based on feedback from mock interviews.

๐Ÿ“ŒAdditional Tips:
- Utilize online courses, like โ€œCracking the Coding Interviewโ€ by Gayle Laakmann McDowell.
- Leverage YouTube tutorials and online forums for additional guidance.
- Prioritize consistent practice and problem-solving over memorization.
- Join coding communities and forums to learn from othersโ€™ experiences.
Remember that while three months is a relatively short time frame, dedication, consistent practice, and targeted learning can significantly improve your coding skills and interview readiness. Aim for steady progress and continue refining your skills even after the initial three months.

Follow @techschoool for more
โค2
โœ…๏ธ Walmart is Hiring

Position: Analyst Business Support

Job type: Full-time

CTC: up to โ‚น 34k per month

Qualification: Bachelor's Degree

Experience: 0-2 years

Location: Haryana

Link: https://bitly.ws/35uQs

Do not forget to React on this Message for More Content Like this ๐Ÿš€

Thanks For Joining All ๐Ÿ™Œ๐Ÿป๐Ÿ’•
๐Ÿ‘1
๐Ÿคฉ FREE SQL Mastery Courses with Certifications๐ŸŽ“๐Ÿš€

1. SQL for Data Analysis - Udacity
- โฐ Duration: Approximately 4 Weeks
- ๐Ÿ‘จโ€๐Ÿ’ป Skill Level: Beginner
- [Course Link](https://www.shiksha.com/online-courses/sql-for-data-analysis-course-udacl3)

2. Intro to SQL - Kaggle
- โฐ Duration: Approx. 3 hours
- ๐Ÿ‘จโ€๐Ÿ’ป Skill Level: Beginner
- [Course Link](https://www.kaggle.com/learn/intro-to-sql)

3. Advanced SQL - Kaggle
- โฐ Duration: Approx. 4 hours
- ๐Ÿ‘จโ€๐Ÿ’ป Skill Level: Intermediate
- [Course Link](https://www.kaggle.com/learn/advanced-sql)

4. Introduction to Databases and SQL Querying - Udemy
- โฐ Duration: Approx 2hr 17 min
- ๐Ÿ‘จโ€๐Ÿ’ป Skill Level: Beginner
- [Course Link](https://www.udemy.com/course/introduction-to-databases-and-sql-querying/)

5. Intro to Relational Databases - Udacity
- โฐ Duration: 4 weeks
- ๐Ÿ‘จโ€๐Ÿ’ป Skill Level: Intermediate learner
- [Course Link](https://www.udacity.com/course/intro-to-relational-databases--ud197)

6. Introduction to SQL - DataCamp
- โฐ Duration: 4.5 Hours
- ๐Ÿ‘จโ€๐Ÿ’ป Skill Level: Beginner
- [Course Link](https://www.datacamp.com/courses/introduction-to-sql)

๐Ÿ‘ Like, ๐Ÿ’ฌ Comment, ๐Ÿ’พ Save, and โ†—๏ธ Share if you found this helpful! ๐Ÿ™Œ๐Ÿป

Donโ€™t forget to follow @techschoool for more content ๐Ÿ’•

#MachineLearning #ArtificialIntelligence #AI #Tech #Technology #Innovation #Programming #Coding #SQL #DataAnalysis
๐Ÿ‘3
1. Python reigns as the world's most popular programming language! ๐ŸŒŽ

2. Java boasts usage by 90% of Fortune 500 companies! ๐Ÿ’ผ

3. C++ excels in crafting video games and virtual reality experiences! ๐ŸŽฎ

4. Programming skills are universally valuable, transcending career paths! ๐Ÿ’ป

5. Python's simplicity and readability cater perfectly to beginners! ๐Ÿ

6. Java's platform independence ensures it runs seamlessly on any device or OS! ๐Ÿ”ง

7. C++ is renowned for its speed, ideal for financial trading systems! ๐Ÿ’ธ

8. Coding enhances problem-solving and critical thinking abilities! ๐Ÿง 

9. The soaring demand for Python developers reflects its widespread popularity! ๐Ÿ“ˆ

10. Java's object-oriented approach simplifies managing complex applications! ๐Ÿงฉ

11. Major tech giants like Google, Microsoft, and Amazon rely on C++! ๐ŸŒŸ

12. Python, Java, and C++ power diverse applications from mobile to AI! ๐Ÿค–

13. Python's rich library speeds up complex app development! ๐Ÿš€

14. Java's robust security features make it a top pick for finance apps! ๐Ÿ’ฐ

15. C++ shapes operating systems and system software! ๐Ÿ”ง

16. Coding can be an enjoyable and fulfilling hobby, beyond career pursuits! ๐Ÿค—

17. Python's popularity births a thriving community of developers and enthusiasts! ๐Ÿ‘ฅ

18. Java's scalability shines in building large-scale applications! ๐Ÿ“ˆ

19. C++ drives high-performance scientific computing apps! ๐Ÿ”ฌ

20. Programming skills emerge as a vital asset in today's diverse job market! ๐Ÿ’ผ

React to this message if you need more Interesting Project Like thisโค๏ธ

Follow @techschoool for more such content..!!!
โค1
https://www.instagram.com/reel/C0ytLXtLVQv/?igshid=MzRlODBiNWFlZA==

๐Ÿš€ Front-End Development Free Course! ๐Ÿคฉ

Join Meta staff-led sessions for a dynamic introduction to web development. ๐ŸŒ Master HTML, CSS, React, and more!

๐Ÿ”ง Learn Skills
- HTML for structure
- CSS for styling
- React for interactivity

๐Ÿ”ฅ Why Choose Us?
- Free of charge
- Full-stack focus
- Job-ready skills

๐ŸŒŸ Enroll Today!
Seize this opportunity to shape your future.

Link: https://bit.ly/frontendbymeta

#frontend #webdev #javascript #react #HTMLCSS #freecourse

Comment 'Yes' if you are interested!! ๐Ÿ’ž

Follow @techschoool for more such content..!!!๐Ÿ™Œ๐Ÿป
๐Ÿ‘2
โœจ๏ธJAVA VS PYTHONโœจ๏ธ

๐Ÿš€Java:

1. Syntax: Complex, verbose code. ๐Ÿง‘โ€๐Ÿ’ป

2. Speed: Faster due to bytecode compilation. ๐ŸŽฏ

3. Memory Management: Automatic with garbage collector.โ›ณ๏ธ

4. Libraries: Abundant enterprise-level frameworks (Spring, Hibernate).๐Ÿงฉ

5. Community: Large, active suppor network.๐Ÿ”ฎ

๐Ÿš€Python:

1. Syntax: Simple, readable code.๐ŸŽฐ

2. Speed: Slower, but ideal for rapid development.๐ŸŽ

3. Memory Management: Uses garbage collection.๐ŸŽฒ

4. Libraries: Rich ecosystem for data tasks (NumPy, Pandas).๐Ÿงธ

5. Community: Welcoming, beginner-friendly, strong support.๐Ÿชข

Do not forget to React on this Message for More Content Like this ๐Ÿš€

Follow @techschoool for more such content..!!!

Thanks For Joining All ๐Ÿ’•๐Ÿ™Œ๐Ÿป
โค2๐Ÿ‘2๐Ÿ‘1
Master the Coding Game ๐ŸŽฎ with these Top 75 to enhance your programming skills and excel in tech interviews. Level up with these challenges!๐ŸŽฏ

Link ๐Ÿ–‡: https://leetcode.com/discuss/general-discussion/460599/blind-75-leetcode-questions

Comment 'Yes' if you are interested!! ๐Ÿ™Œ๐Ÿป

โœ…๏ธ Follow @techschoool for more such content..!!!โœจ๏ธ

#leetcode #geeks #programmig #internahip #coder
https://www.instagram.com/reel/C01L_G6rvc3/?igshid=MTc4MmM1YmI2Ng==
๐Ÿ‘1
GOLDMAN SACHS IS HIRING

Role: Summer Analyst Internship

Salary: up to 40,000/Month

Eligibility: Bachelors or Masters degree

Location:Across India

Batch: 2024 and 2025

Apply Link ๐Ÿ‘‡: -

https://bit.ly/41fNBw1

Apply before the link expires
โค1
"Unleash your inner geek and sprinkle some 'Ctrl+Alt+Laugh' on your day! ๐Ÿ˜„๐Ÿค“

1. The first computer mouse was wooden, but thankfully, it didn't squeak or nibble on cables. ๐Ÿญ๐Ÿ’ปโœจ

2. If you ever feel useless, remember that there's a "scroll lock" key on your keyboard. No one really knows what it does. ๐Ÿคทโ€โ™‚๏ธโŒจ๏ธโ“

3. Programmers and cats have a lot in common โ€“ they both appreciate a good mouse. ๐Ÿฑ๐Ÿ’พ๐Ÿ˜ธ

4. "Why do programmers prefer dark mode?" Because the light attracts bugs. ๐ŸŒ‘๐Ÿž๐Ÿ’ก

5. The computer's favorite snack? Chips! ๐Ÿฅ”๐Ÿ’ป๐Ÿ˜‹

6. Debugging is like being the detective in a crime movie where you're also the murderer. "Who wrote this code? Oh, right, me." ๐Ÿ”๐Ÿ•ต๏ธโ€โ™‚๏ธ๐Ÿ˜…

7. The speed of your internet is directly proportional to how urgently you need to use it. ๐Ÿš€๐Ÿ“กโณ

8. Why don't programmers like nature? It has too many bugs. ๐ŸŒณ๐Ÿœ๐Ÿ™…โ€โ™‚๏ธ

9. The best way to communicate with a programmer is to write it down and slip it under their door. Preferably in Python. ๐Ÿ๐Ÿšช๐Ÿ“œ

10. If at first, you don't succeed, call it version 1.0. ๐Ÿš€1๏ธโƒฃ.0๏ธโƒฃ๐Ÿ˜†

Do not forget to React on this Message ๐Ÿ‘€

Thanks For Joining All ๐Ÿ™Œ๐Ÿป๐Ÿ’•
โค6๐Ÿ‘1
These are must things to add in ur resume ๐Ÿ‘จโ€๐Ÿ’ป

HARD SKILLS ๐Ÿš€

1. Computer programming

2. Network security

3. Data analysis

4. UX Design

5. Business analysis

6. SEO/SEM Marketing

7. Artificial intelligence

8. Sales & Administrative

9. Certifications & Licenses

10. Foreign language skills

SOFT SKILLS๐Ÿ“Œ

1. Problem-solving

2. Time management

3. Communication

4. Creativity

5. Negotiation

6. Collaboration

7. Adaptability

8. Emotional intelligence

9. Decision making

10. Organization

Comment 'Yes' if you are interested!!๐ŸŽฏ

Follow @techschoool for more such content..!!! ๐Ÿ’•

#TechTuesday, #InnovationNation, #CodeLife, #FutureTech
๐Ÿ‘1