Tech Academy
Open in Telegram
Tech enthusiast on a journey through the digital realm 🌐| Making tech simple, one post at a time| Join me and let's explore together! 🚀
Show more902
Subscribers
No data24 hours
-57 days
-1530 days
Data loading in progress...
Similar Channels
Tags Cloud
No data
Any problems? Please refresh the page or contact our support manager.
Incoming and Outgoing Mentions
---
---
---
---
---
---
Attracting Subscribers
September '24
September '24
+2
in 0 channels
August '24
+905
in 0 channels
| Date | Subscriber Growth | Mentions | Channels | |
| 25 September | +1 | |||
| 24 September | 0 | |||
| 23 September | 0 | |||
| 22 September | 0 | |||
| 21 September | 0 | |||
| 20 September | 0 | |||
| 19 September | 0 | |||
| 18 September | 0 | |||
| 17 September | 0 | |||
| 16 September | 0 | |||
| 15 September | 0 | |||
| 14 September | +1 | |||
| 13 September | 0 | |||
| 12 September | 0 | |||
| 11 September | 0 | |||
| 10 September | 0 | |||
| 09 September | 0 | |||
| 08 September | 0 | |||
| 07 September | 0 | |||
| 06 September | 0 | |||
| 05 September | 0 | |||
| 04 September | 0 | |||
| 03 September | 0 | |||
| 02 September | 0 | |||
| 01 September | 0 |
Channel Posts
Here's the direct links for playlists to learn Java in easy way.
1. Kunal Kushwaha
Java DSA Interview Preparation Course
Link- https://youtube.com/playlist?list=PL9gnSGHSqcnr_DxHsP7AW9ftq0AtAyYqJ&si=mBNH0M802rLiNGWr
2. Bro Cade
Java Full Course for free
Link- https://youtu.be/xk4_1vDrzzo?si=meqrXm5XH5L_uG_3
3. Apna College
Java & DSA Course for Placement
Link- https://youtube.com/playlist?list=PLfqMhTWNBTe3LtFWcvwpqTkUSlB32kJop&si=r5LcDdLtCeTFHWxL
4. Telusko
Java Tutorial For beginners
Link- https://youtube.com/playlist?list=PLsyeobzWxl7pe_IiTfNyr55kwJPWbgxB5&si=NRMfaM1ccx5lEEq0
| 2 | Here's the link for YouTube channels which will teach you DSA in understanding way
1. Abdul Bari
Link- https://youtube.com/@abdul_bari?si=PArOQMsqOPqdJO5b
2. Michael Sambol
Link- https://youtube.com/@michaelsambol?si=QaWDGJsmSCUJ2AbB
3. NeetCode
Link- https://youtube.com/@neetcode?si=VvBJMuheeXXQSfqD | 0 |
| 3 | Here's the website that have Cheat sheet of every PROGRAMMING LANGUAGE , Shortcut for software and chatGPT prompt to solve coding problems.
Link- https://quickref.me/ | 0 |
| 4 | Youtube Channels which will make you a MERN Stack Developer in 50 Days
HTML and CSS
1. freeCodeCamp
Link- https://youtube.com/@freecodecamp?si=ixK2o_ZvgKVW5qBj
2. ProgrammingWithMosper
Link- https://youtube.com/@programmingwithmosh?si=4pKSR6noZ3yPQYqp
JavaScript
1. Namastey Javascript Akshay saini
Link- https://youtube.com/playlist?list=PLlasXeu85E9cQ32gLCvAvr9vNaUccPVNP&si=5PLfF1-FdKhpzBLK
2. ProgrammingWithMosh
Link- https://youtube.com/@programmingwithmosh?si=4pKSR6noZ3yPQYqp
MongoDB
1. freeCodeCamp
Link- https://youtube.com/@freecodecamp?si=ixK2o_ZvgKVW5qBj
2. Amigoscode
Link- https://youtube.com/@amigoscode?si=597jVoS38Gu8sWMZ
Node & Express
1. freeCodeCamp
Link- https://youtube.com/@freecodecamp?si=ixK2o_ZvgKVW5qBj
2. Traversy Media
Link- https://youtube.com/@traversymedia?si=RCVC2C4013Lveeff
React.
1. Codevolution
Link- https://youtube.com/@codevolution?si=sDkfb8FbXj27IOzv
2. Academind
Link- https://youtube.com/@academind?si=vhv9xADAIg-jqkiz
3. Traversy Media
Link- https://youtube.com/@traversymedia?si=RCVC2C4013Lveeff
Git and Github
1. freeCodeCamp
Link- https://youtube.com/@freecodecamp?si=ixK2o_ZvgKVW5qBj
2. Codewithharry - hindi
Link- https://youtube.com/@codewithharry?si=stq_d9Ny4wtkhGDD | 0 |
| 5 | Here's the direct links for games to learn SQL
1. SQL murder Mystery
Link- https://mystery.knightlab.com/
2. SQL Island
Link- https://sql-island.informatik.uni-kl.de/
3. SQL Police Department
Link- https://sqlpd.com/ | 0 |
| 6 | Start your career in data analysis for freshers 😄👇
1. Learn the Basics: Begin with understanding the fundamental concepts of statistics, mathematics, and programming languages like Python or R.
2. Acquire Technical Skills: Develop proficiency in data analysis tools such as Excel, SQL, and data visualization tools like Tableau or Power BI.
3. Gain Knowledge in Statistics: A solid foundation in statistical concepts is crucial for data analysis. Learn about probability, hypothesis testing, and regression analysis.
Free course by Khan Academy will help you to enhance these skills.
4. Programming Proficiency: Enhance your programming skills, especially in languages commonly used in data analysis like Python or R. Familiarity with libraries such as Pandas and NumPy in Python is beneficial. Kaggle has amazing content to learn these skills.
5. Data Cleaning and Preprocessing: Understand the importance of cleaning and preprocessing data. Learn techniques to handle missing values, outliers, and transform data for analysis.
6. Database Knowledge: Acquire knowledge about databases and SQL for efficient data retrieval and manipulation.
7. Data Visualization: Master the art of presenting insights through visualizations. Learn tools like Matplotlib, Seaborn, or ggplot2 for creating meaningful charts and graphs. If you are from non-technical background, learn Tableau or Power BI.
8. Machine Learning Basics: Familiarize yourself with basic machine learning concepts. This knowledge can be beneficial for advanced analytics tasks.
9. Build a Portfolio: Work on projects that showcase your skills. This could be personal projects, contributions to open-source projects, or challenges from platforms like Kaggle.
10. Networking and Continuous Learning: Engage with the data science community, attend meetups, webinars, and conferences. Build your strong Linkedin profile and enhance your network.
11. Apply for Internships or Entry-Level Positions: Gain practical experience by applying for internships or entry-level positions in data analysis. Real-world projects contribute significantly to your learning.
12. Effective Communication: Develop strong communication skills. Being able to convey your findings and insights in a clear and understandable manner is crucial. | 0 |
| 7 | Here's the direct playlists of YouTube channels that helped me throughout my CS degree.
1. take U forward
Link- https://youtube.com/playlist?list=PLgUwDviBIf0oF6QL8m22w1hIDC1vJ_BHz&si=AsN0MbTFJMWKRMoB
2. Jenny's Lectures CS IT
Link- https://youtube.com/playlist?list=PLdo5W4Nhv31b33kF46f9aFjoJPOkdlsRc&si=b3Y7oHOMhD8AnqVC
3. Neso Academy ( Operating System )
Link- https://youtube.com/playlist?list=PLBlnK6fEyqRiVhbXDGLXDk_OQAeuVcp2O&si=z0ZZvFpXvgSycFWu
4. Sheryians Coding School
Link- https://youtube.com/playlist?list=PLbtI3_MArDOkNtOan8BQkG6P8wf6pNVz-&si=ShuY5-64b-VMdUnZ | 0 |
| 8 | Here's the link for the YouTube channels which helps to crack product based company
1. Take U forever
Link- https://youtube.com/@takeuforward?si=bPUZhrioeZDYQkoC
2. CodeHelp - by Babbar
Link- https://youtube.com/@codehelp?si=IHR6kcwG1n3NvYug
3. Aditya Verma
Link- https://youtube.com/@theadityaverma?si=1P2TLSpCU8r0sVrP
4. CodeWithHarry
Link- https://youtube.com/@codewithharry?si=CyjswMrp2w0_9sNV | 0 |
| 9 | Here's the free courses provided by Microsoft.
1. AI FOR BEGINNER
LINK- https://microsoft.github.io/AI-For-Beginners/
2. IOT FOR BEGINNER
Link- https://microsoft.github.io/IoT-For-Beginners/#/
3. Machine learning for beginners
Link- https://microsoft.github.io/ML-For-Beginners/#/
4. Data science for beginners
Link- https://microsoft.github.io/Data-Science-For-Beginners/#/ | 0 |
| 10 | 💥📚These SQL interview questions typically asked in a Data Analyst interview?
1.What distinguishes a Primary key from a Unique key?
Primary key uniquely identifies each record in a table and cannot contain null values, whereas a Unique key also uniquely identifies records but can contain null values and multiple unique keys can exist in a table.
2. Define Candidate key.
Candidate key is a key or set of keys that uniquely identifies each record in a table. It can be a combination of Primary and Alternate keys.
3.Explain the concept of Constraint in SQL.
A Constraint is a specific rule or limit defined in a table to enforce data integrity. Examples include NOT NULL and AUTO INCREMENT.
4. Differentiate between TRUNCATE and DELETE commands.
TRUNCATE is a DDL command that removes all data from a table while preserving the table's structure, and it is faster than DELETE. DELETE is a DML command that removes specific rows based on conditions and operates slower than TRUNCATE as it deletes data row by row.
5.Compare and contrast a 'View' and a 'Stored Procedure'.
A View is a virtual table derived from one or more base tables, often used to simplify complex queries, while a Stored Procedure is a precompiled collection of SQL statements stored on the database server, used to perform specific tasks or operations.
6.What sets apart a Common Table Expression from a temporary table?
A Common Table Expression (CTE) is a temporary result set defined within the execution scope of a single SELECT, DELETE, or UPDATE statement, while a temporary table is stored in TempDB and persists until the session ends.
7.Contrast a clustered index with a non-clustered index.
A clustered index determines the physical ordering of data in a table and there can be only one clustered index per table. In contrast, a non-clustered index is similar to an index in a book where data is stored separately from the index, and multiple non-clustered indexes can exist for a table.
8.Define triggers in SQL and their purpose.
Triggers are SQL codes that automatically execute in response to certain events on a table, such as INSERT, UPDATE, or DELETE operations. They are used to maintain data integrity and perform actions based on specific conditions.
React 👍❤️ to this it helps you in your Data Analyst interview.. | 0 |
| 11 | I am sharing '100 data science project' with you | 0 |
| 12 | Here are the YouTube channels and there specific playlists from which I learnt javascript.
1. LearnCode.academy
Javascript Fundamentals
Link- https://youtube.com/playlist?list=PLoYCgNOIyGACnrXwo5HMCfOH9VT05znGv&si=XVqgqS0laf3TRbAE
2. Code With Dary
JavaScript Fundamentals
Link- https://youtube.com/playlist?list=PLFHz2csJcgk_05eXbkFNlJbA6fksXohDW&si=l7_JanQDhYwoH7Fu
3. CodeWithHarry
JavaScript Tutorials for Beginners in Hindi
Link- https://youtube.com/playlist?list=PLu0W_9lII9ahR1blWXxgSlL4y9iQBnLpR&si=kPG7fMOto8qqC-Rf | 0 |
| 13 | Here are 4 best websites to practice code.
1. Hacker rank
Link- https://www.hackerrank.com/
2. Code chef
Link- https://www.codechef.com/
3. Geeks for geeks
Link- https://www.geeksforgeeks.org/
4. Leetcode
Link- https://leetcode.com/ | 0 |
| 14 | Tips for using Data Analysis tools 🔥
💁Understand Your Tools: Take the time to thoroughly understand the features and capabilities of the data analysis tools you're using. This knowledge will empower you to use them more effectively.
💁Data Cleaning is Key: Before diving into analysis, ensure your data is clean and well-organized. Address missing values, outliers, and inconsistencies to ensure accurate results.
💁Document Your Process: Keep detailed documentation of your analysis process, including the steps taken and the reasoning behind them. This makes it easier to revisit and share your work.
💁Utilize Keyboard Shortcuts: Learn and use keyboard shortcuts for your chosen tools to improve efficiency. This can save a significant amount of time in the long run.
💁Explore Visualization Options: Experiment with various visualization techniques to represent your data. Visualizations often make complex patterns easier to understand and communicate.
💁Master the Art of Querying: If you're using SQL or similar query languages, practice and become proficient in writing efficient and effective queries. This skill is fundamental for extracting valuable insights from databases.
💁Stay Organized: Keep your files, code, and datasets organized. Establish a clear folder structure and naming conventions to make it easy to locate and understand your work.
💁Validate Results: Double-check your results using different methods or tools. Verifying your findings helps ensure the accuracy and reliability of your analysis.
💁Collaborate and Seek Feedback: If you're working in a team, collaborate with others and seek feedback on your analysis. This can lead to valuable insights and improvements.
💁Continuous Learning: Data analysis tools are continually evolving. Stay curious and invest time in staying updated with the latest features, tools, and best practices in data analysis.
👉👉Applying these tips can enhance your efficiency and the quality of your data analysis work. | 0 |
| 15 | Complete all courses and get Certificate from Chegg
Link- https://skills.internships.com/dashboard
Data and Analytics
Career Development
IT and Cybersecurity
Software Engineering
Marketing
Finance and Accounting
Critical Thinking
Design | 0 |
| 16 | 🚀👉Explore these essential books to delve into the world of data analytics...
1. "Python for Data Analysis" by Wes McKinney
2. "The Data Warehouse Toolkit" by Ralph Kimball
3. "Data Science for Business" by Foster Provost and Tom Fawcett
4. "Storytelling with Data" by Cole Nussbaumer Knaflic
5. "SQL Performance Explained" by Markus Winand
6. "Data Analytics Made Accessible" by Anil Maheshwari
7. "Data Science from Scratch" by Joel Grus
8. "Big Data: A Revolution That Will Transform How We Live, Work, and Think" by Viktor Mayer-Schönberger and Kenneth Cukier
9. "Data Mining: Concepts and Techniques" by Jiawei Han and Micheline Kamber
10. "R for Data Science" by Hadley Wickham and Garrett Grolemund | 0 |
| 17 | TCS
Role:- Data Analyst /Data Scientist
Job Location:- Across India
Salary:- Upto 8 LPA
Last Date To Apply :- Friday, 17th May 2024
Apply Link :- https://www.tcs.com/careers/india/tcs-atlas-hiring-2024
Comment YES If Interested | 0 |
| 18 | 1. Techdose
Link- https://youtube.com/@techdose4u?si=bAUVXMXlpmxe1m4e
2. Arsh Goyal
Link- https://youtube.com/@ArshGoyal?si=e4zrp6cPOJfJheC9
3. Aditya Verma
Link- https://youtube.com/@TheAdityaVerma?si=p_HmAzws8T-aeWnh
4. take U forward
Link- https://youtube.com/@takeUforward?si=a5GKVyXeJ1x-L33F
5. CodeNCode
Link- https://youtube.com/@codencode?si=dHySstcpeVDAA76h | 0 |
| 19 | https://www.instagram.com/reel/C6n9bgayyZ7/?igsh=MXhkaWEzbTd5Y291ZQ==
Here are the direct links to the free courses provided by Google:
1) Digital Marketing: [Google Digital Garage](https://learndigital.withgoogle.com/digitalgarage)
2) Artificial Intelligence: [Google AI](https://ai.google/education/)
3.) Machine Learning: [Machine Learning Crash Course](https://developers.google.com/machine-learning/crash-course)
4.) Google Analytics: [Google Analytics Academy](https://analytics.google.com/analytics/academy/)
5.) Google Display Campaign: [Google Ads Display Certification](https://skillshop.exceedlms.com/student/path/18068) | 0 |
| 20 | Learn SQL in seven days.
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
✔ 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. | 0 |
