INtroductio to Database ,SQL ServerMongoDB database
Programming
Introduction to Databases
Step 1: First learn about Databases
Step 2
Apply the concepts of data and databases by learning to install a SQL and No-SQL Database
(Instructions to install or just login)
Step 3
Investigate how data is stored in different types of databases
-
-
-
-
-
-
-
-
-
-
-
-
- Explore a Database
-
-
-
-
-
-
-
-
-
-
-
Given a basic SQL Server (Northwind) and MongoDB database (Northwind), import the data and explore the structure of the databases and how they are similar and different from each other.
Use the following commands to import Northwind in Mongodb from the command prompt once MongoDB is installed.
- mongoimport -d Northwind -c categories –type csv –file categories.csv –headerline
- mongoimport -d Northwind -c customers –type csv –file customers.csv –headerline
- mongoimport -d Northwind -c employee-territories –type csv –file employee-territories.csv –headerline
- mongoimport -d Northwind -c employees –type csv –file employees.csv –headerline
- mongoimport -d Northwind -c northwind –type csv –file northwind.csv –headerline
- mongoimport -d Northwind -c order-details –type csv –file order-details.csv –headerline
- mongoimport -d Northwind -c orders –type csv –file orders.csv –headerline
- mongoimport -d Northwind -c products –type csv –file products.csv –headerline
- mongoimport -d Northwind -c regions –type csv –file regions.csv –headerline
- mongoimport -d Northwind -c shippers –type csv –file shippers.csv –headerline
- mongoimport -d Northwind -c suppliers –type csv –file suppliers.csv –headerline
- mongoimport -d Northwind -c territories –type csv –file territories.csv –headerline
# TASK
Submit the Project Deliverable in a 2 page document that provides recommendations
First Choice Urgent Care has asked that you write a 2-page summary defining the basic concepts of a relational database management system and a NoSQL database and outline the advantages and disadvantages of each, so they can make a decision about which database management system to use. Consider the following questions:
- What are the hardware and software requirements for the database?
- How much will the database cost to operate?
- What are the Pros and Cons of using the database?
- What are the performance issues that you need to consider?
- What are the relative merits of using the database?
