TechSchoool
13K subscribers
4.2K photos
10 files
4.65K links
Download Telegram
๐Ÿ“ŒHere are some top courses offered by Google that will elevate your tech skills

โœ…1)Google Professional Workspace Administrator (Coursera)**
Specs: Duration: Approx. 2 months to complete (5 hours/week) | Certificate: Yes | Level: Beginner
Apply Link: https://www.coursera.org/professional-certificates/g-suite-administration?irclickid=xCgxLF0ZSxyPRuG2-Cw5E1hWUkFUwWx%3AEzt%3AWU0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=1359419&utm_content=b2c

Google Professional Workspace Administrator course helps you to learn about Googleโ€™s best practices to protect your users and data. After learning this course, you will able to use the tools provided to identify security events and risks.

This course teaches you how to configure, compliance and implement measures to protect your organization from spam, spoofing, and malware attacks. You will also be able to become familiar with the various mail routing options available. At the end of this Google course, you will also earn Googleโ€™s best practices for deploying G Suite into your organization.

โœ…2) Google IT Support Professional Certificate (Coursera)
Specs: Rating: 4.8 | Certificate: Yes | Level: Beginner
Apply Link: https://www.coursera.org/professional-certificates/google-it-automation?irclickid=xCgxLF0ZSxyPRuG2-Cw5E1hWUkFUwWwmEzt%3AWU0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=1359419&utm_content=b2c
Google IT Support Professional Certificate is a free program from Google that will offer tools to land an entry-level role in 6 moth time.

It includes 5 different courses on core skills you should know to obtain your Certification. This course bundle helps you learn IT support fundamentals, computer networking, operating system, IT infrastructure services, etc.

โœ…3. Google IT Automation with Python Professional Certificate (Coursera)
Specs: Rating: 4.8 | Duration: Approx. 6 months to complete (10 hours/week) | Fee: Free | Certificate: Yes | Level: Beginner
Apply Link: https://www.coursera.org/professional-certificates/google-it-automation?irclickid=xCgxLF0ZSxyPRuG2-Cw5E1hWUkFUwWwmEzt%3AWU0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=1359419&utm_content=b2c
Google IT Automation with Python Professional Certificate is a bundle of six-course certificates developed by Google to provide IT professionals with in-demand IT skills, like Python, Git, and IT automation.

This course program builds, which helps you to take your career to the next level. This learning material designed in such a way that teaches you how you can program with Python and how you can use Python to automate frequently use system administration tasks.
โœ…4. Preparing for Google Cloud Certification (Coursera)
Specs: Rating: 4.6 | Duration: Approx. 5 months to complete (3 hours/week) | Certificate: Yes | Level: Intermediate
Apply Link: https://www.coursera.org/professional-certificates/gcp-data-engineering?irclickid=xCgxLF0ZSxyPRuG2-Cw5E1hWUkFUwW3HEzt%3AWU0&irgwc=1&utm_medium=partners&utm_source=impact&utm_campaign=1359419&utm_content=b2c
Preparing for Google Cloud Certification is a hands-on course. It helps you to apply the skills you learn in the video lessons. Projects will cover topics such as Google BigQuery, which are used and configured within Qwiklabs.

You will also get practical hands-on experience with the concepts explained throughout the modules. After the end of this course, you will get a course completion certificate, which you can share with your professional network.
โค2๐Ÿ‘1
American Express Makeathon 2024

Winners stand a chance to pursue career opportunities at American Express Technology ( full time offer/internship basis eligibility) along with customized gift hampers and cash prizes worth 1.55 Lacs INR.

Apply Link๐Ÿ‘‡ :-

https://bit.ly/3Jh4i2a

Apply Before The Link Expires
๐Ÿ‘2
โœ…5. Android Basics by Google
Specs: Duration: 3 Months (At 10 hrs/week) | Certificate: No | Level: Beginner
Apply Link: https://www.udacity.com/course/android-kotlin-developer-nanodegree--nd940?irclickid=zeswydw8fxyPRQiynCwVEUViUkFUwWWGEzt%3AWU0&irgwc=1&utm_source=affiliate&utm_medium=&aff=1359419&utm_term=&utm_campaign=_best-google-course_&utm_content=&adid=786224
Android basic by Google is a course material built for aspiring Android developers who are new to programming. This course provides sound knowledge about this subject and ensure that they get the needed skills to grow their career to become a professional Android Developer.

