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.
What are they expecting you to do on their database? Basic selects, updates, deletes, etc?
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.
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 2012http://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 ^^