This course covers:
? How to use SELECT statements to retrieve data
? How to use SQL Server aggregate functions
? How to manipulate text fields
? How to retrieve data from multiple sources
? All of the key aspects of working with data in SQL Server
Each time you're introduced to a new concept or function, you'll have the opportunity to test your knowledge and build your confidence. You'll work with a digital media database to review the sales of various artists and tracks, Eurovision datasets, and review trends in US power outages to explore a number of different data types and scenarios.