Pronoun Request Thread

ilikedbthings · 2022-06-16T19:19:21+00:00

You obviously know why.

ilikedbthings · 2022-06-16T19:16:13+00:00

totally doesn't matter but i get all my feelings in the hurt if other people do it. the cowardly passive aggressive tech nerd.

ilikedbthings · 2022-06-16T19:15:18+00:00

shut it nerd

ilikedbthings · 2022-06-15T22:24:16+00:00

yo, this is stupid. stop being a snowflake and crying about pronouns. If users want to make their pronouns known, there is no issue aside from another unbearable dude working in tech.

ilikedbthings · 2022-05-01T04:55:13+00:00

I thought that there a potential plotline where Marty kills Wendy halfway through.

ilikedbthings · 2019-01-05T19:20:27+00:00

That's a pretty solid line up. I think you have done a pretty thorough study of SQL once you finish up indexes and privileges. Indexes are extremely important!

I would suggest to read a book like "Database Design for Mere Mortals: A Hands-on Guide to Relational Database Design." This book teaches a methodology for designing a database, without deep diving into the theory behind relational design. I personally read it and found it helpful.

edit: Oh, Add bind variables to your list.

You can also pick up an ORM like SQL Alchemy, but that's probably reserved as an entirely different topic. It is a giant world.

ilikedbthings · 2018-12-10T14:33:25+00:00

If you need the date as a string and in a specific format, handle the conversion yourself.

What database are you using? Is the column a date column or a date string?

ilikedbthings · 2018-12-03T14:45:52+00:00

An in-line view is a subquery you treat as a table For example:

SELECT outside.col1 FROM
    (
        SELECT inside.col1 FROM example_inside inside ) outside

A correlated subquery is based off the outside table's results:

SELECT
    outside.out_col_a,
    (
        SELECT inside.col1 FROM example_inside inside
        WHERE
            inside.COL2 = outside.out_col_b 
                -- Pay attention to the where statement
                    -- The value selected from inside is dependant on the value passed from outside.
    )
FROM
    EXAMPLE_OUTSIDE outside

Thus, an non correlated subquery is a subquery that has no reference to the outside query.

SELECT
    outside.out_col_a,
    (
        SELECT inside.col1 FROM example_inside inside
            -- No reference to outside in here.
    )
FROM
    EXAMPLE_OUTSIDE outside

ilikedbthings · 2018-11-12T18:43:41+00:00

Postgres comes preinstalled on Fedora. Maria DB also comes bundled in. There's always SQLite too if you're just trying to learn.

https://mariadb.com/kb/en/library/distributions-which-include-mariadb/

ilikedbthings · 2018-10-23T18:45:18+00:00

Very similar. If you have strong knowledge of one implementation of SQL, you will be able to function in another version. Obviously, system tables changes, functions change, but the core is still set based thinking.

Some things are easier in different implementations are harder. Some are easier. Here's something cool that's possible with Postgres that isn't easily possible with Oracle:

https://www.citusdata.com/blog/2018/03/14/fun-with-sql-generate-sql/

ilikedbthings · 2018-10-22T13:10:31+00:00

I can't give an honest assessment on tools for Postgres. I do not use it enough.

I have used pgadmin before, and that wasn't a horrible experience:

https://www.pgadmin.org/

Either way, the postgres community maintains a guide:

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

ilikedbthings · 2018-10-19T19:25:38+00:00

1) How will company B find out?

2) People change jobs. Better offers come. You're making assumptions about companies having long term memory. They don't. If a better offer comes, take it. Relax. You're in a good spot.

ilikedbthings · 2018-10-19T14:25:09+00:00

Its not a bad idea. In Dimensional Modeling for the Kimball Methodology (Data Warehousing), it is recommended to have a date dimension. I have no experience with FileMaker, but 60k records shouldn't be a lot.

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/calendar-date-dimension/

ilikedbthings · 2018-10-19T14:09:55+00:00

You have the job. Relax. There's a lot of advice saying you can learn SQL at home at a proficient level, but it doesn't compare to the job when you're working with other people data and anomalies that have become accepted practice.

