Any advice on where to start with learning SQL and C#?

Hi all,

Not sure if this is correct place to post this thread but im looking for advice on where to start with learning SQL and C# as i wish to start in a new career as a DBA.

Cheers,

Your best bet is to download the express editions, and buy some books. C# and SQL are obviously different languages, you'll also need to learn ADO.NET, which is part of the .NET library that is for talking to databases.

In the first instance, I suggest you learn C#. Which means buying a book and working through it. It also means writing console applications first, unless you have a C++ background, in which case you should get into the basics quickly. Then you should learn enough SQL to build a database, and start working on connecting the two.

What's your background ? Have you done programming before ? What's prompting this move ?

|||

I have a legal copy of Visual Studio 2005 Pro and a copy of SQL 2005 Standard so as for the software im sorted, i have a limited understanding of VB6 but not the .Net Framwork not sure if it will help as i have been told that the syntax are very much apart.

The move is being prompted as i am leaving the Armed forces and have gained MCP and MCSE from them although that was Server 2003.

As my main aim is to become a DBA would i be better off learning VB or C#?

|||

VB.NET is very different to VB6, enough that some people regard it as a whole new language. However, the syntax is more VB like than C# is, C# syntax is C++ like.

There is no reason to choose between VB.NET or C# that has any basis in capability of performance, you should choose whatever suits you, probably VB.NET. There are differences, but none of them stop either language from being able to write the same applications as the other.

|||Thanks for the advice i think i will move to VB .NET