Relationship, SQL

How to create database in Microsoft SQL Server and view via Visual Studio

1. Download SQL Server Express
2. Download Microsoft SQL Server Management Studio
3. On SQL Express window click on Connect now button.
or
in cmd type sqlcmd -S <ComputerName>  
As result sqlcmd window will be opend
type create database NewDB
4. type go
5. type  use NewDB
6. type go
7. type create table NewTable ( columnname1 columntype1, columnname2 columntype2)
8. type go
9. In Management Studio click on File/Connect Object Explorer
    type server name and authentication
If DB created locally you can find server name on the tpo of sqlcmd
If DB created locally authentification will be Windows Authentification
10. in Visual Studio Tools/Connect to Database type server name and authentication

SQL fundamentals

http://jtest.ru/bazyi-dannyix/
https://drive.google.com/open?id=0B82wCxQRWVScdjBVcVktV3NTVGc
https://drive.google.com/open?id=0B82wCxQRWVScMVlsZkhiR1pLS2c