Menu
With so many SQL dialects, it can be hard to know where to start. Popular dialects include MySQL, SQLite, and SQL Server, but we recommend starting with PostgreSQL—it's the closest to standard SQL syntax so it's easily adapted to other dialects.
How Long Does it Take to Learn SQL? Because SQL is a relatively simple language, learners can expect to become familiar with the basics within two to three weeks. That said, if you're planning on using SQL skills at work, you'll probably need a higher level of fluency.
1) Get a base understanding of what a database is (Google, Wikipedia)
2) Learn what a RDBMS is (Relational Database Management System)
3) Learn what a 'normal form' is.
4) Read an easy to read 'primer' book. I suggest this book:
MySQL Crash course by Ben Forta, Sams publishing 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.
http://www.w3schools.com/sql/default.asp Their tutorials are a great start.
Check this site: SQLZoo, its a very good interactive tutorial, really nice, you can learn by practicing your queries on the fly...
first learn about relational databases and relational theory in general (and set theory upon which it is based), then SQL will be much easier to comprehend. the classic book on databases by C J Date is hard to beat
For Microsoft SQL Server 2005,
You can download SQL Server 2005 Express Edition version for free.
Get an understanding of database schemas with these SQL Server Database schemas
Getting started with SQL Basics
Set yourself up a Bloglines account 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 Kits look 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 Fundamentals is the best SQL book I have read. It gives examples in both Oracle and MS Access and is geared toward the beginner.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With