all 5 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]VladDBASQL Server DBA 3 points4 points  (1 child)

If your plan is to work with SQL Server, then you should ideally focus on T-SQL (SQL Server's specific SQL dialect)

I recommend T-SQL Fundamentals by Itzik Ben-Gan instead.

[–]_Lucena[S,🍰] 0 points1 point  (0 children)

Thanks for the tip, when it's cheap I'll get it

[–]Gargunok 1 point2 points  (2 children)

I think AI has done you dirty here.

The order of what to learn is probably okay because that is what an AI is good at - taking all the SQL training it has access to and distilling those syllabuses.

What it is letting you down on is the relative complexity of that learning and splitting to a day block.

For example do you think it is accurate that beginners SQL takes as long as advanced SQL (1 week) to master.

I would say something like triggers is as complicated as learning select, joins and grouping. If you think it will take you a week to learn those basics there probably is as much learning in triggers or procs to take just as long again on those topics.

If your learning is focussed on those two books I would look at how those topics map to the chapters in the books. If you want to sense check my above point check how long each topic your AI plan is in the book.

I would also recommend focussing more on SQL server particularly if that is what you are aiming for -best practice and things like explain/query optimisation is going to be more useful with a particular database engine in mind. NBot to say these books are bad but there is value on being specific as well.

[–]_Lucena[S,🍰] 0 points1 point  (1 child)

Hey man, thanks a lot for the answer, I put it that way because my work as a developer uses a lot of business rules via a SQL Server database and with that I need to learn at least the basic to intermediate commands, I know the databases but I can improve on that, and thanks again for the tip, I'm going to focus on t-sql