TechSchoool
13K subscribers
4.2K photos
10 files
4.65K links
Download Telegram
๐๐ฒ๐ญ๐ก๐จ๐ง ๐ข๐ฌ ๐ญ๐ก๐ž ๐ฆ๐จ๐ฌ๐ญ ๐๐ž๐ฆ๐š๐ง๐๐ข๐ง๐  ๐ฌ๐ค๐ข๐ฅ๐ฅ ๐ข๐ง ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ’ ๐Ÿ’ป

The average salary of a Python Developer is 8 LPA ๐Ÿ’ฐ

Learn Python and become an expert in 28 days ๐Ÿ

๐‡๐ข๐ ๐ก๐ฅ๐ข๐ ๐ก๐ญ๐ฌ :-

- Micro Degree ๐ŸŽ“
- Live Classes ๐ŸŽฅ
- Verified Certificate ๐Ÿ“œ
- Lifetime Access ๐Ÿ”

๐€๐ฉ๐ฉ๐ฅ๐ฒ ๐“๐จ๐๐š๐ฒ ๐Ÿ‘‡ :- 

 https://bit.ly/48B7osl

( Discount applicable for next 10 candidates only)

Comment 'Yes' if you are interested!!โœจ๏ธ

Follow @techschoool for more such content..!!!โšก๏ธ

Check my reel ๐Ÿ‘‡๐Ÿป

https://www.instagram.com/reel/C24WvdlrQTD/?igsh=MWRkaWg0bXk5cDllMw==
๐Ÿ‘2
Google Recruitment Drive 2024

Role :- Software Engineer

Location:-  Bangalore

Salary:- Upto 12 LPA

Apply Link ๐Ÿ‘‡:-

https://bit.ly/3HJZYYk

Apply before the link expires
๐Ÿ‘2
โœจ๏ธTop 50 SQL Interview Questionsโœจ๏ธ

1. What is SQL? ๐Ÿค”
2. What is a primary key in SQL? ๐Ÿ”‘
3. What is a foreign key in SQL? ๐Ÿ”—
4. What is normalization in SQL? ๐Ÿ”„
5. What are the different types of joins in SQL? ๐Ÿ”„
6. What is an index in SQL? ๐Ÿ“Š
7. What is a trigger in SQL? ๐Ÿš€
8. What is a view in SQL? ๐Ÿ‘€
9. What is a stored procedure in SQL? ๐Ÿ—ƒ๏ธ
10. What is a cursor in SQL? ๐Ÿ–ฑ๏ธ
11. What is a transaction in SQL? ๐Ÿ’ฐ
12. What is the difference between a primary key and a unique key? ๐Ÿ”‘
13. What is the difference between an inner join and an outer join? ๐Ÿ”„
14. What is the difference between a view and a table? ๐Ÿ‘€
15. What is the difference between a clustered and a non-clustered index? ๐Ÿ“Š
16. What is the difference between a function and a stored procedure? ๐Ÿ”„
17. What is a subquery in SQL? ๐Ÿค”
18. What is a self-join in SQL? ๐Ÿ”„
19. What is the difference between truncate and delete in SQL? ๐Ÿ—‘๏ธ
20. What is the difference between a left join and a right join? ๐Ÿ”„
21. What is the difference between a full outer join and a cross join? ๐Ÿ”„
22. What is the difference between group by and order by in SQL? ๐Ÿ”„
23. What is a correlated subquery in SQL? ๐Ÿ”„
24. What is the difference between having and where clause in SQL? ๐Ÿ”„
25. What is the difference between char and varchar in SQL? ๐Ÿค”
26. What is the difference between date and datetime in SQL? ๐Ÿ“…
27. What is the difference between a clustered and non-clustered index? ๐Ÿ“Š
28. What is the difference between distinct and group by in SQL? ๐Ÿ”„
29. What is the difference between top and limit in SQL? ๐Ÿค”
30. What is the difference between count and sum in SQL? ๐Ÿ”ข
31. What is the difference between case and if statement in SQL? ๐Ÿ”„
32. What is the difference between an alias and a synonym in SQL? ๐Ÿค”
33. What is the difference between union and union all in SQL? ๐Ÿ”„
34. What is the difference between primary key and unique key constraints? ๐Ÿ”‘
35. What is the difference between an update and an insert statement in SQL? ๐Ÿ”„
36. What is the difference between isnull and coalesce in SQL? ๐Ÿ”„
37. What is the difference between inner join and cross join in SQL? ๐Ÿ”„
38. What is the difference between left join and right join in SQL? ๐Ÿ”„
39. What is the difference between truncate and delete in SQL? ๐Ÿ—‘๏ธ
40. What is the difference between a view and a materialized view in SQL? ๐Ÿ‘€
41. What is the difference between a natural join and an equi-join in SQL? ๐Ÿ”„
42. What is the difference between an open cursor and a closed cursor in SQL? ๐Ÿ–ฑ๏ธ
43. What is the difference between a stored procedure and a user-defined function in SQL? ๐Ÿ”„
44. What is the difference between a schema and a database in SQL? ๐Ÿค”
45. What is the difference between rownum and rank in SQL? ๐Ÿ”ข
46. What is the difference between a CTE and a derived table in SQL? ๐Ÿ”„
47. What is the difference between a left outer join and a right outer join in SQL? ๐Ÿ”„
48. What is the difference between a clustered and a non-clustered index in SQL Server? ๐Ÿ“Š
49. What is the difference between a transaction and a batch in SQL Server? ๐Ÿ’ฐ
50. What is the difference between a scalar function and a table-valued function in SQL? ๐Ÿ”ข

