Customer Behavior Analysis in SQL Server

What you get?

Fully interactive online courses. Just you, SQL, Python, R and the web browser.

Instant access to lessons. You decide when and how long you want to learn.

Hundreds of SQL, Python, R exercises to master Your skills.

Course completion certificate to show the world that you really can!

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

15/17 Question 1

1. Welcome

2. The data model

3. Customer registrations in a time period

4. Registrations in a time period with DATEADD()

5. Calculating the beginning of the current time period

6. Registration count for the current time period

7. Registration over time report – single date part

8. Registration over time report – multiple date parts

9. Registration over time report – exercise with multiple date parts

10. Weekly registration report – displaying week label

11. Customer cohorts

12. Customer cohort report

13. Customer cohort report – exercise

Okay, the first question comes now!

Show the number of registrations in the current year. Name the column RegistrationsThisYear.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Create a free accountand start learning now!

What you get?

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Instruction

Exercise

Stuck? Here's a hint!

Need assistance?