Description
Audience Profile
This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.
At Course Completion
After completing this course, students will be able to:
- Create single table SELECT queries
- Create multiple table SELECT queries
- Filter and sort data
- Insert, update, and delete data
- Query data using built-in functions
- Create queries that aggregate data
- Create subqueries
- Create queries that use table expressions
- Use UNION, INTERSECT, and EXCEPT on multiple sets of data
- Implement window functions in queries
- Use PIVOT and GROUPING SETS in queries
- Use stored procedures in queries
- Add error handling to queries
- Use transactions in queries
Prerequisites
- Basic understanding of relational databases.
- Basic Windows knowledge.