Introduction to SQL Server

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Beginner

Teaching Type

Self Paced

Video Content

4 hours

Course Description

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!

Course Overview

Virtual Labs

Job Assistance

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Become proficient at using SQL Server to perform common data manipulation tasks

You'll become proficient in the most common data manipulation tasks in SQL Server and build a solid foundation for the upcoming T-SQL courses here on DataCamp!

You'll mainly work with the Chinook digital media database, representing sales of various artists and tracks

Course Content

Expand all sections

Module 1: SELECTion Box

Module 2: Groups, strings, and counting things

Module 3: Joining tables

Module 4: You've got the power

Course Instructors

John MacKintosh

Data Manager

I work in the UK healthcare sector. I was introduced to SQL and SQL Server in 2010. My course aims to help those who are coming from spreadsheets, or who are otherwise new to SQL Server, to get u...