- Databases
- Beginner
About this Course
SQL can be used to generate reports and present information on websites. This course covers powerful SQL features in helping you answer more interesting questions about your data.
What you'll learn
- Ordering, limiting and paging through a result set
- Manipulating text
- Working with numbers
- Working with dates
Ordering, Limiting and Paging Results
Databases can store a lot of data. Retrieving all of that in one go isn't performant or helpful to users.
9 stepsWorking with Text
Being able to manipulate text is vital for displaying information in a more human readable or standardized way. In this stage we'll take a look at some key ways we can format and manipulate text.
14 steps-
What Are Functions?
3:12
-
Adding Text Columns Together
3:39
-
Single vs Double Quotes
-
Concatenating Text
2 objectives
-
Finding the Length of Text
2:50
-
Getting the Length of a String
1 objective
-
Changing the Case of Text Columns
2:45
-
Changing Cases of Strings
2 objectives
-
Creating Excerpts From Text
2:19
-
Creating Excerpts
1 objective
-
Replacing Portions of Text
1:58
-
Replacing Strings
1 objective
-
Practice Session
3:27
-
Review: Working with Text
5 questions
Aggregate and Numeric Functions
Performing mathematic operations on groups of rows, like getting a total or getting an average is super handy. In this stage you'll learn this and more.
14 steps-
Counting Results
4:41
-
Counting Results
2 objectives
-
Counting Groups of Rows
2:21
-
Counting Groups
2 objectives
-
Getting the Grand Total
5:31
-
Summing Values
1 objective
-
Calculating Averages
2:01
-
Averaging Values
1 objective
-
Getting Minimum and Maximum Values
2:08
-
Calculating the Minimum and Maximum Values
1 objective
-
Performing Math on Numeric Types
4:35
-
Performing Math
1 objective
-
Practice Session
2:31
-
Review: Aggregate and Numeric Functions
5 questions
Date and Time Functions
Displaying results based on dates and times is crucial for reporting and presenting information that's time sensitive or to perform analysis. We'll take a look at how we can use dates in our reporting and how we can format dates too.
9 stepsTeacher
-
Andrew Chalkley
I'm an alien, I'm a legal alien, I'm an Englishman in Portland. All of my professional life I've worked with computers online. I'm a polyglot programmer and like using the right tools for the job. In my spare time I enjoy spending time with my family and when I get chance, sticking opponents in Halo 4.