Getting started with SQL

rubberduck · 24 Feb 2021 at 18:00

Hi

Looking to learn the basics of SQL, are their any free options for setting up a very rudimentary data base and playing around with tables. Preferably some tutorials I can follow to understand the basic - not looking to go complex.

Thanks

gpuerrilla · 24 Feb 2021 at 19:50

Can you use any spare equipment to setup a home lab?

Randomface74 · 24 Feb 2021 at 20:00

You can download SQL Server developer edition from here:
https://www.microsoft.com/en-gb/sql-server/sql-server-downloads

You'll use SQL Server Management Studio as your graphical user interface, you can get it here:
https://docs.microsoft.com/en-us/sq...-management-studio-ssms?view=sql-server-ver15

If you want to write some C# to use your database, here's a tutorial:
https://www.youtube.com/watch?v=Et2khGnrIqc

You'll need Visual Studio installed for that, you can get the Community edition from here:
https://visualstudio.microsoft.com/downloads/

Deleted member 77746 · 24 Feb 2021 at 20:06

A home lab for sure! You can even use SQL just on your PC/laptop as localhost to have a play.

Dolph · 26 Feb 2021 at 16:51

https://skillcrush.com/blog/learn-sql-online/

Loads of free resources/courses, find one that suits your style.

HippoTank · 13 Apr 2021 at 20:18

Raspberry Pi is good for stuff like this

Deleted member 77746 · 15 Apr 2021 at 14:07

HippoTank said:
Raspberry Pi is good for stuff like this

No need for it just use localhost on any pc will do. Or even a vm if you want.

Cooler running · 20 Apr 2021 at 23:44

rubberduck said:
Hi

Looking to learn the basics of SQL, are their any free options for setting up a very rudimentary data base and playing around with tables. Preferably some tutorials I can follow to understand the basic - not looking to go complex.

Thanks

Something like this maybe? Should be easy enough to follow along with the video.
Any normal computer can run SQL, it's light weight and most database engines are freeware.

As a side note, it will take much longer than 4 hours to follow along, so recommend maybe 1 hour of following along for each 30 minutes of video.

bremen1874 · 21 Apr 2021 at 00:17

If you want to start creating SQL databases the platform and implementation don't matter very much, what you need to know is how to structure the tables.

Do some reading on database normalis(z)nation and make sure you understand how to get to at least 3NF.

balanceballs · 21 Apr 2021 at 16:12

Don't worry about servers, home labs or raspberry pis. Just install SQL server on your own machine, download the Adventureworks database and follow some of the many Microsoft documentation pages and other tutorials online.

Generally though, if you are having to ask on a forum how to do something like this you will probably struggle. You could have figured all of this out by Googling it yourself. That's a huge part of learning.

Deleted member 77746 · 24 Apr 2021 at 10:51

balanceballs said:
Don't worry about servers, home labs or raspberry pis. Just install SQL server on your own machine

balanceballs said:
Just install SQL server on your own machine

That is a home lab then.

gpuerrilla · 24 Apr 2021 at 11:38

Then you get loads of services starting, local files to mess with. Fine if you have to, but you will learn more and appreciate a separate place to host the back ends, containers etc. if you use a repurposed machine or a pi like we said.

I know people cringe but we are not talking corporate grade here to start out. I learned my basics on Access then started to split the FE and BE, linking databases - the language is similar and you can get comfortable with it easily. You can then set up mySQL or postgresql and take it to the next level. There are so many ways you can implement a 'database' to the needs it would be more helpful to target what you need it for, unless its simply to mess with.

balanceballs · 26 Apr 2021 at 00:32

Th0nt said:
Then you get loads of services starting, local files to mess with. Fine if you have to, but you will learn more and appreciate a separate place to host the back ends, containers etc. if you use a repurposed machine or a pi like we said.

I know people cringe but we are not talking corporate grade here to start out. I learned my basics on Access then started to split the FE and BE, linking databases - the language is similar and you can get comfortable with it easily. You can then set up mySQL or postgresql and take it to the next level. There are so many ways you can implement a 'database' to the needs it would be more helpful to target what you need it for, unless its simply to mess with.

If he/she is literally just trying it out then there's not much point going to all that effort. Just install it, play around and if you like it, build a server or whatever. If you must have it seperated, run it in a VM

As I said though, this person should have figured those basic steps out for themselves. Doesn't bode well for future learning if they're already stuck.

Tee Hee Johnson · 8 May 2021 at 01:48

I would take a look at some of the Brent Ozar fundamentals. May not give a 'qualification' at the end, but will give you a good grasp of the basic administration of SQL Server.

lukegarbutt · 11 May 2021 at 23:28

Depends on your level, but if you are brand new to coding in general and just literally want to get running some commands, something like http://sqlfiddle.com/ is great.

If you're a little more experienced then why not install docker and just build the postgres image? This would be my preference

Bassmansam · 5 Jun 2021 at 14:16

I used this course from udemy .. https://www.udemy.com/course/oracle...roach/learn/lecture/4732842?start=15#overview

Robert Walker · 13 Jun 2021 at 18:48

I used to install SQL Server (the free edition) on my personal PC. Decent enough GUI - you can build and edit tables through the GUI if I remember correctly, and you can write scripts, stored procedures, triggers and all of that. As others have said, the downside is that it runs as a service on your machine and as my machine got longer in the tooth it definitely slowed down startup times etc.

I've just installed SQLite and a GUI for it (DB Browser for SQLite) on my machine - it doesn't give all the functionality (e.g. stored procedures) of the proper SQL platforms, but it's great for playing around and learning. Runs as a file so no need to install a server and should be easy enough to delete when you're done. To be honest, if you just want to try something and knock a few things together I would pretty much recommend it to play with and see if you like it and get the hang of it.

I've never tried mySQL or PostgreSQL, but as they're both open source (I think) I expect you'd be able to download and install either on your machine and they'll work somewhat like SQL Server - running as a service and with the full suite of SQL capabilities. I've not done it and I've not researched for this post, but they're both pretty big names in SQL so they're worth mentioning but I'm afraid you'll need to DYOR on them.

Good luck.