A naukri.com initiative
Dev
1M
172
Image Credit: Dev
My Cloud Journey — Week 4: Databases (MySQL)
- This week's learning focused on databases and SQL, examining various topics such as primary, natural, composite, and surrogate keys, as well as different types of databases and commands.
- SQL, the standard programming language used to communicate and manage databases, allows for various operations such as querying, inserting, updating, and deleting data.
- NoSQL databases are optimized for specific data models and can handle large volumes of diverse data, unlike traditional relational databases (SQL).
- Database Management Systems (DBMS) provides an interface for users to interact with databases, managing data, engines and schema.
- Relational Database Management Systems (RDBMS) organize data into tables consisting of rows and columns, with SQL used to manage and query data ensuring integrity and constraints are met.
- The SQL command categories include DQL, DDL, DCL, and DML.
- Data types in DBMS range from numeric, character, date and time, binary to boolean and enumerated.
- Commands and queries such as CREATE, DESCRIBE, DROP, ALTER, SELECT * FROM, UPDATE, SET, WHERE, DISTINCT, COUNT, AVG, SUM, ORDER BY, LIMIT, AND, OR, IN, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, NESTED QUERIES, and TRIGGERS are key components of SQL.
- Understanding databases is crucial for cloud engineering as databases need to be scalable, highly available, and capable of handling large volumes of data.
- Next week, the focus will shift to AWS Certified Cloud Practitioner Certification Course (CLF-C02), which will mark the beginning of the author's journey into the world of AWS.
Read Full Article
10 Likes
For uninterrupted reading, download the app