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

78 posts tagged with sql and database. (View popular tags)
Displaying 1 through 50 of 78. 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 get a Microsoft DB certification

I want to get a Microsoft Database certification so I can become a database developer (I know some basic SQL using Postgres but I'd like to know more and get a certification). What's the best way to do this using a book instead of taking a class? [more inside]
posted by Mrs. Pterodactyl on Jul 15, 2014 - 3 answers

SQL Trace: How to aggregate data by stored procedure without ClearTrace

I'm trying to put together an automated SQL server monitoring and diagnostics solution, including SQL Trace data. I want to be able to group RPC:Completed event data by stored procedure. Unfortunately, the formatting and parameter values in each specific call make this kind of aggregation impossible. For instance "Select * From qryLinksByNewsletterID Where NewsletterID=19" and "Select * From qryLinksByNewsletterID Where NewsletterID=234" would be considered different remote procedure calls. ClearTrace does that for you. But, ClearTrace can't run as an automated SQL job. Some kind of script would be ideal, and someone by the name of Andrew Zanevsky made a post describing one back in 2004, but the link to the actual script is dead. I could create my own with Regexes and such, but it seems like someone out there must have done it already. [more inside]
posted by UrbanEye on Feb 23, 2014 - 1 answer

Document-Oriented Database for Non-Programmers?

Is there such a thing as a Document-Oriented Database for Non-Programmers? I've been searching the web for several days and I'm quite confused so I thought to post here. [more inside]
posted by dylan_k on Dec 3, 2013 - 20 answers

SQL Teaching Game

I remember coming across a game that represented rows in a database as stars in a galaxy, and gave the player visual feedback for the queries they entered. What was that called?
posted by phrontist on Aug 1, 2013 - 2 answers

MS Access Combo Box Fields behaving strangely.

I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob on Jun 9, 2013 - 1 answer

Data Driven Clinical Care - Dynamic Graphing Website

I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality hates the MS Access solution that is being built. [more inside]
posted by rosswald on Jan 16, 2013 - 4 answers

How do I go from MAMP to champ?

How do I transfer my locally-created Wordpress site (using MAMP) to my live Dreamhost site? [more inside]
posted by This_Will_Be_Good on Feb 12, 2012 - 13 answers

SQL: How do I increment an alphanumeric field by + 1?

I'm a bit of a SQL novice but learning at a decent clip. I'm using SQL (Aqua Data Studio, if that matters to you) to update a couple of fields in an Oracle database table. I'd like to do this across a range of one of the fields. One field is a numeric field (trans_id - a transaction id) that I need to increase by 1 -- I think have that part licked. The next field is alphanumeric (calendar_name - represents the name of a week) and also needs to be incremented by one. The doozy (for me) is the alphanumeric field. Who's the guru? [more inside]
posted by brokeaspoke on Feb 4, 2012 - 11 answers

Is there a way to visually organize database tables (and saved queries and views)?

I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way? [more inside]
posted by iamkimiam on Feb 2, 2012 - 4 answers

How do I move this database online?

What's the easiest, most secure way to move this SQL database and its browser-based front end online? [more inside]
posted by infinitywaltz on Jan 18, 2012 - 17 answers

Learning Oracle and SQL

Hey all. I need to learn the basic principles of SQL and Oracle databases. I'm looking for web resources and books. Got any favorites? What's out there? Thanks in advance.
posted by Stagger Lee on Dec 5, 2011 - 12 answers

SELECT careerhelp FROM much better informer mefites.

It is time to refine my career. Help me become an excellent database administrator. [more inside]
posted by munchingzombie on Oct 23, 2011 - 7 answers

i need a database!

[Python/database filter] I wrote a script in python for a class and I want to challenge myself now to make it attached to a database... [more inside]
posted by handbanana on Aug 26, 2011 - 8 answers

Looking for a good book to help me brush up on my database skills

I've been working with SQL and RDBMSes for a number of years, but my most recent job involved no DB work at all. Understandably, I'm a bit rusty. So I'd like to get a good book to help me brush up, and also to learn a bit more about RDBMS technology. What would you recommend? [more inside]
posted by Sloop John B on May 3, 2011 - 3 answers

[hɛlp mi si junikod ɪn maɪ deɪtəbeɪs, ɔr maɪ dætəbeɪs ivɛn]

I'm using Navicat Lite to connect to my Oracle research database (Mac OSX). Much of my data is in IPA (International Phonetic Alphabet). These are unicode symbols. Is there a way to display the IPA/Unicode in Navicat? Or some other GUI? Or is there some addon/code/plugin/whatever that will show me the symbols? [more inside]
posted by iamkimiam on Mar 8, 2011 - 2 answers

SQL Query help in Access 2000

I have a MS Access 2000 table with approx 300,000 records. I need help with constructing a query. [more inside]
posted by selton on Feb 13, 2011 - 3 answers

How do I collect dictionary definitions for ~350 words to put into a database?

I have a list of about 350 words that I'm putting into a database that I'm building from scratch. For each word in the list, I'd like to include its American English dictionary definition (preferably American Heritage Dictionary), UrbanDictionary entry, and Wikipedia page link (I realize that entries may not exist for some columns for many of these words). Is there some way to streamline or data-mine this process, so I don't have to look up each word individually in 3 separate sources x350+, not to mention all the copying and pasting? [more inside]
posted by iamkimiam on Feb 11, 2011 - 10 answers

I haven't needed SQL this ugly before

What SQL magic do I need to turn one column into several? [more inside]
posted by flabdablet on Dec 19, 2010 - 14 answers

How can I select this in SQL?

SQLfilter: Help me solve a problem that's driving me crazy. I'm working with someone else's data, and I've got a seemingly insurmountable select problem that no amount of googling has helped me with so far. [more inside]
posted by Mr. Bad Example on Dec 17, 2010 - 11 answers

Best front ends for SQL databases?

What are the current best options for providing a front end for users to search and enter data to a SQL database? [more inside]
posted by tabulem on Oct 15, 2010 - 8 answers

How to export data from a SQL database into a CSV file and add some new data?

How can I export data from a SQL database into a CSV file and add a new column at the same time? [more inside]
posted by jfricke on Sep 8, 2010 - 8 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

SQL on demand?

Is there somewhere you can go to upload some tables (or import CSV files) and run SQL commands on it? [more inside]
posted by metametababe on Jun 7, 2010 - 8 answers

SQL - Accurately show how many rows an UPDATE statement is going to affect before execution.

SQL - How to get an accurate count of the rows potentially affected by an UPDATE statement, or best practices for performing updates? [more inside]
posted by odinsdream on Feb 9, 2010 - 18 answers

Need recs for IT training in Seattle.

In the Seattle/Snohomish area. Which schools provide good training in beginning SQL, or database design, or IT project management? [more inside]
posted by valannc on Oct 31, 2009 - 3 answers

How to keep track of many computers?

I need an inventory management system to keep track of computer hardware and its users. [more inside]
posted by the matching mole on May 7, 2009 - 3 answers

SQL Query Question

SQL query help. Given the (fictional but equivalent) table disk_status = computer_id:int, disk_id:int, datetime:datetime, temperature:float, rpm:int, I need to provide a table of disk status for a given computer_id, without knowing in advance how many disks there are. So if there were two disks for a particular computer, the result would have the header: datetime, disk_1_temperature, disk_1_rpm, disk_2_temperature, disk_2_rpm, disk_2_rpm [more inside]
posted by Nothing on Apr 16, 2009 - 25 answers

Upsize Access database?

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody on Mar 10, 2009 - 11 answers

Comparing two similar but non-matching tables in Access?

Microsoft Access query problem - Comparing two similar tables that don't match up well. It's lists of classes in a collection of locations from two consecutive years, and what I need is to show the class fees side by side for any class that happened in the same location both years. [more inside]
posted by dnash on Feb 5, 2009 - 13 answers

How does flickr do it?

My developer and I want to create a database schema that allows us to search through hundreds of tags applied to thousands of records. So far our benchmarks suck. Are we expecting too much? [more inside]
posted by hayvac on Feb 4, 2009 - 17 answers

How do I convert checkbox results to numbers?

Can anyone give me advice on dealing with checkboxes in PHP, to hand off to SQL. [more inside]
posted by opsin on Jan 30, 2009 - 8 answers

Database suggestions

Database Olympics: File Maker Pro vs. MySQL! Help us pick a database system (Anko or Firebrand). Which do you think is superior to run a print publication database? [more inside]
posted by spakto on Aug 19, 2008 - 6 answers

Reconstituting a wiki database from html?

I'd like to reconstitute a years-defunct wiki I used to collaborate on. I've contacted the principals, & our searches for the database backup have come up empty so far. Without having the original database, the simplest path appears to be taking the html & transforming it into, say, an sql dump. So - how do I do that? Are there any MediaWiki, database, or Perl trails to follow?
posted by Pronoiac on Aug 6, 2008 - 10 answers

How can I import a 46GB database into MSSQL without ending up with a 46GB transaction log?

I need to import a database into MS SQL but I do not want to end up with a transaction log as large as the database. What's the best way to do the import? [more inside]
posted by odinsdream on May 29, 2008 - 4 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

SQL sorting when sort field is null

MySQL sorting issue. When I have "first name" and "last name" columns, and I'm sorting primarily by "last name." Some entries have only a "first name," and rather than have those end up at either the start or end of the sort, I'd like it to pretend the "first name" IS the "last name" and sort accordingly. Is there a way to do this with the SQL SELECT statement or should I just edit the data? [more inside]
posted by dnash on May 2, 2008 - 8 answers

How much database normalization is too much?

How much SQL normalization is too much? [more inside]
posted by EduTek on Apr 25, 2008 - 21 answers

How to count the number of times a string appears in a database field.

SQL Filter: What query can I use to count the number of times a word appears in a text field? [more inside]
posted by Wild_Eep on Feb 21, 2008 - 6 answers

SQL/DBMS ninjas please help! How can I replicate my current abilities at a new company from scratch?

Some colleagues and I will soon be leaving our current employer and starting a new company. How can I best replicate our current relational database/SQL abilities from scratch? [more inside]
posted by raz5 on Jan 23, 2008 - 11 answers

Best DBA certification?

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar on Jan 15, 2008 - 3 answers

SQL help

Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted by loquax on Nov 19, 2007 - 12 answers

All months, now.

Sum of data for all months, including months with no rows, in MySQL? [more inside]
posted by tmcw on Nov 15, 2007 - 7 answers

ColdFusion SQL Injection Attack Terror

ColdFusion MX 7 and Microsoft SQL Server 2005. There's a lot of unvalidated parameters in our CFQUERYs. But, I'm told that putting the parameters in single-quotes will prevent injection attacks, because of the way ColdFusion escapes single-quotes. Is this foolproof, or do I have to go in and validate everything with CFQUERYPARAM tags?
posted by East Manitoba Regional Junior Kabaddi Champion '94 on Oct 22, 2007 - 3 answers

Could I design databases for a living?

Can I, should I, make a career change into database design? [more inside]
posted by argybarg on Sep 25, 2007 - 16 answers

an asp stung my database

Where can I get some noob information on how to read/write simple database tables with ASP? [more inside]
posted by yonation on Sep 25, 2007 - 4 answers

What is the prefered way to represent status changes over time in a relational database?

What is the prefered way to represent status changes over time in a relational database? [more inside]
posted by kimota on Sep 4, 2007 - 17 answers

SQL Combinations

Any SQL / math ninja's on the green fancy a quick challenge..? So I've got this table containing number pairs, right, and I need to compute all the possible combinations. [more inside]
posted by whoojemaflip on Aug 15, 2007 - 25 answers

SQL to update multi-values?

Need some help with MS SQL text replacement. [more inside]
posted by Four Flavors on Jun 18, 2007 - 15 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

Page: 1 2