Welcome to Software Engineers's Private Community

Best way to learn and practice python and sql. Help me with platforms and ideas to get withit

Application analyst

Best way to learn and practice python and sql. Help me with platforms and ideas to get withit- Grapevine

Welcome to Indian Startups's Private Community

Need to practice sql for an interview, which website/tool to use.
Have went through course on w3 school but need to practice.

SQL help

Product Manager

Welcome to IT Company Discussion's Private Community

hi, whoever is reading this, i hope you are doing great and wish you good health. 
Could you please guide me in this?

As a fresher I joined TCS & since then I've been working on a mainframe support project for the past 3 years. I want to change my role as Data Analyst from mainframe. My management is not willing to release me, so the only option i have is to switch from TCS. 

Currently I'm doing Google Data Analytics certification. 
Apart from this, what should I do, to get a data analyst job offer? Could you please guide me to shape  my career as data analyst?

Thanks for reading this far. I wish you all the best.

Need Guidance

Systems Engineer

Welcome to Product Managers's Private Community

I have done my bachelors and have read databases during my degree. But I am not really good at them because there has been quite some time. I have been not using SQL and not writing queries. So would love to know how I can sort of brush up my skills and sort of learn basics of SQL is and joins and reading data from database so that I will be able to sort of query data during my day to day job as a product manager.

What is the best way to learn SQL for PMs?

Which are the  best non-coding jobs presently which pay a good amount of salary and have wide opportunities in the market .

Career change

Software Developer

Welcome to Data Scientists's Private Community

Hey people of Grapevine,

