DEV Community

Yogaraj
Yogaraj

Posted on

"Week 2 Update: Starting SQL Basics Alongside My AWS Learning"

Hey everyone! πŸ‘‹

Checking in with my Week 2 learning update β€” shifting gears a bit alongside AWS to start exploring SQL fundamentals. Here’s what I covered this week using MySQL for hands-on practice:

πŸš€ What I Learned This Week:
πŸ”Ή Core Concepts:

Data Types: Qualitative vs. Quantitative

DBMS vs. RDBMS: Understanding how SQL talks to databases

Local Server Setup & MySQL Installation

πŸ”Ή Table Basics:

Creating Tables

SQL Data Types: NUMBER, TEXT, DATE

CHAR vs. VARCHAR

πŸ”Ή Table Constraints:

PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK

DEFAULT, AUTO_INCREMENT

πŸ”Ή Operators & Commands:

Comparison + Logical Operators (AND, OR, NOT)

SQL Command Types: DDL, DML, DQL, TCL, DCL

GROUP BY + HAVING β€” filtering grouped data

✍️ Why SQL?
Since many cloud roles involve working with databases, I wanted to build up SQL fundamentals alongside AWS.

βœ… Next Up:
SQL JOINS

Subqueries

Real-world practice scenarios

That’s my SQL progress so far as part of my AWS learning journey. Next, I’ll dive deeper into JOINS, subqueries, and real-time SQL scenarios.

Thanks for stopping by β€” and if you're also on a similar path, let’s connect and grow together! 🌱

Follow me for weekly updates and reflections from my cloud learning journey.

aws #cloudcomputing #sql #linux
πŸ’­ Got suggestions, feedback, or just want to say hi?

πŸ“© Reach me at: yogarajprof@gmail.com

Top comments (0)