You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I wanna teach my kids a bit of SQL. Just the basics what is a table/index/view. How to write Select/Inset etc...
Is there a very light weight free db (for Win10 ) that I can type in SQL into? Or is there a free cloud db we can play with?
Where did this go?
MS SQL Server Express has always been free. Or else SQL Server Developer is in the "always free" tier on Azure - https://azure.microsoft.com/en-gb/free/#12-months-free
sqllite, its a flat file you can save like a document, no servers required
Your poor kids...
I like a bit of programming, I can see the fun stuff you can do with kids, but SELECT * FROM * I am calling social services
Extremely lightweight would be sqllite.
Slightly heavier would be postgres or mysql.
I would be tempted to go for sqlserver dev edition though since SSMS does make life easier.
was about to post the same tor5
#thumbsup
Much thanks folks - I'll check them out tomorrow.
Is this the coding equivalent of the naughty step?
Your poor kids…
ha - the reason I want it lite is because I make them create a new VM on their laptops for each topic I get them to learn. And they don't exactly have workstations.
I can't hang a picture frame straight so I got to pass something on.
On-line SQL scratch pad?
PostgreSQL/PGAdmin is free and pretty easy to set up. I'm a data science professor and I used it this semester to teach a basic SQL course remotely. Everyone could set it up on their own machine and use it wherever, even if they didn't have a consistent internet connection. Outside of some inconsistent file permissions across operating systems, it worked pretty smoothly.
Before teaching a class in it, I'd basically never used SQL before and I actually like it a good deal. I think it does a good job of making students think about the logic of the comparison they are making and the relations between variables/levels of analysis.
Some of my students though, really don't love it. They seem to prefer R/Python even though I think of them as more complex.
I find https://www.w3schools.com/ a great free resource.
They also have other languages like python that would be worth learning too.
If you are going down the MS SQL server route you may want to look at dbatools: https://dbatools.io/ , these are built using PowerShell and are a greate way of working smarter, i.e. least administrative effort, help is your friend etc.
Go the full monty and teach them all about Boyce–Codd. Fun, fun, fun 😉 🙂
'3rd normal form' sticker along the chainstay 🙂
Think you can install a SQLite database with DBeaver which is my own personal favourite database thingy tool. Plus can easily hook it up to RDS/Aurora if you wanted something different.
Mentioned above too but w3schools is an excellent resource - my go-to for most SQL stuff which I don't know (I'm by no means a SQL expert but need to do bits in my current job, mainly because nobody else wants to!).
Also mentioned above, social services need to be involved.
No love for MySQL? Learn a bit of Linux whilst they're at it.
ha – the reason I want it lite is because I make them create a new VM on their laptops for each topic I get them to learn. And they don’t exactly have workstations.
Why not just install a VM with a sqlserver already embedded
Check out SQL murder mysteries: https://mystery.knightlab.com/
There is a similar thing for terminal.
@tomlg - that looks cool. Definitely having a look.
As for social services.. I'm a believer that kids are amazing - mine - yours - everybody's. They can learn anything given the right steps. And for me - learning how to teach someone is a big part of the experience.
At my son's 8th (?) birthday - I taught the kids how to count in binary as a party game. Some got it straight away, some didn't so between them they taught each other. They were all eager to know it and in the next little while, they were testing each other while lining up for class in the morning.
SELECT * FROM * I am calling social services
That made me laugh. I have nothing more to add, I deal with SQL on a daily basis but I'm nowhere near good enough at it to do complicated stuff.
I taught the kids how to count in binary as a party game
Sigh. There's always one.
No love for MySQL? Learn a bit of Linux whilst they’re at it.
Exactly. Linux From Scratch.
No love for MySQL?
Would go for MariaDB rather than an Oracle product.
No love for MySQL? Learn a bit of Linux whilst they’re at it.
TBH postgres is better in nearly every way now
TBH postgres is better in nearly every way now
Doesn't make it better to just learn SQL from though...
However for the OP's purpose I'd just find and DL a VM with a sql server and perhaps something to use it for... (like a CMS they can play with)
Random example (not specifically recommended)
https://marketplace.cloud.vmware.com/services/details/turnkey-joomla-appliance/?slug=true
Learn a bit of Linux whilst they’re at it.
My 14y daughter wrote a little cube colour game in HTML/CSS/JS and my son (12y) created a vm, install a apache server on mint to host it so she could show her friends. I knew the extra £1 per month for a static IP was more useful than just Minecraft.
Yea it takes a lot of patience and I have to resist the temptation to just jump in and help. But I don't actually know that stuff either so I'm learning at the same time.
Funny thing is sometimes when I don't give him permission to do something he says 'sudo' then does it anyway.
Funny thing is sometimes when I don’t give him permission to do something he says ‘sudo’ then does it anyway.
You need to edit sudoers. That'll learn him.
Thirty posts in and no one's mentioned Northwind Traders? Pfffffffffff.
https://www.geeksengine.com/article/northwind.html
Personally I'd avoid sqlite, particularly for learning. The DB-in-a-file aspect is nice, but it's too compromised in other respects. I spent hours debugging why a join wasn't working before discovering that it had done something stupid with dynamic typing so that two values that looked identical weren't considered equal. Better to learn on something that does typing properly.
PostgreSQL is my preference, but these days there's not a lot to choose between MariaDB and Postgres, and MariaDB is far more widely used.
EDIT: why I hate sqlite
Postgres or Maria are the go to free options. Oracle and sqlserver both offer free with limits (that won't bother you), but both of them are scarily humungous. Sqllite is a bit odd because it's not really a server, but the SQL concepts are the same.
Don't bother with setting it up on a VM, learn docker, it will save you hours.