Advise for SQL course

Business Central/NAV General Discussions
1

hi everyone,

I need everyone inputs/ advise for sql courses. i am currently a navision technical developer( still novice). who doesnt have any sql background.

I wanted to take up some SQL courses which would be helpful to my development understanding(navision performance tuning, optimisation). I understand that there are lots of sql course out there (eg: implementing sql, design sql, adminstrating sql etc etc). for my current level, which would be the most appropriate course to start with considering that my current companies already implmenting sql 2008 (unfortunately is maintain by other team) where occasionally i only have chance to do sql backup, create new navision database.

2

Seems that MS courses are more aimed towards administration & maintenance of SQL server, but there are some for developers (T-SQL scripting, stored procedures etc), too.

For specific NAV & SQL server issues you can get Jorg Stryk’s book The NAV/SQL Performance Field Guide (and even ask questions to the author here in DUG - Jorg is SQL Server forum moderator [;)] )

3

hi modris,

awesome! thats something i have in mind! cant imagine the frustration i had had
(eg: whenever there’s a locking issues, performance, doing scripting to extract large amount of data, doing sql backup in *.bak file format which is faster i believe)

thumbs up, pal! [Y]