Advise for SQL course

nikeman77
Member Posts: 517
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.
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.
0
Answers
-
If you have not already done so, install the SQL Server Dev edition on your personal PC. If you have enough RAM on your PC (at least 4GB), you can run 2 instances - SQL Server 2008R2 and SQL Server 2012.
Then go to a online book store and find a good training book for your first SQL Server exam and use it as a guide on what to study.
In addition to paid physical classes there are a variety of online classes available, if you need additional help.
See if you have any local SQL Server user groups in your area you can attend.David Machanick
http://mibuso.com/blogs/davidmachanick/0 -
hi davmac1,
appreciate your reply.. but from the direction of navision developer where would you advise i should start focusing on more..?
for the downloading of sql2008r3, is it available 'free'?
if i take download from my company sql cd into my company laptop, can i practice it without connecting to any server?
(similar to local native navision, fin.exe)0 -
The Developer's Edition is not free, but it is relatively inexpensive. Around $50 US.There are no bugs - only undocumented features.0
-
0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions