Announcement: TiggTV Episode #1

[TJ_Tigger]

I have been toying with the idea of launching an educational series on coding within AMS. The aim is to cover a lot of the topics that are asked in these forums and help out our fellow forum members. I don't know how long each show will be or if I will be able to release a new show every week, but I figure I will give it a shot.

So without further delay, I would like to announce the release of TiggTV Episode 1. These first few episodes will be centered around a particular project idea. I was helping a friend with some coding in the project and figured it might be a good place to start. There are a lot of common coding practices demonstrated in this episode.

At this time I don't know if I will release this show in any other format other than the Flash episode that I will post below. If the demand is there for another format I will give it some thought. I also cannot guarantee that I will have more than one episode available at a time, this is mainly due to storage space and the cost of bandwidth.

So here it is:

TiggTV Episode #1 (http://s94928149.onlinehome.us/pub/TiggTV/TiggTV.html)
Objectives
- Enable the SQLite plugin
- Add Objects to the page to provide a project flow
- Create an SQLite Database
- Add a table to the Database
- Create a function to read the Database and populates a listbox
- Create a function that addes entries to the Database


I highly recommend that you watch the trainig videos provided by IndigoRose as they cover a lot of the basics that may not be covered in this series. I would also like to request that if you have ideas of a topic you would like to have covered please post them here and I will see what I can do.

Tigg

Disclaimer: I am not a professional coder nor am I a professional voice over artist. :D But I do enjoy coding and working with AMS and have a wee bit of experience in education and adult learning practices.

[sue]

What a great idea, TJ!!!! Thank so much for offering it!!!

My request is a tutorial about the Datagrid plugin.

Keep up the good work!!

Sue

[Friethoe]

Tigg........ This is awesome!!! You rock!!!
Great, realy great :yes :yes

Can't wait to see the next episode. I hope same time, same channel :lol

Great idea and very nice to watch and to listen to, very easy to understand!

My compliments :yes

Thanks a lot

Eric

[Intrigued]

TJ, looking good! Surely this will help others to better understand SQLite. Corey has some competition now. ;)

I would suggest posting the project too with a copy of the project's code from your Code Viewer application.

[TJ_Tigger]

Corey has some competition now. ;)

I would suggest posting the project too with a copy of the project's code from your Code Viewer application.

I meant to upload the project and put the objectives on the page as well. I have uploaded the html file again and added my fantastic Orange to the background :D . Tell me if the Orange is too much.

Don't want to compete with Corey in creating this stuff and hopefully IR doesn't mind my posting these videos.

Tigg

[bule]

Nice show and a great idea!

BTW, What capturing software and codec do you use TJ?

[srussell]

Nicely done! I just wanted to check it out for a minute and ended watching the entire episode... Can't wait for the next one! :yes

And same question as bule... What software did you use for the screen capture and audio?

[stickck]

Great Video Tigg! I use a program called ScreenFlash to do the same thing. i never thought about adding the videos to a web page though. I think I might make up some simple videos for work to help our users set up thier email account, mapped drives and some other stuff that they usually come to me to get help with. Thanks Tigg! Great Idea! My only problem is that i dont know any HTML.

i guess its time to learn.

Chris

[holtgrewe]

Amazing...Thanks so much.

[TJ_Tigger]

Thanks guys. I used CamStudio to capture and piece together the clips and such.

Tigg

[Intrigued]

TJ seems to use what I use. Techsmith's (Camtasia Studio) product? I just bought the latest version myself. I have been using them for years, great company, products. They have three default skins now for the video controls/frame.

:yes

TJ, that sounds a lot like a Podcast if I ever heard one. I hope to see you posting that to iTunes soon!

;)

[TJ_Tigger]

TJ, that sounds a lot like a Podcast if I ever heard one. I hope to see you posting that to iTunes soon!


Yeah kind of does doesn't it. I hope to keep going with it. It was fun to put together. One of the projects I was thinking of building on the show is an RSS tool. Help learn XML and how to parse such a file. Then that could be used to download and play the video rather than watching in on the web.

But like I alluded to earlier, the episodes may not come out on a regular basis, all depends on time and such.

Tigg

