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