973 posts
  • Has referred 10+ members
  • Has sold $5,000+ on Envato Market
  • Has been a beta tester for an Envato feature
  • Has collected 100+ items on Envato Market
+5 more
aaranmcguire says

Hey,

I have a client that wants me to take a look at a MS SQL database, I was wondering can anyone set me up a bit of a practice area to see how it all works, I have never seen MS SQL before so it would be nice to go on a server that has at least 2 tables that has a few columns and some data and just see how I can navigate stuff and export it to a back up (if thats posable).

If you cant give me access can you give me some screenshots of stuff, or, a bit of a tut?

Thanks in advance.

499 posts
  • Has referred 1+ members
  • Has sold $1,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Located in Canada
+2 more
TutelageSystems says

What are they expecting you to do on their database? Basic selects, updates, deletes, etc?

973 posts
  • Has referred 10+ members
  • Has sold $5,000+ on Envato Market
  • Has been a beta tester for an Envato feature
  • Has collected 100+ items on Envato Market
+5 more
aaranmcguire says

Selecting and inserting… The main goal is to see what equals what with the website front end.

Its something I wanted to do because its useful to know, and I know MySQL.

669 posts
  • Has been part of the Envato Community for over 2 years
  • Has referred 1+ members
  • Has sold $10,000+ on Envato Market
  • Has been a beta tester for an Envato feature
+1 more
Typps says

Selecting and inserting… The main goal is to see what equals what with the website front end. Its something I wanted to do because its useful to know, and I know MySQL.

Just install the express editions for SQL Server. These are great for learning and development. So look for SQL Server 2012 Express (the basics), install it. In addition get SQL Server Management Studio Express. This includes the management tools you can use to manage your databases. You install this after installing SQL Server 2012

http://www.microsoft.com/en-us/download/details.aspx?id=29062

From the files in the download (link above), just get the one with ADV in the name, this is the advanced version which should have everything in a single install i.e. The basics + SQL Server Management Studio Express, full text queries and reporting. Most likely the easiest for you to install.

This is the best way for you to test drive SQL Server and do local development. It’s rather intuitive if you’ve used other databases before so I don’t think you’ll have any trouble familiarizing yourself with it before commencing work for your client.

Good luck ^^

973 posts
  • Has referred 10+ members
  • Has sold $5,000+ on Envato Market
  • Has been a beta tester for an Envato feature
  • Has collected 100+ items on Envato Market
+5 more
aaranmcguire says

Thanks @Typps I will look into it.

by
by
by
by
by
by