Any free software to learn SQL

Minibiker

Minibiker

Minibiker

Soldato
Joined
27 Mar 2016
Posts
7,595
Location
Bristolian living in Swindon
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
 
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.
docs.microsoft.com

Install SQL Server Management Studio

Learn how to use the Visual Studio installer to install SQL Server Management Studio (SSMS).
docs.microsoft.com

Then create a database.
docs.microsoft.com

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.
docs.microsoft.com

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 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 www.tutorialrepublic.com
 
Bouton Aide said:
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
Click to expand...

Yeah will get it all installed and have a mess around with it.. Thank you
throwaway4372 said:
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.
docs.microsoft.com

Install SQL Server Management Studio

Learn how to use the Visual Studio installer to install SQL Server Management Studio (SSMS).
docs.microsoft.com

Then create a database.
docs.microsoft.com

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.
docs.microsoft.com

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 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 www.tutorialrepublic.com
Click to expand...

Cheers bud, great help will have a look at this lot
Drizmod said:
Youtube
Click to expand...

I have a few YouTube videos on my watch list so will get watching, thank you
 
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!
 
Last edited:
Nemiyen said:
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!
Click to expand...

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
 
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.
 
junior said:
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.
Click to expand...

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
 
You must log in or register to reply here.
Back
Top Bottom