Solved

SQL Learning how it works in an organisation

Posted on 2014-10-06
7
123 Views
Last Modified: 2014-10-07
Hi

I have been interacting with SQL via VB.net coding for a while.
I want to learn how to use SQL without VB.net as a user
would in an organisation. Is there a resource for this?
Would I use SQL management server
0
Comment
Question by:murbro
7 Comments
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 167 total points
ID: 40365340
What is your background? Have you worked with another RDBMS before? If so, which one(s)?
For sure you already searched in the web for documentation or tutorial. What you've found and why you think aren't good enough?
Here's a good start point.
0
 
LVL 48

Assisted Solution

by:PortletPaul
PortletPaul earned 167 total points
ID: 40365343
You could run SQL Server Express (free) or Developer Edition (~$50 I think)
0
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 166 total points
ID: 40365411
I would buy the exam book for MS SQL Server. Have a look at your favorite book shop for the Microsoft Exam Guide for 70-461; it is very comprehensive, and not that expensive.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Closing Comment

by:murbro
ID: 40365439
Thank you all very much.
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40365473
Thanks! by the way:

Books by Itzik Ben-Gan are highly recommended by EE expert Scott Pletcher
0
 

Author Comment

by:murbro
ID: 40365595
Excellent. Will have a look.
0
 
LVL 34

Expert Comment

by:Dan Craciun
ID: 40367070
how to use SQL as a user would in an organisation
In most organizations, users would never use SQL. The regular users have Excel, while "power users" have BI tools.

Most analytic tools try to hide the complexities of SQL for users.

HTH,
Dan
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Run SQL Server Proc from Access 11 31
sql select record as one long string 21 24
what are the unique tables in SQL master database 5 62
Can > be used for a Text field 6 49
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

803 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