January 22, 2015 at 2:32 am
I've been asked today if i can give someone a quick few hour-1day course on sql. I didn't reply yet because i don't know what to reply and be polite same time. The things to be covered:
Hi Emil
I have very little knowledge of SQL databases, the things I would like covered are
1) Copying SQL databases so they can be looked at remotely
2) How to open and look at databases either over a network or on a remote laptop
3) How to add data to databases over the network database
4) If it is possible how to delete data from the databases over a network
5) How to obtain data from the databases over the network
6) How to replace databases
7) How to look at the structure of the SQL databases
8) How to repair SQL databases
9) How to automatically backup databases
10) Difference between access and SQL databases
11) What to do if there are problems with the databases.
Not sure what to reply...
January 22, 2015 at 2:46 am
You've been asked this as part of your job? If so, ask your boss/manager if they can allocate you time to prep such a course. Rough guideline there is 8 hours prep per hour of training.
You've been asked outside of work to do this? If so, are they willing to pay for a custom course to be preped and delivered, at reasonable rates and do you have the spare time to do the prep work?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 22, 2015 at 3:35 am
We are a small company and I'm the only DBA, my concern is that when people that are not familiar at all with the sql, after a one day training want to do all of what have beed listed.
Have a look at point 8.
8) How to repair SQL databases
you could cover so much only on this subject that 1 day may not be enough, because one thing is showing someone how to do something other is make him understand what he did so i won't end up with bigger mess.
January 22, 2015 at 4:43 am
Actually, that's easy to teach.
"Call the DBA."
Repairing a SQL DB is not something that an end user can do at all, as it requires sysadmin access and a lot of knowledge, neither of which is something which an end user has.
I'd approach this as a 'differences between SQL Server and MS Access' type training. Emphasis that SQL Server is a server and that they won't be creating databases, repairing databases any more than they'd be installing web servers or managing the mail server
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 22, 2015 at 7:02 am
Thanks Gail, especially for the last sentence, it shows the point.
"Call the DBA" training would be the training to do, just need to print some business cards :hehe:
January 22, 2015 at 7:13 am
These questions all appear to be written by someone who has worked with Access, especially all of the "over the network" questions.
I can relate to being in a small shop. You may want to suggest Pluralsight, and as these people take each course/section, follow through with relating the training to your environment.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
February 2, 2015 at 2:57 am
I think I found a solution that would satisfy me and my collegues.
The company has a HUB website, sort of a community site where they post all the internal announcments etc. There is an option to create your own small blog. I think that would help in some way to pass my knowlage to people in the company that want to know more about SQL and how it applies to our machinery and on the other side it would help me to open up a little bit and show my creative side.
Any suggestions, opinions?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply