MySQL DB task to create a Design DB model for Guvi Zen class

Modify Ruby on Rails ActiveRecord Default Primary Keys from BIGINT to INTEGER

This project involved converting an Excel spreadsheet system for a hotel to a relational database. The database was designed to satisfy 3NF using the data provided. An ERD diagram was created to represent the database as well as the script to create and populate the tables and SQL queries.

Learning to create, read, update, and delete operations on MySQL

Analyzing customer behavior, determine primary keys and ERD, visualize insights with dashboards and present business strategy recommendations.

"TREINANDO PARA A PROVA DE LAB BANCO"

My first major task is a research project on employees of the corporation from the 1980s and 1990s. All that remain of the database of employees from that period are six CSV files.

Using PostgreSQL to query an employee database. Creating an ERD to showcase relationships between database tables. Using primary keys and foreign keys.

ID to UID/UUID

Creating requirements for the System, deciding the users who will be using this system, defining constraints, creating relations, primary keys, foreign keys etc. Performed operations using PostgreSQL, Query tuning & evaluating reporting queries in SQL

This project includes data modeling, engineering and analysis of employee data. Demonstrates use of SQL, creating schemas, queries, joins, aggregate functions, primary keys, and foreign keys.

Unique is a java based distributed sequence component. It provides RESTful APIs and clients(RPC, HTTP) to obtain sequences, and it supports Spring Boot, Spring Cloud and MyBatis.

Developed a program that Generates SQL Statements to Check Normalization in One Table and Normalize It If Needed. [Python and PostgreSQL]

Oracle SQL, PL/SQL solution to resolve Table References

Research project on employees of the corporation from the 1980s and 1990s. Design the tables to hold data in the CSVs, import the CSVs into a SQL database, and answer questions about the data.

Laravel Eloquent using UUIDs as primary keys.

Seminar task from college subject SQL Practicum. App that finds primary key candidates and handles database normalization - decomposition to Third Normal Form and Boyce-Codd normal form. 🔑

Utilize SQL to create a database and pull information on retiring employees at a company.

Exercise to create databases, tables, entities, relationships, diagrams and a database project on the Mexico City subway

The Blog app will be a classic example of a blog website. A fully functional website that will display the list of posts and empower readers to interact with them by allowing comments to be added and posts to be liked.