Lynda Sql Server 2008 Essential Training Free Download

1. Essential Training Solutions

The goal of is to provide a place for interesting and informative SQL content and discussions. Filter PostsPostingWhen requesting help or asking questions please prefix your title with the SQL variant/platform you are using within square brackets like so:. MySQL. Oracle. MS SQL. PostgreSQL. etcWhile naturally we should endeavor to work as platform neutrally as possible many questions and answers require tailoring to the feature set of a specific platform.

Help postsIf you are a student or just looking for help on your code please do not just post your questions and expect the community to do all the work for you. We will gladly help where we can as long as you post the work you have already done or show that you have attempted to figure it out on your own. Format Your CodeIf you are including actual code in a post or comment, please attempt to format it in a way that is readable for other users. This will greatly increase your chances of receiving the help you desire. I am very new to SQL so I've decided to give the Lynda.com tutorials a shot. It has me setup pHpmyAdmin in XAMPP adding localhost user 'web', granting all global privileges.

After it has me edit config.inc.php in the pHpmyadmin folder to add.It then has me setup 3 new databases: world, test and album using latin1bin and importing 3 provided SQL fils per each database. It then has me copy their provided SID folder into XAMPP/htdocs. Also the same for CRUD. Afterwards it has me load locahost/SID/SID.php and sumbit a query and I receive an error 'Visual Studio Just-In-Time Debugger' (An unhandled win32 exception occured in apache.exe 960. Just-In-Time debugging this expection failed with the following error: No installed debugger has Just-In-Time debugging enabled. In Visual Studio, Just-In-Time debugging can be eneabled from Tools/Options/Debugging/Just-In-Time.

Essential Training Solutions

Check the documentation index for 'Just-In-Time debugging, errors' for more information.After receving the error both submitting query to SID.php and loading CRUD.php, I reinstalled XAMPP, rolling back to the same version used in the training videos and am still receiving the same error. Can someone help clear this up or point me to somewhere more reputable than Lynda.com please?. I installed windows 7 instead of windows xp, and a newer version of XAMPP and getting an error when loading XAMPP control panel now:'XAMPP Component Status Check Failure 3/Current Directory: c:xamppInstall (er) Directory: c:xamppRun this program only from your XAMPP root directory.' Also receiving:'$cfg'Servers'$i'tracking'. Not OK Documentation Tracking: Disabled'When pHpmyAdmin is run.Would it be any simpler using Microsoft SQL server 2005 or 2008?EDIT: 00:32AM Reinstalled again and receiving Apache HTTP Server has stopped responding. This is after using both root and web users. Strange, I tried to install it and everything went smooth:.

downloaded archive (not installer) and unpacked it on the root of the drive. Web is the user that the tutorial has you make, granting all privlidges and is linked to localhost. Basically an all access offline only account. Its named web because the excersize files were made with web being the mysql user.I am now switching to win 7 x86 after attempting an install in ubuntu but I could not get the mysql to start when launching xampp from terminal. Error log said network not set as localhost or something.Not a big fan of the way ubuntu works since you have to jump through hoops to access root. I just dropped it.Will test on win7 x86 if that doesnt work I will try to find a more bare version of linux than ubuntu. I cant stand the ubuntu gui.

Its too constrained.