Introduction to SQL Server

SQL Server is a vital skill for data analysts. It is the most widely used database in the world. This course will show you how to create simple SQL statements, and refine your queries with ORDER BY and WHERE clauses. Learn how to combine, aggregate, and work with strings. This course will show you how to create tables, as well as the most common ways to join them. You'll also learn how to insert or update data. Your main tool will be the Chinook digital media database. It also includes artist and track sales. The Eurovision and old music databases can be used to continue the music theme. We will also be looking at trends in American power outages. SQL Server will allow you to perform data manipulation tasks. This will prepare for the DataCamp T-SQL courses!