稍微谈谈SQL

很明显

Pwn 发表于 2014-9-2 22:39
我的电脑里有个MySQL Workbench 5.2 CE，有数据库例子。还不知道怎么玩呢。

高人！

jin-1234

ichibai 发表于 2014-6-20 17:53
对于从来没接触过SQL的人，如何自学入门呢？自己的电脑里也没有一个database，怎么练习使用SQL呢？ ...

1. Download and install Microsoft SQL server express with Advanced Features. [Free Database software that good enough for learner]
2. Search Google and find MS Adventure Works data samples. [DATA for practice]

Then install Adventure Works data base by following the instructions found in the folder.

The Adventure is good for basic transaction-SQL and Data warehousing study.

jin-1234

ichibai 发表于 2014-6-23 11:24
我连初学都不是呢。谢谢您耐心的解释，谢谢啦。

you need to go W3Schools, under SQL section. You can learn SQL basics for FREE

Pwn

jin-1234 发表于 2014-9-3 12:31
you need to go W3Schools, under SQL section. You can learn SQL basics for FREE

how to do Reports?

jin-1234

Pwn 发表于 2014-9-3 12:56
how to do Reports?

Hobbyist version: join relevant tables together, then you have the report.
Professional version: learn OBIEE(former SIEBEL) or IBM Cognos. But the knowledge is dear. Either a company pays licence fee and let you learn on the job, or pay expensive training by yourself.

Pwn

jin-1234 发表于 2014-9-3 13:07
Hobbyist version: join relevant tables together, then you have the report.
Professional version: l ...

我下了一个Nucleon Software出的database manager 6. 可以连到mysql数据库上。里面有Reports。但是随便点一个report，出错说“未将对象引用设置到对象的实例”。

还是access简单，都在一起，什么都有了。