Course Outline
Foundations
- Selecting all columns/fields
- Selecting specific columns/fields
- Utilizing distinct/unique values
- Selecting specific rows/records
- Selecting values within a range
- Selecting values that match a pattern mask
- Selecting values present in a list
- Handling null values
- Sorting and ordering data
- Selecting calculated and derived values
- Customizing column headings in query results
- Exporting query results to external files
Joining Tables
- Principles of table joining:
- Using cartesian joins
- Using inner joins
- Using non-equi joins
- Using outer joins
Combining Queries
- Union operator
- Intersect operator
- Except operator
Simple Functions
- Conversion functions
- Date functions
- Number functions
- Text functions
- Group/summary/aggregate functions
Sub-Queries
- Principles of sub-queries
- Filtering rows from the main query
- Employing nested sub-queries
- Utilizing multi-column sub-queries
- Implementing correlated sub-queries
- Using sub-queries as inline views and common table expressions
- Incorporating sub-queries as columns in the main query
Case Statements
- Principles of case statements
- Using case statements to derive column values
- Employing nested case statements
- Using case statements to create pivot tables
- Integrating case statements with sub-queries
Data Manipulation
- Inserting values into a table
- Copying values between tables
- Updating values
- Deleting records
- Modifying data via views
- Managing transactions
- Locking rows and tables
Data Definition
- Principles of relational databases and data normalization
- Using primary key and foreign key relationships and constraints
- Creating tables
- Altering tables
- Creating views
- Using synonyms
- Dropping tables and views
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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
