I literally have no code knowledge
I know some HTML? A tiny bit.
Kind of always wanted to learn Java.
And my join is generally all SharePoint.. so what's useful there? (If I were ever allowed into the backend)
i should go to code academy and start super basic
like
css
SQL is really quite easy. Optimized SQL takes work, but you need tools to analyze join paths for that, so you probably won't have to do that very often.
This. You can learn the basics of SQL in a handful of hours, and that would cover probably 70-80% of the queries I've had to write for applications.
HTML and CSS are only a little more complicated to learn the basics, and you can build static webpages with those.
Where it gets fun is when you start throwing in javascript to make your HTML do cool things, and then a server language of some sort (C#, Java, etc) to talk to your database with SQL.
Suddenly, you can start making web apps that do... whatever you want them to really.
And then you start writing 250-300 line PL/SQL stored procedures with no training but the Oracle For Dummies book in front of you and a lot of gumption
I literally have no code knowledge
I know some HTML? A tiny bit.
Kind of always wanted to learn Java.
And my join is generally all SharePoint.. so what's useful there? (If I were ever allowed into the backend)
I dunno, where to best start probably depends on what exactly you're trying to do.
If you're basically just trying to pull data out of a database efficiently and maybe do some analysis, you might not care about anything other than SQL. With your background in excel it wouldn't surprise me if this is just what you want to stick to.
But if you're trying to produce something more general purpose or more complicated or whatever, you might want to start with a general purpose programming language instead.
I wish that someway, somehow, that I could save every one of us
HacksawJ. Duggan Esq.Wrestler at LawRegistered Userregular
You know you're working with seasoned professionals when you hear a loud crashing sound come from the next room over and then immediately following it: "Don't worry. That was supposed to happen."
Does anyone like planning social activities for the work place? I was just told that the chair wants us to do something in a couple weeks.
And no indication of what we should do. Potlucks don't work because there is no place to store food.
Any ideas?
November is good for outdoor socializing during the bright sunlight, but it's murder-cold during dusk and evening, especially on the East Coast.
I would recommend a wine tasting. Alcohol reps love to rub elbows with of-age students and professors and faculty.
And do you know what goes well with wine, Sass?
CHEESE.
If you're looking for a tee-totalling event, you could ... quite literally ... have a tea tasting. Tea, coffee and spiced cider are perfect for Brovember, but you'll need to contact a specialty shop that has catering staff or get a caterer willing to give their staff a crash course in hot beverage service.
Or you could just pour a bunch of cheap red wine in a bucket with some oranges and make ghetto sangria ... AKA gangria.
Darth Waiter on
0
FishmanPut your goddamned hand in the goddamned Box of Pain.Registered Userregular
I had never heard the term 'Ice-cream social' before Sarge said it in an episode of Red vs Blue.
So now, any time I see it written down, the entire post becomes dictated in Sarge voice.
I am by no means a SQL expert but I have taught myself the basics by running into issues at work, and poking around at the structure of our ERP system to do things, so if you have any questions shoot me an IM or an email or whatever, I'm usually around!
You might want to start with MS Access, as it'll get you the basics on database structure and writing queries.
The only flavor of SQL I have experience with is MS SQL though, and each one has their own little quirks, so you'd also have to consider what/why you're wanting to learn to do with SQL.
For me it was to clean up 6+ years of what should have been pretty standardized data entry values into something consistent I could work with. Once I had values that were consistent (like, State abbreviations) I was able to apply that to other values in the database.
So, once all the 'Georgia's, 'G.A.'s, 'ga's, etc were all 'GA' (and the same for FL, AL, etc) I could then write SQL statements to alter the poorly implemented Sales Territory field in our system to stuff like
UPDATE dbo.CUSTOMER_DATA SET SLSTERR='US-SOUTHEAST' where STATE IN ('GA', 'FL', 'AL')
Once I had all of those consistently grouped, I could assigned Sales Reps to territories by updating records where the territory='X'
We've also done a lot of the same with classifying and categorizing our inventory items in a similar manner.
Accidentally arrived an hour early and am now sitting in a darkened opera house, alone. If this place didn't have free wifi I'd feel really stupid right now.
If you put me alone in a room that carries sound well... look out. Don't give a professional opera singer that kind of freedom.
When I was doing Mikado in Santa Monica our venue was crazy with sound. You barely had to make a noise for it to carry through the entire house. I'm pretty loud, so it was actually difficult having to scale back to match such a great sound in such a small theater.
I stopped using Ye Olde a long time ago. I've got a few random pieces of a few different userscripts from those threads.
Basically just dealing with reactions, sig blocks, and the emoticon box.
I need to browse through there and look at a few, some of'em seem pretty neat. Someone (not me) should make some kind of master list of widgets people have made for the forums.
Posts
I literally have no code knowledge
I know some HTML? A tiny bit.
Kind of always wanted to learn Java.
And my join is generally all SharePoint.. so what's useful there? (If I were ever allowed into the backend)
Saturday 2-7 PM...
That's it. That's the entire thing.
This. You can learn the basics of SQL in a handful of hours, and that would cover probably 70-80% of the queries I've had to write for applications.
HTML and CSS are only a little more complicated to learn the basics, and you can build static webpages with those.
Where it gets fun is when you start throwing in javascript to make your HTML do cool things, and then a server language of some sort (C#, Java, etc) to talk to your database with SQL.
Suddenly, you can start making web apps that do... whatever you want them to really.
thank you, petting-owl guy
(for me it was never enough gumption)
Oh god
I dunno, where to best start probably depends on what exactly you're trying to do.
If you're basically just trying to pull data out of a database efficiently and maybe do some analysis, you might not care about anything other than SQL. With your background in excel it wouldn't surprise me if this is just what you want to stick to.
But if you're trying to produce something more general purpose or more complicated or whatever, you might want to start with a general purpose programming language instead.
Then I came to my fucking senses
That's too high level for beginning. Gotta get down there in the weeds with an assembly language.
And no indication of what we should do. Potlucks don't work because there is no place to store food.
Any ideas?
Give three suggestions. One is really boring, one is really scary and one is a tour of a brewery followed by a pissup. Let them pick.
Alternatively: white-water rafting?
Like, if it wasn't happening in November we would probably just do an ice cream social.
November is good for outdoor socializing during the bright sunlight, but it's murder-cold during dusk and evening, especially on the East Coast.
I would recommend a wine tasting. Alcohol reps love to rub elbows with of-age students and professors and faculty.
And do you know what goes well with wine, Sass?
CHEESE.
If you're looking for a tee-totalling event, you could ... quite literally ... have a tea tasting. Tea, coffee and spiced cider are perfect for Brovember, but you'll need to contact a specialty shop that has catering staff or get a caterer willing to give their staff a crash course in hot beverage service.
Or you could just pour a bunch of cheap red wine in a bucket with some oranges and make ghetto sangria ... AKA gangria.
So now, any time I see it written down, the entire post becomes dictated in Sarge voice.
And now Sass sounds like Sarge.
I am by no means a SQL expert but I have taught myself the basics by running into issues at work, and poking around at the structure of our ERP system to do things, so if you have any questions shoot me an IM or an email or whatever, I'm usually around!
You might want to start with MS Access, as it'll get you the basics on database structure and writing queries.
The only flavor of SQL I have experience with is MS SQL though, and each one has their own little quirks, so you'd also have to consider what/why you're wanting to learn to do with SQL.
For me it was to clean up 6+ years of what should have been pretty standardized data entry values into something consistent I could work with. Once I had values that were consistent (like, State abbreviations) I was able to apply that to other values in the database.
So, once all the 'Georgia's, 'G.A.'s, 'ga's, etc were all 'GA' (and the same for FL, AL, etc) I could then write SQL statements to alter the poorly implemented Sales Territory field in our system to stuff like
UPDATE dbo.CUSTOMER_DATA SET SLSTERR='US-SOUTHEAST' where STATE IN ('GA', 'FL', 'AL')Once I had all of those consistently grouped, I could assigned Sales Reps to territories by updating records where the territory='X'
We've also done a lot of the same with classifying and categorizing our inventory items in a similar manner.
edit:
Yep, it was the PA Tweaks userscript. Probably hasn't been updated in forever. Shame, I liked some of what it did.
Basically just dealing with reactions, sig blocks, and the emoticon box.
Bitchin
Who rocks the party that rocks the piñata?
If you put me alone in a room that carries sound well... look out. Don't give a professional opera singer that kind of freedom.
When I was doing Mikado in Santa Monica our venue was crazy with sound. You barely had to make a noise for it to carry through the entire house. I'm pretty loud, so it was actually difficult having to scale back to match such a great sound in such a small theater.
I need to browse through there and look at a few, some of'em seem pretty neat. Someone (not me) should make some kind of master list of widgets people have made for the forums.
My roosters will be sufficiently warm this winter, but I'll pass your information along to my friends.
html mess up is like "oh i forgot to close this thing"
sql mess up is like "oh fuck everything is fucked. time to rollback to backup"
PARKER, YOU'RE FIRED! <-- My comic book podcast! Satan look here!
and backups, gotta have backups