โœ…6. Firebase in a Weekend (Udacity)
Specs: Duration: 3 Months (At 10 hrs/week) | Certificate: No | Level: Intermediate
Apply Link: https://www.udacity.com/course/firebase-in-a-weekend-by-google-android--ud0352?irclickid=zeswydw8fxyPRQiynCwVEUViUkFUwWQmEzt%3AWU0&irgwc=1&utm_source=affiliate&utm_medium=&aff=1359419&utm_term=&utm_campaign=_best-google-course_&utm_content=&adid=786224

Firebase in a Weekend is a course, which helps you to learn how to use the Firebase app development platform. After learning this course you will know how you can allow users to login, have data associated with them, and send them notifications.

โœ…7. Fundamentals of digital marketing (Google)
Specs: Rating: 4.6 | Duration: 40 hours to complete | Fee: Free | Certificate: No | Level: Beginner
Apply Link: https://skillshop.exceedlms.com/student/collection/654330-digital-marketing?locale=en-GB
Fundamental of digital marketing is the best course to learn various SEO related techniques. It is one of the best Google career certificates which is accredited by Interactive Advertising Bureau Europe.

The course contains 26 modules, helps you to explore in depth study material created by Google trainers. This study material offers plenty of practical exercises and real-world examples that help you to excel in your digital marketing knowledge.
โค1
๐‹๐ž๐š๐ซ๐ง ๐‚๐จ๐๐ข๐ง๐  ๐…๐ซ๐จ๐ฆ ๐“๐จ๐ฉ ๐ˆ๐“ ๐๐ซ๐จ๐Ÿ๐ž๐ฌ๐ฌ๐ข๐จ๐ง๐š๐ฅ๐ฌ

Ignite Your Tech Career Today: Learn, Grow, and Get Placed
 
Get placed in Top MNC's with our Pay After Placement Training

Highlights:-

๐ŸŒŸ Trusted by 6000+ Students
๐Ÿค 450+ Hiring Partners
๐Ÿ’ผ Avg. Rs. 7.2 LPA
๐Ÿš€ 41 LPA Highest Package

Eligibility: BTech / BCA / BSc / MCA / MSc

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

https://bit.ly/3SuNQRe

Hurry, limited seats available!
๐Ÿ‘3โค1
Data Analytics Internship Program 2024

Company Name :- Bizongo 

Position title โ€“ Data Analyst Intern

Stipend :- Upto 20,000rs/Month

Experience:- 0 to 1 year

Apply Link๐Ÿ‘‡ :-

https://bit.ly/442lRMY

Apply before the link expires
โค3๐Ÿ‘1
๐ŸŽฏCourses I regret doing in 2024, I should have done them before ๐Ÿฅฒ

1. Facebook Blueprint: Social Media Marketing
๐Ÿ”—Course Link: https://www.facebook.com/blueprint

2. Microsoft Learn: Introduction to Python
- ๐Ÿ”—Course Link: https://docs.microsoft.com/en-us/learn/paths/python-first-steps/

3. Google Digital Garage: Fundamentals of Digital Marketing
๐Ÿ”—Course Link: https://learndigital.withgoogle.com/digitalgarage/course/digital-marketing

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 (AI)
- ๐Ÿ”—Course Link: https://www.ibm.com/training/badge/ea9f8f2d-2e81-412a-8c73-38ed6ffba1dd

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

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

8. Cisco Networking Academy: Introduction to Cybersecurity
- ๐Ÿ”—Course Link: https://www.netacad.com/courses/cybersecurity/introduction-cybersecurity

9. HubSpot Academy: Inbound Marketing Certification
- ๐Ÿ”—Course Link: https://academy.hubspot.com/courses/inbound-marketing

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
๐Ÿ‘6โค2
Top Companies Hiring For Analytics Roles

Companies Hiring:- Genpact, EY ,HSBC , Barclays & JLL

Salary Range :- 5 LPA To 20 LPA

Location:- Across India

Apply Link ๐Ÿ‘‡:-

https://bit.ly/444B93G

Apply before the link expires
๐Ÿ‘2
CGI is Hiring for 2024
 
Role:- Trainee โ€“ Data Science

Job Location:- Bangalore, Karnataka

Experience:- Freshers

Qualification:- Graduation

Salary:- Upto 6 LPA

Apply Link ๐Ÿ‘‡:-

https://bit.ly/3vZ2kjU

Apply before the link expires
๐Ÿ‘2โค1
๐Ÿ“Š Top YouTube Channels to Master Power BI:

1๏ธโƒฃ Guy in a Cube: Adam Saxton and Patrick LeBlanc's channel offers practical Power BI tutorials and best practices, making learning a breeze. ๐Ÿ’ก