Follow @techschoool for more such content..!!! ๐ŸŽ‰

Do not forget to React on this Message for More Content Like this ๐ŸŽŠ

Thanks For Joining All โ™ฅ๏ธ

๐Ÿ‘‰WhatsApp Channel for daily jobs updates :https://whatsapp.com/channel/0029VaITVKQ9mrGf9LO7RQ43
๐Ÿ‘2
Free courses from IBM learn Data Analytics, Python, AI , SQL, Machine Learning

Link:๐Ÿ–‡ https://www.ibm.com/training/

Comment 'Yes' if you are interested!!๐Ÿš€

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

Watch my new reel just in one click ๐Ÿ‘‡

https://www.instagram.com/reel/C27PqxTP5lu/?igsh=MWs5OWxqa2s0dXJ3NQ==
๐Ÿ‘3
Avasoft Walk In Drive On 10th Feb 2024

Role:- Trainee Engineer (Service Now )

Specialization:- BBA,BCA,MCA,BSC IT,BSC CSE

Location :- Chennai , Tamil Nadu

Registration close date โ€“ 7th Feb 2023, 6:00PM

Apply Link ๐Ÿ‘‡:-


https://bit.ly/3uoeNNd

Apply before the link expires
๐Ÿ‘1
๐ŸŒŸ YASH Technologies is hiring!

๐Ÿ” Position: Junior Data Analyst

๐ŸŽ“ Qualifications: Bachelorโ€™s/ Masterโ€™s Degree

๐Ÿ’ฐ Salary: 5.5 - 8.5 LPA (Expected)

๐Ÿ‘จโ€๐Ÿ’ผ Experience: Freshers/ Experienced

๐Ÿ“ Location: Bangalore, India

๐Ÿ“ Apply link in bio

๐Ÿ’ฌ Comment "yes" if you are interested

๐Ÿ‘‰ Follow @techschoool for more such job updates

๐Ÿš€ Important - Donโ€™t forget to mention this video clip is not owned by us video credit goes to respective owner kindly DM us for any removal or credit

๐Ÿ“Œ Apply Now: https://placementdrive.in/job/yash-technologies-is-hiring-for-2024-junior-data-analyst
Watch my new reel ๐Ÿ‘‡

