Solved

SQL knowledge

Posted on 2011-09-28
7
206 Views
Last Modified: 2012-05-12
can anyone please provide me links on sql just basic things which administrator has to know in daily routine job like how to take backup, quiries, managemnet of datastores e.t.c..
0
Comment
7 Comments
 
LVL 21

Expert Comment

by:JestersGrind
ID: 36718686
Let me start by saying that there is a lot to learn.  The couple of links here will give you some how to instructions from Microsoft.  

Administration topics
http://msdn.microsoft.com/en-us/library/bb522544.aspx

Writing SQL queries
http://msdn.microsoft.com/en-us/library/bb264565%28v=sql.90%29.aspx

Greg

0
 

Author Comment

by:Yogesh_Exchange_Expert
ID: 36718694
i just want know the basics of it nothing more than it.
0
 
LVL 5

Expert Comment

by:MrNetic
ID: 36718700
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 21

Expert Comment

by:JestersGrind
ID: 36718726
As you are learning the basics, this is a good site to ask specific questions that you may have.

Greg
0
 
LVL 9

Expert Comment

by:DrewKjell
ID: 36718839
I'm a fan of w3schools for learning new technologies as they provide a way for you to not just read about the technology but to try it out.  

http://www.w3schools.com/sql/default.asp

Drew
0
 

Author Comment

by:Yogesh_Exchange_Expert
ID: 36719301
Any PDF or book apart from links....
0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36719387
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question