SQL Intermediate Course
Take your SQL skills up a level
Our Intermediate SQL course builds upon the skills learnt in our SQL Beginner course.
In this SQL course, you will move beyond using basic SELECT clauses for retrieving data. Learn to work with many different types of functions and expressions that modify the way data is returned in the result set. Students will use built-in T-SQL functions for working with string, date and numeric data types and will calculate moving averages, running totals and percentages using window functions.
Learn to use subqueries to perform more complex querying and to use views to to simplify querying. Students will also create their own user-defined functions to encapsulate business logic and improve efficiency. Read our course outline below.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
Frequently Asked Questions
Meet your Developer
What is Remote Training?
Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually. With remote learning students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Intermediate Course Details
SQL Course Outlines
SQL City Pages
Skills Test
Contact Us
What do I need to know to attend?
This course builds on the knowledge gained and skills taught in our SQL Beginner course.
Students must be familiar with writing SQL queries.
SQL Intermediate Learning Outcomes
In this course, you will:
- work with an Azure SQL database
- write queries in Transact-SQL (T-SQL)
- learn to use T-SQL built-in functions
- learn to create user-defined functions
- learn to write subqueries and create views
SQL Intermediate Course Content
- Introduction
- SQL and T-SQL
- Data Types
- Conversion between data types
- CAST, CONVERT and PARSE
- Functions in SQL
- Built-in Functions
- Aggregate Functions
- Scalar Functions
- Ranking Functions
- User-defined functions
- Aggregate Functions and Group By Extensions
- GROUP BY CUBE, ROLLUP and GROUPING SETS
- CASE and CASE alternatives
- COALESCE
- NULLIFF
- String Functions
- Concatenate, replace and format
- Date and Time Functions
- Get today's date
- Calculate date/time differences
- Calculate a new date
- Extracting date components
- Creating dates
- Logical Functions
- IIF
- CHOOSE
- GREATEST and LEAST
- Mathematical Functions
- ROUND, CEILING and FLOOR
- Writing More Complex Queries
- Subqueries
- Views
- Window Functions
- OVER clause
- Calculate percentages, moving averages, and running totals
- LAG and LEAD
- FIRST_VALUE, LAST_VALUE
- Ranking Functions
- ROW_NUMBER
- RANK and DENSE RANK
- NTILE
- User-Defined Functions
- Scalar user-defined functions
- Schemas
- Local variables
- Control-of-flow statements
- Query Performance
- Improving query performance
Contact Us
phone
email
enquiry
-
Log in from your Desk
-
Instructor Led Training
-
Your Questions Answered -
-
