Join 3,561 readers in helping fund MetaFilter (Hide)

17 posts tagged with programming and SQL. (View popular tags)
Displaying 1 through 17 of 17. Subscribe:

Best resources for learning SQL for database newbies

I am making a transition from an Excel-based reporting analyst to a database-oriented role in which SQL will be the primary necessary skill. I have next to zero database experience. I'm looking for resources that would be effective at teaching me what I need to learn. More within… [more inside]
posted by JimBJ9 on Aug 20, 2014 - 15 answers

Help me use Excel to save my job

So, I just got promoted to a new position at my company (Yay!). Unfortunately, the new requirements involve scheduling a ridiculous number of people. It turns out my predecessor has just been doing dozens of iterations manually until one kind of worked, but every slight change puts a bunch of other things out of wack. I feel like Excel could probably be capable of doing it, but I have no idea how I would go about designing such a spread sheet. [more inside]
posted by cacofonie on Jun 19, 2014 - 17 answers

SQL Query to find unique combinations

SQLNoobFilter: I am trying to find all unique combinations on a table. Does my simple query do the trick or is there more to it? [more inside]
posted by amazingstill on Mar 14, 2012 - 5 answers

What do I need to know to fill in the gaps?

Looking for books and articles on programming, design patterns, information architecture, and whatever else. Clear information on Things To Do and Things To Avoid, with a smattering of theory and opinion, would be great. [more inside]
posted by jsturgill on Aug 23, 2011 - 5 answers

Effing Access combo boxes, how do they work?

I'm trying to make a combo box populate properly in an MS Access form (oh, the pain), and I need some help. [more inside]
posted by middleclasstool on Jul 8, 2010 - 2 answers

Beginner resources for ASP.NET and SQL?

So the company I've started working for has asked me to step into a website development role, and while I've got some limited tech knowledge, I need to find some resources to start really digging into ASP.NET and SQL. [more inside]
posted by Mali on Mar 2, 2010 - 5 answers

Complex SQL Query

SQLFilter: I'm struggling with a specific SQL query. I have 2 tables, 'questions' and 'answers', which are linked by a field in answers. I would like to select the questions which have the most answers in the last 24 hours. [more inside]
posted by charmston on Jul 19, 2008 - 2 answers

PerHaPs SeQuentiaLly?

Which version of PHP should I start to learn, and how? I know HTML and CSS, and intend to build with Drupal (or similar) and its many extensions. [more inside]
posted by prophetsearcher on May 4, 2008 - 12 answers

It's not you - my CPU says yes, but my database say no

How many database reads/writes are okay per web page view? Also, what is better, big tables or lots of join tables? [more inside]
posted by markovich on Nov 16, 2007 - 13 answers

Help with creating a SQL query with optional multi-value parameters

Looking for some guidance in building an "advanced search" query using XML and optional multi-value parameters. [more inside]
posted by mkultra on Jun 26, 2007 - 6 answers

How to query SQL with Ruby?

What's the best way (using the internet, and/or books) to learn how to query SQL databases with Ruby?
posted by anonymous on Jun 10, 2007 - 3 answers

Know any dead trees that can teach me about php and MySQL?

Recommendations for a book to teach myself php and MySQL? [more inside]
posted by dripdripdrop on Nov 20, 2006 - 8 answers

Gurus only

Perhaps advanced MSSQL question.. [more inside]
posted by eas98 on Jul 31, 2006 - 7 answers

Help with SQL unions needed

Question for the SQL ninjas in the house. Say you're grabbing data from a bunch of similar tables in a big union. Now say you want the last ten items added anywhere to the database, from any one of those tables. What's the most efficient way to do that? [more inside]
posted by mathowie on May 10, 2006 - 22 answers

Succor From SQL

I have a Windows-served website programmed in C# and connected to a SQL database. I'd like to move the whole thing to the Mac. [more inside]
posted by thejoshu on Feb 24, 2006 - 8 answers

SELECT answer FROM askmefi

I need help with what I hope is a fairly simple mySQL query question. [more inside]
posted by Asparagirl on Nov 29, 2005 - 18 answers

Can FileMaker have hooks into MySQL?

I have a MySQL database that contains two fields - name and e-mail - for a bunch of records. Separately I have a FileMaker 7 database that contains the same fields - name and e-mail - and contains other fields, like "notes". My question: can the FileMaker database, after polling the MySQL database, show name and e-mail as read-only; and then show the other fields as editable? i.e. if I make a change to the MySQL database, can I get it to show up in FM? [more inside]
posted by mark7570 on Sep 30, 2005 - 2 answers

Page: 1