Posts Tagged ‘Database’
Q&A: How do I apporach becoming an Oracle Database administrator?
Posted by PuneStuff in Pune Stuff Questions & Answers on December 12th, 2011
Question by Iain K: How do I apporach becoming an Oracle Database administrator?
Hi.
I graduated from Glasgow Uni 3 years ago in June, I graduated as a BSc in Applied mathematics.
Since then I joined a graduate scheme (medium sized organisation), recently I have moved to the IT side of the company, more especially an Oracle implementation. After speaking to the Oracle Project Manager, he commented that there is huge scope and opportunity for Oracle database administrators.
Whilst I consider myself to have some knowledge with Microsoft Access, that is as far as my experience stretches. I really fancy the opportunity to challenge myself by training up as a database administrator. I don’t even know where to start? Can anyone with similar experience recommend where to start, what to learn? Any help would be much appreciated.
Thanks
Best answer:
Answer by The Unit
Try to take some courses from Oracle near your location and also look for a job as Database Administrator and consider that you should get the opportunity to learn so try to learn every day and also always read and research about Oracle if this is what you want to do.
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=3
Add your own answer in the comments!
How can I obtain the software /database clearance that US search and other companies have to locate people?
Posted by PuneStuff in Pune Stuff Questions & Answers on December 11th, 2011
Question by komputerzrkool: How can I obtain the software /database clearance that US search and other companies have to locate people?
Just curious.
Best answer:
Answer by Doctor Deth
they probably use all public sources – they just have to pay for the ones that cost money – not sure any clearance is needed
Know better? Leave your own answer in the comments!
Q&A: Software Testing or Database Admin ?
Posted by PuneStuff in Pune Stuff Questions & Answers on December 11th, 2011
Question by Nicky: Software Testing or Database Admin ?
I am an MCA and have 4 yrs of experience in BPO and KPO (non-voice). I want to switch my career to some technical field. Primarily thinking of Software Testing or Database admin.
Please let me know which one is the best paid and interesting. OR should i continue in the same field (KPO).
[Please dontreply as "depends on ur interest".]. It can make or break my life.
Best answer:
Answer by Mr. X
Database Admin
Give your answer to this question below!
Associates in computer science/certificate in database management?
Posted by PuneStuff in Pune Stuff Questions & Answers on December 11th, 2011
Question by Ben: Associates in computer science/certificate in database management?
Associates in computer science/certificate in database management?
I have an associates degree in computer science and a certificate in database and was wondering if with that it’s possible to land a job in:
A. the USA
B. France(thats where i was born and would like to go back to it if i can land a job with my degree and other skills)
C. Australia.
How hard is it to land your foot in the door? All the jobs i see require like a billion years of experience in whatever fields which seems like i just can’t find a job. Since this would be the first job that im looking for thats related to my field im not looking for a job that pays a billion dollars for a company like microsoft, just one thats pays the bills and will get my experience down.
I just really need some guidance on where to start
Best answer:
Answer by Brett C
In the USA, an Associate’s Degree won’t carry much weight by itself and few managers will really know what a certificate in database management means. You may have trouble getting past the HR department of all but the smallest employers because many jobs will require a Bachelor’s Degree.
The good news is that in IT more than in any other field, we value people for what they know and what they can do much more than what their pedigree is. Your challenge will be to demonstrate what you can actually do. Good DBA’s are very valuable and hard to come by. Whatever you can do to gain some experience working with non-trivial database administration tasks will be helpful so you can try to include that experience in a cover letter and display it PROMINENTLY in your resume.
One possibility might be to get involved in an open source project or two and volunteer to handle the database portion of the project. This could be especially interesting to IT shops that preferentially use open source software. Alternately, you could write your own application. Even if it’s a dumb little app, there’s no limit to the customizable end user preferences and slice-and-dice reporting options you can build which display your DBA skills. At least it’s something tangible that shows you can create something that works.
Another possibility, and one I think would be especially cool, would be to get involved in MySQL. I don’t know if just anyone can contribute to the base product anymore but they do still have Guilds and a support community. What if you could say on your resume that you are on the Top 100 MySQL support experts in the world? I have one of the top 3 contributors to one of EMC’s storage products working in my storage team. Do you think I’m going to let him get away anytime soon? No Way! All you need to do is invest your time and energy.
Remember, from an employer’s perspective a hiring mistake is huge because a bad employee is a giant pain to deal with and it’s expensive to replace him/her. The more you can do to demonstrate actual skills and experience, the less of a risk you are. Heck, if you have some time and money, consider contacting 20 companies in your area and offering to do a free 3 month project for them. 19 will turn you down but you only need one… Read Seth Godin’s blog for more on this internship approach.
Add your own answer in the comments!
How much bandwidth does transactional database replication consume?
Posted by PuneStuff in Pune Stuff Questions & Answers on December 10th, 2011
Question by nickelRev: How much bandwidth does transactional database replication consume?
My company uses a really bad POS system with about 150 clients. The POS software is garbage. Each of the cash registers has a SQL Server on it, and each connects to the central database server. The clients check for replication about once every 5 minutes. They are constantly replicating day and night, and on top of this each one has a service on it that pings the database server continuously. (When pinging stops the server assumes a problem.)
If all of this is done on a 100 Mb infrastructure, is all this activity going to saturate the line to the server? (These things are all continuously 24/7/365 replicating and pinging.)
Best answer:
Answer by gopatriots!!
probably around 2 billion zillion
Give your answer to this question below!
Posting data from a MySQL database into a form with PHP?
Posted by PuneStuff in Pune Stuff Questions & Answers on December 9th, 2011
Question by Pure Kenergy: Posting data from a MySQL database into a form with PHP?
I am working on a client’s website that has forms for their customers. I have a login section already created, and a MySQL database will store all the client information. The login is set up to automatically redirect the user to a certain page based on their login, so in this case it will only show their forms. What I want to do is have their data such as business name, name, address, phone, etc. auto-fill into the appropriate fields so all they have to do is enter what they are writing about. Sort of to give the feel of it being customized just for the client. So when they open a form all the information about them is already in the fields (i.e. the business name field will already have their company’s name in the field). Then when they enter what they are writing about they hit submit and it goes through email (which is also already done).
Can someone direct me or tell me how you code with PHP to pull records from the MySQL database from just the specific client’s information to fill in the form fields I want filled in with the appropriate info? I see all kinds of web pages related to posting data to MySQL from a form, which I know how to do. The retrieval is what I am having issue with.
Any help would be greatly appreciated, and best answer will get 10+ points. If you need further clarification on what exactly I’m trying to do let me know.
Best answer:
Answer by Andrew A
pretty extensive question, i would recommend bookmarking phpbuilders.com their forums is where I taught myself php from scratch.
first you have to call up the mysql db:
$ link = mysql_connect (“server address”, ‘username’, ‘password’) or die (“Could not connect”);
}
mysql_select_db(‘database name’);
then you get your record:
$ result = mysql_query(“select * from tablename WHERE unique_id=’whatever’”);
$ row = mysql_fetch_object($ result);
then in your form you just put the value into it:
Name: