From the course: SQL Essential Training
Join today to access over 24,700 courses taught by industry experts.
Column custom names - SQL Tutorial
From the course: SQL Essential Training
Column custom names
Let's get into something that's pretty important with regard to communication of your query results. Now, often the technical language of a database will differ from the common language of a business. If we look at our example here, the way that our WSDA music database stores the first name in the customer table is not in the most readable way. Now, what I'm referring to is the column name. First name is all one word, even though it really is two distinct words. The same goes for last name. In SQL, we have ways of improving the communication of our results to our business audience. And we do this via something called aliases. aliases allow us to rename our columns to names that are more appropriate to the business. So in our example here, we have first name, last name, e-mail, and WSDA music management usually refers to these particular columns as customer first name, customer last name, and customer e-mail. Now, how would we go about actually communicating these particular column…
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.