This class is for web administrators, web developers, analysts, or anybody else wanting to learn how to write simple to complex queries to retrieve and manipulate data from a SQL Server or other similiar database.
SQL stands for Structured Query Language. SQL is a standard language that was designed to query and manage data in relational database management systems (RDBMS). An RDBMS is a database management system that is used today in every type of desktop or web-based application. Microsoft provides T-SQL (Transact SQL) as a dialect of, or extension to, SQL in Microsoft SQL Server, its RDBMS
Microsoft SQL Server is one of the most popular RDBMS used today and a solid understanding of T-SQL is critical if you want to have a successful career in Microsoft application development (desktop or web).
The class is only $25 and there are no other materials or software needed to purchase.
Topics covered:
Week 1: Setting up SQL Server 2008 Express & Management Studio
Week 2: SELECT statements; Predicates and Operators, Case Expressions
Week 3: Joins: Cross, Outer and Inner
Week 4: Subqueries
Week 5: Data Modification: Inserting, Updating, Deleting and Merging
Week 6: Programmable Objects: Variables, Routines and Functions
To give you an idea of how each lesson looks, here is the first lesson (.pdf).
Materials for Class
All the course materials for the class are sent via email as attachments within 48 hours of payment. Feel free to contact me if you have any questions.
