DEV Community

Cover image for MySQL for Data Analytics
Ruthvik Raja M.V
Ruthvik Raja M.V

Posted on • Edited on

1

MySQL for Data Analytics

To learn SQL from basics I have uploaded all the related files in Github and the link is provided below.

The following topics are covered:-

1)DDL

2)DML

3)DCL

4)TCL

5)Keys

6)Relational Schema

7)Data Types

8)Constraints

9)Operators

10)WildCard Characters

11)Aggregate Functions

12)GROUP BY, ORDER BY

13)WHERE (vs) HAVING

14)LIMIT

15)JOINS

16)UNION (vs) UNION ALL

17)SubQueries

18)EXISTS (vs) IN

19)Views

20)Stored Routines

21)Advanced SQL Topics like Triggers, Variables, INDEX, CASE etc

Link to access all the related files:
https://github.com/ruthvikraja/SQL

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay