SQL 学习SQL。从哪里开始？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/273777/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Learning SQL. Where to get started?
提问by ashokgelal
I want to start learning sql? Where should I get started from? I am looking specific answers for: Platform - Windows/ Linux RDBMS - MSSQL/ Oracle/ MySQL Books - that goes along with some real world case studies (not the boring author/books relationship) Online resources - tutorials/ real world projects
我想开始学习sql？我应该从哪里开始？我正在寻找以下方面的具体答案：平台 - Windows/Linux RDBMS - MSSQL/Oracle/MySQL 书籍 - 与一些真实世界的案例研究（不是无聊的作者/书籍关系）在线资源 - 教程/真实世界项目
采纳答案by Klathzazt
1) Get a base understanding of what a database is (Google, Wikipedia)
1）对数据库是什么有一个基本的了解（谷歌，维基百科）
2) Learn what a RDBMS is (Relational Database Management System)
2) 了解什么是 RDBMS（关系数据库管理系统）
3) Learn what a 'normal form' is.
3) 了解什么是“正常形式”。
4) Read an easy to read 'primer' book. I suggest this book:
4) 阅读一本易于阅读的“入门”书。我推荐这本书：
MySQL Crash course by Ben Forta, Sams publishing ISBN: 0-672-32712-0
Ben Forta 的 MySQL 速成课程，Sams 出版 ISBN：0-672-32712-0
5) Download + Install MySQL and read through the documentation. It comes with a help file that should help you out. Use whatever book you have to go through the base examples and learn. Ideally whatever book you have will walk you through the concepts with very clear and explicit examples.
5) 下载 + 安装 MySQL 并通读文档。它带有一个帮助文件，应该可以帮助你。使用您必须阅读的任何书籍来完成基本示例并学习。理想情况下，无论您拥有什么书，都会通过非常清晰和明确的示例引导您了解概念。
回答by Knoth23
http://www.w3schools.com/sql/default.aspTheir tutorials are a great start.
http://www.w3schools.com/sql/default.asp他们的教程是一个很好的开始。
回答by CMS
回答by Russ Cam
For Microsoft SQL Server 2005,
对于 Microsoft SQL Server 2005，
You can download SQL Server 2005 Express Editionversion for free.
Get an understanding of database schemas with these SQL Server Database schemas
Set yourself up a Bloglinesaccount and subscribe to SQL Server feeds that you come across that interest you. I can add some suggestions to the comments if you want to get started.
If you would like to sink your teeth into how SQL Server is utilised in collaboration with different types of application then the Samples and Starter Kitslook like they would be a good starting point. Bear in mind that you will also need one of the free Visual Studio IDEs for each sample application too. Details are on the page.
您可以免费下载SQL Server 2005 Express Edition版本。
通过这些SQL Server 数据库架构了解数据库架构
为自己设置一个Bloglines帐户并订阅您遇到的感兴趣的 SQL Server 提要。如果你想开始，我可以在评论中添加一些建议。
如果您想深入了解如何将 SQL Server 与不同类型的应用程序协作使用，那么示例和入门工具包看起来将是一个很好的起点。请记住，您还需要为每个示例应用程序提供一个免费的 Visual Studio IDE。详情在页面上。
回答by Steven A. Lowe
回答by Andrew Cowenhoven
SQL Fundamentalsis the best SQL book I have read. It gives examples in both Oracle and MS Access and is geared toward the beginner.
SQL Fundamentals是我读过的最好的 SQL 书籍。它提供了 Oracle 和 MS Access 中的示例，面向初学者。
回答by no_one
Books by Joe Celko- especially thinking in sets
