Your cart is empty
Total:
Intro to SQL Server and T-SQL
closed
Taught by
Jeremy S.
Subject:
Programming
- Saturday June 8, 9:00 - 12:00 Add to calendar
Installation of SQL Server. Creating a database and security options for accessing it. Creating schemas, tables (with proper keys), stored procedures, functions, and understanding their purposes. Inserting, updating, selecting, and deleting data from tables.
Requirements: Windows 7 laptop
When you register classes, an account will be created at txrxlabs.org using your email address. You will be emailed login credentials. Most people who take classes with us just ignore this email, and that is fine.
Come to the lab in person and ask to see Roland or any officer. They can accept payment and give you a receipt. Some classes do have an enrollment cap, so it is better to do this sooner than later.
Most classes are for beginners, and clicking on the class title will take you to the class detail page. The right column shows prerequisites and requirements. If you mouse over them you will see what is required for that class. Some classes require a brief safety class which is taught 20 minutes before the class. Additionally, there may be fee notes which explain how much of the cost goes towards materials.
Comments
bebuxe - Wednesday, 29 May at 03:30
So what version of T-SQL do we need to install? Or will a copy be provide?
Login to reply to this commentPS
I really wanted this to be about pgSQL, but I can live with this intro.
jeremysouthard - Wednesday, 29 May at 06:07
The installation process is part of the class due to the multitude of options during installation, but I can write up a quick installation guide and give you the settings to select if you want to get started on your own. Is that something you'd be interested in?
I've never used postgreSQL so I can't comment on the differences without parroting the results from a google search on a comparison, but I assume the basic T-SQL information would apply in most cases. I prefer to create, modify, and delete the database objects via T-SQL, so this class will not take you through the SQL Server "wizards" for creating them, but show how to write a script to do the work. I find this to be a faster method of database object manipulation, with the added benefit of understanding "why" these objects work the way they do.
Login to reply to this commentbebuxe - Wednesday, 29 May at 07:01
Ah, no then. If installation is part of the class, then I'd rather enjoy it there. I am just too excited to learn after finally taken the time to at the least get acquainted with the ACID standard.
Login to reply to this commentPS
Hopefully I'll be come a nightly member too they day before. I am way past my bedtime posting this. I still have books collecting dust, e.g. ISBN 0-9546120-2-7.