| Author |
 Topic  |
|
|
stika
Starting Member
2 Posts |
 Posted - 06/18/2010 : 10:34:59
|
I am currently studying accountancy, and from what I heard we will be learning microsoft acess, which makes sense.
But one of the professors said casually during the last class that
"can anyone tell me why do you need to learn SQL in accountancy"
"Is there any situation in which an accountant would need to use SQL?"
I know the basics of microsoft Acess, but that's it.
However my proffessor specifically said "SQL"
So I'd like to hear it from your point of view, what do you think? |
|
|
jimf
Flowing Fount of Yak Knowledge
USA
2868 Posts |
Posted - 06/18/2010 : 11:42:04
|
SQL means Structured Query Language, of which Microsoft's t-SQL is just one of many. MS Access uses an SQL, SQL Server uses one, Oracle, mySQL, etc. Knowing a little of it can save you the hassle of begging someone in IT to provide you with basic data, and future companies might use Access for its forms and so knowing some Access may be a good idea. Beyond that, I don't see why you'd need any SQL training any more than I need Accounting training.
Jim
Everyday I learn something that somebody else already knew |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
6997 Posts |
Posted - 06/18/2010 : 12:41:58
|
It might be useful when you decide you really don't want to be an accountant and want to move into IT. 
CODO ERGO SUM |
|
|
|
stika
Starting Member
2 Posts |
Posted - 06/18/2010 : 12:43:04
|
| I guess that makes sense, thanks for the info :) |
|
|
|
fdtoo
Starting Member
25 Posts |
Posted - 01/05/2011 : 21:22:42
|
If you have a curious mind, you will really go to the extent of learning how something works. Ever wonder how your data captured in your system can generate those wonderful reports? How does the system automate your accountant's double-entry whenever a sales invoice get generated? Ever thought of how your system can execute credit control and posting restriction on your system? The answer as quoted by your professor, "SQL".
accountingdes.com
|
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
Posted - 01/15/2011 : 06:21:50
|
useful in knowing - even if you don't become an expert - even just for helping communicate your requirements to a developer
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
dataguru1971
Flowing Fount of Yak Knowledge
USA
1464 Posts |
Posted - 01/15/2011 : 06:50:58
|
any accountant should know that the cost of not knowing SQL is far greater than the cost of knowing it.
Poor planning on your part does not constitute an emergency on my part.
|
|
|
|
sqltrainingonline
Starting Member
3 Posts |
Posted - 05/29/2012 : 15:41:26
|
If you are going to be an accountant at a large corporation, then the data you need to do your job will most likely be stored inside a database. And you will probably encounter large accounting systems and ERP's, such as SAP. Many of these systems have canned daily reports that will tell you your P&L, General Ledger, etc. But, if any of those reports look bad for an account, you will have to do some research to figure out what was booked to the wrong place.
This is where SQL will come into play. SQL is the language you use to talk to the database. If you use Microsoft Access, it will write the SQL for you, but it can be temperamental and can write some very bad code/queries.
Many times, accountants will ask IT for assistance, but that takes a while and you depend on their timeframe.
In my consulting experience, it is very beneficial for Accounts, Business Analysts, and Financial Professionals to learn SQL.
If you want some training, I put together some free videos. unspammed
Joey
---------
unspammed |
Edited by - sqltrainingonline on 06/14/2012 10:19:15 |
|
|
| |
Topic |
|
As a future accountant do I need to learn SQL?
