SQL Fundamentals in SQL Server

1 Day | Price: $425

This workshop covers the basics of SQL to effectively transform information contained in databases into information that is usable by a variety of sources. The workshop assumes that users have a basic familiarity with databases and an understanding of relational database concepts.
1 – Introducing SQL
  • Understanding SQL
  • Overview of syntax
2 – Retrieving data from a table
  • Selecting records
  • Selecting columns
  • Creating column/table aliases
  • Filtering data rows
  • Ordering data
  • Working with aggregate functions
  • Grouping data
  • Filtering a group
3 – Using operators
  • Using logical operators
  • Using list operators
  • Using string operators
4 – Using String functions
  • Pulling out parts of strings
  • Concatenating data
  • Locating specific items in strings
5 – Using date functions
  • Using system date
  • Displaying month, day or year
  • Adding and substracting dates
6 – Using joins
  • Overview of joins
  • Creating inner joins
  • Creating outer joins
StartsRegister