DEV Community

Ramya .C
Ramya .C

Posted on

Day 15 – Data Analytics Journey !

Today, I learned about SQL (Structured Query Language) and its importance in data analytics.

Here’s what I covered today:

  1. What is SQL?
  • SQL stands for Structured Query Language.
  • It is used to store, retrieve, update, and manage data in databases.
  1. Why we use SQL?
  • To interact with databases easily.
  • To manage large amounts of structured data efficiently.
  1. Platforms Used to Run SQL:
  • MySQL Workbench (GUI tool)
  • Command Prompt / Terminal (using MySQL CLI)
  • Online SQL Editors like SQLFiddle, Mode Analytics
  • Database Management Systems like Oracle, PostgreSQL, MS SQL Server
  1. What is Big Data?
  • Big Data means extremely large datasets that cannot be handled by traditional data processing tools.
  1. Key Components in SQL:
  • Tables
  • Queries
  • Keys (Primary, Foreign)
  • Constraints
  • Joins
  1. Rules for Writing Queries:
  • Use proper SQL syntax.
  • Always end queries with a semicolon.
  • Use uppercase for SQL keywords for readability.
  1. SQL Categories:
  • DDL (Data Definition Language) → CREATE, ALTER, DROP
  • DML (Data Manipulation Language) → INSERT, UPDATE, DELETE
  • DQL (Data Query Language) → SELECT
  • DCL (Data Control Language) → GRANT, REVOKE
  • TCL (Transaction Control Language) → COMMIT, ROLLBACK, SAVEPOINT
  1. How to Write SQL in Command Prompt:
  • Open Command Prompt → Type mysql -u root -p
  • Enter password → Start writing SQL commands.
  1. How to Use MySQL:
  • Install MySQL.
  • Log in via Command Prompt or MySQL Workbench.
  • Create databases and tables, then run queries.

Task of the Day:
Created a table named Student with the following columns:


sql
CREATE TABLE Student (
    name VARCHAR(50),
    age INT,
    phone_number BIGINT

);
Enter fullscreen mode Exit fullscreen mode

Top comments (1)

Collapse
 
star_dewvalleyapk_2b60f profile image
Star Dew valley apk • Edited

Absolutely loving the clarity and structure in your learning journey! You've nailed the fundamentals of SQL and even touched on its role in handling Big Data—solid groundwork for any aspiring data analyst. Creating the Student table is a great hands-on start for a game. As you progress, try experimenting with constraints like PRIMARY KEY or NOT NULL to make your schema more robust. Keep building and querying—SQL mastery is all about practice and curiosity. Looking forward to seeing what you tackle next! 👏