Advise on my Next Project

Solidad · 09-28-2008, 09:38 PM

Well i was planning on moving from VB6 to VB.Net. and i am thinking of making a program that will let me manage my DVD archive.

anyway what since i will be doing my program design in the near future for my undergrad degree this will serve as my training.

i want to learn managing Databases, should i go with SQL or learn MySQL? of course it is good to learn both but, w/c one is easier to learn first?

any site that is easy to understand tutorials for this?

**dm01** · 09-28-2008, 10:49 PM

MySQL is an SQL server. Did you mean Microsoft SQL Server? SQL is not a database system. SQL is Server Query Language, the language in which commands to the server databases are constructed.

http://www.tizag.com/mysqlTutorial/
http://www.functionx.com/sqlserver/

MySQL is free open-source software. You can get a Windows binary (executable) here: http://dev.mysql.com/downloads/.
Microsoft SQL Server 2008 is more pricey. You can get a free crippled SQL Server [Express Edition] here: http://www.microsoft.com/express/sql/default.aspx .

For learning SQL: http://www.w3schools.com/sql/default.asp

Solidad · 09-29-2008, 03:42 AM

Yup i when i usually say SQL its the Microsoft database.

do these database can store images?

recommendations for a tutorial website for VB.net from scratch?

**dm01** · 09-29-2008, 09:44 AM

Yes, you can. http://www.phpriot.com/articles/images-in-mysql explains the different ways this can be done, and which one is best.

Solidad · 09-29-2008, 07:59 PM

Nice that could come in handy. but its primary used in PHP i need a VB.net example. anyway that will come later. thanks.

09-28-2008, 09:38 PM	#1 (permalink)
Solidad Registered User Join Date: Aug 2008 Location: Philippines Posts: 45 OS: WinXP Pro sp3	Advise on my Next Project Well i was planning on moving from VB6 to VB.Net. and i am thinking of making a program that will let me manage my DVD archive. anyway what since i will be doing my program design in the near future for my undergrad degree this will serve as my training. i want to learn managing Databases, should i go with SQL or learn MySQL? of course it is good to learn both but, w/c one is easier to learn first? any site that is easy to understand tutorials for this?

09-28-2008, 10:49 PM	#2 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,446 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Advise on my Next Project MySQL is an SQL server. Did you mean Microsoft SQL Server? SQL is not a database system. SQL is Server Query Language, the language in which commands to the server databases are constructed. http://www.tizag.com/mysqlTutorial/ http://www.functionx.com/sqlserver/ MySQL is free open-source software. You can get a Windows binary (executable) here: http://dev.mysql.com/downloads/. Microsoft SQL Server 2008 is more pricey. You can get a free crippled SQL Server [Express Edition] here: http://www.microsoft.com/express/sql/default.aspx . For learning SQL: http://www.w3schools.com/sql/default.asp __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

09-29-2008, 03:42 AM	#3 (permalink)
Solidad Registered User Join Date: Aug 2008 Location: Philippines Posts: 45 OS: WinXP Pro sp3	Re: Advise on my Next Project Yup i when i usually say SQL its the Microsoft database. do these database can store images? recommendations for a tutorial website for VB.net from scratch?

09-29-2008, 09:44 AM	#4 (permalink)
dm01 Moderator: Design Join Date: Oct 2006 Location: Richmond, B.C.; Canada Posts: 1,446 OS: Windows XP [Version 5.1.2600] SP3 \| Ubuntu Jaunty Jackalope \| Windows 7 BETA My System	Re: Advise on my Next Project Yes, you can. http://www.phpriot.com/articles/images-in-mysql explains the different ways this can be done, and which one is best. __________________ Validate your Markup Validate your CSS Notepad++ Please use [html], [php], and [code] when posting code or markup. I do not help by Private Message or e-mail. If for some reason I have over-looked a reply to a thread that I have previously replied to, then send me a message.

09-29-2008, 07:59 PM	#5 (permalink)
Solidad Registered User Join Date: Aug 2008 Location: Philippines Posts: 45 OS: WinXP Pro sp3	Re: Advise on my Next Project Nice that could come in handy. but its primary used in PHP i need a VB.net example. anyway that will come later. thanks.