Any free software to learn SQL

[Minibiker]

Hi all

My work have put up job ads for internal staff members to apply for, they need a Junior Data Analyst and I'm wanting to apply for it, I've spoke to someone in the IT department and he said to learn basics of SQL so I'm wandering if anyone knows if there are any free software downloads I could get to help me do some hands on practice aswell as learn with books etc

Thank you

 

[Deleted member 77746]

You best off just installing it and having a play about with it.

Break it, Fix it, Connect to it, Restore it. e.t.c

 

[throwaway4372]

You can get SQL Server from here, free download of Developer or Express, I'd pick Developer but it probably doesn't matter.

SQL Server Downloads | Microsoft

Get started with Microsoft SQL Server downloads. Choose a SQL Server trial, edition, tool, or connector that best meets your data and workload needs.

www.microsoft.com

Then use SQL Server Management Studio program to connect to your SQL Server and gives you a user interface for doing stuff with it.

Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS)

Download the latest version of SQL Server Management Studio (SSMS) for managing and configuring instances of SQL Server and Azure SQL.

docs.microsoft.com

Then create a database.

Create a database - SQL Server

Create a database in SQL Server by using SQL Server Management Studio or Transact-SQL. View recommendations for the procedure.

docs.microsoft.com

Then create a table.

Create tables (Database Engine) - SQL Server

Create a new table, name it, and add it to an existing database using the Database Engine.

docs.microsoft.com

Then learn INSERT, SELECT, UPDATE, DELETE statements, to manipulate data in your database.

SQL Tutorial - An Ultimate Guide for Beginners

SQL Tutorials for Beginners - Learn the concepts of world's most popular query language for databases in simple and easy steps with lots of live examples.

www.tutorialrepublic.com

That is 'the basics of sql' imo.

If you take to it, then learn the rest of the stuff at:

SQL Tutorial - An Ultimate Guide for Beginners

SQL Tutorials for Beginners - Learn the concepts of world's most popular query language for databases in simple and easy steps with lots of live examples.

www.tutorialrepublic.com

 

[Drizmod]

Youtube

 

[Minibiker]

You best off just installing it and having a play about with it.

Break it, Fix it, Connect to it, Restore it. e.t.c

Yeah will get it all installed and have a mess around with it.. Thank you

You can get SQL Server from here, free download of Developer or Express, I'd pick Developer but it probably doesn't matter.

SQL Server Downloads | Microsoft

Get started with Microsoft SQL Server downloads. Choose a SQL Server trial, edition, tool, or connector that best meets your data and workload needs.

www.microsoft.com

Then use SQL Server Management Studio program to connect to your SQL Server and gives you a user interface for doing stuff with it.

Download SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS)

Download the latest version of SQL Server Management Studio (SSMS) for managing and configuring instances of SQL Server and Azure SQL.

docs.microsoft.com

Then create a database.

Create a database - SQL Server

Create a database in SQL Server by using SQL Server Management Studio or Transact-SQL. View recommendations for the procedure.

docs.microsoft.com

Then create a table.

Create tables (Database Engine) - SQL Server

Create a new table, name it, and add it to an existing database using the Database Engine.

docs.microsoft.com

Then learn INSERT, SELECT, UPDATE, DELETE statements, to manipulate data in your database.

SQL Tutorial - An Ultimate Guide for Beginners

SQL Tutorials for Beginners - Learn the concepts of world's most popular query language for databases in simple and easy steps with lots of live examples.

www.tutorialrepublic.com

That is 'the basics of sql' imo.

If you take to it, then learn the rest of the stuff at:

SQL Tutorial - An Ultimate Guide for Beginners

SQL Tutorials for Beginners - Learn the concepts of world's most popular query language for databases in simple and easy steps with lots of live examples.

www.tutorialrepublic.com

Cheers bud, great help will have a look at this lot

Youtube

I have a few YouTube videos on my watch list so will get watching, thank you

 

[Nemiyen]

The SQL stuff at my work is pretty basic so I don't touch on it very often but the scripts this guy writes:

Ola Hallengren

And the blog this guy writes:

www.brentozar.com

Are great for SQL knowledge and tips and tricks etc.

We have stuff that relies heavily on SQL but the database is about 100MB so in SQL terms is about as noddy as they come! (luckily for me!)

Edit: Good luck with the testing and job application if you go for it!

 

[Minibiker]

The SQL stuff at my work is pretty basic so I don't touch on it very often but the scripts this guy writes:

Ola Hallengren

And the blog this guy writes:

www.brentozar.com

Are great for SQL knowledge and tips and tricks etc.

We have stuff that relies heavily on SQL but the database is about 100MB so in SQL terms is about as noddy as they come! (luckily for me!)

Edit: Good luck with the testing and job application if you go for it!

Thanks bud I will have a look at that also, hopefully I can get into it as IT has been something I've considered for a while now

 

[goldy6660]

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

 

[Minibiker]

W3Schools.com

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

Thank you bud

 

[Chaos]

I think the Sams Teach Yourself SQL books cover installation and provide a free Database to play with.

 

[Minibiker]

I think the Sams Teach Yourself SQL books cover installation and provide a free Database to play with.

OK brilliant will take a look thank you bud

 

[radderfire]

It might be a little advanced for a beginner, but these MS SQL Notes probably still have some useful info for you.

 

[junior]

I'm to trying to get in to sql and python, for mobile app, specifically android you have solo learn. You have a pay or subscribe option.

Although the suggestion above to install is a good idea as doing it on a mobile, you can get easily distracted I find.

 

[Minibiker]

I'm to trying to get in to sql and python, for mobile app, specifically android you have solo learn. You have a pay or subscribe option.

Although the suggestion above to install is a good idea as doing it on a mobile, you can get easily distracted I find.

I have a bit of beginner knowledge with Python but compared to many on here it's not much, it's very enjoyable to learn

 

[Chaos]

I noticed some of these recommended on Reddit -

Sqlbolt - You can do it all in your browser

SQLBolt - Learn SQL - Introduction to SQL

SQLBolt provides a set of interactive lessons and exercises to help you learn SQL

sqlbolt.com

Sqlzoo - Same as above -

SQLZOO

sqlzoo.net

And this Udemy course looks pretty decent -

Data Analytics: Intro to SQL using Healthcare Data (SSMS)

Master SQL using Microsoft SQL Server Management Studio in 2022

www.udemy.com