SQL Tutorial: Introduction

Relational Database Tables

 
A relational database stores data in tables. Each table has a number of rows and columns.
The table below has 4 rows and 3 columns.


 

SQL and Relational Databases

 
A relational database contains tables which store data that is related in some way.
SQL is the language that allows retrieval and manipulation of table data in a relational database.
 
The database below has 2 tables: one with data on Users and another with data on Products.


 

Example database

 
This tutorial uses a database which is a modernized version of Microsoft’s Northwind database. Northwind is a fictitious store that sells specialty food products from all over the world. The database has 5 tables.
 
Below is an Entity Relationship Diagram (ERD) which shows the tables and their relationships.

Additional details of the data model are available on the Sample Database page.
You can also ‘play’ with the database directly from your browser using our SQL Sandbox.

“SQL Tutorial: Introduction”의 110개의 댓글

  1. whoah this blog is excellent i really like reading your
    posts. Keep up the great work! You realize, lots of people are hunting round for
    this information, you can help them greatly.

  2. When I originally commented I clicked the “Notify me when new comments are added” checkbox
    and now each time a comment is added I get three e-mails with the same comment.

    Is there any way you can remove people from that service?

    Many thanks!

  3. I simply want to mention I’m all new to weblog and absolutely liked this page. Likely I’m going to bookmark your website . You amazingly come with superb articles. Appreciate it for sharing your web site.

  4. Greetings from Carolina! I’m bored to tears at work so I decided to check out your website on my iphone during lunch break. I really like the info you provide here and can’t wait to take a look when I get home. I’m shocked at how quick your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyhow, awesome site!

  5. Thanks so much for providing individuals with an exceptionally superb possiblity to read in detail from this site. It’s usually so sweet plus full of amusement for me personally and my office peers to search your web site at the very least 3 times in a week to see the latest secrets you have got. And lastly, I’m actually pleased with all the amazing hints you give. Certain 2 points in this article are in truth the very best we’ve ever had.

  6. Have you ever considered writing an e-book or guest authoring on other blogs? I have a blog based on the same ideas you discuss and would really like to have you share some stories/information. I know my visitors would value your work. If you are even remotely interested, feel free to shoot me an email.

  7. The subsequent time I learn a blog, I hope that it doesnt disappoint me as much as this one. I mean, I know it was my choice to read, however I actually thought youd have one thing fascinating to say. All I hear is a bunch of whining about something that you can fix in the event you werent too busy looking for attention.

  8. An impressive share, I merely with all this onto a colleague who was doing small analysis with this. And he in truth bought me breakfast simply because I found it for him.. smile. So ok, i’ll reword that: Thnx to the treat! But yeah Thnkx for spending plenty of time go over this, I believe strongly over it and really like reading much more about this topic. If at all possible, as you grow expertise, would you mind updating your blog with a lot more details? It is highly of great help for me. Large thumb up with this writing!

  9. Thank you for extra excellent blog. Exactly where else could i recieve this particular compassionate of information written in this kind of incite complete way? i have been seeing with regard to this kind of fine detail.

  10. I simply want to tell you that I am all new to blogs and definitely enjoyed you’re blog site. More than likely I’m planning to bookmark your site . You absolutely have very good articles and reviews. Bless you for sharing your blog.

  11. Hello there! I could have sworn I’ve visited this blog before but after going through some of the posts I realized it’s new to me. Anyways, I’m definitely pleased I discovered it and I’ll be book-marking it and checking back regularly.

  12. This is the best blog for anybody who wants to search out out about this topic. You understand so much its almost hard to argue with you (not that I actually would want…HaHa). You undoubtedly put a new spin on a topic thats been written about for years. Great stuff, simply great!

  13. An impressive share! I’ve just forwarded this onto a colleague who has been doing a little homework on this. And he actually ordered me lunch because I discovered it for him… lol. So allow me to reword this…. Thanks for the meal!! But yeah, thanks for spending the time to discuss this subject here on your internet site.

  14. You’ve made some decent points there. I checked on the internet for additional information about the issue and found most individuals will go along with your views on this site.

  15. I seriously love your website.. Excellent colors & theme. Did you build this website yourself? Please reply back as I’m planning to create my very own blog and want to find out where you got this from or what the theme is called. Appreciate it!

  16. You can definitely see your enthusiasm in the paintings you write. The arena hopes for even more passionate writers like you who aren’t afraid to mention how they believe. All the time follow your heart. “What power has law where only money rules.” by Gaius Petronius.

  17. A powerful share, I just given this onto a colleague who was doing a bit of evaluation on this. And he in reality purchased me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the deal with! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love studying extra on this topic. If possible, as you change into expertise, would you thoughts updating your blog with more details? It is extremely useful for me. Large thumb up for this weblog publish!

  18. I’m impressed, I have to admit. Rarely do I come across a blog that’s both equally educative and amusing, and without a doubt, you have hit the nail on the head. The issue is something that not enough people are speaking intelligently about. Now i’m very happy that I stumbled across this in my search for something relating to this.

  19. I am just writing to make you be aware of of the superb encounter my wife’s child went through visiting yuor web blog. She came to find plenty of pieces, not to mention what it’s like to possess a marvelous helping mindset to make a number of people really easily master a variety of extremely tough subject matter. You undoubtedly exceeded our own desires. Thanks for providing these helpful, trusted, educational not to mention easy tips about that topic to Sandra.

  20. I like this post, enjoyed this one thank you for posting. “The reward for conformity was that everyone liked you except yourself.” by Rita Mae Brown.

  21. Greetings from Los angeles! I’m bored to death at work so I decided to browse your website on my iphone during lunch break. I enjoy the information you provide here and can’t wait to take a look when I get home. I’m shocked at how quick your blog loaded on my cell phone .. I’m not even using WIFI, just 3G .. Anyhow, superb blog!

  22. you are actually a just right webmaster. The site loading pace is incredible. It kind of feels that you are doing any distinctive trick. In addition, The contents are masterpiece. you’ve done a great process on this topic!

  23. I must express some thanks to this writer just for rescuing me from this particular problem. As a result of researching throughout the world-wide-web and meeting ways which are not helpful, I assumed my life was well over. Being alive without the presence of strategies to the problems you’ve resolved all through this short article is a serious case, as well as those which could have in a negative way affected my entire career if I had not discovered your blog post. The capability and kindness in touching the whole lot was crucial. I’m not sure what I would’ve done if I had not come across such a stuff like this. I’m able to at this point look ahead to my future. Thanks for your time very much for this expert and amazing help. I won’t be reluctant to recommend the sites to anyone who requires guidance about this subject matter.

  24. I feel like I’m constantly looking for interesting things to read about a variety of subjects, but I manage to include your blog among my reads every day because you have compelling entries that I look forward to. Here’s hoping there’s a lot more amazing material coming!click here

  25. After I originally commented I appear to have clicked on the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I receive 4 emails with the same comment. Perhaps there is a means you can remove me from that service? Thanks.

  26. I intended to compose you one little bit of observation to give many thanks over again regarding the exceptional opinions you’ve contributed on this website. This has been certainly particularly open-handed of people like you to give publicly what exactly a few individuals would have made available as an electronic book to help with making some cash for their own end, notably now that you might well have done it if you decided. These tactics also served like a good way to fully grasp that other individuals have the same dream similar to my own to know significantly more on the topic of this condition. I’m certain there are several more fun situations up front for folks who start reading your blog.

  27. Having read this I thought it was extremely enlightening. I appreciate you taking the time and energy to put this article together. I once again find myself personally spending a lot of time both reading and posting comments. But so what, it was still worth it!

  28. In the awesome design of things you get an A with regard to effort and hard work. Where exactly you actually lost everybody was first on your details. You know, they say, the devil is in the details… And that couldn’t be much more true here. Having said that, let me reveal to you precisely what did give good results. Your article (parts of it) is certainly highly engaging which is probably the reason why I am making the effort to comment. I do not really make it a regular habit of doing that. Next, despite the fact that I can certainly notice the leaps in logic you make, I am definitely not certain of how you appear to unite the points which in turn produce the actual final result. For the moment I will subscribe to your issue however hope in the near future you actually link your facts much better.

  29. I have to thank you for the efforts you have put in writing this site. I really hope to see the same high-grade content from you in the future as well. In truth, your creative writing abilities has inspired me to get my own, personal blog now 😉

  30. Almost all of what you say is supprisingly precise and it makes me wonder why I hadn’t looked at this with this light before. Your piece truly did switch the light on for me personally as far as this subject matter goes. But at this time there is one particular point I am not too comfortable with and whilst I make an effort to reconcile that with the central theme of the position, permit me see exactly what the rest of your subscribers have to say.Well done.

  31. Somebody necessarily help to make critically posts I would state. This is the first time I frequented your web page and up to now? I surprised with the analysis you made to make this actual post incredible. Excellent activity!

  32. Excellent post. I was checking constantly this weblog and I am inspired! Extremely useful information specifically the closing part 🙂 I deal with such information much. I used to be looking for this particular info for a long time. Thank you and good luck.

  33. I must say, as a lot as I enjoyed reading what you had to say, I couldnt help but lose interest after a while. Its as if you had a wonderful grasp on the subject matter, but you forgot to include your readers. Perhaps you should think about this from far more than one angle. Or maybe you shouldnt generalise so considerably. Its better if you think about what others may have to say instead of just going for a gut reaction to the subject. Think about adjusting your own believed process and giving others who may read this the benefit of the doubt.Jobs offered

  34. I’m not sure why but this website is loading extremely slow for me. Is anyone else having this issue or is it a issue on my end? I’ll check back later and see if the problem still exists.

  35. Hey very nice blog!! Man .. Beautiful .. Wonderful .. I will bookmark your website and take the feeds also…I’m glad to find so many helpful info right here in the put up, we want develop more techniques in this regard, thanks for sharing. . . . . .

  36. Spot on with this write-up, I absolutely believe this website needs much more attention. I’ll probably be back again to read more, thanks for the information!

  37. Thanks for some other excellent post. Where else could anyone get that kind of information in such an ideal approach of writing? I have a presentation subsequent week, and I’m on the look for such information.

댓글 남기기