Alpha Video Training
Results 1 to 11 of 11

Thread: Learning SQL

  1. #1
    "Certified" Alphaholic Charles Hoens's Avatar
    Real Name
    Charles Hoens
    Join Date
    Sep 2000
    Location
    Princeton, NJ
    Posts
    1,170

    Default Learning SQL

    Hi everyone!

    I am a longtime dBaser and up until recently saw no reason to change. However, now I see more and more of SQL being used.


    Simply put, can anyone point me in the direction of some basic SQL knowledge, especially as to how it relates to Alpha?


    Thanks,


    Charlie

  2. #2
    "Certified" Alphaholic glenschild's Avatar
    Real Name
    Glen Schild
    Join Date
    Apr 2000
    Location
    Frome, Somerset, UK
    Posts
    1,514

    Default Re: Learning SQL

    Hi Charlie

    Welcome to the dark side :-)

    I would recommend https://www.w3schools.com/sql/sql_intro.asp as a good place to start.

    Glen
    Glen Schild



    My Blog


  3. #3
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,844

    Default Re: Learning SQL

    What Glen said. I'd also recommend a simple google search.

    "how to get duplicate rows in sql"

    Google that and the first result is a stackoverflow forum post. Stackoverflow is a great source on information all things programming.
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

  4. #4
    VAR Pat Bremkamp's Avatar
    Real Name
    Pat Bremkamp
    Join Date
    Apr 2000
    Location
    Oregon, USA
    Posts
    2,625

    Default Re: Learning SQL

    If you plan to go with MySQL or Mariadb, then the book MySQL by Paul DuBois is a great reference. After all this time, I still use it every week.
    Pat Bremkamp
    MindKicks Consulting

  5. #5
    "Certified" Alphaholic kkfin's Avatar
    Real Name
    Kenneth
    Join Date
    Dec 2006
    Location
    EU
    Posts
    1,543

    Default Re: Learning SQL

    Here is a good video to start from basics. It is little old but nothing has really changed.

  6. #6
    "Certified" Alphaholic iRadiate's Avatar
    Real Name
    Stephen
    Join Date
    Jan 2011
    Location
    London, ON
    Posts
    1,642

    Default Re: Learning SQL

    I'm a big fan of Rick Morelan's Joes2Pros series of SQL training videos.

    https://www.youtube.com/user/Joes2Pros/playlists


    The Microsoft Virtual Academy courses are also excellent. They are free and if you create an account you get a certificate on completion of each course.

    https://mva.microsoft.com/product-tr...ver#!lang=1033
    Last edited by iRadiate; 09-03-2018 at 10:24 AM.
    Alpha Anywhere v12.4.6.1.2 Build 6012-5338 IIS v8.5 on Windows Server 2012 in Hyper-V

  7. #7
    "Certified" Alphaholic CharlesParker's Avatar
    Real Name
    Charles Parker
    Join Date
    Dec 2012
    Location
    New Orleans, LA
    Posts
    2,115

    Default Re: Learning SQL

    Good one Ken! btw the 4th edition of that guys book is easily found online as PDF for free for those of you who enjoy reading.
    NWCOPRO: Nuisance Wildlife Control Software My Application: http://www.nwcopro.com "Without forgetting, we would have no memory at all...now what was I saying?"

  8. #8
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,355

    Default Re: Learning SQL

    Charlie, Alpha has a SQL builder, so you can try creating your code in something you are familiar with.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  9. #9
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    174

    Post Re: Learning SQL

    Hi Charles,

    Check this ms sql books on line here:
    https://docs.microsoft.com/en-us/sql...ql-server-2014

    Regards,

    Doron
    The Farber Consulting Group, Inc.

    Main Web Site: https://www.dFarber.com
    Alpha Five Development
    Reverse Database Engineering and Database Design

  10. #10
    "Certified" Alphaholic MoGrace's Avatar
    Real Name
    Robin
    Join Date
    Mar 2006
    Location
    Los Angeles
    Posts
    3,662

    Default Re: Learning SQL

    Quote Originally Posted by iRadiate View Post
    I'm a big fan of Rick Morelan's Joes2Pros series of SQL training videos.

    https://www.youtube.com/user/Joes2Pros/playlists


    The Microsoft Virtual Academy courses are also excellent. They are free and if you create an account you get a certificate on completion of each course.

    https://mva.microsoft.com/product-tr...ver#!lang=1033
    MS Website has a note that the Virtual Academy is being retired as of today
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

  11. #11
    Member
    Real Name
    Doron
    Join Date
    Dec 2011
    Location
    NJ, USA
    Posts
    174

    Post How to send emails from ms sql database and Alpha AnyWhere

    Hi Madtowng,


    You will need to have a UX component that will call the SP as mentioned below. You can have a list of users in a list View component. Send their names and emails as parameters to the SP. You can choose multiple users or just highlight one row and click the button.

    Check this link for MS SP:
    How to send emails from ms sql database.

    OR

    Check the help file for Alpha AnyWhere here: Send an e-mail message

    Regards,

    Doron
    The Farber Consulting Group, Inc.

    Main Web Site: http://www.dFarber.com
    Alpha AnyWhere Development
    Last edited by DoronF; 01-31-2019 at 05:03 PM.

Similar Threads

  1. Learning XBasic
    By Andy Dibble in forum Alpha Five Version 5
    Replies: 4
    Last Post: 08-07-2004, 02:57 PM
  2. Learning X basic
    By Dr Alok Modi MD in forum Alpha Five Version 5
    Replies: 16
    Last Post: 04-23-2004, 07:44 PM
  3. Learning center
    By Ed Barley in forum Alpha Five Version 5
    Replies: 3
    Last Post: 02-18-2004, 07:11 PM
  4. Just learning
    By tony cox in forum Alpha Five Version 4
    Replies: 1
    Last Post: 03-05-2003, 02:42 AM
  5. Learning Xbasic
    By Edward F. Schulz in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-29-2002, 06:58 PM

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
  •