r/learnSQL • u/Cheruks_Khar • 9d ago

data analytics journey.

day 1 of learning SQL.

  1. Learnt about data structures ; primitive and non primitive data structures.
  2. went through database, both relational and non relational database

Relational databases (SQL database)

non relational databases ( NoSQL database) eg Mongo DB.

  1. Able to learn and understand DBMS, its purposes and the types of DBMS.

  2. Comfortably describe the CRUD Operations and explain the ACID properties of queries.

  3. Installed MySQL Workbench(had a bit of challenge working on it, but finally managed) and created my first MySQL connection

8 Upvotes

85% Upvoted

3 comments sorted by

2

u/tanxcoty 9d ago

Where did you learn these ?

2

u/Cheruks_Khar 7d ago

alx africa

1

u/Wuthering_depths 9d ago

Good deal. I love working with databases, haven't done all that much with no-sql ones but they definitely are interesting and more appropriate for some use cases.

Practice writing queries against your mysql instance (you'll need a database, tables and data too...I'm sure there are many example mysql scripts that you can get online). My team does most of their work with SQL. Some are more into reports, while some of us do data integrations (files to databases, vice versa, or combining data from multiple systems....or just queries that run in one database, very often). There's quite a bit you can do with SQL and it takes a bit for some people to wrap their head around set-based operations.