Originally posted by jamesbrown
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Learn SQL - Recommendations?
Collapse
X
-
The greatest trick the devil ever pulled was convincing the world that he didn't exist -
Originally posted by ladymuck View PostBut understanding how tables are organised in a proper database will help navigate where something has been fully normalised and you have to do multiple joins (and work out which type) in order to get a "sensible" looking output.
None of it is deliberate by the way.. no one designing these systems says we are going to put x, y, z tables in 2NF and a, b, c tables in 3NF and d, e, f tables are a combination, etc.
When was the last time you looked at a system and saw an address table for example?
Teaching people who only need to query data about normalisation just gets them worrying about theory that isn't consistent in practice and isn't even really applicable to their select query anyway.Comment
-
I think another important thing to understand is the difference between OLTP and reporting databases.
OLTP are designed for getting data in and are almost a table per user screen, while reporting databases have been structured so that data is easier to analyse.
Personally, if you're starting of with databases, I'd recommending downloading and installing MS SQL Server - it's free and easy to install and is very popular with on-premises. If cloud is your thing, then Postgres or MySQL would be more appropriate. All flavours of SQL are fairly similar but have nuances around things like dates and string manipulation.
As others have said, production code shouldn't ever contain SELECT *The greatest trick the devil ever pulled was convincing the world that he didn't existComment
-
Originally posted by jayn200 View Post
When was the last time you looked at a system and saw an address table for example?Comment
-
Originally posted by woohoo View PostToday.
I have seen it split out probably less than 10% of the time in ERP and CRM systems both off the shelf and bespoke.
Point is they're hardly ever normalized to any consistent standard. Occasionally you will see an ERP system that's mostly normalized to 3NF and it's absolute hell to deal with for any type of data integration and impossible to work with without a full data dictionary.Comment
-
Originally posted by jayn200 View PostDid you create it?
I have seen it split out probably less than 10% of the time in ERP and CRM systems both off the shelf and bespoke.
Point is they're hardly ever normalized to any consistent standard. Occasionally you will see an ERP system that's mostly normalized to 3NF and it's absolute hell to deal with for any type of data integration and impossible to work with without a full data dictionary.
But i take your point.Comment
-
Last client went to a level of overkill on table design that made getting data out very difficult. Over normalised, if such a thing is possible.
My point was less about the nuts and bolts of database design but more about understanding how the design affects the type of join you need to do in order to access the data you need.Comment
-
When I did some DB design in previous life, I used to normalise to Boyce-Codd Normal Form, just because I liked the name.
Well, it was DB design - something had to keep me entertained.Comment
-
Originally posted by LondonManc View PostNo self-respecting developer admits to being a developer.
I've developed using C-41 in the past. Does that count?…Maybe we ain’t that young anymoreComment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment