973 posts
  • United Kingdom
  • Attended a Community Meetup
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • Sold between 5 000 and 10 000 dollars
  • Has been a member for 3-4 years
  • Envato Studio (Microlancer) Beta Tester
  • Bought between 100 and 499 items
  • Referred between 10 and 49 users
  • Exclusive Author
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
  • Canada
  • Exclusive Author
  • Sold between 1 000 and 5 000 dollars
  • Has been a member for 5-6 years
  • Bought between 10 and 49 items
  • Referred between 1 and 9 users
TutelageSystems says

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

973 posts
  • United Kingdom
  • Attended a Community Meetup
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • Sold between 5 000 and 10 000 dollars
  • Has been a member for 3-4 years
  • Envato Studio (Microlancer) Beta Tester
  • Bought between 100 and 499 items
  • Referred between 10 and 49 users
  • Exclusive Author
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.

616 posts
  • Envato Studio (Microlancer) Beta Tester
  • Exclusive Author
  • Has been a member for 2-3 years
  • Referred between 1 and 9 users
  • Sold between 10 000 and 50 000 dollars
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
  • United Kingdom
  • Attended a Community Meetup
  • Repeatedly Helped protect Envato Marketplaces against copyright violations
  • Sold between 5 000 and 10 000 dollars
  • Has been a member for 3-4 years
  • Envato Studio (Microlancer) Beta Tester
  • Bought between 100 and 499 items
  • Referred between 10 and 49 users
  • Exclusive Author
aaranmcguire says

Thanks @Typps I will look into it.

by
by
by
by
by
by