From the course: Introduction to Career Skills in Data Analytics
Join today to access over 25,100 courses taught by industry experts.
Transforming data in SQL
From the course: Introduction to Career Skills in Data Analytics
Transforming data in SQL
- [Instructor] If you are a data analyst, at some point you will encounter or hear SQL or SEQUEL. Let's start with the basics. SQL stands for Structured Query Language. Structured query language is vast. It's not unlike any other language. SEQUEL, however, is a computer language that works with data and the relationships between them. Microsoft SQL Server is a relational database management system developed by Microsoft with the primary function of being storing and retrieving data, although it does so much more. It was developed over 30 years ago and it does a lot of different things with data. And it's important to understand you don't need to know them all. As a data analyst, you do need to know some basic queries. A basic query allows you to select data from the database. There are two required statements for a SELECT. You must know what you want and where you want it from. This is the SELECT and the FROM statement.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.