- Create a primary key
- create a database and table
- create an index
- Insert
- Create more tables
- Select data.
- Create foreign keys
- Where clauses
- Join and relationships
- Updates data
- Functions
- Delete data
- Group by
- Change table (new column update column)
Database that use sql
- Sql server
- Oracle
- Mysql
- Postgresql
- SQ.lite
- DB2
- Big data
- Sql Server
SQL Server Management Studio (SSMS) is a software application first launched with microsoft sql that is used for configuring, managing, and administering all components within microsoft sql It’s the successor to the in SQL 2000 or before. The tool includes both script editors and graphical tools which work with objects and features of the server.
- Sql work bench
- TOAD
- Sql developer
Sql database command
Create customer database
(
Create table customer
(
First Name varchar(50);
Last Name varchar(50);
Age int
)
)
So in order to run that and i don’t show you that but i clicked f5 you can actually come order here and there ‘s this execute button right there and see how underneath the executor says f5 after you do this a lot you start hitting f5 every time instead of clicking that button and so basically what i did is hit f5 we ve got a customer database but notice you don’t see it over here and that because this free of folders has not refreshed so i’m gonna goto database right click and now i have a customer database so that was step one let’s create in a database the database holds all the tables so now now need some tables to put data into so
i expanded the customer database and there a bunch of other folders in here and what we want our tables it comes with system tables which we don’t see any right now file tables and external tables what we want to do is create our user tables but before we do that we need to make sure we .
