Contents ...
udn網路城邦
SQL_TECH_WEB_RESOURCE
2010/09/29 18:52
瀏覽756
迴響4
推薦0
引用0

1.W3CSCHOOL:一個有各種教學說明的國外網站

大都跟WEB有關:

http://www.w3schools.com/sql/default.asp

內容

SQL Basic
SQL HOME
SQL Intro
SQL Syntax
SQL Select
SQL Distinct
SQL Where
SQL And & Or
SQL Order By
SQL Insert
SQL Update
SQL Delete

SQL Demo
SQL Try It

SQL Advanced
SQL Top
SQL Like
SQL Wildcards
SQL In
SQL Between
SQL Alias
SQL Joins
SQL Inner Join
SQL Left Join
SQL Right Join
SQL Full Join
SQL Union
SQL Select Into
SQL Create DB
SQL Create Table
SQL Constraints
SQL Not Null
SQL Unique
SQL Primary Key
SQL Foreign Key
SQL Check
SQL Default
SQL Create Index
SQL Drop
SQL Alter
SQL Increment
SQL Views
SQL Dates
SQL Nulls
SQL isnull()
SQL Data Types

SQL Functions
SQL Functions
SQL avg()
SQL count()
SQL first()
SQL last()
SQL max()
SQL min()
SQL sum()
SQL Group By
SQL Having
SQL ucase()
SQL lcase()
SQL mid()
SQL len()
SQL round()
SQL now()
SQL format()

SQL Quick Ref
SQL Hosting
SQL Summary

SQL Quiz
SQL Quiz

2.SQLCOURSE

http://sqlcourse.com/

1 What is SQL?
2 Table basics
3 Selecting data
4 Creating tables
5 Inserting into a table
6 Updating records
7 Deleting records
8 Drop a table
9 Advanced Queries
10 Standalone SQL interpreter
11 Advertise on SQLCourse.com
12 Database Links
13 Technology Jobs


3.SQL NOTE

http://irw.ncut.edu.tw/peterju/sql.html

簡介
SQL指令類別
Data Definition Language(DDL)
Data Manipulation Language(DML)
Data Query Language(DQL)
MS-SQL
參考書目
網路資源


4.SQL TECH

http://www.techonthenet.com/sql/

Data Types SELECT Statement
Literals (Constants) DISTINCT
Declaring Variables COUNT / SUM / MIN / MAX
Is Null / Is Not Null  
  WHERE Clause
Loops and Conditional Statements "AND" Condition
Sequences (Autonumber) "OR" Condition
Transactions Combining "AND" with "OR"
Cursors 
Functions (Built-In) (By Category) "LIKE" Condition
Functions (Built-In) (Alphabetical) "IN" Function
Oracle System Tables BETWEEN Condition
  EXISTS Condition
Primary Keys GROUP BY
Foreign Keys HAVING
Unique Constraints ORDER BY (sort by)
Check Constraints  
Indexes JOINS (inner, outer)
  Subqueries
Creating Functions  
Creating Procedures UNION Query
Creating Triggers UNION ALL Query
Exception Handling INTERSECT Query
Oracle Error Messages MINUS Query
   
Grant/Revoke Privileges UPDATE Statement
Roles (set of privileges) INSERT Statement
Change Password DELETE Statement
   
Synonyms (create, drop) Tables (create, alter, drop, temp)
  Views
Question & Answer  


5.SQL ZOO:除了SQL 教學外更有練習的環境

且有各家SQL 的比較

http://sqlzoo.net/

全站分類:知識學習 隨堂筆記
自訂分類:DBMS
上一則: Oracle SQL Developer Release 3.0
下一則: TRUNCATE TABLE REUSE STORAGE
迴響(4) :
4樓. Nitin
2021/04/17 18:36

"This is a wonderful article. I can see that you have done a lot of research and your subject knowledge is good and impressive.

This is Nitin, I also like to write for an education blog www.cleariitmedical.com - This is an online blog for students who want to prepare for India's most difficult entrance exams - IIT JEE and NEET This is a free blog and provide free study material, quiz and notes to those who can't afford to pay hefty fees of coaching institutes. I write free of cost for the good cause. I know you must be busy with your work but if you could take out some time from your busy schedule and have a look at it. I saw a good collection of articles. If you only write a few words about this blog then it can help a lot of students out there. Thanks!"


(nitic383@gmail.com)
3樓. Megha
2021/04/17 18:26

Wow! Such an articulate post it is! I am a fan of your writing. Being a new writer, it's always good to see inspiring posts like this. I am a management graduate and write for 12th pass students for various career options. I write for a good blog: www.clearlawentrance.com I want to write about a lot of things out there, please guide me on how I can become a good blogger.


(bms.clearexam@gmail.com)
2樓. Preeti Sharma
2021/04/17 18:03

Very nice article! I'm Preeti, I write for educational blogs. I make a collection of wonderful educational blogs from where I could take inspiration for writing. This article really inspires me though it is a little different from my domain but nonetheless it is a good writing. I sometime write for a education site blogs

www.clearexam.ac.in Let me know your thoughts if I could contribute to your blog too.


(preeti55243@gmail.com)
1樓. Preeti Singh
2021/02/27 15:22
Very nice article! I'm Preeti, I write for educational blogs. I make a collection of wonderful educational blogs from where i could take inspiration for writing. This article really inspires me though it is a little different from my domain but nonetheless it is a good writing. I sometime write for a education site blogs
www.clearexam.ac.in Let me know your thoughts if I could contribute for your blog too.
(preetising1605@gmail.com)
發表迴響

會員登入