crio-bytes / database Goto Github PK

MicroByte Title: SQL JOIN TABLE CONCEPT AND COMMANDS

Domain: DBMS

Scope of learning for learners: After leaning the basic SQL commands, a step ahead to learn advanced SQL query

Activities: Join a table, make join queries(INNER JOIN, OUTER JOIN, CROSS JOIN etc)

Entity: @CrioDo

Contributions:

• eventOrganising

Entity: @Ak-Shaw

Contributions:

• code
• doc
• eventOrganizing
• ideas
• maintenance
• review

MicroByte Title: Basic command in MySQL

Domain: DBMS

Scope of learning for learners: The beginners who want to get started with MySQL. The byte will include all the basic concepts and commands to create a table, alter table, view table, Primary key and many more things.

Activities: Make a student database, create student table, course table and learn update, alter commands.

MicroByte Title: Everything about getting started with MongoDB.

Domain: NoSQL Database operation.

Scope of learning for learners: Learners keen to learn about nosql database and MongoDB as one of its kind can get hands on with it and know the nitty-gritty of MongoDB and NoSql databases.

Activities: The microbyte will contain activities like -

• Running mongoDB locally as well as remotely.
• Knowing about mongoDB clients and drivers.
• Basics about mongoDB.
• Queries in mongoDB.
• CRUD operations in mongoDB.
• When to use mongoDB(SQL vs NoSQL)

MicroByte Title: Build a Leaderboard using Redis

Domain: Database

Scope of learning for learners: Redis is mainly used for caching purpose but one of the datatype "sorted sets" goes unnoticed. This byte will discuss a usecase for the sorted sets in the form of design of leaderboard.

Activities:

1. Why redis is suitable for leaderboard?
2. Create simple schema of leaderboard.
3. Define various operations like
   a) Find top 10 users
   b) Update score of the user in efficient way
   C) Get whole record of the user.
   More activities to be added soon. The basic ones are mentioned here.

MicroByte Title: MySQL Table with constraints

Improvement Proposal:

• Add AUTO INCREMENT feature in activities
• Add ALTER TABLE command in activities

Benefits of proposed improvements:

• Adding the aforementioned feature and command in the activities will further improve the learning scope