While there are some things that both can do, Excel and SQL are predominantly used for different things. Excel is for working with spreadsheets and SQL works with databases. So you cannot really compare them and say that one is better than the other.
SQL is Structured Query Language, and relates to databases. Excel is a spreadsheet application.
SQL means Structured Query Language. It is a programming language which is mainly used for maintaining databases. Excel is one of the application developed by Microsoft to do calculations, graphs using spreadsheets.
Dbase is a software basically like excel, it is like a old form of excel and you can do mostly all functions plus use sql commands in dbase.
It depends on what you want to do. Both are useful to learn and know about. Knowing either one of them would enable you to do lots of things. Knowing something about both of them would be even better.
You need to be able to use and edit Visual Basic and have experience with Arrays. Anything beyond that and they should be using SQL instead of Excel.
The general opinion is that Excel is better than Numbers.
you can not open the sql server back up file in access. You have to use server wizard to see the data base provided. It it not simple access or excel file. AnandDave.
Karrox is good in Mumbai for SQL. Also, I heard same about NIIT. For VBA macro, you need personal efforts.
YES !
Both Excel and Access are capable of doing a lot of things that the other can do. Excel is a spreadsheet application and Access is a database application, so they are used for different things. They are different kinds of applications so they cannot be compared in full, only on certain things. If you want to do a lot of databasing things, while you can do them in Excel, Access is better for it. If you are doing a lot of calculations, then Excel is better although Access can do calculations too. So it depends on what you want to do.
SQL instances are individual running copies of the SQL Server software, each with its own system databases and user databases. They are used to segregate and manage multiple databases on a single SQL Server. Instances allow for better utilization of server resources and provide a level of isolation between different sets of databases.
One can find an SQL formatter from: SQL Format, Free Formatter, Poor SQL, T-SQL Tidy, Stack Overflow, SQL Inform, Apex SQL, SQL Parser, Red Gate software, to name a few.