It’s that time again! Time to start up a new class and cover some more advanced topics in SQL Development. Before beginning these lessons, You need to be comfortable with all the material in my SQL101 series. Specifically you’re going to need to know SELECT, INSERT, UPDATE, and DELETE.
With those skills in hand, I’ll help you take the next steps in your education. Here are the topics I plan to cover in this class:
- INTERSECT, UNION, EXCEPT –Combine and compare result sets
- Sub Queries– when a join just won’t cut it
- Ranking Data – who’s the boss?
- Views –It’s like a table… but not
- CREATE TABLE– some times you’ll have to roll your own.
- IDENTITY Columns – the easiest primary key to implement
- IDENTITY INSERT –for those time you need to force a record in
- COMPUTED – there are some useful time savings you can do with these
- CONSTRAINT –make sure your data is what you think it is
- Primary Keys
- Foreign Keys – the basis of relational database systems
- ALTER TABLE – trust me, requirements change…therefore tables change
- SELECT INTO – make a backup, the easy way
- DROP/TRUNCATE/DELETE
- Variables
- remember data types
- table variables
- Errors –learn to deal with them now, before they get bad
- error number
- error text
- RAISERROR — create and raise your own errors
- CREATE PROCEDURE– now you start “real” programming
- Functions –remember sum, avg?
- CREATE FUNCTION
- scalar
- tvf
- OUTPUT – think of them as on demand triggers
- MERGE
- TRANSACTIONS
- CTE
- Recursive CTEs
There’s a LOT more to this class than 101, but when you’re done with this, you’ll be ready for any junior level SQL job you can find. Much of this I didn’t learn until I was well into my mid level positions.
As always, if you have any problems with the class, please let me know… I’m here to help!