Software/Databases

My career has encompassed years of experience involving software development, database management, and project management.  Software development includes scripting, Java and C programming languages.  Database management includes design, change management and database recovery.   Project management of software development includes start up, execution, monitoring and closure of projects.   Here are some software and database posts of interest to me.

Mike

Advertisements

4 thoughts on “Software/Databases

  1. I have started looking into Hadoop database management classes because of all the hoopla with cloud computing. Can you say “Hadoop hoopla” fast three times? Anyways a week of classes is $2000. A four day class is $1400. But online classes appear to be free. But that is probably just the first class.

  2. Challenge – SQL Question – Conditional Join on Columns based on value of one column. Here is my answer.

    Try a union
    select * from tbla ta, tblb tb
    where ta.column_1 = 1
    and ta.column_2 = tb.column_2
    union
    select * from tbla ta, tblb tb
    where ta.column_1 = 2
    and ta.column_2 = tb.column_2
    and ta.column_3 = tb.column_3
    union
    select * from tbla ta, tblb tb
    where ta.column_1 = 3
    and ta.column_2 = tb.column_2
    and ta.column_3 = tb.column_3
    and ta.column_4 = tb.column_4
    the end

    Here is the website to see other answers

    http://stackoverflow.com/questions/10846936/sybase-conditional-join-on-columns-based-on-value-of-one-column/10866671#10866671

  3. SQL Challenge: How to remove percent signs (%) from column in table.

    Solution:

    If your DBMS does NOT have a “replace” function, you will have to use character substitution using several string functions.

    Here is an example in Sybase and SQL Server.

    UPDATE YourTable
    SET YourColumn = stuff(YourColumn, patindex(YourColumn, ‘%’), 1, NULL)

    This says find the pattern of ‘%’ in YourColumn. Now use that position number and replace aka stuff the character with NULL instead.

    Good SQL, good night.

Please leave a reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s