2๏ธโƒฃ Microsoft Power BI: Get in-depth insights, updates, and guidance directly from the Power BI source. Stay ahead with the official channel. ๐Ÿš€

3๏ธโƒฃ Curbal: Ruth Pozuelo's tutorials are crystal clear, providing a wide range of Power BI tips and data visualization expertise. ๐ŸŒ

4๏ธโƒฃ BI Elite: Dive into advanced Power BI content covering data modeling, DAX calculations, and more. Elevate your skills with BI Elite. ๐Ÿ“ˆ

5๏ธโƒฃ SQLBI: Marco Russo and Alberto Ferrari, industry experts, share deep insights into Power BI, DAX, and data modeling. Learn from the best. ๐Ÿง 

6๏ธโƒฃ THE Power BI Guy: Parker Stevens brings engaging tutorials and tips to create compelling reports and dashboards. Master Power BI with his approachable teaching style. ๐ŸŽ“

Don't forget to follow @techschool for more awesome content. ๐Ÿ“š
๐Ÿ‘2
TCS MBA Hiring Now Live!

Batch :- 2023 & 2024

Job Location:- Across India

Eligibility: 2 years full-time MBA/MMS/PGDBA/PGDM

Apply Link ๐Ÿ‘‡ :-

https://bit.ly/3JsvH10

Apply before the link expires
๐Ÿ‘2
Walmart FREE Internship Certification Program On Advanced Software Engineering

Apply Link๐Ÿ‘‡:-

https://bit.ly/49JihbP

Earn a certificate and add it to your resume and LinkedIn as an extra curricular activity.
๐Ÿ‘2
Top 10 Excel Interview Questions with Answers ๐Ÿ˜„๐Ÿ‘‡

1. Question: What is the difference between CONCATENATE and "&" in Excel?

Answer: CONCATENATE and "&" both combine text, but "&" is more concise. For example, =A1&B1 achieves the same result as =CONCATENATE(A1, B1).

2. Question: How can you freeze rows and columns simultaneously in Excel?

Answer: Use the "Freeze Panes" option under the "View" tab. Select the cell below and to the right of the rows and columns you want to freeze, and then click on "Freeze Panes."

3. Question: Explain the VLOOKUP function and when would you use it?

Answer: VLOOKUP searches for a value in the first column of a range and returns a corresponding value in the same row from another column. It's useful for looking up information in a table based on a specific criteria.

4. Question: What is the purpose of the IFERROR function?

Answer: IFERROR is used to handle errors in Excel formulas. It returns a specified value if a formula results in an error, and the actual result if there's no error.

5. Question: How do you create a PivotTable, and what is its purpose?

Answer: To create a PivotTable, select your data, go to the "Insert" tab, and choose "PivotTable." It summarizes and analyzes data in a spreadsheet, allowing you to make sense of large datasets.

6. Question: Explain the difference between relative and absolute cell references.

Answer: Relative references change when you copy a formula to another cell, while absolute references stay fixed. Use a $ symbol to make a reference absolute (e.g., $A$1).

7. Question: What is the purpose of the INDEX and MATCH functions?

Answer: INDEX returns a value in a specified range based on the row and column number, while MATCH searches for a value in a range and returns its relative position. Combined, they provide a flexible way to look up data.

8. Question: How can you find and remove duplicate values in Excel?

Answer: Use the "Remove Duplicates" feature under the "Data" tab. Select the range containing duplicates, go to "Data" -> "Remove Duplicates," and choose the columns to check for duplicates.

9. Question: Explain the difference between a workbook and a worksheet.

Answer: A workbook is the entire Excel file, while a worksheet is a single sheet within that file. Workbooks can contain multiple worksheets.

10. Question: What is the purpose of the COUNTIF function?

Answer: COUNTIF counts the number of cells within a range that meet a specified condition. For example, =COUNTIF(A1:A10, ">50") counts the cells in A1 to A10 that are greater than 50.
๐Ÿ‘5๐Ÿ‘1
Hi Friends,

We have launched the Python & Front End Training + Internship Program. 

Duration :- 2 Months 

If anyone is interested, kindly join using the links below.

๐๐ฒ๐ญ๐ก๐จ๐ง ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐  + ๐ˆ๐ง๐ญ๐ž๐ซ๐ง๐ฌ๐ก๐ข๐ฉ๐Ÿ‘‡ :- 

https://bit.ly/3UD7goC