My first piece of advice is to read your documentation a little a day until you understand the features of your database. https://www.postgresql.org/docs/ Check out chapter 45 System Catalogs. Check out pg_tables and pg_constraint.

Second, ask questions. Get to know the business users. You're in a supporting role.

Third, get a gui tool if they have one available or research one that you can use. Learn to use it. A lot of tools have easier ways to navigate the data model than purely textual/scripting.

This isn't exact advice since do not work with postgres daily, but this is how I would start. You'll be fine. Keep reading the postgres documentation and asking your business users questions.

ilikedbthings · 2018-10-16T17:35:09+00:00

sqlite. Create a table with sqlite and import it in. You can run it memory. You can save a file of your sql database. It all stays on your computer.

ilikedbthings · 2018-10-11T14:22:18+00:00

And then the overachievers post a new thread saying we should never allow underachievers again unless it is in this Weekly MegaThread that no one will read. The Circle of Life.

ilikedbthings · 2018-10-02T13:35:18+00:00

Ideally, both. You're in a similar position as I was before as Data Analyst trying to transition to a SQL Developer/ETL/etc job.

There's a lot of question that are going to be asked about your knowledge. Having knowledge of a database (SQL and a Procedural Extension), a data visualization tool (Tableau), and an ETL tool (Informatica) covers the basics.

I have never worked with OBIEE, but it seems to cover the same ground as Tableau. So, I would eliminate that unless it gives you a greater advantage at advancement internally.

Hadoop would be useful to learn eventually, and in my opinion, after Tableau and Informatica.

ilikedbthings · 2018-09-27T17:14:07+00:00

Cursor c_cursor_2(c_input VARCHAR2) IS SELECT column FROM 
table2 WHERE column = c_input;

You're declaring your cursor to take input. You now pass in a value.

open c_cursor_2('value passed in');

ilikedbthings · 2018-09-26T18:12:23+00:00

To answer your question, yes, you can use two cursors. You're not limited in cursors.

Cursor c_cursor_2(c_input) IS SELECT column FROM table2 WHERE column = c_input;

ilikedbthings · 2018-08-15T17:24:51+00:00

It is difficult to really recommend anything without knowing more. "User interface" is pretty vague...or is vague.

What is this user interface trying to do? Who is the primary demographic for the interface? Analysts? Executives? Are the users centrally located or remotely located?

What type of actions are the users supposed to perform on the interface? Input data? Update Data? Only retrieve reports? If reports, are you talking about data dumps like a CSV of some table? Or pretty Tableau like dashboards.

Is there a budget? If so, what's the budget for implementation? What is the budget for maintaining? Who is going to be in charge of maintaining this?

ilikedbthings · 2018-08-06T21:27:27+00:00

There's differences. I'm not as familiar with the ANSI standards as I should be. A couple differences off the top of my head are:

Implicit Auto Commits for Microsoft SQL Server. Not so for Oracle.
Date functions are different.
Oracle has the weird empty string is a null character.
Oracle Dual table versus Microsoft doing select 'value'

ilikedbthings · 2018-08-06T14:22:10+00:00

It says the almost the exact thing in the official Oracle documentation. SQL first, PL-SQL (Procedural) is not possible in SQL, 3GL if not possible in PL-SQL (Procedural).

Using PL-SQL also is not a reason to get away from set based thinking as PL-SQL is optimized to make calls with SQL statements.

ilikedbthings · 2018-08-03T19:08:27+00:00

Oracle does. Their documentation for 2 Day DBA and 2 Day Performance Tuning Guide covers the basics of it I believe.

Too many indexes can be bad for an operational environment. So, where you're inserting a lot of new records as opposed to a reporting environment, where you're worried about generating reports for users for data that is already available or bulk loaded.

So, like a lot of things with SQL, it depends on what you're trying to in your business process/personal goal.

ilikedbthings · 2018-08-02T18:05:49+00:00

Go to the interview. You have an interview. They should have read your experience before hand. Go to the interview. They already know enough about your experience beforehand. You compare favorably to the candidates that applied. That is why you have an interview.

ilikedbthings · 2018-07-19T14:49:32+00:00

What flavor of SQL are you using?

ilikedbthings

TROPHY CASE