Professional Web Applications Themes

Recommendations For A Good Start - Microsoft SQL / MS SQL Server

If you just want an introduction to writing SQL statements without buying anything, design your access queries and then look at the SQL code that is created. You can go from query design view in access to SQL view -- just click the SQL button. >-----Original Message----- >I have been using access quite frequently now for about a >year and have stayed away from SQL, but now I want to gain >some knowledge and start working with SQL. Does anyone >have a recommendation for a good starting book and >software that is not too expensive that would point me in ...

  1. #1

    Default Recommendations For A Good Start

    If you just want an introduction to writing SQL statements
    without buying anything, design your access queries and
    then look at the SQL code that is created. You can go
    from query design view in access to SQL view -- just click
    the SQL button.
    >-----Original Message-----
    >I have been using access quite frequently now for about a
    >year and have stayed away from SQL, but now I want to
    gain
    >some knowledge and start working with SQL. Does anyone
    >have a recommendation for a good starting book and
    >software that is not too expensive that would point me in
    >the right direction.
    >
    >Thanks
    >Scott
    >.
    >
    Andrea Worley Guest

  2. #2

    Default Re: Recommendations For A Good Start

    Get the "Database Design for Mere Mortals" and "SQL Queries for Mere
    Mortals" books by Micheal Hernandez.

    You can download the SQL Server Evaluation Edition from the Microsoft
    website, but you need a Windows Server Operating System to run it (no
    Windows 9x, Me, XP etc).

    And as pointed out in the other post, Access use SQL as well (although it
    has quite a different dialect from standard SQL)

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Scott" <scsteinprodigy.com> wrote in message
    news:87b701c34556$d4964df0$a401280aphx.gbl...
    > I have been using access quite frequently now for about a
    > year and have stayed away from SQL, but now I want to gain
    > some knowledge and start working with SQL. Does anyone
    > have a recommendation for a good starting book and
    > software that is not too expensive that would point me in
    > the right direction.
    >
    > Thanks
    > Scott

    Jacco Schalkwijk Guest

  3. #3

    Default Re: Recommendations For A Good Start

    "Scott" <scsteinprodigy.com> wrote in message
    news:87b701c34556$d4964df0$a401280aphx.gbl...
    > I have been using access quite frequently now for about a
    > year and have stayed away from SQL, but now I want to gain
    > some knowledge and start working with SQL. Does anyone
    > have a recommendation for a good starting book and
    > software that is not too expensive that would point me in
    > the right direction.
    >
    Lay hands on SQLServer and create a Active Data Project in Access.

    This will let you get started with SQLServer in a familiar environment.

    David


    David Browne Guest

  4. #4

    Default Re: Recommendations For A Good Start

    Scott,
    Like you, I found the need to start learning SQL for work.

    I purchased 2 books, that have been pretty solid in getting me up to speed. Both are by Wrox Press,
    and the book by Rob Viera has been quoted as the 'de facto' standard for many, as a reference book.

    Here are the two books, available on Amazon.com:

    [url]http://www.amazon.com/exec/obidos/ASIN/1861005237/qid%3D1057757102/sr%3D11-1/ref%3Dsr%5F11%5F1/104-6902458-6729559[/url]

    MAIN BOOK I RECOMMEND
    [url]http://www.amazon.com/exec/obidos/ASIN/1861004486/qid%3D1057757156/sr%3D11-1/ref%3Dsr%5F11%5F1/104-6902458-6729559[/url]

    RMH


    "Scott" <scsteinprodigy.com> wrote in message news:87b701c34556$d4964df0$a401280aphx.gbl...
    > I have been using access quite frequently now for about a
    > year and have stayed away from SQL, but now I want to gain
    > some knowledge and start working with SQL. Does anyone
    > have a recommendation for a good starting book and
    > software that is not too expensive that would point me in
    > the right direction.
    >
    > Thanks
    > Scott

    RMH Guest

Similar Threads

  1. Not a good start with MX 2004
    By RES in forum Macromedia Director Basics
    Replies: 0
    Last Post: February 12th, 09:32 PM
  2. Good resource/book to get start with DB2?
    By elaine in forum IBM DB2
    Replies: 7
    Last Post: September 18th, 11:27 AM
  3. OT: Any recommendations for a good Free Counter(s) w/ stats
    By Beatleman webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 16th, 01:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139