SQL

jryantech

There seems to be many different extensions/types of "SQL".

I'm looking to learn SQL for Database Administration.
What programs does someone who does SQL Database Admin work use on the daily basis?
(I have Microsoft Excel, Access and Visual Studio 200

Do you have any Books/Online Videos/Courses you might recommend me picking up?
Also is their any type of Certification tracks for SQL, I'm currently looking into a .NET/C# track and was wondering if SQL has a track.

Also what is the difference between MySQL and SQL? MySQL seems to be from Sun and more Web-Based...

Hopefully you guys can get these questions answers for me

dynamik

Well, SQL is a standard. Vendors (MS, Oracle, IBM, MySQL) work off that standard and add their own additional functionality.

Any general SQL book, such as SQL in 24 Hours, will get you up and running. You'll need to find a book that's specific to the version you're using for your intermediate-advanced studies.

MS uses Transact-SQL: http://en.wikipedia.org/wiki/T-SQL

MS has certifications for SQL Server 2005 and will soon have them for SQL Server 2008. Oracle certifications are huge in the DB world as well. Other vendors, such as MySQL have certifications as well, but they're not as popular.

BeaverC32

Popular programs are SQL Server and Oracle 10g/11g, etc. Another app all of our DBAs use is Toad.

Before you begin administering SQL it is important to understand the basics. A few excellent books:

http://www.amazon.com/Beginning-SQL-Server-2005-Administration/dp/0470047046/ref=sr_1_5?ie=UTF8&s=books&qid=1217347397&sr=1-5

http://www.amazon.com/Beginning-Server-2005-Programming-Programmer/dp/0764584332/ref=pd_bbs_4?ie=UTF8&s=books&qid=1217347339&sr=8-4

jryantech

Ok so learning SQL Server 2005 would be a good start?

What programs do they use for SQL Server 2005/2008?

BeaverC32

SQL Server is the application suite: http://www.microsoft.com/SQL/default.mspx

jryantech

BeaverC32 wrote:

SQL Server is the application suite: http://www.microsoft.com/SQL/default.mspx

Ok so I can get " SQL Server 2005 Developer Edition - 32-bit " for free at my school. I'll pick it up when I'm on campus next.

Thanks for the help guys.

If anyone else has input please reply

undomiel

MySQL is free: http://www.mysql.com/
PostgreSQL is free as well: http://www.postgresql.org/

I've seen a lot of jobs looking for MySQL. Especially if you're into Linux.

On another note if you don't mind me expressing my concerns here, you may want to make sure you aren't spreading yourself too thin here. You recently got your A+ and got a new job with Firedog, you're still looking for a better one, you're studying for your 70-620, learning programming and looking at certification for that, learning SQL and looking for certification in that, and whatever else you're pursuing as well. Make sure you don't burn yourself out and/or just be a jack of all trades with no real knowledge in at least one.

jryantech

undomiel wrote:

MySQL is free: http://www.mysql.com/
PostgreSQL is free as well: http://www.postgresql.org/

I've seen a lot of jobs looking for MySQL. Especially if you're into Linux.

On another note if you don't mind me expressing my concerns here, you may want to make sure you aren't spreading yourself too thin here. You recently got your A+ and got a new job with Firedog, you're still looking for a better one, you're studying for your 70-620, learning programming and looking at certification for that, learning SQL and looking for certification in that, and whatever else you're pursuing as well. Make sure you don't burn yourself out and/or just be a jack of all trades with no real knowledge in at least one.

Yeah I'm halfway threw the MS Pressbook for 620 and completed some Microsoft E-learning courses on it... I'm not stressing getting the certification, I just need something else on my resume.

I've looked into many programming languages and I'm currently trying to find two or three to focus on... C#/.NET is one and I'm thinking SQL should be the other... Java is cool just doesn't seem to have the jobs like C# and SQL does.

I'm interested in learning the foundations of C# and SQL. Also the certification tracks just for future concern.

C# Software Development and SQL Database Administration seem to be pretty good fields right now, so hopefully in three years after I complete my degrees, I can jump on one of these.

Does anyone disagree with going C#/.NET and SQL? From my research the last few months these seem the best route and plus I'm very interested in Visual Studio.