|
Hi
I've a masters degree in computer application.I would like to become a database administrator. What should I learn?
and what is the current job market
please advice me
Thanks & Regards
BMP
|
|
|
|
|
BMP1980 wrote: What should I learn?
Databases? I'm not sure what you mean by your question.
BMP1980 wrote: what is the current job market
Depends where you are in the world. There is a shortage of good DBAs in Scotland at the moment according to the people I met at my local SQL Server UG earlier this evening. That means companies are paying lots of money to DBAs.
|
|
|
|
|
There are some certificates according to databases.
If the question is what system you should learn?
Then I think there are two solutions:
Either go for a oracle DB which is a create one! But it costs! So it is just in use from some companies, who have two much money 
Or you should have a try on the MySql. It is free and well documented. It is not as good as the oracle but normally it is more than ok.
Cheers
You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)
|
|
|
|
|
Fatbuddha 1 wrote: There are some certificates according to databases.
If the question is what system you should learn?
Then I think there are two solutions:
Either go for a oracle DB which is a create one! But it costs! So it is just in use from some companies, who have two much money
Or you should have a try on the MySql. It is free and well documented. It is not as good as the oracle but normally it is more than ok.
I disagree.
SQL Server has recently overtaken Oracle for enterprise database systems. It would therefore seem to be prudent to learn the system that is gaining ground and needs more DBAs than the system that is losing ground.
SQL Server also comes in many flavours. SQL Server Express is free. It is well documented and there are several user groups where support from ones peers is available. If you want to learn the enterprise level features then the Developer Edition costs just $49 which is identical to the Enterprise edition but for two things. First it can also run on Windows XP or Vista (Enterprise Edition cannot) and second the licence only permits use for development and testing. Naturally, when putting those skills to use in a comercial environment the final deployed solution would be on a full license.
Finally, the OP asked the question on a Microsoft centric website. That suggests that the OP is self-selecting a choice to just what Microsoft offer. That is Access or the plethora of SQL Server Editions.
|
|
|
|
|
I've just been employed (about three months ago) by a large corp, as a .NET senior dev, after working my way through a few standard dev jobs over the last few years. They are interviewing a couple of contractors next week to come in and supplement the team here. My department head just came down to my desk, and told me all this (which I had heard on the grapevine) and all of a sudden asked me to sit in on the interviews next week to query these guys on their technical knowledge of .NET. As this is the first time I've been involved in the interview process from this end, I was wondering if any of you old hands out there on CP have some standard tacks you would take on this? I have the weekend to think about it and come up with a gameplan.
Off the top of my head I'm thinking;
a) Quiz them on their understanding of the concepts of OO, and their general development methodology. Soften them up with some "concept" questions, to get a feel for how they think about the development process and how well developed their personal standards are. Perhaps some simple written tests on an algorithmic basis, using Java/C# as the syntactic base, to test their general debugging abilities.
b) Explore their knowledge of the namespaces in .NET, and their familiarity with the platform in general. Here, I'm wondering what to focus on - which areas would you consider vital to be expert in, and which might catch out an indifferent dev?
c) A couple of very specific questions to explore their knowledge of threading, web services, and SQL.
Does this sound over-the-top, or on the other hand too "vanilla"?
And also, just on the subject of coming up with specific allgorithmic tests, does anyone know of any resources on the Net which would contain some samples I could use or adapt? Or if anyone has specific tests they favour of their own, I'd welcome the input...
All the dude ever wanted... was his rug back.
|
|
|
|
|
melchizidech wrote: As this is the first time I've been involved in the interview process from this end, I was wondering if any of you old hands out there on CP have some standard tacks you would take on this?
What we do[^] - From my blog.
The important thing is to discuss their CV. Don't go in with a standard set of questions that must all match up. If they don't have exactly what you are looking for they'll be able to pick it up fairly quickly if they have the basics all sorted out.
melchizidech wrote: Quiz them on their understanding of the concepts of OO, and their general development methodology
Excellent idea.
melchizidech wrote: Explore their knowledge of the namespaces in .NET, and their familiarity with the platform in general. Here, I'm wondering what to focus on - which areas would you consider vital to be expert in, and which might catch out an indifferent dev?
Just cover the basics here + what ever is on their CV. If they know ASP.NET really well then you start asking them lots about Windows Forms developement just isn't going give good results.
In other words. Things along the lines of how string works (e.g. it is immutable) and when to use StringBuilder.
melchizidech wrote: A couple of very specific questions to explore their knowledge of threading, web services, and SQL
If this is relevant then go for it. If it is a MUST HAVE requirement of the job because they are doing highly multi-threaded database backed web services then absolutely.
I was once in an interview where I was invited in and they asked me a load of questions about stuff that wasn't on my CV. e.g. Have you worked with X? And I just had to answer no to all these questions. They then terminated the interview. I'm still wondering why they invited me to interview. It doesn't give me a very good impression of their company.
|
|
|
|
|
Greetings! I am sure many of you will read this and sigh, because this is the same question that I have seen a dozen times on here. I am going to approach this in a hopefully different way, so my simple question may be a bit longer than usual, but the core of it is "what do I do from here"?
I have been on and off reading/lab programming for a while now (boardering on a year). It wasn't until a few months ago that I became a lot more serious about my intent to participate. I've started tackling the OOP understanding barrier, studying and testing ideas pretty much every night of the week. I have a non-tech degree (management) and I am a little older than the average programmer new to the field (30). I feel like my knowledge is progressing well, but I am still not quite ready yet. My language of choice is C# based on the recommendation of a good friend who is a senior programmer and a named company (I know the community is tightly tied together, so I would rather not say where). Needless to say, my best freind has become my mentor. We work on my code and dress it up so that I understand how my code can be better prepared. I feel like I will still need a year to learn up to a comprable level at the casual study rate. However, now that I am seeing a sort of path, I have found that I am programming more and more, and willingly stepping outside of the boundaries of what I know to see if I can just build random items.
Here is what I know at the moment:
Basic class structures, loops, arrays, and I am working on base classes in C#. This gives me the ability (tied with the VS developer) to create very simple but functional programs. I will begin to work on SQL and ADO shortly (probably another month). However, I want to really start stepping up. I think that I want to go into applications development based on the following facts: web development has a home in PHP and Javascript as well, and I am not really ready for that sort of versatility just yet. I realized that I need to keep focused on the .Net group of languages for a while. In order, I intend to expand my C# development skills much further and this is my primary goal, following with SQL(T-SQL), ADO, and then ASP in their respective .Net form. So basically I am a semi-functional beginner.
But here is where I was hoping that some people could give me ideas, part of the challenge that I have discovered is that as a beginning programmer I am now stuck in a middle place. I am a little more advanced than the basic stuff like loops, so the beginning classes are not good for me, and the advanced classes are still just out of my range. I want to get out there and code! Play QA or something to get some real time in and start developing.
From what I understand most of the people that graduate college have little more than a theoretical understanding of programming concepts, although I am sure there are many of you out there that popped out of the womb as pros, so please don't take that as an insult. I'm a very rapid learner, and don't have to ask twice. If any of you have any sources where I can start to develop additional applications, I would appreciate it. My ideas are simply not complex enough to challenge me anymore (you can't create something greater than yourself, is the way it was told to me), and honestly my friend has better things to do with his life than always answer my questions or design more stuff for me to do.
I have heard a few suggestions about elance and things like that, but when I search there, they want pros like you guys (as I would too), and they are not really there except to get a job done (the point of outsourcing).
So again, any thoughts that you have for me, good or bad, are accepted and appreciated. I just want to get out there and get a job in the end, and at this point the only way to do that is to churn out more code.
Thanks again for your help
Beginning Programmer - Still learning as much as possible.
|
|
|
|
|
How refreshing this post was. Coherent. Well thought out and to the point. More importantly, you laid out your skill levels well and indicated the areas where you want to progress. So how can you go about this? Well, probably the best way to do this is to go out and code. I know that this seems to be obvious, but it's surprising how few people actually think it through.
Obviously, CP has so many good articles on coding that you should be downloading and playing with some of the samples. I'm going to make a really suggestion here - find a project that hasn't been touched in a while (preferably a .NET 1 article) and bring it up to date in .NET 2. Pick a project that is reasonably well written, but looks to have been left on the shelf for a year or so. What you get here is a base to start from, and you can bring your own programming personality to bear on it.
If you have problems, then feel free to post questions on the forums and we will do our best to help out with this.
Now - you need to learn about things like patterns. Pick up a couple of good tutorials on patterns and see if you can redo the work using patterns. I'd be surprised if you couldn't find at least a couple of patterns that you could use.
If you need help on choosing a project, pick a couple that you think that you might want to take a look at and post the links. We'll take a look and say if we think that the skill level is too great.
Good luck - and I hope we see more of you.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Will do! Thank you very much!
Beginning Programmer - Still learning as much as possible.
|
|
|
|
|
I would like to report that it is going much better than it was at the time I wrote this a few months ago.
But I am finding that there is still a very strong opportunity to bit off more than I can chew, as I have done with my last project (an app for work that I am doing on my own time).
I don't care what anyone says, I can see the value of classes that walk you in a structured process, and you get the opportunity to learn MVCs, and controller classes, and frickin design concepts for interfaces and databases.
Right now I feel like my right hand is furiously working to make my click events happen in this program and my left hand is punching me in the face for thinking that this was going to be a quick transition (if not an easy one).
Much respect to those of you out there. Learning this so far has taught me that it's not just syntax. It's designing the look, and creating the framework, and syntax, and after all that testing, and retesting, and staring at the screen going "...hmmm, I wonder why it's doing that?"
Oh well, at least I am getting better about asking more specific questions and being more clear as to what I need to make my programs work.
Not that that is worth more than a poop in the hand right now. 
Beginning Programmer - Still learning as much as possible.
|
|
|
|
|
Hi guys
Is there any way by which we can modify BMP file metadata to add comments to the file , i.e set the properties in the image file .
Please suggest some solution to this .
|
|
|
|
|
So how is this a Work and Training Issue??? You might want to ask this in the Graphics forum.
|
|
|
|
|
Damn. I missed that one.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello,
I have code like
window.open(strurl, strwinName)
where strWinName's value is coming from database.
User can enter value like [ABC]0001, ABC^001, if these value is assigning to strWinName then in Internet explorer getting error like 'Invalid arguments', but this works fine in firefox.
Here problem in windows name, if we have any special characters like [,] or ^ then it is throwing error, How can I escape these characters any work around is appreciated.
Thanks & Regards,
Kumar
|
|
|
|
|
How is this a work or training issue? Apart from the obvious - that you need more training to accomplish this.
Anyways - as we're here, if you're coding in .NET you could use HttpServerUtility.HtmlEncode. In Javascript, you can use escape on the string, i.e. escape(url).
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Pete O`Hanlon wrote: How is this a work or training issue? Apart from the obvious - that you need more training to accomplish this.
Training is overrated, isn't it? I thought it was optional.
|
|
|
|
|
Scott Dorman wrote: Training is overrated,
I far prefer to just wing it and cover my tracks with generous helpings of bad attitude and strong opinions.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hello,
Thank you for your reply.
This is a work issue. javascript escape function was also throwing error. HtmlEncode I will check.
Thanks & Regards,
Kumar
|
|
|
|
|
This forum is generally for non-programming related work and training issues. From the forum description: Talk about work issues, get tips on resume writing or discussion certification programs.
|
|
|
|
|
What does this have to do with work and training issues? You are in the wrong forum.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Suppose I am developing an application for a bank that has about 7 types of customers. Then the class diagram would consist of one customer base class and 7 inherited classes. Each class would be having thier own methods. But when we(in our company) apply this in code we create only a single class file that encapsulate all the functions, properties etc the application needs. That is we are not creating individual classes as it would be depicted in a typical class diagram. I want to know whether this is the right way or not.
If we follow the class diagram then our application should have 8 classes(a base class and 7 derrived class). Then there should be another class that contains some general functions to handle the database, etc.
Please suggest the proper Object Oriented way of implementing such a scenario.
Thankyou
|
|
|
|
|
I would go like that:
As you said a base class and 7 sub classes.
So according to the DB I would build up a class that works for the general one and then some classes for the sub classes.
I think that is a clean solution.
Because if someone has to redesign or change some stuff in your code he would thank you if you keep thinks apart and easy to read into.
What do you think?
Cheers
You have the thought that modern physics just relay on assumptions, that somehow depends on a smile of a cat, which isn’t there.( Albert Einstein)
|
|
|
|
|
i have downloaded a file for installation of sqlserver 2005 management studio. In the properties of that file the type of file is shown as "file". i have seen this type of file first time. when i try to open this file an "open with" dialog box opens and i don't know with which program it will open. plz guide me how to open and install it. remember file type is "file".thx
Mugh@ls
|
|
|
|
|
There is no executable with an extension of "file". Where did you download this things from?? Are you using SQL Server 2005 Express??
|
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
