SQL & Databases
A DMBS (Database Management System) is a system that allows users to create, alter, organize and manage databases. It helps companies store, organize and retrieve large amounts of data quickly and efficiently.
Here, I created a table named "Vehicles", with 4 columns. With an ID column as a primary key, and year, make and model. Creating at least 5 rows
I added a 1984 BMW with no Model, then deleted the table, restoring my database
I created a simple schema of a 3 table database including student,teacher and class data with each table having a relationship with at least 1 other table. Each table has a primary key. There is also a primary key and foreign key for each relationship.
-
-
In the products table, I deleted all products from "Bigfoot Breweries."
I Changed the customer "Queen Cozinha" to "Cozinha" and country to Argentina.
Retrieved all products between $10 and $50 that start with the letter C and priced them from lowest to highest.
-Returned all the orders with the order ID and shipper name.
No Collections Here
Sort your projects into collections. Click on "Manage Collections" to get started