My Quick Start is Broken-From Stratch To Involved

I cannot install the template and set up as described in the documentation. I tried quick start first and there was database probs with script, and now I can't figure out the install, and it looks like crap, it's puched...
can you please help!

The joomla sql file was not built correctly and thus would not install, even with recommended hostgator. so to fix....here is the scenario

When first running through the install script this error occurred.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `wa89g_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default ! NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`

Essentially the issue that was occurring was with this line right here.
'TYPE=MyISAM CHARACTER SET `utf8`
What it should have read was
'ENGINE=MyISAM CHARACTER SET `utf8`

After that was changed in the joomla.sql file everything worked fine and the install was completed.

I already answered in other thread, windows version of mySQL hostgator user does not recognize TYPE=MyISAM , you have to modify installation scripts in /installation folder

TYPE=MyISAM
replace with
ENGINE=MyISAM