Self Training- Book Recommendations for SQL/VB

Posted on 2006-05-04
Last Modified: 2008-03-06

i started a job where a database needed building and between me and my collegue we achived that with a sql server back end and access front end.

Although i understand what im doing, with no formal training (only over the shoulder type) i have big gaps in my knowledge of the fundamentals.  problem is my collegue is now big deal as it's already set up but i need to be able to expand my knowlegde....

as it will be a busy time of year i cant go on a training course so am wondering if there are any good books i can use to learn the fundamentals of sql and access vb....

i have sams teach yourself sql in 21 days which is pretty good but i'd like something that was based on sql server rather than oracle....i also have visual basic in eays steps which doesn't tell me much really...has loads of examples but no explanations of theory.

so i'd appreciate any book recommendations- books about sql or vb which are the standard industry reference.  there are a lot out there and i wanna make sure i get the most suitable.

Question by:Dubs
    LVL 4

    Accepted Solution

    Try this, its really worth buying.

    Visual Basic Database Programming, with CDROM SBN: 0201721937 by Michael Kofler
    The expert guide to better database application development with Visual Basic.-- In-depth coverage of ADO, including a compact reference,Includes detailed coverage of SQL Server and Microsoft Data Engine (MSDE),undocumented problems, presents workarounds, and describes optimizations based on how VB and SQL Server 7 really work together.
    LVL 44

    Assisted Solution

    which version of VB are you using ? VB6, VB.NET 2003, VB.Net 2005?

    You might want to look into the following books, by Rocky Lhotka:

    Visual Basic 6 Business Objects
    Rockford Lhotka
    APress Books
    ISBN: 186100107X

    Expert One-To-One
    Visual Basic .NET Business Objects
    Rockford Lhotka
    APress Books
    ISBN: 1590591453

    depending on which verion of VB you have.



    Author Comment

    im on vb 6.


    LVL 3

    Assisted Solution

    Try Visual Basic 6 Developer's Handbook by Petroutsos and Hough from Sybex.  I use it to death...has lots of SQL-Server info.


    Author Comment

    nice one, points split based on number of books offered- dunno how else handle it as i will look into all of them- so you are all right in a way


    LVL 3

    Expert Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Introduction After workin in a plethora of programming languages like C, Pro*C, ESQL/C, C++, VC++, VB, Java, HTML,JavaScipt etc, technologies and frameworks like JSP, Servlets, Struts, Spring, IBatis etc and databases like MS Access, SQLServer, Inf…
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now