Date and Time Fundamentals in .NET and SQL Server

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Teaching ApproachNo fluff, no ranting, no beating the air. I esteem your time. The course material is succinct, yet comprehensive. All the important concepts are covered. Particularly important topics are covered in-depth. For absolute beginners, I offer my help on Skype absolutely free, if requested.Take this course, and you will be satisfied.Build a solid foundation of working with Date and Time with this courseAlmost all the software works with date and time in one form or another. Some programs, of course, need to work with date and time more than other. However, date and time hide many pitfalls even in very simple scenarios. We all know that security and logging are regular aspects of almost any program. There is a wise phrase that sounds like: “Developers recall about security when it is too late.” The same can be said about date and time. Most developers don’t even imagine how many bugs are hiding behind the simple face of date and time. Those bugs are sitting in programs and waiting for their moment to blow up your production code causing very unfortunate repercussions. That’s why working with date and time is the full-fledged and very important aspect of software development.Have you watched magnificent enlightening TV Shows by BBC? This course in some parts is like those BBC shows, because you’ll learn many interesting surprising facts. Besides, being familiar with peculiarities of working with date and time, you can write much more reliable and maintainable applications.Content and OverviewThis course is aimed at all kind of developers. It provides solid theoretical base reinforced by practical material.
.
We start with basics of date and time. I’ll show you some real cases when bugs related to date and time caused unpleasant consequences, event deaths of people. You’ll learn why the hell Gregorian calendar was introduced, why the 5th of October 1582 doesn’t exist at all eatures provided by this library. You’ll...

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Use date & time related types from BCL properly
Use Noda Time for writing reliable code
Avoid common mistakes
Apply best practices of working with date and time values

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Perspective
  • PC training
  • PC
  • Database training
  • SQL
  • Database
  • Server
  • Unix

Course programme

Theoretical Background 14 lectures 50:20 How to Ask Questions Outline Why You Need to Learn About Date and Time Problems with Dates and Times How a PC Stores and Measures Time Timers (Counters). Advanced Lecture Atomic Time UTC and GMT Introduction to Time Zones Date Formats Unix and Epoch Time Scope Perspective Theoretical Background - Conclusion Theoretical Background 14 lectures 50:20 How to Ask Questions Outline Why You Need to Learn About Date and Time Problems with Dates and Times How a PC Stores and Measures Time Timers (Counters). Advanced Lecture Atomic Time UTC and GMT Introduction to Time Zones Date Formats Unix and Epoch Time Scope Perspective Theoretical Background - Conclusion How to Ask Questions How to Ask Questions How to Ask Questions How to Ask Questions Outline Outline Outline Outline Why You Need to Learn About Date and Time Why You Need to Learn About Date and Time Why You Need to Learn About Date and Time Why You Need to Learn About Date and Time Problems with Dates and Times Problems with Dates and Times Problems with Dates and Times Problems with Dates and Times How a PC Stores and Measures Time How a PC Stores and Measures Time How a PC Stores and Measures Time How a PC Stores and Measures Time Timers (Counters). Advanced Lecture Timers (Counters). Advanced Lecture Timers (Counters). Advanced Lecture Timers (Counters). Advanced Lecture Atomic Time Atomic Time Atomic Time Atomic Time UTC and GMT UTC and GMT UTC and GMT UTC and GMT Introduction to Time Zones Introduction to Time Zones Introduction to Time Zones Introduction to Time Zones Date Formats Date Formats Date Formats Date Formats Unix and Epoch Time Unix and Epoch Time Unix and Epoch Time Unix and Epoch Time Scope Scope Scope Scope Perspective Perspective Perspective Perspective Theoretical Background - Conclusion Theoretical Background - Conclusion Theoretical Background - Conclusion Theoretical Background - Conclusion Time Zones 6 lectures 25:57 Time Zones - Outline Daylight Saving Time (DST) What is a Time Zone? IANA Time Zone Database (TZDB) Microsoft Time Zone Database Time Zones - Conclusion Time Zones 6 lectures 25:57 Time Zones - Outline Daylight Saving Time (DST) What is a Time Zone? IANA Time Zone Database (TZDB) Microsoft Time Zone Database Time Zones - Conclusion Time Zones - Outline Time Zones - Outline Time Zones - Outline Time Zones - Outline Daylight Saving Time (DST) Daylight Saving Time (DST) Daylight Saving Time (DST) Daylight Saving Time (DST) What is a Time Zone? What is a Time Zone? What is a Time Zone? What is a Time Zone? IANA Time Zone Database (TZDB) IANA Time Zone Database (TZDB) IANA Time Zone Database (TZDB) IANA Time Zone Database (TZDB) Microsoft Time Zone Database Microsoft Time Zone Database Microsoft Time Zone Database Microsoft Time Zone Database Time Zones - Conclusion Time Zones - Conclusion Time Zones - Conclusion Time Zones - Conclusion Date and Time in the .NET Framework 9 lectures 38:52 .NET Framework - Outline DateTime Structure DateTime Roundtrip Example DateTimeOffset TimeZoneInfo - Working with Time Zones TimeSpan Calendars Stopwatch Conclusion on BCL Types Date and Time in the .NET Framework. 9 lectures 38:52 .NET Framework - Outline DateTime Structure DateTime Roundtrip Example DateTimeOffset TimeZoneInfo - Working with Time Zones TimeSpan Calendars Stopwatch Conclusion on BCL Types .NET Framework - Outline .NET Framework - Outline .NET Framework - Outline Calculating a Birthday Calculating a Birthday Scheduling Events Scheduling Events Scheduling Events Scheduling Events Dates and Times - Date Formats Dates and Times - Date Formats Dates and Times - Date Formats Dates and Times - Date Formats Working with Ranges Working with Ranges Working with Ranges Working with Ranges Other Best Practices Other Best Practices Other Best Practices Other Best Practices ...

Additional information

You should have some experience in C# (nothing more)

Date and Time Fundamentals in .NET and SQL Server

£ 10 + VAT