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)