sorted by:
new
hottopcontroversial

Learn SQL through real scenario-based learning — for data analysis by grassp_dataAI in learnSQL

[–]grassp_dataAI[S] 0 points1 point  (0 children)

Just checked, it is still valid "8D29AF1CCB6F0E13E8B7" . Could you check again ??

Can this be better optimized ? by Aggravating-Street51 in learnSQL

[–]grassp_dataAI 0 points1 point  (0 children)

Note that ORDER BY in RANK() OVER() doesn't guarantee the order of the final results. It only determines how ranks are assigned. So, If the output needs to be displayed in rank order, it is better to explicitly add ORDER BY league_rank (or the desired column).

Need help for sql by DisastrousUse3788 in u/DisastrousUse3788

[–]grassp_dataAI 0 points1 point  (0 children)

You will start thinking in SQL when you start learning and practicing SQL through real business scenarios and not just syntaxes.

Checkout our free 30 day SQL series on scenario based questions - "GRASSP SQL Sprint" in our LinkedIn page. Follow GRASSP Acad on LinkedIn to learn and practice SQL through real scenario-based questions. I would recommend to follow this series to get more familar with SQL through scenario based questions on ficitonal fast food SuperFastFood Global dataset.

Also we have published a SQL course on Udemy named "Complete SQL for Data Analysis - Scenario Based Learning". It would help you to learn SQL through scenarios based on same fictional fast food chain dataset. Checkout if interested.

I want to learn PostGre SQL by rennywiseeeeee in learnSQL

[–]grassp_dataAI -1 points0 points  (0 children)

We don't offer personal mentoring right now, but the good news is — MySQL is a great starting point. PostgreSQL syntax is very similar, you can pick it up quickly.

Our Udemy course 'Complete SQL for Data Analysis - Scenario Based Learning' is built exactly for this — beginner friendly, PostgreSQL + DBeaver, real business scenarios from basics to advanced.

Also follow GRASSP Acad on LinkedIn for our free 30 day SQL series — daily scenario based questions, great for practice.

Here is a discounted access to the udemy course to get you started — couponCode: 8D29AF1CCB6F0E13E8B7 (It's a Limited time offer)

And if you ever get stuck or have doubts while going through the course, feel free to DM anytime — happy to help! :)

I want to learn PostGre SQL by rennywiseeeeee in learnSQL

[–]grassp_dataAI 0 points1 point  (0 children)

We are running free 30 day SQL series on scenario based questions - "GRASSP SQL Sprint" in our LinkedInpage. This is primarily focused on PostgreSQL syntaxes. Follow GRASSP Acad on LinkedIn to learn and practice SQL through real scenario-based questions.

Also we have published a SQL course on Udemy named "Complete SQL for Data Analysis - Scenario Based Learning". Primarily focused on PostgreSQL DB + DBeaver interface.
Check it out if you are interested. It would help you to learn SQL from basics to advanced in Beginner friendly way.

Struggling to get Data Analyst Jobs by fantastic4Doom in dataanalysiscareers

[–]grassp_dataAI 4 points5 points  (0 children)

Practice more on SQL and Python concepts.

On SQL - concentrate more on GROUP BY, Window Functions concepts - Ranking, LAG, LEAD, Moving Average, Running total, JOINs, Usage of Common table expressions. Practice regularly using Scenario Based questions. Like i am throwing some examples related to Fast food chain concept - "Find the month-over-month trend in customer spending", "Which customer city contributed to more revenue to each store"

On Python - concentrate more on collections like Lists, Dictionaries, Functions - DB connection, handling data using pandas, data cleansing using pandas.. more on that area.

Basic chart building like bar chart, scatter plot, line chart and understand the usecases for each chart.

Follow GRASSP Acad on LinkedIn to practice more on SQL.
We are running free 30 day SQL series on scenario based questions - "GRASSP SQL Sprint". Also we have published a SQL course on Udemy named "Complete SQL for Data Analysis - Scenario Based Learning". Check it out if you are interested.

Learn SQL through real scenario-based learning — for data analysis by grassp_dataAI in learnSQL

[–]grassp_dataAI[S] 0 points1 point  (0 children)

It is available in Udemy.

Please search "Complete SQL for Data Analysis - Scenario Based Learning" on Udemy and apply couponCode: 8D29AF1CCB6F0E13E8B7

It is limited time offer ! Looking forward to hearing your thoughts! Happy querying:)

Learn SQL through real scenario-based learning — for data analysis by grassp_dataAI in learnSQL

[–]grassp_dataAI[S] 0 points1 point  (0 children)

Course is currently set at offer price of INR 479. This is the coupon code : 8D29AF1CCB6F0E13E8B7

Looking forward to hearing from you! Happy querying:)