Advice Needed / DBA

Database
Teradata Employee

Advice Needed / DBA

Hello All,

 

I am new to Teradata Databases Adminstration, i took the course but didn't got certified yet.

Right now i am working on improving my SQL skills, almost finishing it.

I am wondering if there's any way to practice the adminstration on a Teradata Database, Dump databases maybe with requirements to be done by an Admin, Real Life scenarios, .... etc,

I am new to the field and i am hoping to get more knowledge about performing a real life Database Adminstrator tasks.

Thanks in advance,


Accepted Solutions
Teradata Employee

Re: Advice Needed / DBA

I agree with Dave, Teradata Express is a good starting point. If you have the option, choose a version that includes viewpoint, as this gives you additional experience in tasks performed by a Teradata DBA.

You can find Teradata express here

 

http://downloads.teradata.com/download/database/teradata-express-for-vmware-player

 

There may also be some YouTube videos from Tom Coffing that you could watch

1 ACCEPTED SOLUTION
3 REPLIES
Senior Apprentice

Re: Advice Needed / DBA

Hi,

 

Brushing up SQL is always useful. I'd also recommend downloading a copy of 'Teradata Express' (free) and getting that up and running - usually really simple to do.

 

This gives you a TD environment where you can test things out as much as you like and it doesn't matter if you completely break the system. You just reinstall it.

 

It can sometimes be hard to work out what to test out, maybe you could look at the sample questions that TD provide and try and answer them. Maybe do the 'dba task' behind those.

 

Another way to approach this might be to look at task/subject areas:

- databases and tables: create them, populate, look at disk space requirements and usage

- users: create, change definitions directly for the user or via profiles

- security: look at access rights and roles

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: Advice Needed / DBA

I agree with Dave, Teradata Express is a good starting point. If you have the option, choose a version that includes viewpoint, as this gives you additional experience in tasks performed by a Teradata DBA.

You can find Teradata express here

 

http://downloads.teradata.com/download/database/teradata-express-for-vmware-player

 

There may also be some YouTube videos from Tom Coffing that you could watch

Teradata Employee

Re: Advice Needed / DBA

Hello All,

 

Thank you for your advices, i will do it :)