登入
忘記密碼
通過條件成 績 ：60 分
-
01 The Basic (Flat) Relational Model
-
02 Retrieving Data Using the SQL SELECT Statement
-
03 Restricting and Sorting Data
-
04 Using Single-Row Functions to Customize Output
-
Week 02 Homework
-
02_1 Oracle Database值得學習嗎？
-
02_2 SQL值得學習嗎？
-
05 Using Conversion Functions and Conditional Expressions
-
06 Reporting Aggregated Data Using the Group Functions
-
07 Displaying Data from Multiple Tables
-
Week 03 Homework
-
03_1 Group Function 的應用
-
03_2 Outer Join 的應用
-
08 Using Subqueries to Solve Queries
-
09 Using the Set Operators
-
10 Manipulating Data
-
Week 04 Homework
-
04_1 Subquery 的應用
-
04_2 Set Operator 的應用
-
11 Using DDL Statements to Create and Manage Tables
-
12 Creating Other Schema Objects
-
Week 05 Homework
-
05_1 Constraints 的應用
-
05_2 View 的應用
-
13 Controlling User Access
-
14 Managing Schema Objects
-
Week 06 Homework
-
06_1 Role 的應用
-
06_2 External Table 的應用
-
15 Managing Objects with Data Dictionary Views
-
16 Manipulating Large Data Sets
-
Week 08 Homework
-
08_1 Data Dictionary View 的欄位
-
08_2 Multitable INSERT Statement 的應用
-
期中考題目說明
-
17 Managing Data in Different Time Zones
-
18 Retrieving Data Using Subqueries
-
Week 10 Homework
-
10_1 與「日期、時間、區間、時區」等相關的形態或函數之應用
-
10_2 Subquery 的應用
-
19 Regular Expression Support
-
20 More SQL
-
Week 12 Homework
-
12_1 Regular Expresssion 的應用
-
12_2 複雜的 SQL 應用
-
21 What Is Data Modeling?
-
22 Basics of Sound Structure
-
Week 14 Homework
-
23 The Entity-Relationship Approach
-
24 Subtypes and Supertypes
-
期末考題目說明
- 課程介紹
- 課程安排
- 評論
