SQL Development

It's been awhile /prog/ trying to ditch front end programming because it's just tedious busy work with no thought required and trying to get into backend SQL development/database developer.

I know SQL and I know T-SQL quite a bit. I can analyze a query plan, I know the differences between tables, temp tables, table variables, Common Table Expressions, and table valued parameters. I know how to use cursors. I make frequent use of transactions.

Is there anything else I really need? I mean due to doing front end development for so long the only people I can get replies from are basic entry level which I assume I'll take just to get my foot in the door, but I'm concerned that I might be missing something as I have one interview coming up this week, which in the phone portion all they asked me was if I knew about joins (not very promising at all it would seem)...


so any advice or preping you can offer?

oh also DDL and DML triggers along with DML actions on views

install gentoo

>>3
already did

>>4
Then you've already failed the test

learn object oriented database systems

>>3
arch linux master race reporting in

>>7
It's still linux.

>>8
I'm really happy for you and Ima let you finish, but what you’re refering to as Linux, is in fact, GNU/Linux, or as I’ve recently taken to calling it, GNU plus Linux. Linux is not an operating system unto itself, but rather another free component of a fully functioning GNU system made useful by the GNU corelibs, shell utilities and vital system components comprising a full OS as defined by POSIX.

Many computer users run a modified version of the GNU system every day, without realizing it. Through a peculiar turn of events, the version of GNU which is widely used today is often called “Linux”, and many of its users are not aware that it is basically the GNU system, developed by the GNU Project.

There really is a Linux, and these people are using it, but it is just a part of the system they use. Linux is the kernel: the program in the system that allocates the machine’s resources to the other programs that you run. The kernel is an essential part of an operating system, but useless by itself; it can only function in the context of a complete operating system. Linux is normally used in combination with the GNU operating system: the whole system is basically GNU with Linux added, or GNU/Linux. All the so-called “Linux” distributions are really distributions of GNU/Linux.

Is there anything else I really need?
http://en.wikipedia.org/wiki/Relational_algebra

>le pedophile sage