Date and Time Fundamentals in .NET and SQL Server

所在平台: Udemy

课程主页: https://www.udemy.com/course/date-and-time-fundamentals/

课程评论:没有评论

第一个写评论        关注课程

课程简介

课程名称:.NET 和 SQL Server 日期与时间基础 课程概述:本课程强调高效的教学方式,没有多余的废话,尊重学员的时间。课程内容简洁而全面,涵盖所有重要概念,特别是对关键主题进行了深入讲解。针对绝对初学者,提供免费的Skype帮助。通过本课程,您将建立扎实的日期和时间处理基础,因为几乎所有软件都涉及日期和时间,不同程序的需求各异。这方面的潜在问题往往被忽视,导致严重的错误和后果。因此,掌握日期和时间的处理是软件开发的重要组成部分。 课程内容与概述:本课程面向各类开发者,提供坚实的理论基础与实用材料。我们将从日期与时间的基础知识入手,讨论相关的真实案例,了解与日期和时间相关的错误。例如,格里历的引入、1582年10月5日的“消失”,以及“分钟”可能超过60秒的对比。此外,您将学习UTC与GMT的区别以及全球计算机如何同步时间。接下来,将介绍时区的概念、日期和时间格式标准、Epoch Time和Unix Time的定义等。 课程的第三部分专注于.NET中的日期和时间相关类型,包括DateTime、DateTimeOffset、TimeZoneInfo、TimeSpan、日历和计时器,并指出其中的潜在问题。随后,我们将介绍名为“Noda Time”的第三方库及其核心类型,例如LocalTime、LocalDate、LocalDateTime等,学习如何在使用日期和时间值的代码中进行单元测试。 课程最后将讨论最佳实践,包括日期的算术运算、解析问题、生日计算和事件调度等。课程时间约为3小时,全程为视频讲解,您可以下载课程中的幻灯片和代码示例。 课程关键词:C# 日期时间, C# 日期时间格式, C# 日期时间解析, C# 日期时间偏移, 日期与时间基础, .NET 中的日期与时间, Noda Time, SQL Server 日期函数等。

课程评论(0条)

课程详情

Teaching Approach No 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 course Almost 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 Overview This 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. And did you know that actually a minute can last more than 60 seconds? Yes, you heard that, a minute can last more than 60 seconds. You'll learn what is UTC, GMT, what is the difference between them and how time gets synchronized between computers all over the world. And by the way, what is time at all, how humanity measures it? After that, you'll be introduced to the concept of time zones, you'll learn about different standards that regulate date and time formatting. You'll learn what is Epoch Time and Unix Time. Finally, you'll understand the difference between different date-time scopes and perspectives. The next section is dedicated to Time Zones where you'll learn about daylight saving time and different very odd case with time transitions back and forth. I'll give you a full definition of a time zone. You'll learn more about providers of time zone information: IANA and Microsoft. You'll learn many interesting facts and what fallacies exist about time zones. The third section is all about date and time related types from BCL in.NET. You'll learn about DateTime, DateTimeOffset, TimeZoneInfo, TimeSpan, Calendars and Stopwatch. I'll show you that DateTime hides many pitfalls. You'll learn that actual precision of BCL types is not equal to 100 nanoseconds as declared in the documentation. You'll see how many calendars exist and what we can do with them. The third section reveals all the problems with the types built-in to BCL, so in the next section, you'll learn about a third-party library called "Noda Time". Yes, a whole section is dedicated to the Noda Time library. You'll learn about features provided by this library. You'll get an overview of all the core types such as: LocalTime, LocalDate, LocalDateTime, Instant, Interval, Duration, ZonedDateTime and others. You'll also learn how to write unit tests on code which uses date and time values with the help of Noda Time. The whole section is dedicated to best practices of working with date and time. You'll see some astonishing things like arithmetic on dates and problems of birthday calculation. You'll learn the problems related to parsing and how to overcome them. I'll show you the problems of events scheduling and what to do to avoid common mistakes. You'll learn about date and time ranges, "intervals" is a separate peculiar topic. I'll also show some additional best practices. In other words, an exciting journey is waiting for you, just take it, relax and enjoy. So, in short, the course covers the following topics: Date and Time Fundamentals: Gregorian calendar, UTC, GMT, Atomic Time, How Computers Store Time, NTP, Date and Time Formats based on Standards and Specifications, Epoch Time and Unit Time, Date and Time Scope and Perspective Time Zones: Definition (complex one), Daylight-Saving Time (DST), Providers such as IANA or TZDB and Microsoft Date and Time in.NET: DateTime, DateTimeOffset, TimeZoneInfo, TimeSpan, Calendars, Stopwatch and many intrinsic details. Noda Time: overview, core types, unit testing A great number of best practices of working with Date and Time: arithmetic on dates, parsing, calculating of birthdays, scheduling events, date formats, ranges and other. In the end, we will recap what you have learned. How long is this course: The course is around 3 hours. All are video lectures. You will be able to download all the slides and code samples used in the course. Keywords. C# datetime, C# datetime format, datetime parse, C# datetimeoffset, date and time fundamentals, datetime in.net, noda time, nodatime, C# datetime now, C# string to datetime, C# tostring format, utc now, noda time tutorial, C# datetime tutorial, datetime C# tutorial, datetime vs nodatime, datetime vs noda time, noda time C#, noda time vs datetimeoffset, noda time vs datetimeSQL date, SQL Server Date Functions, SQL Date Functions, DateTime SQL, SQL Server DateTime.

课程标签

0人关注该课程

主题相关的课程