Course Outline
Core Concepts
- Selecting all columns or fields
- Selecting specific columns or fields
- Utilizing distinct and unique values
- Selecting specific rows or records
- Selecting values within a defined range
- Selecting values that match a specific pattern
- Selecting values from a specified list
- Handling null values effectively
- Sorting and ordering data
- Selecting calculated and derived values
- Customizing column headings in query results
- Exporting query results to external files
Combining Tables
- Understanding table join principles:
- Applying cartesian joins
- Applying inner joins
- Applying non-equi joins
- Applying outer joins
Merging Query Results
- Using the Union operator
- Using the Intersect operator
- Using the Except operator
Essential Functions
- Data conversion functions
- Date manipulation functions
- Numeric functions
- Text manipulation functions
- Grouping, summarization, and aggregate functions
Sub-Queries
- Understanding sub-query principles
- Filtering rows from the main query
- Implementing nested sub-queries
- Utilizing multi-column sub-queries
- Employing correlated sub-queries
- Using sub-queries as inline views and Common Table Expressions (CTEs)
- Incorporating sub-queries as columns within the main query
Case Statements
- Understanding the principles of case statements
- Deriving column values using case statements
- Implementing nested case statements
- Creating pivot tables with case statements
- Integrating case statements with sub-queries
Data Manipulation
- Inserting values into a table
- Copying values between tables
- Updating existing values
- Deleting records
- Modifying data through views
- Managing transactions
- Locking rows and tables for concurrency control
Data Definition
- Understanding relational database principles and data normalization
- Implementing primary and foreign key relationships and constraints
- Creating tables
- Altering existing tables
- Creating views
- Utilizing synonyms
- Dropping (removing) tables and views
Testimonials (6)
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Łukasz was very good. I liked how Łukasz talked about best practices. Pace was good. I liked the exercises. Having a wiki for future reference is good
Jake Real - Welsh Revenue Authority
Course - Transact SQL Basic
Lukasz was very patient and knowledgeable and made learning SQL very fun and informative. Easily one of the most rewarding training sessions of any subject I've had the pleasure of being part of!
Carwyn - Welsh Revenue Authority
Course - Transact SQL Basic
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
Course - Transact SQL Basic
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Course - Transact SQL Basic
Interactive exercises
