Home › Forums › MS SQL Server

BCCC Intro to SQL Spring 2012

This is the place to get all the files related to this course, and to post any questions you may have while working on the material. A full reference of T-SQL constructs and commands can be found at http://msdn.microsoft.com/en-us/library/ms189826%28SQL.90%29.aspx. If you are interested in installing a copy of SQL Server at home for educational use, you can download SQL Server 2005: Express Edition free of charge at http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx. SQL Server 2008 R2 Express can be found at http://www.microsoft.com/sqlserver/en/us/editions/express.aspx.

AttachmentSize
SQLSyllabus -Spring 2012.pdf64.86 KB
sql01.ppt113 KB
sql02.ppt136 KB
sql06.ppt106 KB
Library_Init_sql.txt2.39 KB
Euphoria integration example ›
Wed, 02/29/2012 - 17:57 — m_sabal

Links for class 11

SQL Server Business Intelligence Development Studio
includes Integration Services, Reporting Services, and Analysis Services.

http://msdn.microsoft.com/en-us/library/ms173767.aspx (BIDS)
http://msdn.microsoft.com/en-us/library/ms159106.aspx (SSRS)
http://msdn.microsoft.com/en-us/library/ms167305.aspx (SSRS Tutorial)
http://msdn.microsoft.com/en-us/library/ms174181.aspx (SSIS)
http://msdn.microsoft.com/en-us/library/ms173709.aspx (SSAS)

Wed, 06/22/2011 - 15:03 — scott1278

SQL Server Express download

I was able to download SQL Server 2008 Express from the MS website using Firefox instead of IE. Of course, I had to wait about five minutes while the system hung at 99% downloaded but eventually it all came through to my PC. The appl installed without problem. I also downloaded the Adventure database for SQL Server 2008. It came as a self extracting executable so I didn't have to place the .mdf file by hand. All the work Michael did in class can be done at home. SQL Server Express is a great learning tool. We'll all be certified in no time.

Tue, 06/21/2011 - 17:36 — m_sabal

SQL Server Express 2008

This is a better link. Apparently the main page is just to get your contact information.
http://www.microsoft.com/download/en/details.aspx?id=12847
You should get SQLEXPWT_x86_ENU, a 327MB file. This is the only version of Express Edition that contains the management studio.

Here is the link for the 2008 version of the AdventureWorks sample database:
http://msftdbprodsamples.codeplex.com/releases/view/37109#DownloadId=106391

It's a ZIP file, so you'll have to extract the database files, then attach them in SQL Server Management Studio (right-click on databases, choose Attach, and browse to the folder where you're keeping the files).