I want to teach myself SQL. I have windows xp home version. Do I need to download the software to practice or is there another alternative. Also can you create a database in MS Access and then change it into SQL? Lastly, how does Visual basic work with SQL? Is there a way to create a database in Visual basic 6 and then change programing into SQL?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Self training 4
- Thread starter leslie37
- Start date
-
2
- #2
I would recommend trying these two online SQL tutorials for starters:
It is a very informative and concise two part interactive tutorial.
Not real sure about Access to SQL database transitioning. I found Access to be so limiting and quirky that I simply abandoned it and began designing everything in SQL Server 2000 (presuming that's what you'd be using). Database contruction is relatively easy using SQL Server's query analyzer and even moreso using Enterprise Manager (all part of the package).
I don't use Visual Basic a lot myself, but I know several people far more knowledgeable than I who do so frequently in SQL, therefore I surmise that SQL is pretty friendly to the prospect.
Good luck,
carrr
It is a very informative and concise two part interactive tutorial.
Not real sure about Access to SQL database transitioning. I found Access to be so limiting and quirky that I simply abandoned it and began designing everything in SQL Server 2000 (presuming that's what you'd be using). Database contruction is relatively easy using SQL Server's query analyzer and even moreso using Enterprise Manager (all part of the package).
I don't use Visual Basic a lot myself, but I know several people far more knowledgeable than I who do so frequently in SQL, therefore I surmise that SQL is pretty friendly to the prospect.
Good luck,
carrr
Access is tranferable to SQL Server, however depending on the database, it can be a little troublesome.
VB Works as a user interface to SQL Server. This allows you to have the the database but people using the program don't need to know how something works to use it too.
As far as creating the DB from VB, not recommended. It is best to do both separately. I use VB alot and the first step is creating the DB then designing the screens in VB to match what is needed.
Billy
VB Works as a user interface to SQL Server. This allows you to have the the database but people using the program don't need to know how something works to use it too.
As far as creating the DB from VB, not recommended. It is best to do both separately. I use VB alot and the first step is creating the DB then designing the screens in VB to match what is needed.
Billy
-
1
- #4
-
1
- #5
tlbroadbent
MIS
Check the following link for information about migrating from Access to SQL Server.
Look at faq183-694 for more training and tutorial resources. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Look at faq183-694 for more training and tutorial resources. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
You may also take a look at SQLPorter, something we used to migrate from Access to SQL Server.
You can do a google search to find it or
either one
You can do a google search to find it or
either one
- Status
Similar threads
- Locked
- Question