https://www.instagram.com/reel/C29svk5r_0B/?igsh=YTE2Mmc1eXRiNzUw
โค1๐Ÿ‘1
๐Ÿ‘€ Let's have a Basic Quiz about SQL ๐Ÿ“Š Are you Guys ready ๐Ÿ™Œ๐Ÿป
๐Ÿ‘4โค3
1. Which SQL keyword is used to retrieve data from a database?
Anonymous Quiz
84%
A) SELECT
15%
B) UPDATE
1%
C) DELETE
3. Which SQL statement is used to delete a record from a database?
Anonymous Quiz
29%
A) DROP
13%
B) REMOVE
58%
C) DELETE
4. Which SQL function is used to count the number of rows in a table?
Anonymous Quiz
7%
A) SUM()
91%
B) COUNT(*)
2%
C) AVG()
Learn data science with this simple steps๐Ÿ‘‡๐Ÿ‘‡

โœจ๏ธYouTube Channelโœจ๏ธ

- Python: Corey Schafer
- SQL: Joey Blue
- Excel: ExcellsFun
- PowerBI: Guy in a Cube
- Tableau: Tableau Tim
- Mathematics: 3Blue1Brown
- Statistics: StatQuest
- Data Analyst: AlexTheAnalyst
- ML, DL: sentd


๐Ÿ’ฅBooks ๐Ÿ“š ๐Ÿ’ฅ

โ€ข Python for Data Analysis

โ›ณ๏ธ by Wes McKinney

โ€ข Hands-On Machine Learning

โ›ณ๏ธ by Aurรฉlien Gรฉron

โ€ข The Art of Data Science

โ›ณ๏ธ by Roger D. Peng and Elizabeth M.

Data Science from Scratch

โ›ณ๏ธ by Joel Grus


โšก๏ธPodcasts ๐Ÿ‘ฉ๐Ÿปโ€๐ŸŽ“โšก๏ธ

โ€ข Data Science at Home

โ€ข Talking Machines

โ€ข O'Reilly Data Science Podcast

โ€ข Linear Digressions

โ€ข DataFramel

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

Thanks For Joining All โ™ฅ๏ธ

๐Ÿ‘‰WhatsApp Channel for daily jobs updates :https://whatsapp.com/channel/0029VaITVKQ9mrGf9LO7RQ43
๐Ÿ‘5โค3
๐‹๐ž๐š๐ซ๐ง ๐‚๐จ๐๐ข๐ง๐  ๐Ÿ๐ซ๐จ๐ฆ ๐ฌ๐œ๐ซ๐š๐ญ๐œ๐ก & ๐œ๐ซ๐š๐œ๐ค ๐ฉ๐š๐ฒ ๐š๐Ÿ๐ญ๐ž๐ซ ๐ฉ๐ฅ๐š๐œ๐ž๐ฆ๐ž๐ง๐ญ ๐›๐š๐ญ๐œ๐ก ๐ˆ๐ง ๐‰๐ฎ๐ฌ๐ญ ๐Ÿ– ๐๐š๐ฒ๐ฌ

7th Feb - 14th Feb | 8 - 10 PM
 
๐ŸŒŸ Trusted by 6000+ Students
๐Ÿค 300+ Hiring Partners
๐Ÿ’ผ Avg. Rs. 8.3 LPA
๐Ÿš€ 41 LPA Highest Package

Here is how you can be part of :
๐Ÿ‘‰ Step 1: Register on our website
๐Ÿ‘‰ Step 2: Learn Coding From Scratch in our live classes
๐Ÿ‘‰ Step 3 : Solve coding assignments & become part of our exclusive pay after placement batch

๐‘๐ž๐ ๐ข๐ฌ๐ญ๐ž๐ซ ๐๐จ๐ฐ ๐Ÿ‘‡: -

https://bit.ly/3SuNQRe

Hurry, limited seats available!

Checkout my new reel ๐Ÿคฉ๐Ÿ‘‡

