Recent Topics
drywall crack. how do i fix it?
by WhyMe - 02/21/20 02:55 PM
Yokohama AVID Ascend GT
by Bottom_Feeder - 02/21/20 02:53 PM
Getting my Chevy 4.3 to 300k
by CharlotteB - 02/21/20 02:16 PM
Updated PDS for Valvoline ME
by buster - 02/21/20 01:56 PM
Havoline ProDS Full Synthetic
by Fordiesel69 - 02/21/20 01:32 PM
Correct oil for flat tappets
by Gokhan - 02/21/20 11:55 AM
Laser tachometer?
by Elkins45 - 02/21/20 11:13 AM
Best beginner press?
by MVFarms - 02/21/20 10:20 AM
Help me pick a generator size
by dlundblad - 02/21/20 09:56 AM
...musical 'flat-tappet' oils
by Mad_Max_Sam - 02/21/20 09:44 AM
KIA
by WyrTwister - 02/21/20 09:42 AM
Valvoline NextGen Conventional
by Char Baby - 02/21/20 07:20 AM
Let's Talk Porsche 911
by john_pifer - 02/21/20 02:51 AM
CLEARANCE ALERT O'Reilly's Mobil Super Oil
by GMguy84 - 02/21/20 01:27 AM
No more poulan / weedeater at walmart.
by jakewells - 02/21/20 12:44 AM
1991 Land Cruiser FJ80
by CCI - 02/20/20 09:57 PM
Gas price spread
by Chris142 - 02/20/20 09:28 PM
Need an Ecoboost Oil
by kstanf150 - 02/20/20 08:47 PM
Newest Members
onuryas, vidirola, CharlotteB, Grennx, coverage
70766 Registered Users
Who's Online Now
119 registered members (1foxracing, andreigbs, 1978elcamino, Anduril, 53' Stude, 28oz, 8 invisible), 2,515 guests, and 15 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums67
Topics301,750
Posts5,202,020
Members70,766
Most Online4,538
Jan 20th, 2020
Donate to BITOG
Print Thread
Hop To
SQL Basics? #5330238 01/23/20 11:08 AM
Joined: May 2003
Posts: 9,541
tom slick Offline OP
OP Offline
Joined: May 2003
Posts: 9,541
I recently implemented an ERP system at work that uses SQL. I’ve learned some very basic stuff for modifying queries but would like to become a little more proficient. I’m using Microsoft Report Builder, PowerBI, and SSMS for making/modifying reports.

Anyone have some resources for learning how to write SQL queries?


You get what you pay for...
So keep in mind how much you paid for this advice.
Re: SQL Basics? [Re: tom slick] #5330253 01/23/20 11:25 AM
Joined: May 2015
Posts: 2,713
A
Alfred_B Offline
Offline
A
Joined: May 2015
Posts: 2,713
Are you above SQL FOR DUMMIES book?

Re: SQL Basics? [Re: tom slick] #5330271 01/23/20 11:55 AM
Joined: Jan 2010
Posts: 3,181
J
JeffKeryk Online Content
Online Content
J
Joined: Jan 2010
Posts: 3,181
I started with v. 6.21a when it split from Sybase.

edx.org and Youtube are your friends. I took the Harvard University course in R, for free.
Find a local user's group.

Microsoft Transact SQL

Beginning SQL

Last edited by JeffKeryk; 01/23/20 11:55 AM.

2018 Tesla Model 3, Medium Range Battery
2018 Lexus RX450h
2013 Lexus GS350 F Sport
2006 Acura TSX
2001 Tundra Access Cab, 1998 Accord LX, 1968 Corvette L36 Roadster, 1965 Olds 4-4-2
Re: SQL Basics? [Re: tom slick] #5330276 01/23/20 12:04 PM
Joined: Dec 2006
Posts: 600
N
NYSteve Offline
Offline
N
Joined: Dec 2006
Posts: 600
W3 School is where I tell people to start:

https://www.w3schools.com/sql/

Re: SQL Basics? [Re: tom slick] #5330332 01/23/20 01:48 PM
Joined: Apr 2008
Posts: 13,872
M
Miller88 Offline
Offline
M
Joined: Apr 2008
Posts: 13,872
W3 schools is a huge help. I found myself in a similar role a few years back. Just jumping in and working with already existing examples was the biggest help. It's easier to learn on real data than stuff you make up yourself.

But it's definitely helpful to get yourself some made up data and start learning to query / update / create on your own.


18 Forester 2.5I 6M
00 Jeep XJ
01 F-350 4x4 5M
Re: SQL Basics? [Re: tom slick] #5331743 01/25/20 10:37 AM
Joined: Mar 2011
Posts: 2,063
S
spackard Offline
Offline
S
Joined: Mar 2011
Posts: 2,063
CJ Date is considered the father of relational databases.
An Introduction to Database Systems, 8th ed.
Would help you with the theory. Not sure if it would help you with implementation though.

Re: SQL Basics? [Re: tom slick] #5334884 01/28/20 06:29 PM
Joined: May 2003
Posts: 9,541
tom slick Offline OP
OP Offline
Joined: May 2003
Posts: 9,541
Thank you for the recommendations.
Right now I mostly modify existing queries to make the report do what I want.
I want to dig into powerbi, it can do some really neat stuff.


You get what you pay for...
So keep in mind how much you paid for this advice.
Re: SQL Basics? [Re: tom slick] #5335161 01/29/20 06:54 AM
Joined: Aug 2011
Posts: 3,932
P
pandus13 Online Content
Online Content
P
Joined: Aug 2011
Posts: 3,932
the youtube channels: Curbal, Guy in a Cube, MyOnlineTrainingHub, ExcelIsFun
If the queries you run are big/lots of data, look into sql optimization/query optimization.

Your ERP should have come with a running reports utility. if not, probably MS SSRS or SAP Crystal Reports. Look at the youtube tutorials.

Hopefully, they deployed with adequate hardware. Also thinking for 5 years growth of data. I had to deal with really old hardware, badly designed ERP and crazy connection drivers.
And to top it off, people that think Excel is the ultimate utility (for pulling lots of data)

Good luck.


16 Golf SportWagen
13 Mazda5
08 Yaris
04 Elantra
95 accent
95 mystique
97 concorde
Re: SQL Basics? [Re: tom slick] #5335169 01/29/20 07:07 AM
Joined: Jun 2003
Posts: 41
D
DZello Offline
Offline
D
Joined: Jun 2003
Posts: 41
You need to know which SQL database is used by the product. SQL is used to query a lot of different systems and they're not all exactly the same. For example, T-SQL used by MS SQL is different than the SQL used on MySQL. Oracle is also different. Basic queries are similar, but when you dig deeper, you'll discover things that are not working everywhere.

Re: SQL Basics? [Re: tom slick] #5335936 01/29/20 08:48 PM
Joined: May 2003
Posts: 9,541
tom slick Offline OP
OP Offline
Joined: May 2003
Posts: 9,541
The ERP is loaded with reports but we like to customize them and don’t always want to wait/pay for it especially if it is a couple lines of code.

It uses MS SQL and it uses MS Report Builder for reports directly out of the ERP. We are also using MS PowerBI for more graphical/interactive external reports.

We outgrew QuickBooks and Excel for managing our manufacturing. Excel is a great tool for manipulating data but a mess for data storage.

Last edited by tom slick; 01/29/20 08:52 PM.

You get what you pay for...
So keep in mind how much you paid for this advice.
Re: SQL Basics? [Re: tom slick] #5336129 01/30/20 06:35 AM
Joined: Jul 2015
Posts: 5,791
M
madRiver Offline
Offline
M
Joined: Jul 2015
Posts: 5,791
I have moved away from using SQL based systems to document based for cloud applications.

That being said w3schools got me really far however working with real SQL DB2 admins was beyond valuable to attempt something yourself then pass through them to learn how to optimize the query and approach. Reporting is more adhoc though I think is different then what I do typicallly and ask admins to create views from attempts (prepared virtual table of joined data aggregated with simply key).

Most of my work has been with DB2 over last 20+ years and occasionally MySQL and Oracle. SQL though is pretty generic it seems.

Previous Thread
Index
Next Thread

BOB IS THE OIL GUY® Powered by UBB.threads™