Reporting with SQL

سرفصل های دوره

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

01. Ordering, Limiting and Paging Results

01. Overview

02. Retrieving Results in a Particular Order

03. Limiting the Number of Results

04. Paging Through Results

05. Practice Session

02. Working with Text

01. What Are Functions

02. Adding Text Columns Together

04. Finding the Length of Text

05. Changing the Case of Text Columns

06. Creating Excerpts From Text

07. Replacing Portions of Text

08. Practice Session

03. Aggregate and Numeric Functions

01. Counting Results

02. Counting Groups of Rows

03. Getting the Grand Total

04. Calculating Averages

05. Getting Minimum and Maximum Values

06. Performing Math on Numeric Types

07. Practice Session

04. Date and Time Functions

01. Differences Between Databases

02. Creating Up-to-the-Minute Reports

03. Calculating Dates

04. Formatting Dates For Reporting

05. Practice Session

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

مدرس: Andrew Chalkley