Deals Of The Week -
hours only!
Up to 80% off on all courses and bundles.
-
Close
Ad-blocking extension has been detected. Please disable it. It may cause problems.
Vertabelo Academy
Menu
Log in
Create free account
Back to course details
Light
on
off
32/54
Practice time!
Introduction
1. Introduction
2. The Route table
3. The Aircraft table
4. The Flight table
Dealing with dates
5. Dates in T-SQL
6. DATE: The T-SQL default format
7. Using logical operators with dates
8. Using BETWEEN with dates
9. Sorting dates with ORDER BY
10. Practice time!
Working with time data
11. Time in T-SQL
12. Using logical operators with time
13. Using BETWEEN with time
14. Sorting by TIME columns
15. Practice time!
Date and time date
16. Date and time
17. Date and time data types
18. Using date and time with constant values
19. Using BETWEEN with date and time data
20. Sorting date and time data with ORDER BY
21. Practice time!
Extracting dates and times
22. The YEAR(), MONTH(), and DAY() functions
23. Using YEAR(), MONTH(), and DAY() with aggregate functions
24. Using the DATEPART() function
25. Using the DATEPART() function in grouping
26. The DATENAME() function
27. Practice time!
Doing arithmetic with dates
28. The DATEADD() function
29. The DATEADD() to subtract dates
30. The DATEDIFF() function
31. The EOMONTH() function
32. Practice time!
Converting date and time data
33. The CAST() function
34. The CONVERT() function
35. The AT TIME ZONE function
36. The FORMAT() function
37. Practice time!
Current date and time data
38. Getting the current date and time in T-SQL
39. The CURRENT_TIMESTAMP and GETDATE() functions
40. The GETUTCDATE() function
41. High-precision date and time functions
42. Current date and time
43. Current date and time in queries
44. Current date and time in queries—additional practice
45. What we've learned so far
Building date and time data from parts
46. The DATEFROMPARTS() function
47. Other functions
Summary and review
48. Summary
49. Exercise 1
50. Exercise 2
51. Exercise 3
52. Exercise 4
53. Exercise 5
54. Congratulations
Instruction
Fantastic! Let's practice before we move on!
Exercise
Count the number of flights performed in
August 2015
.