[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y ] [Home]
4chanarchives logo
SQL
Images are sometimes not shown due to bandwidth/network limitations. Refreshing the page usually helps.

You are currently reading a thread in /biz/ - Business & Finance

Thread replies: 9
Thread images: 1
File: 21631412592_7721149b4b_h.jpg (510 KB, 1600x1067) Image search: [Google]
21631412592_7721149b4b_h.jpg
510 KB, 1600x1067
Who here has "working knowledge" of SQL? Im interested in learning it because I think its something I would benefit from but I'm curious as to what kind of commitment it would take to get to a working level. Is it something I could get down in a few months or would it take years? What are some good resources to learn (free or cheap preferably)?
>>
you can learn enough to write queries to databases in a few days

learning enough to design your own dbs will take much longer
>>
Querying data is easy. Designing, maintaining, and ensuring data integrity is not.

What exactly do you want to know?
>>
learning enough to design your own dbs will take much MUCH longer

possibly a week
>>
Microsoft Access is thought of a kind introduction to SQL
>>
>>1075189
microsoft access is absolute shit written so non-programmers and non-dbas can smash together their excel sheets and write absolute abominations of queries.

sqlite is a good starting point, it's SQL compliant with very easy setup and few datatypes to worry about
>>
>>1075185
>What exactly do you want to know?
Enough to get a good job essentially. I'm looking for positions as a buyer/procurement specialist or something that involves ERP systems. Most jobs like this list SQL as a desired skill. I dont know enough about it to say I want to be a SQL developer, but looking at their salaries I'd say it wouldn't be a bad idea to get a job where I learn more about it.
>>
Install a DB (I prefer PostgreSQL)

Google some tutorials for it, learn select/insert/delete

Look up "database normalization" and get a feel for what denormalized data looks like

Come up with something you would want to model (like a school which has teachers, students, classes, etc.) and design it in a schema designer (google "www sql designer") at the third normal form

Learn how to do joins (google "visual guide to sql joins)

Write some queries which product reports on your schema (average # of students per class, # of classes within x% of capacity, find all the unique students a teacher is responsible for, find all the unique teachers for a student, etc.)
>>
>>1075202
Ill try this, thanks.
Thread replies: 9
Thread images: 1

banner
banner
[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y] [Home]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
If a post contains personal/copyrighted/illegal content you can contact me at [email protected] with that post and thread number and it will be removed as soon as possible.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com, send takedown notices to them.
This is a 4chan archive - all of the content originated from them. If you need IP information for a Poster - you need to contact them. This website shows only archived content.