12 Replies - 1204 Views - Last Post: 03 January 2019 - 12:18 AM Rate Topic: -----

#1 hexagod   User is offline

  • 😂😂😂
  • member icon

Reputation: 31
  • View blog
  • Posts: 577
  • Joined: 29-October 16

What's a Good Way to Learn SQL ?

Posted 18 December 2018 - 08:27 PM

I'm looking to build my resume and get into SQL; in particular, I want to learn integration with C#. The problem is that I don't have a web database to practice with. Is it possible for me to practice using SQL with an .xlsx file? If not, what resources do you recommend for getting started?
Is This A Good Question/Topic? 0
  • +

Replies To: What's a Good Way to Learn SQL ?

#2 astonecipher   User is offline

  • Senior Systems Engineer
  • member icon

Reputation: 2918
  • View blog
  • Posts: 11,335
  • Joined: 03-December 12

Re: What's a Good Way to Learn SQL ?

Posted 18 December 2018 - 08:34 PM

https://www.microsof...ditions-express



Then run a sample data set that are downloadable in a plethora of places to practice with.
Was This Post Helpful? 2
  • +
  • -

#3 ndc85430   User is offline

  • I think you'll find it's "Dr"
  • member icon

Reputation: 979
  • View blog
  • Posts: 3,858
  • Joined: 13-June 14

Re: What's a Good Way to Learn SQL ?

Posted 18 December 2018 - 09:40 PM

SQLite is a small relational database you might consider. There's no server, just files.

Otherwise, does Docker run on Windows these days? You could always run a database server in a Docker container to save you having to install stuff on your machine (other than Docker of course!). Containers are easily thrown away when you're done with them. I use Docker for the DBs in my projects at home and we do so heavily at work (although on Unix rather than Windows).

This post has been edited by ndc85430: 20 December 2018 - 12:10 AM

Was This Post Helpful? 2
  • +
  • -

#4 Sheepings   User is offline

  • D.I.C Lover
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,260
  • Joined: 05-December 13

Re: What's a Good Way to Learn SQL ?

Posted 20 December 2018 - 05:22 PM

While it is good to use, it is depreciated https://en.wikipedia...act#Deprecation but full of resources online with many blogs dedicated to it. You can check out Erik's blog here http://erikej.blogspot.com/ one of many MVPs who still write content about it dispite being depreciated since 2012 or so.
Was This Post Helpful? 0
  • +
  • -

#5 andrewsw   User is offline

  • never lube your breaks
  • member icon

Reputation: 6813
  • View blog
  • Posts: 28,190
  • Joined: 12-December 12

Re: What's a Good Way to Learn SQL ?

Posted 21 December 2018 - 04:51 AM

Deprecated ;)
Was This Post Helpful? 1
  • +
  • -

#6 Sheepings   User is offline

  • D.I.C Lover
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,260
  • Joined: 05-December 13

Re: What's a Good Way to Learn SQL ?

Posted 21 December 2018 - 07:33 AM

Good snag lol that's the one ;)

Dam I even done it twice haha
Was This Post Helpful? 0
  • +
  • -

#7 baavgai   User is offline

  • Dreaming Coder
  • member icon


Reputation: 7471
  • View blog
  • Posts: 15,493
  • Joined: 16-October 07

Re: What's a Good Way to Learn SQL ?

Posted 21 December 2018 - 08:32 AM

View PostSheepings, on 20 December 2018 - 07:22 PM, said:

While it is good to use, it is depreciated https://en.wikipedia...act#Deprecation

To be clear, SQL Server Compact is NOT SQL Server Express, which is doing just fine.

I'd second SQLite as a most minimal beastie to play with. In fact, I'm fiddling with SQLite right now. However, I found the IDE (ok, command line) annoying enough that I shot the tables into MS SQL so I could use SQL Server Management Studio instead.

SQLite, by its nature, is missing a few features. You can use the free SQL Server Management Studio tool to manage SQL Server Express and get a production level experience and a ton of web support. If you're not Micr$oft inclined, the MySQL toolset is also feature rich enough to have decent SQL and web support.
Was This Post Helpful? 1
  • +
  • -

#8 Sheepings   User is offline

  • D.I.C Lover
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,260
  • Joined: 05-December 13

Re: What's a Good Way to Learn SQL ?

Posted 23 December 2018 - 03:57 PM

Obviously I'm not trying to check you, as I am sure you know very well the differences between the versions baavgai, but as you listed SQLite. I'd like to point out, SQLite is also not SQLCompact, as SQLite is still actively maintained afaik, as I've seen other posts else where assume these are one in one. As pointed out; not so here on that SO question. -Side note, personally If I want to test or work on SQL, i just install a server locally for it. Although I'd preference working with MySQL over all. :)
Was This Post Helpful? 0
  • +
  • -

#9 baavgai   User is offline

  • Dreaming Coder
  • member icon


Reputation: 7471
  • View blog
  • Posts: 15,493
  • Joined: 16-October 07

Re: What's a Good Way to Learn SQL ?

Posted 24 December 2018 - 04:44 AM

View PostSheepings, on 23 December 2018 - 05:57 PM, said:

but as you listed SQLite. I'd like to point out, SQLite is also not SQLCompact

Indeed, and goats are not unicorns. What does do either of these assertions have to do with my statement?

View Postbaavgai, on 21 December 2018 - 10:32 AM, said:

SQL Server Compact is NOT SQL Server Express


SQLite is simply not part of the conversation about "SQL Server Compact Edition and SQL Server Express Edition." Oddly, SQLite is also completely absent from your SO link as well.

So, yes, I agree, SQLite and SQL Server Compact Edition are completely unrelated.
Was This Post Helpful? 0
  • +
  • -

#10 Sheepings   User is offline

  • D.I.C Lover
  • member icon

Reputation: 224
  • View blog
  • Posts: 1,260
  • Joined: 05-December 13

Re: What's a Good Way to Learn SQL ?

Posted 24 December 2018 - 07:04 AM

Some might call it; pointing out the obvious. Whereas its not so obvious to some others. ;)
Was This Post Helpful? 0
  • +
  • -

#11 jch053   User is offline

  • New D.I.C Head
  • member icon

Reputation: 7
  • View blog
  • Posts: 34
  • Joined: 20-December 14

Re: What's a Good Way to Learn SQL ?

Posted 27 December 2018 - 08:59 AM

MySQL documentation points you to this test/playground database you can download in order to learn - https://github.com/datacharmer/test_db
Pop that bad boy into SQLite and start playing!

If you just want to play around with SQL and make your own db quickly online you should try out SQLFiddle
Was This Post Helpful? 1
  • +
  • -

#12 baavgai   User is offline

  • Dreaming Coder
  • member icon


Reputation: 7471
  • View blog
  • Posts: 15,493
  • Joined: 16-October 07

Re: What's a Good Way to Learn SQL ?

Posted 27 December 2018 - 10:10 AM

I'd second having a ready loaded database to play with.

One of the classics is the "pubs" database. ( Google that. ) I see Microsoft getting the credited for it, but it really came from Sybase, the DB company larger players essentially eviscerated. MS SQL Server has Sybase DNA throughout due to an odd partnership history.
Was This Post Helpful? 0
  • +
  • -

#13 rahulbatra   User is offline

  • D.I.C Head
  • member icon

Reputation: 17
  • View blog
  • Posts: 187
  • Joined: 28-December 05

Re: What's a Good Way to Learn SQL ?

Posted 03 January 2019 - 12:18 AM

If you prefer a more guided approach, there are a lot of good SQL texts out there. They also come with their own dataset to practice on. Teach yourself SQL in 10 minutes is great if you are looking for something short. If you can tackle something more thorough, I highly recommend SQL Variants by Bowman et al.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1