Shulou(Shulou.com)06/01 Report--

Define

Data warehouse, which stores data. Is a file system that also uses files to save data, but access data (add delete and modify queries) must be accessed using standard sql statements

Common relational database

* Oracle-large applications, for a fee.

* MySQL-small database, free and open source! Acquired by Oracle, charging from version 6.x.

* SQLServer-Microsoft

* DB2-IBM's company, bank's enterprise.

Related concepts

* A server that installs a database on a computer and creates multiple databases in the database server

* create multiple tables in each database. The table is used to store data. The table contains fields (column names) and the data stored under the fields.

* in Java code, an object of JavaBean corresponds to a row of data in a table.

The extension of the installation package for the mysql database is msi

Common graphical interfaces are: sqlyong navicat

Sql

1. SQL is a non-procedural language.

* SQL:Structured Query Language, structured query language

* procedural language: the execution of this statement depends on the previous statement or statements.

* non-procedural language: only one statement will produce a result.

2. Classification of SQL language

* DDL (Data Definition Language)

* data definition language, create database, create table structure

* create drop

* DML (Data Manipulation Language)

* data manipulation language, add data, modify data, delete data

* insert update delete

* DCL (Data Control Language)

* data control language, stored procedure

* if else

* DQL (Data Query Language)

* query language for data, query data

* select

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.