๐…๐ซ๐จ๐ง๐ญ๐ž๐ง๐ ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐  + ๐ˆ๐ง๐ญ๐ž๐ซ๐ง๐ฌ๐ก๐ข๐ฉ ๐Ÿ‘‡:- 

https://bit.ly/3T8qCRg

( Limited Slots )

- Get an internship completion certificate to make a strong resume
๐Ÿ‘5โค2
TOP 10 data analytics interview questions.

1. Question: What is Tableau and how does it differ from traditional business intelligence tools?

Answer: Tableau is a data visualization and business intelligence tool that allows users to connect, visualize, and share insights from their data. It stands out for its user-friendly interface and real-time analytics capabilities.

2. Question: Explain the difference between a Tableau extract and a live connection.

Answer: A Tableau extract is a snapshot of data stored in a Tableau data extract (.hyper) file, providing faster performance. A live connection directly queries the data source in real-time.

3. Question: How can you create a calculated field in Tableau?

Answer: To create a calculated field, right-click on the data pane, select "Create Calculated Field," enter a formula, and click OK. Calculated fields allow users to perform custom calculations on the data.

4. Question: What is a dual-axis chart in Tableau, and when would you use it?

Answer: A dual-axis chart combines two different chart types on the same axes. It is useful when you want to compare two measures with different scales in a single view.

5. Question: How do you publish a Tableau dashboard to Tableau Server?

Answer: Use Tableau Desktop to open the dashboard, navigate to Server -> Publish Workbook, select the project and folder on Tableau Server, and click "Publish."

6. Question: Explain the purpose of parameters in Tableau.

Answer: Parameters allow users to create dynamic, interactive elements in a Tableau workbook. They enable users to input values that can be referenced in calculations, filters, and reference lines.

7. Question: What is the role of the Tableau Prep tool?

Answer: Tableau Prep is used for data preparation and cleaning. It helps users shape, clean, and combine data from various sources before analyzing it in Tableau.

8. Question: How does Tableau handle geographical data?

Answer: Tableau has built-in geocoding and mapping capabilities. It can automatically recognize geographic fields and generate maps, allowing users to visualize spatial data.

9. Question: What is the purpose of the LOD (Level of Detail) expressions in Tableau?

Answer: LOD expressions enable users to control the granularity of the aggregation independently of the view. This is useful when you want to perform calculations at a different level than the view.

10. Question: How can you create a dashboard in Tableau, and what components can it include?

Answer: To create a dashboard, drag sheets into the dashboard tab, arrange them, and add objects like text, images, and web pages. Components can include sheets, filters, parameters, and legends, creating an interactive and comprehensive view of the data.

Hope it helps :)
๐Ÿ‘8โค1
๐†๐ซ๐ž๐š๐ญ ๐Ž๐ฉ๐ฉ๐จ๐ซ๐ญ๐ฎ๐ง๐ข๐ญ๐ฒ ๐…๐จ๐ซ ๐’๐ญ๐ฎ๐๐ž๐ง๐ญ๐ฌ, ๐…๐ซ๐ž๐ฌ๐ก๐ž๐ซ๐ฌ & ๐„๐ฑ๐ฉ๐ž๐ซ๐ข๐ž๐ง๐œ๐ž๐ ๐๐ซ๐จ๐Ÿ๐ž๐ฌ๐ฌ๐ข๐จ๐ง๐š๐ฅ๐ฌ 

Apply To 100+ Internships & Job Opportunities 

Salary:- 3 LPA To 25 LPA

Job Location:- Across India/WFH

๐‘๐ž๐ ๐ข๐ฌ๐ญ๐ž๐ซ & ๐”๐ฉ๐ฅ๐จ๐š๐ ๐‘๐ž๐ฌ๐ฎ๐ฆ๐ž:- 

https://bit.ly/3xiGdFq

Complete the registration process & apply to the jobs that match your profile. 

Imp Note:- Recruiters don't ask for money in exchange for a job. Becalls Aware of fake calls!
Top Companies Hiring For Human Resources (HR) Roles

Companies Hiring :- Accenture , Pepsico , JPMorgan & Wells Fargo

Salary Range:- 4 LPA To 25 LPA

Location :- Across India

Apply Link ๐Ÿ‘‡:-

https://bit.ly/4b1QKTO

Apply before the link expires.
Top Companies are hiring for Data Analyst roles for freshers

Companies Hiring :- Cognizant , JPMorgan & S&P Global

Salary Range:- 3/5 LPA To 16 LPA

Location :- Across India

Apply Link ๐Ÿ‘‡:-

https://bit.ly/3UwNdaM

Apply before the link expires.
๐Ÿ‘3