SQL Databases - Create SQL Database

• No pre-requisites are required for this course.

Who should attend?

• IT Professionals wanting to further their knowledge about creating SQL Database Queries using T-SQL should attend.

What will you learn?

• The ability to retrieve data from statements
• The ability to filter rows using logical comparisons
• The ability to group and aggregate data

Course Outline

• Introduction to Creating SQL Database Queries using T-SQL
• Overview of SQL Database
• Overview of SQL Query
• Overview of Transact-SQL (T-SQL)
• Overview of Retrieving Data
• Overview of Filtering Rows
• Overview of Sorting returned rows
• Overview of Grouping and Aggregating data
• Overview of Utilising Views and Stored Procedures
• Overview of Common Functions
• Overview of Basic comparisons
• Overview of SELECT statements
• Overview of Null-value manipulation functions