Recent Topics
Get your physicals done people
by BeerCan - 03/29/20 08:41 AM
2004 Silverado
by mjk - 03/29/20 08:29 AM
Shimmy on the Hiwy
by Char Baby - 03/29/20 06:06 AM
10w40 over 5w30 diesel
by angryorc - 03/29/20 03:20 AM
Clover Overseeding.
by GumbyJarvis - 03/29/20 01:52 AM
Crawfish Boil
by BlueOvalFitter - 03/29/20 01:09 AM
Crude Pricing Dynamics
by Y_K - 03/28/20 11:24 PM
Best battery tender for AGM
by painfx - 03/28/20 10:27 PM
Tinted my DRLs
by mclasser - 03/28/20 09:04 PM
Chicken Burritos tonight
by urrlord - 03/28/20 08:34 PM
ACDelco Oil filter date code
by nwjones18 - 03/28/20 07:43 PM
GM Plastic Heater Hose T-Fitting(s) Broke!
by jetman - 03/28/20 06:26 PM
Elite Iron Bipod
by claluja - 03/28/20 05:44 PM
Uneven Pad Wear?
by JeffKeryk - 03/28/20 05:43 PM
Left valve cover leaking oil
by NH73 - 03/28/20 05:03 PM
Pennzoil platinum high mileage
by Micahmcmeen - 03/28/20 04:04 PM
Beans!
by 53' Stude - 03/28/20 03:54 PM
1997 Dodge Ram v6
by urrlord - 03/28/20 03:31 PM
Blood shortages
by 53' Stude - 03/28/20 03:09 PM
Decent little score
by JPP - 03/28/20 02:23 PM
Newest Members
yulichris, jeff58, jimmyturner, ChainsawGuy, jbr
71038 Registered Users
Who's Online Now
114 registered members (4WD, 53' Stude, 007, alarmguy, 762fermeandyou, 2010Civic, 12 invisible), 1,812 guests, and 16 spiders.
Key: Admin, Global Mod, Mod
Forum Statistics
Forums67
Topics303,305
Posts5,233,633
Members71,038
Most Online4,538
Jan 20th, 2020
Donate to BITOG
Print Thread
Hop To
SQL Basics? #5330238 01/23/20 12:08 PM
Joined: May 2003
Posts: 9,547
tom slick Offline OP
OP Offline
Joined: May 2003
Posts: 9,547
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 12:25 PM
Joined: May 2015
Posts: 2,812
A
Alfred_B Offline
Offline
A
Joined: May 2015
Posts: 2,812
Are you above SQL FOR DUMMIES book?

Re: SQL Basics? [Re: tom slick] #5330271 01/23/20 12:55 PM
Joined: Jan 2010
Posts: 3,380
J
JeffKeryk Online Content
Online Content
J
Joined: Jan 2010
Posts: 3,380
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 12:55 PM.

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 01:04 PM
Joined: Dec 2006
Posts: 603
N
NYSteve Offline
Offline
N
Joined: Dec 2006
Posts: 603
W3 School is where I tell people to start:

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

Re: SQL Basics? [Re: tom slick] #5330332 01/23/20 02:48 PM
Joined: Apr 2008
Posts: 13,911
M
Miller88 Offline
Offline
M
Joined: Apr 2008
Posts: 13,911
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 11:37 AM
Joined: Mar 2011
Posts: 2,076
S
spackard Offline
Offline
S
Joined: Mar 2011
Posts: 2,076
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 07:29 PM
Joined: May 2003
Posts: 9,547
tom slick Offline OP
OP Offline
Joined: May 2003
Posts: 9,547
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 07:54 AM
Joined: Aug 2011
Posts: 4,001
P
pandus13 Offline
Offline
P
Joined: Aug 2011
Posts: 4,001
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 08: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 09:48 PM
Joined: May 2003
Posts: 9,547
tom slick Offline OP
OP Offline
Joined: May 2003
Posts: 9,547
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 09: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 07:35 AM
Joined: Jul 2015
Posts: 5,870
M
madRiver Offline
Offline
M
Joined: Jul 2015
Posts: 5,870
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™