MsSQL Temel Eğitim

MSSQL

Volkan ŞENGÜL

Yazılımcı'nın Seyir Defteri

@volkansengul

http://volkansengul.com

SQL Nedir?

Structured Query Language

Verilerin / veri kümlerinin Modellenmesi, yönetilmesi için kullanılan dildir.

RDBMS?

Relational Database Management System

MySQL?

Relational Database Management System

Schema

CREATE SCHEMA `aytungaDb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;

Table

create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

SELECT

SELECT * FROM customers;

Tüm veriyi çekmek

SELECT id, first_name, surname FROM customers;

Belirli kolonları çekmek

INSERT

create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

UPDATE

create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

DELETE

create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

UPSERT

create table aytungadb.customersz (
id INT NOT NULL AUTO_INCREMENT,
first_name VARCHAR(45),
surname VARCHAR(45),
email VARCHAR(60),
PRIMARY KEY(id)
)
ENGINE = innoDB
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;