Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
newsqldba
Starting Member
14 Posts |
 Posted - 2007-08-28 : 19:33:38
|
| hi. i dont understand what they mean when they say developing oltp solutions. can anybody pls explain it to me. also does anyone know what ways there are to develop sql oltp solutions using SQL 2005 reporting services, OLTO, Excel Services. as well as any good tutorials for it? thanks for the help. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 21:29:10
|
| That's online transaction processing system. |
 |
|
|
newsqldba
Starting Member
14 Posts |
Posted - 2007-08-28 : 21:47:07
|
| :) thanks for giving the literal meaning of the acronym. hehe. i know it means online transaction processing system. i was actually hoping for more detailed information on the subject. :) thanks though |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-08-28 : 22:07:45
|
| Sounds like another way of stating the need to write queries in Transact SQL on the backend for use by applications. Try getting the book "The Gurus guide to Transact SQL" this is a good book for learning how to do that sort of thing. You should then play with Reporting services and building reports in Excel etc to familiarize yourself with that part. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 22:44:20
|
| What do you like to know in specific? It's a huge topic. |
|
|
|
newsqldba
Starting Member
14 Posts |
Posted - 2007-08-29 : 00:19:45
|
| thanks for the info. il definitely check out the book. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-29 : 01:10:41
|
| your best shot is to take some classes on databases as well as SQL language so you start understanding the terms. You can usually find decent classes through a university (extension classes) or at a decent junior college and they are typically fairly inexpensive.You can also take courses that are product specific (SQL Server admin, Oracle admin, etc.) at training centers. These classes are usually more expensive than extension courses and are geared more for technical certification than general knowledge, so they may not be that good for a noob.The class will be good for the big chunks of information. SQLteam will be useful to help you finetune your understanding.-ec |
|
|
|
|
|
|
please help with oltp solutions