SQL - Complex queries, Stored procedures, Views, Functions, Triggers

Question

Hi All,

I’m trying to develop my SQL skills and need help with the following topics:

Complex queries
Stored procedures
Views
Functions
Triggers
Performance Tuning

All help is appreciated.

Thanks in advance.

Gee

Answer 1

@Janning: Thanks for your quick response. I need the mostly used concepts within each category. i want to have a thorough understanding of them.

Answer 2

I’ll do just that. Thanks for suggesting.

Answer 3

Kind of a mixed bag you have there. Can you be a bit more specific about which concepts within each category are tripping you up? Might be best to have separate questions so we can consider each in turn (give each proper attention) as well.

For what it's worth:

https://community.modeanalytics.com/sql/

Some of your topics will be in the Intermediate section and some will be in the Advanced section.

Answer 4

I'm not sure there are statistics available to determine which are the "mostly used concepts within each category," but I would be glad to be proven wrong. 😊

Answer 5

what would be your suggestion in terms of focus?

Answer 6

That depends. I don't really know what you already know and I don't know what kind of project you are working on.

Answer 7

It’s a personal project where i’m using the AdventureWorks 2017 databases and data warehouse

Answer 8

I can't say I know much about that. It doesn't seem to be maintained anymore, according to this article:

https://blogs.msdn.microsoft.com/samlester/2016/06/13/so-long-adventureworks-well-miss-you-and-hello-world-wide-importers/

😔

Answer 9

It’s definitely being maintained. It’s on my system.

Answer 10

Not sure that's what the article meant.

Answer 11

i’ll send you something later

Answer 12

thanks for coming back quickly. Truly appreciated. Just trying to gain knowledge.

Answer 13

@Janning: hope you’re well? i’ve been advised to look at windows functions in SQL. Do you have any experience with that?

Answer 14

SoloLearn seems to like MySQL. I don't work as much on databases anymore / these days, but I prefer PostgreSQL. If you have a specific question about SQL Server or something related, maybe introduce it as a separate thread. You'd probably get someone with more up to date experience to help you out. 🙂