Reporting with SQL

Focused View

Andrew Chalkley

1:11:07

221 View

01. Ordering, Limiting and Paging Results

01. Overview.webm

03:07

02. Retrieving Results in a Particular Order.webm

05:13

03. Limiting the Number of Results.webm

02:49

04. Paging Through Results.webm

02:33

05. Practice Session.webm

01:08

02. Working with Text

01. What Are Functions.webm

03:12

02. Adding Text Columns Together.webm

03:39

04. Finding the Length of Text.webm

02:50

05. Changing the Case of Text Columns.webm

02:45

06. Creating Excerpts From Text.webm

02:19

07. Replacing Portions of Text.webm

01:58

08. Practice Session.webm

03:27

03. Aggregate and Numeric Functions

01. Counting Results.webm

04:41

02. Counting Groups of Rows.webm

02:21

03. Getting the Grand Total.webm

05:31

04. Calculating Averages.webm

02:01

05. Getting Minimum and Maximum Values.webm

02:08

06. Performing Math on Numeric Types.webm

04:35

07. Practice Session.webm

02:31

04. Date and Time Functions

01. Differences Between Databases.webm

01:20

02. Creating Up-to-the-Minute Reports.webm

02:17

03. Calculating Dates.webm

04:03

04. Formatting Dates For Reporting.webm

03:17

05. Practice Session.webm

01:22

Description

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.