TOP
0
0
即日起~6/30,暑期閱讀書展,好書7折起
Sql Programming: Beginners

Sql Programming: Beginners

商品資訊

定價
:NT$ 1200 元
無庫存,下單後進貨(到貨天數約30-45天)
可得紅利積點:36 點
相關商品
商品簡介

商品簡介

Chapter 1: Introduction
1 Database
2 DBMS
3 RDBMS different from DBMS
4 SQL
5 Difference between SQL and MySQL
6 Tables and Fields
7 Constraints in SQL
8 Primary Key
9 UNIQUE constraint
10 Foreign Key
11 Join and List its different types
12 Self-Join
13 Cross-Join
14 Index and its different types
15 Difference between Clustered and Non-clustered index
16 Data Integrity

Chapter 2: Query
1 Query
2 Subquery and its types
3 SELECT statement
4 Common clauses used with SELECT query in SQL
5 UNION, MINUS and INTERSECT commands
6 Cursor and How to use a Cursor

Chapter 3: Relationships
1 Entities and Relationships
2 List of different types of relationships in SQL
3 Alias in SQL
4 View
5 Normalization
6 Denormalization
7 Various forms of Normalization

Chapter 4: Table
1 TRUNCATE, DELETE and DROP statements
2 Difference between DROP and TRUNCATE statements
3 Difference between DELETE and TRUNCATE statements
4 Aggregate and Scalar functions
5 User-defined function and its various types
6 OLTP
7 Differences between OLTP and OLAP
8 Collation different types of Collation Sensitivity
9 Stored Procedure
10 Recursive Stored Procedure
11 Creating empty tables with the same structure as another table
12 Pattern Matching in SQL
13 ACID properties
14 Transaction Isolations

Chapter 5: Software Installation
Introduction
Eclipse Installation
Jdk1.6 Installation And Configuring to Eclipse
Tomcat1.6 Installation And Configuring to Eclipse
MySql5.0 Installation
Eclipse Font Size Increase

您曾經瀏覽過的商品

購物須知

外文書商品之書封,為出版社提供之樣本。實際出貨商品,以出版社所提供之現有版本為主。部份書籍,因出版社供應狀況特殊,匯率將依實際狀況做調整。

無庫存之商品,在您完成訂單程序之後,將以空運的方式為你下單調貨。為了縮短等待的時間,建議您將外文書與其他商品分開下單,以獲得最快的取貨速度,平均調貨時間為1~2個月。

為了保護您的權益,「三民網路書店」提供會員七日商品鑑賞期(收到商品為起始日)。

若要辦理退貨,請在商品鑑賞期內寄回,且商品必須是全新狀態與完整包裝(商品、附件、發票、隨貨贈品等)否則恕不接受退貨。

定價:100 1200
無庫存,下單後進貨
(到貨天數約30-45天)

暢銷榜

客服中心

收藏

會員專區