https://www.instagram.com/reel/C3Czdquva1T/?igsh=MW5yc29sOGYwbmFubA==
๐Ÿ‘2
Intel Work From Home(Hybrid) Internship Program 2024

Role :-  Graduate Technical Intern

Experience:- Student

Work Mode:- Hybrid

Qualification :- Pursuing BE/B Tech or ME/M Tech

Apply Link ๐Ÿ‘‡:-

https://bit.ly/3StRI3S


Apply before the link expires
โค2
๐Ÿ†Journey to Data Analyst in 2024: A Step-by-Step Guide!๐Ÿ‘‡

Before you start reading follow us & save this so you can check it later โœ…

1๏ธโƒฃ Lay the Groundwork: Start by solidifying your foundation in Excel, SQL, and essential statistics.

2๏ธโƒฃ Embrace Coding: Immerse yourself in Python for handling and analyzing data.

3๏ธโƒฃ Dive into Reality: Gain practical experience by working on genuine datasets, and consider participating in Kaggle competitions for hands-on learning.

4๏ธโƒฃ Elevate Visualization Skills: Bring data to vibrant life using tools like Tableau or Power BI for impactful presentations.

5๏ธโƒฃ Grasp Machine Learning Essentials: Develop a foundational understanding to set yourself apart in the field.

6๏ธโƒฃ Assemble a Stellar Portfolio: Showcase your expertise and projects to highlight your skills effectively.

7๏ธโƒฃ Connect and Learn: Engage with the data analytics community by joining groups and attending events to stay informed and inspired.

8๏ธโƒฃ Strategize Applications: Tailor your resume to match analytics roles intelligently, maximizing your chances of success

All the best!

๐Ÿ† Follow @techschoool for more amazing resources

๐Ÿ“ŒTag your friends who would like to know about this

๐Ÿ‘‰WhatsApp Channel for daily jobs updates :https://whatsapp.com/channel/0029VaITVKQ9mrGf9LO7RQ43
๐Ÿ‘‰ If you're having difficulty with the first round (Aptitude) of your interviews, these Aptitude Topics might be helpful for you. Would you like me to locate and provide some topics for on aptitude tests? ๐Ÿ™Œ๐Ÿป

๐Ÿš€ Here the direct links for RESOURCES ๐Ÿ“Œ

1.aptitudeacademy

https://youtube.com/@aptitudeacademy?si=inxwGQrVM20ii9-r

2.CareerRide

https://youtube.com/@CareerRideOfficial?si=K6ZS-Pr9bbTbruQV

3. Freshersworld.com

https://youtube.com/@freshersworld?si=JC31gxnI6AofingY

4. Study Smart

https://youtube.com/@StudySmartOfficial?si=wO4mmkn3Do4TYvlH

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

Thanks For Joining All ๐Ÿ™Œ๐Ÿป๐Ÿ’•

๐Ÿ‘‰WhatsApp Channel for daily jobs updates :https://whatsapp.com/channel/0029VaITVKQ9mrGf9LO7RQ43
โœจ๏ธ Do check our New reel ๐Ÿ‘‡๐Ÿ‘‡
https://www.instagram.com/reel/C3Fuu4wPtxp/?igsh=OG5mbHdzNGJxbjMz
Accenture is hiring for 2024

Job Position:- Associate Software Engineer โ€“ Packaged App Development

Salary Package:- 4.5 LPA To 5.5 LPA

Experience :-  0 to 11 Months

Apply Link ๐Ÿ‘‡:-

https://bit.ly/495m0B3

Apply before the link expires
๐Ÿ‘4
Google Summer Internship Program 2024

Role:- Software Engineering Intern

Location :-  Bangalore ,Hyderabad & Pune

Salary :- Upto 40,000rs /Month

Apply Link ๐Ÿ‘‡:-

https://bit.ly/4buil18

Apply before the link expires

Please complete your application before Feb 14, 2024.

NOTE :- Summer Internships start in May/June 2024 and are 10-12 weeks in duration
โค3๐Ÿ‘1