LearnDatabases's profile picture. Online learning account, We are teaching all topics relating to databases and SQL server.

Database Development

@LearnDatabases

Online learning account, We are teaching all topics relating to databases and SQL server.

Primary Key field is away of telling SQL Server that even though there may be other columns in the table that store unique values, this column in particular is the most important. We do this by designating the column as the table's primary key. youtube.com/watch?v=i-_C_K…

LearnDatabases's tweet card. 14 - SQL Primary key fields in SQL Server

youtube.com

YouTube

14 - SQL Primary key fields in SQL Server


In databases it is always a good practice to have a unique record identifier column in your table, A unique identifier will allow you to locate unambiguously a single record, and it's one of the core requirements that make a relational database work. youtube.com/watch?v=DakQxM…

LearnDatabases's tweet card. 13 - SQL Automatically assign record identities in SQL server

youtube.com

YouTube

13 - SQL Automatically assign record identities in SQL server


In this video we are teaching how to create tables from csv or flat files using SQL server management studio. If you have data that is stored in a csv can create table from the data see video for guidance. youtube.com/watch?v=uMqcFP…

LearnDatabases's tweet card. 10 - SQL Create table from flat files

youtube.com

YouTube

10 - SQL Create table from flat files


Install a sample database In this video we are talking about installing a sample database on your machine, link to the database is provided in the video description. youtube.com/watch?v=BfNuip…

LearnDatabases's tweet card. 11 - SQL Install a sample database

youtube.com

YouTube

11 - SQL Install a sample database


Import data from CSV files If you have data stored in a spreadsheet format such as Excel or Google Sheets, or another database system, then you can export that data as a CSV file from their native program to easily bring it into SQL Server. youtube.com/watch?v=eIKhx3…

LearnDatabases's tweet card. 9 - SQL Import data from CSV files

youtube.com

YouTube

9 - SQL Import data from CSV files


SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft. Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with relational databases. youtube.com/watch?v=vEv0Ix…


United States トレンド

Loading...

Something went wrong.


Something went wrong.