Is there an "MS SQL Server Express for dummies" somewhere ?

JesperMP

Lifetime Supporting Member + Moderator
Join Date
Feb 2003
Location
ᚴᚬᛒᛅᚾᚼᚬᚠᚾ
Posts
16,239
Hi, I am at the moment fumbling with testing some programs that work with SQL databases.
In order to have an SQL database to test with, I figured that I could use the free MS SQL Server Express. I downloaded and installed it, but find that I cannot get started with it. I need a push or two in the right direction.

I did check on MS website, but there are only some online lectures that I find too generic, and then there is a 135 MB "book" which I find a bit too much.

I just need to be able to send SQL commands and see the result. I dont need to be a certified SQL database expert.
I need a hands-on guide for noobs, and it must be specifically for MS SQL Server 2005 Express.
 
Aha. I thought that it was something extra for the advanced user. I will download it and give it a look asap. Thanks.

I know SQL structure and commands reasonably well allready.
 
Hi there
If I can learn from this place then surely you can do too!
Ok this site is all about the bacis of the SQL SERVER for DUMMIES.

Just give a look at it, I found its explanation very easy.

If you already know what this site teaches then.............

WWW.QUACKIT.COM
 
I hate how Microsoft labeles their DB frontends - that's one of the peskier things about SQL Server in general. Officially, I think it was Enterprise Manager for SQL Server 2000, and SQL Server Managment Studiofor 2005. Alternatively download third part tools like the DB Tools frontend, which at least used to be free for one database type (you can get a version compatible with pretty much any). You can also use MS Access via an ODBC connection, but that's not the preferred method.

I've never seen much of a frontend tutorial beyond the sections that cover it in the beefy SQL Server books. It's pretty straightforward clicking around when you get there.

I've found SQL Zoo to be a good site to learn to construct basic SQL queries.

S7Guy said:
Did you also install the SQL Management Studio Express? This will be necessary. Otherwise, sql is very easy to learn.
 

Similar Topics

Hi all, I'm having difficulties trying to connect FactoryTalk View SE Local Station (V13.00) to MS SQL Server Express. I state that they are...
Replies
2
Views
109
Hi All, I need a step-by-step method to insert and update lines in the database SQL Server via software builded in FT View SE. Thanks. Fabricio
Replies
60
Views
18,370
Hi Really quick question. Rockwell Historian SE 4.00.01 has MS SQL Server Express behind it. In a previous life, using Wonderware InSQL...
Replies
10
Views
5,171
This is the first time i have tried to configure this sort of thing so please bare with me. I am attempting to configure Intouch to write data to...
Replies
2
Views
8,420
Hi, All: I have a project to replace 3 old window 7 PCs with new window 10 PCs. the 3 old PCs: one is FTV SE server, other 2 are SE clients...
Replies
2
Views
562
Back
Top Bottom