How do I create a database in SQL Server?
The CREATE DATABASE statement is used to create a new SQL database.
The following SQL statement creates a database called "testDB":
- Tip:
- Make sure you have admin privilege before creating any database
Once a database is created, you can check it in the list of databases with the following SQL command:SHOW DATABASES; .
,
Table Production.Products
The production.productstable stores the product’s information such as name, brand, category, model year, and list price.
Each product belongs to a brand specified by the brand_idcolumn.
Hence, a brand may have zero or many products.
Each product also belongs a category specified by the category_idcolumn.
Also, each category may have zero or many pr.
,
Table Sales.Customers
The sales.customerstable stores customer’s information including first name, last name, phone, email, street, city, state and zip code.
,
Table Sales.Order_Items
The sales.order_items table stores the line items of a sales order.
Each line item belongs to a sales order specified by the order_idcolumn.
A sales order line item includes product, order quantity, list price, and discount.
,
Table Sales.Stores
The sales.storestable includes the store’s information.
Each store has a store name, contact information such as phone and email, and an address including street, city, state, and zip code.
,
What is a SQL sample database?
Summary:
- in this tutorial
- you will learn about a SQL Sample Database called HR that manages the HR data of the small businesses
The following
database diagram illustrates the HR sample
database:The employees table stores the data of employees.
The jobs table stores the job data including:job title and salary range.
,
Where can I find a database download & sample?
The database downloads and samples are in the SQL Server samples GitHub repository.
WideWorldImporters readme and samples on GitHub.
AdventureWorks databases can be found on the installation page or directly within the SQL Server samples GitHub repository.
,
Where can I find Azure code examples & examples?
There are several Azure code samples and examples available on GitHub in .NET, Java, Python, Node.js, PHP and Ruby.
Additionally, Azure Resource Manager allows you to configure your applications using a declarative template.
In a single template, you can deploy multiple services along with their dependencies.