Learning SQL

[Charles Hoens]

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

[glenschild]

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

[mikeallenbrown]

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.

[Pat Bremkamp]

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.

[kkfin]

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

[iRadiate]

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

[CharlesParker]

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.

[Ted Giles]

Charlie, Alpha has a SQL builder, so you can try creating your code in something you are familiar with.

[DoronF]

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

[MoGrace]

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

[DoronF]

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