[TJ_Tigger]

If you guys have questions or suggestions for shows you can send those to

TiggTV at gmail dot com

Tigg

[Bruce]

TIGG! :yes Thx so much buddy. ;)

[habbaz]

;) :yes :yes :yes
mais
how made as a master key of a page another with an effect of page has

[Intrigued]

Yes, it's like me and amsuser.com. I would like to be able to update such and add the other dozens of project and support files I have to that domain. But, I'm busy building a business and I have only made time of late to post small code snippets or posts like this.

The RSS Aggragator via AMS is something surely that would be a fun project and that would make for a good Tig TV series.

[Ted Sullivan]

FANTASTIC STUFF!!!

I for one can't wait for the next episode!

[Adam]

Very well done TJ. :yes

Note to self: go to "MyBank" and withdraw money from TJ-Tigger account with the pass word 12345. I'm gonna be rich!

Adam.

[yosik]

Great job Tigg.
Well explained, with prepared-in-advance code...very professional.
I think you would need a "prequel" to this episode with some explainations as to how to work with SQL statements.
Kudos

Yossi

[TJ_Tigger]

Very well done TJ. :yes

Note to self: go to "MyBank" and withdraw money from TJ-Tigger account with the pass word 12345. I'm gonna be rich!

Adam.

uh . . . Let me see you start with zero and take from that zero and that leaves you with . . . uh zero.

:)

Thanks Adam

Tigg

[TJ_Tigger]

Great job Tigg.
Well explained, with prepared-in-advance code...very professional.
I think you would need a "prequel" to this episode with some explainations as to how to work with SQL statements.
Kudos

Yossi

Thanks Yossi,

I figured the prepared-in-advance coding would help with the flow of the tutorial. I could talk about the code without having to be typing the code at the same time.

Do you think it needs more of an explaination on the SQL statements themselves? Something that tries to show the relationship between SQL statement and the actual database itself?

I am also trying to be time conscience. I don't want to have very long episodes. This went beyond my original goal of time (12-15 mins) as has the next one (which can still be redone).

How is the time? Too long? Just right?

What if I concentrate on just one function next time and spend more time on the SQL commands?

Let me know
Tigg

[Dez]

Really nice job Tigg.
Not too long at all, very informative.
Looking forward to more episodes.

Dez

[Tek]

Well done Tigg! Looking forward to seeing more from you in the future. :yes :yes

[yosik]

Tigg,
Timewise, 12 to 15 minutes is good (anyway, at 10 frames per second and 16,000 maximum frames allowed for a flash movie, you are limited to 1600 seconds, or 26-27 minutes).
I would definitely explain relationship with SQL statements. As a given, whenever you are mentionning an external issue, it should be either explained or referred to in another tutorial. A third alternative is not to develop the issue at all if you are 100% sure that your audience is familiar with it.

One thing I cam across in many tuts is the fact that the trainer, knowing his subject , makes the mistake of progressing along the lesson without really explaining why he does it that way.
Saying: " Let's write the action Label.SetText" without adding "in order to set the text of the label to..." is a mistake. I know it is a simplistic example but you know what I mean. Don't forget that although YOU know your subject, the viewer doesn't.

Anyway, let me say again that it is VERY WELL DONE!!

Yossi

[Derek]

I think this is a great idea Tigg. Well done you! :yes :yes

I think it would be good idea to include the swf file in the download so people can refer to it in time. That gives you more freedom with removing them from the server too.

[Mark]

Hey TJ_Tigger,

That is some great stuff! Thanks for putting this stuff up, I'm sure this will help many of our users. Keep up the good work!

[el5ateer]

Hey mate .. You r da best :yes .. Any idea of zipping the SWF file and make downloading as an option ?? as the internet connection is killin me here ;)

[bule]

Try pressing stop or pause button and wait until the swf is entirey buffered.

[TJ_Tigger]

Hey mate .. You r da best :yes .. Any idea of zipping the SWF file and make downloading as an option ?? as the internet connection is killin me here ;)

I have thought about this but bandwidth is of a concern. I don't want to run out due to downloads before the end of the month. I will look into this and see if I can come up with a good way to share the files.

Tigg