I have an MBA in finance and I'm currently working as a QA data analyst at Wells Fargo.
I have a previous 1 year 3 months workex as an Android developer in a startup company (I'm a CS undergrad).

The current role I'm working in requires coding in python to automate Excel files we get to check certain data standards for compliance and validate Excel files based on some standards. Mostly even manual validation of excel files. 

I want to switch my job to work in good ML projects with finance as my domain, for this I have made a strategy:
1. Get a FRM level 1 certification (for the CV to get shortlisted)
2. Learn ML on Kaggle and solve problem sets as a way to prepare for the interviews of ML roles.
3. I'm considering to get an FDP certification as well. (https://fdpinstitute.org/Curriculum-Overview)

My concerns now are:
1. Is the above a valid startegy to crack a fin ML role? (please suggest if anything better)
2. Is FDP a good certification (I know it's not much heard of, but the curriculum is good)
3. What kind of companies and roles can I apply for if add these CV points and if I can get skilled in the above? 

Please do give me your inputs. Any kind of suggestions are appreciated.

Strategy to convert an ML role

Data analyst

I am almost 7 years of experience as Data Analytics Engineering Lead which includes skills like Azure Cloud, Azure Databricks, Azure Data Factory, Storage Services, Power BI and related techniques. Also leading team of 7 members currently. 
Any leads and help is highly appreciated.!!

Looking out for new opportunities

Team lead

Help Need Guys! Can someone please share some SQL and Python Interview Questions to Prepare... I am prepping for a BI and Analytics Role so would be a huge help if you guys can share some useful references you use or share questions you think one should know of!

SQL and Python Interview Questions!

I am a fresher working as a Data analyst in a growing startup. My current role doesn't include much of coding just python and SQL and sometimes little bit ML work. Currently handling 2 projects, and some of PM work to define some roadmaps.
I like engineering and coding in whole and want to know more. So do I switch to some SDE role or is there are more paths after Data analytics? I know ML, DL and NLP but not sure will it be a great choice to make career primarily in Data science.
So, I am little confused. Please give all good advices.

Thanks
A curious Engineer

What after Data analytics?

Every institution, college,  edtech is selling courses.. And every influencer is claiming it’s the next big thing. Any advice on where can a rookie start from to understand what entails being a data analyst!  Where does one start if one wants to get into it?

How can one get into data analytics?

Business Development Manager

I will be using a scale of 10 for better quantification. 


Python : 7/10
SQL: 7/10
PowerBI: 9/10
ML(Pandas): 6/10
PLSQL: 6/10
Advanced Excel: 8/10
Azure Databricks + DataFactory : Started learning
Apache Spark: Started learning
Communication skills: 9/10

Prior Work Ex: 1.8yrs as a PLSQL developer (started off as a fresher) + one SAP internship of 4months + one Data analyst internship of 1 month

Aspiration : Data Engineering Role

1. Is the above techstack enough to get me a good data engineering role? Will I be able to clear the technical rounds at companies like accenture, IBM etc with this profile? I have heard the barrier to entry for data engineering is higher than that of data analyst.

2. Do I need to learn DSA?

3. What salary range do I fall in with this profile? 


I seek your honest answer. I feel lost. 

Also, should I focus more on improving my cloud skills or shall I be more competent with my python skills? Which one would pay me off in a better sense financially? I certainly can not focus on all the tools at once.

Rate My Techstack: Potential Data Engineering Roles

Data engineer

Need Course suggestions to learn SQL from scratch as a program manager

Program Manager

Will be starting a Product Analyst role in July at a fintech firm. What skills should I try to acquire as a pre-requisite for the role? so that I am not surprised and overwhelmed initially.

Skills for a new Product role

Chemical engineer

I am trying to switch to a Data engineering role in a product based company. Please suggest some great practices and strategies to learn DSA with python and SQL to crack interviews at product based companies. 
 I have experience working in AWS data orchestration where I worked on step function creation, Glue, lambda, event bridge. Also used version control like GitHub. 
 Please suggest a way to crack interviews at product based companies for data engineering roles.

Strategies for learning DSA with python, SQL, Spark

Hi!

I'm a CA Inter pass out with about 7 years work ex. 
I have worked in fields such as Accounting, Audit, Taxation, Compliance and Reporting. 

And i for a fair fact also believe i have a thing for Data analytics. 
I get too excited when i have to work with large chunks of data on a spreadsheet to formulate results out of it. 

I want to get into Data Analytics. 
How do I go about it ? 
I have been learning R and Python at a slow pace. 

Suggestions and inputs are most welcome.

Career guidance for switching into Data Analytics

Finance Operations

How much time does it take to learn SQL since it is required everywhere for data science jobs.

Analyst

Hi fellow Grapeviners,  
Can you help with good online resources (youtube/courses) to build a solid understanding of SQL. I want a course that can help me to grasp the basics of SQL from beginner to intermediate/advance level.

SQL Onine Resources

Corporate Strategist

As the question says I’m interested in learning to code. Background: the closest I’ve come to coding is writing SQL/R code. 
Last weekend I started with Harvard CS50 class on Edx and I’m interested in pursuing this further. I’m aware of websites like W3CSchools and Replit. But if someone can suggest a path, I’ll be super grateful

How to learn coding (non tech background )

Founder

A bit of intro:

I started my career in ops in manufacturing, with time I have moved to tech (across various roles ops, marketing, product, project, analytics and eventually sales).
I have sold SaaS, SaaS+Service, and was part of the team that closed reinsurance deals.

What I am making:
I have created a bit of python programs for data analysis, Twitter bots, web scrapping, etc (it's on my website - https://talesofss.com/ ), but don't know how to make web apps. 

I am here to learn:
What do I have to learn to be able to create small online projects

1. Like if I want to create an online platform where people can share their excel sheets and the program does the analysis for them, and output is a few Excel files - know a few US orgs that could pay for this

2. Webp converter online (I created a Mac app, but don't know how to bring it online) - this is to make my life easier 

3. Publish a database but only the first 100 is visible, post which users have to share their email IDs to view the rest - this can be used for user acquisition/monetization

I tried Java, css, html with ChatGPT but still don't know how to publish the results online

Currently doing a course on AWS EC2 but it's too confusing

Looking for someone to either help me build these or point me in the right direction :)

Best way to learn and practice python and sql. Help me with platforms and ideas to get withit

Discover More

Indian Startups on

by Coy Lee

Paytm

SQL help

IT Company Discussion on

by Jordon Taye

TCS

Need Guidance

Product Managers on

by Kendall Carmden

Seed Stage Startup

What is the best way to learn SQL for PMs?

Software Engineers on

by Jordon Lee

Accenture

Career change

Data Scientists on

by Isaiah Nadeen

Wells Fargo

Strategy to convert an ML role

Big 4 on

by Dezi Gabriel

Publicis Sapient

Looking out for new opportunities

Layoffs on

by Blair Vernon

Stealth

SQL and Python Interview Questions!

Software Engineers on

by Jordon Vernon

Student

What after Data analytics?

Data Scientists on

by Dezi Carmden

Searching

How can one get into data analytics?

Referrals on

by Kendall Lee

Stealth

Rate My Techstack: Potential Data Engineering Roles

FAANG on

by Isaiah Taye

Amazon

Need Course suggestions to learn SQL from scratch as a program manager

Product Managers on

by Jordon Lee

Bharat Petroleum Corpn. Ltd.,

Skills for a new Product role

Software Engineers on

by Isaiah Gabriel

Unemployed

Strategies for learning DSA with python, SQL, Spark

Layoffs on

by Jordon Vernon

The/Nudge Institute

Career guidance for switching into Data Analytics

Data Scientists on

by Kalan Gabriel

IT World

How much time does it take to learn SQL since it is required everywhere for data science jobs.

Misc on

by Jordon Carmden

Stealth

SQL Onine Resources

Software Engineers on

by Kendall Lee

Stealth

How to learn coding (non tech background )

Software Engineers on

by Coy Hyrum

Unnamed

Need help from Indie Developers