Try and visit people who have one to see what life with a bird is like. I have had dozens of birds over the years that were rescued from owners who decided they didn't like the mess or the noise or the cleaning of the cage or...
I also try to steer people away from buying animals from the big chain pet stores. Most of their animals are in pitiful condition and I wouldn't trust their health. Small local stores or breeders (obviously) are usually much better for getting good animals.
That said cockatiels are great birds for a first timer. They sing and talk (if you teach them) and love to play. Also because of their size they are not dangerous. Be aware, they will bite. Love bites are no big deal but they could bite because they got scared or something and you need to be aware of it so as to not react badly and injure the bird.
Now I don't want to scare you but it is kind of like getting scratched by a cat. It will happen eventually. Again, because of its size the cockatiel's bite is not that big a deal.
If you want to interact with your bird, make sure and get only one. When there are more than one bird in a cage they tend to not interact with humans as much if at all.
Do not get a Conure. Some of them are extremely noisy and a lot of those become rescues. Have had a few of them. Quakers are nice but they are a bit bigger with a bigger, stronger beak. With kids, a cockatiel is a good first bird.
Last, but not least, before you get a bird get a book on the specific breed and read it. Most birds are in cages too small for them. Most cheap food contains a high percentage of sunflower seeds which are addictive to birds and don't give them much good. Most birds don't have enough toys in their cages. Etc, etc.
Some pretty sound advice here...
I've had numerous birds over the years, including a cockatiel, and currently have a Congo African Gray & a Blue and Gold Macaw.....so here's my $0.02.
First & Foremost... c.cloudwalker is absolutely correct about the chain pet stores. I hate them. You want to find a reputable breeder. Go to any pet store that has birds, and you should be able to find an issue of "Bird Talk" magazine....there is a list of breeders listed by state in the back. Now, just because they are listed there doesn't mean they are great, but it's a good start. You also have the internet at your fingertips.
The reason I emphasize this is that, even though this is a "little" bird, they typically have a lifespan of 12 to 20 years, and 30 years for these little guys is not unheard of....you want to start out with a healthy little guy (or girl) to begin with. You are not just buying a pet, here....you are getting what can be a very loving companion that could potentially be around for a VERY long time.
Buy one that is still hand feeding. This doesn't mean you have to get one that is still feeding every two hours, but you want to get a baby that is still hand feeding once or twice a day. It may sound daunting, but it is actually quite easy to do, and any breeder worth their salt will be
more than willing to show you how...they want their baby to survive!! The reason for this is that hand feeding a bird has a similar effect to feeding a baby, there is a bonding that takes place from the bird to you (and vise-versa

).
Be prepared. I don't care what size bird it is, they are all messy. You could put the food bowl in the center of a 10' cage, they will still find a way to get stuff out on the floor. It's just the way it is, and I quit trying to figure it out.
Birds are very intelligent and
emotional creatures. You need to play with them often, and maintain that level of attention throughout their lifetime. The reason a lot of birds end up in a rescue is from an owner who showered the bird with love the first year or two, and then slowly the novelty, and the attention, tapers off. The bird recognizes this, and becomes very resentful, and this is where most of the biting and attitudes stem from. To add to the emotional side, birds are like us, they have bad days once in a while and can get nippy. Whatever you do...NEVER flick their beak or strike them in ANY way. Birds feed off of positive reinforcement, and if you hurt them for any reason, you may not have a lovable bird for long.
Good luck with your endeavor, and give serious thought about what you are getting into....:thumbup:
Here are some pics of my buddies....