Reporting with SQL

Focused View

Andrew Chalkley

1:11:07

196 View

1 Ordering, Limiting and Paging Results

1-1-Overview.mp4

03:07

1-2_1-Retrieving Results in a Particular Order.mp4

05:13

1-3-Limiting the Number of Results.mp4

02:49

1-4-Paging Through Results.mp4

02:33

1-5-Practice Session.mp4

01:08

2 Working with Text

2-1-What Are Functions.mp4

03:12

2-2- Adding Text Columns Together.mp4

03:39

2-3- Finding the Length of Text.mp4

02:50

2-4-Changing the Case of Text Columns.mp4

02:45

2-5-Creating Excerpts From Text.mp4

02:19

2-6-Replacing Portions of Text.mp4

01:58

2-7-Practice Session.mp4

03:27

3 Aggregate and Numeric Functions

3-1-Counting Results.mp4

04:41

3-2-Counting Groups of Rows.mp4

02:21

3-3-Getting the Grand Total.mp4

05:31

3-4-Calculating Averages.mp4

02:01

3-5-Getting Minimum and Maximum Values.mp4

02:08

3-6-Performing Math on Numeric Types.mp4

04:35

3-7-Practice Session.mp4

02:31

4 Date and Time Functions

4-1-Differences Between Databases.mp4

01:20

4-2-Creating Up-to-the-Minute Reports .mp4

02:17

4-3-Calculating Dates.mp4

04:03

4-4-Formatting Dates For Reporting.mp4

03:17

4-5-Practice Session.mp4

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

SQL

Andrew Chalkley

Instructor's Courses

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.