| Author |
Topic |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2008-02-05 : 12:03:18
|
| The more I realize that I don't really know much. My basic career path so far has been creating customizations of an ERP system using VBA and basic SQL statements as well as writing reports on said data using Crystal Reports. I understand select statements, all the basic joins, normal forms, etc. However, as I read posts on this forum, I often cannot even understand the question, much less the answer. What is the best way to learn this stuff and eventually become Microsoft certified in SQL Server and Business Intelligence? Got any tips for someone who has just realized that he is really a beginner? Dave |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-05 : 12:07:28
|
Stay tuned at SQLTeam.Begin with the question you understand and try to understand the suggestions made.If you can't understand them directly, dissect them into smaller pieces and understand every little piece.Eventually you will see the whole picture.And feel free to ask a follow-up question in the thread even if it is not yours.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-05 : 12:10:54
|
plus you don't have to know real hardcore SQL to be a BI expert  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-05 : 12:21:26
|
| I don't understand most of the questions either.CODO ERGO SUM |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-05 : 12:23:43
|
| albeit for different reasons _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-02-05 : 12:24:02
|
quote:
Originally posted by spirit1
plus you don't have to know real hardcore SQL to be a BI expert _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
"BI expert" usually means "BS expert with a high hourly rate"CODO ERGO SUM |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-02-05 : 12:50:15
|
quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by spirit1
plus you don't have to know real hardcore SQL to be a BI expert _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out
"BI expert" usually means "BS expert with a high hourly rate"CODO ERGO SUM
 Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2008-02-05 : 16:15:34
|
quote:
Originally posted by DavidChel
Got any tips for someone who has just realized that he is really a beginner?
Get the heck away from Crystal Reports. That would be my career advice. I make a point of NOT letting anybody know that I have experience with Crystal Reports.e4 d5 xd5 Nf6 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-05 : 16:24:55
|
quote:
Originally posted by Michael Valentine Jones
"BI expert" usually means "BS expert with a high hourly rate"
Don't forget"BI expert" usually means "BS expert with large vocabulary of buzz words"
E 12°55'05.25"N 56°04'39.16" |
|
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-02-05 : 16:58:05
|
quote:
Originally posted by blindman
quote:
Originally posted by DavidChel
Got any tips for someone who has just realized that he is really a beginner?
Get the heck away from Crystal Reports. That would be my career advice. I make a point of NOT letting anybody know that I have experience with Crystal Reports.e4 d5 xd5 Nf6
May I ask why? |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2008-02-05 : 18:18:43
|
| Crystal Reports is the devils product...Really. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-02-06 : 08:49:51
|
| Most "hard-core" sql developers that know personally have put their time in doing crystal reports (or some other type of report writing). I also removed any hint of that particular skill from my resume. But my reason wasn't so much my disdain of the product as much as my hatred of the "process". Report writing is one area where a developer can get requirements directly from a (sales guy / company officer / acct dept nerd) basically any numb-nut that gets an idea like he gets an erection an acts on it spontaneously. "Hey, i got an idea, I need a report that..." It usually ends up with a lot of too much wasted time and a lot of frustration.Even when a report requirement included an exact "dummied up" example of what the real report will look like, when they get the actual report they say, "I can't use this - It's missing <this>" The most success I've had was when I got to the point of conducting a pre-requirement interview with the requester and got to understand what question they were trying to answer. Then I basically came up with the design and they would say, "oh...yeah I guess that is what I need" even though it was nothing close to what they originaly asked for. None of that is my idea of a good time...Be One with the OptimizerTG |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2008-02-06 : 10:04:53
|
| Since the Crystal Reports topic has split off, anyone else have an opinion for me as to the best way to become a SQL Guru? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-06 : 10:13:50
|
| if you want to become a BI kind of guy this means SSIS, SSAS and SSRS, i'd suggest that you take a BI exam.a coworker is studying for it and i have to say it covers stuff pretty ok.if you want to become just SQL Guru, start by answering questions here. I'd recommend Inside Microsoft SQL Server 2005 book series:http://weblogs.sqlteam.com/mladenp/category/250.aspxthey're great!_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-02-06 : 10:54:11
|
quote:
the best way to become a SQL Guru
If you create a chart tracking 2 things: actual skill level and self-perceived skill levelI believe you would see one very steady line where the rate of improvement directly correlates to the amount of time actively performing that skill. That of course would be the "actual" line. The "self-perceived" line would ocillate greatly throughout the process, probably bigger ocillations at the beginning of the learning process.So the key to become great at anything is to spend time doing it. That day-in and day-out consistancy requires either an enjoyment of the daily process so you just keep doing it, or enough motivation to achieve the goal to force yourself to stick with it. You just have to know that there will be days when you think you're the greatest guru to walk the earth and days you think you don't deserve to walk upright. So find a way to enjoy sql, keep humble and stay willing to listen to anyone no matter how guru-like you become Be One with the OptimizerTG |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-06 : 10:55:50
|
| in other words: when you start thinking of yourself as a guru you start to suck _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-02-06 : 11:36:33
|
| Great stuff, Jeff!Ok David, when you get tired of reading blogs and reference manuals, here is a challenge just for you. This should insure that you have at least another hour of "experience" and hopefully it will be fun. Of course you can blow it off if you want to. Also, I don't know if this would be way too easy for you or hopelessy too tough so...Here is the challenge:-----------------------------------------------------------------------------------------------1)--Create sql code that will return all even numbers between 0 and 32--Don't use any "looping"--Don't use any pre-existing tables--Don't allow the this character to appear in your code: "8"-----------------------------------------------------------------------------------------------2)--Create as simple a code example as you can that when run will result in a deadlock error-----------------------------------------------------------------------------------------------3)--Write a statement that when executed will output "generated code" that if executed will add every db user to the role db_datareader--------------------------------------------------------------------------------------------Be One with the OptimizerTG |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2008-02-14 : 08:29:56
|
| Since when did BI become the butt of jokes?Jayto here knows when |
|
|
|
Next Page
|
The more I learn.....