#DB2 UNIVERSAL DATABASE SOFTWARE#
#DB2 UNIVERSAL DATABASE CODE#
#DB2 UNIVERSAL DATABASE WINDOWS#

Data control language （DCL）：Data Control Language.Data query language （DQL）：Data Query Language.Things control language （TCL）：Transaction Control Language.Data operation language （DML）：Data Manipulation Language.Data definition language （DDL）：Data Definition Language.（3）、 All databases use the same or similar language （2）、SQL Data operations are performed on a relational database 、 Search and maintain the standard language used, It can be used to query data, Manipulating data, Defining data, Control data （1）、SQL（Structured Query Language）： Structured query language （5）、 There is an association between tables 2、 Structured query language （4）、 Columns of the table （Column） Is column data, Also known as fields （Field）（3）、 Table rows （Row） It's horizontal data, Also known as records （Record）（2）、 The table is two-dimensional, It consists of rows and columns （1）、 A relational database consists of multiple data tables （Table） form, Data table is the basic storage structure of relational database （3）、2008 year 1 month 16 Japan ,Sun By Oracle Company purchase, therefore MySQL Now belongs to Oracle company Two 、SQL summary 1、 The concept of table （2）、 Low total cost of ownership 、 Scale comparison Oracle and DB2 Small （1）、MySQL Is an open source small relational database management system, It is widely used in small and medium-sized websites （2）、Microsoft SQL Server The original version of is suitable for small and medium-sized enterprises, But the scope of application is expanding, Has touched on large 、 Data of multinational enterprises 5、MySQL Database Overview

#DB2 UNIVERSAL DATABASE WINDOWS#

（1）、Microsoft SQL Server It's a Microsoft product, Running on the Windows NT Server （4）、DB2 yes Oracle Major competitors of 4、SQL Server Database Overview （3）、DB2 Universal Database Personal Edition and DB2 Universal Database Workgroup Edition They are single user and multi-user systems, Can run in OS/2 and Windows On （2）、DB2 There are many different versions, It can run on different terminal machines from handheld products to mainframes

（1）、DB2 yes IBM The company's relational database management system （4）、Oracle The company's products are rich, Include Oracle The server 、Oracle Development tools and Oracle Application software, The most famous one is Oracle data 3、DB2 Database Overview （3）、Oracle Adopted standards SQL（ Structured query language ）, Support multiple data types, Provide object-oriented data support, With the fourth generation of language development tools, Support UNIX、WINDOWS、OS/2 And so on （2）、Oracle It is the first commercialized relational database management system in the world （1）、Oracle It's famous Oracle（ Oracle ） The company's database products

#DB2 UNIVERSAL DATABASE SOFTWARE#

（2）、 Database management system （Database Management System, abbreviation DBMS）： Database management software 2、Oracle Database Overview Notes ：SQL The statement itself is not case sensitive, But for readability purposes, We usually put SQL All keywords in are capitalized, All non keywords are lowercase

（1）、 database （Database,jianchengDB） It is organized according to the data organization 、 Warehouse for storing and managing data

#DB2 UNIVERSAL DATABASE CODE#

、CHAR、VARCHAR2、DATE Database type CHAR and VARCHAR2 The storage code of 、CHAR and VARCHAR2 Maximum length of 、LONG and CLOB type. Include Oracle、DB2、SQL Server、MySQL Database Overview DDL、DML、TCL、DQL、DCL Language introduction NUMBER

5、CHAR and VARCHAR2 The storage code of.

Db2 universal database