We may earn an affiliate commission when you visit our partners.
Introduction to Dates and Times in SQL Server
Scott Hecht
Scott Hecht
The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer.
Read more
The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer.
Read more
The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer.
The Introduction to Dates and Times in SQL Server course details how to use the date, time, smalldatetime, datetime and datetime2 data types as well as the many date- and time-related functions available to the SQL programmer such as DATEPART(), DATEFROMPARTS(), DATEADD(), as well as many others.
Register for this course and see more details by visiting:
OpenCourser.com/course/fty1gn/introduction
What's inside
Syllabus
Introduction
Quick Start Guide
DATE Data Type
TIME Data Type
Read more
Syllabus
Introduction
Quick Start Guide
DATE Data Type
TIME Data Type
Read more
SMALLDATETIME Data Type
DATETIME and DATETIME2 Data Types
String Literals
Conversion Functions
Additional Functions
Date/Time Manipulations
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Teaches introduction to dates and times in SQL Server
Covers date, time, smalldatetime, datetime, datetime2 data types
Develops date and time-related functions
Provides quick start guide and essential concepts
Includes additional functions and date/time manipulations
Save this course
Save Introduction to Dates and Times in SQL Server to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Introduction to Dates and Times in SQL Server.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Introduction to Dates and Times in SQL Server will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data Analysts commonly investigate and analyze data from a variety of sources to provide insights that drive decision-making. In this role, you can leverage your understanding of date and time data types, conversion functions, and date/time manipulations to effectively manage and interpret temporal data. The course's coverage of additional functions, such as DATEPART() and DATEFROMPARTS(), will equip you with the skills to extract specific date and time components and construct custom date values, providing a foundation for accurate data analysis.
Database Administrator
Database Administrator
Database Administrators ensure the smooth operation and maintenance of database systems, including managing data integrity and security. The course's focus on date and time data types, conversion functions, and date/time manipulations will enhance your ability to handle temporal data effectively. Understanding how to use functions like DATEADD() and additional functions will be instrumental in performing database maintenance tasks, such as managing backups and restoring data to specific points in time.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts gather, analyze, and interpret data to provide insights for business decision-making. The course's coverage of date and time data types, conversion functions, and date/time manipulations will equip you with the skills to effectively manage and analyze temporal data. Understanding how to use functions like DATEPART() and DATEFROMPARTS() will be particularly valuable in extracting specific date and time components to uncover trends and patterns in business data.
Data Engineer
Data Engineer
Data Engineers design, build, and maintain data pipelines to ensure data integrity and accessibility. The course's coverage of date and time data types, conversion functions, and date/time manipulations will provide you with a solid understanding of how to manage and manipulate temporal data. Understanding how to use functions like DATEADD() and additional functions will be essential for building data pipelines that can handle temporal data efficiently and accurately.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications. While the course's focus on date and time data types and functions may not be directly applicable to all software development roles, it can provide a foundation for building applications that involve temporal data management. Understanding how to use functions like DATEPART() and DATEFROMPARTS() can be beneficial in developing features that require date and time calculations or manipulations.
Statistician
Statistician
Statisticians collect, analyze, and interpret data to provide insights and make predictions. The course's coverage of date and time data types, conversion functions, and date/time manipulations will equip you with the skills to effectively manage and analyze temporal data. Understanding how to use functions like DATEPART() and DATEFROMPARTS() will be particularly valuable in extracting specific date and time components to uncover patterns and trends in statistical data.
Financial Analyst
Financial Analyst
Financial Analysts evaluate and interpret financial data to make investment recommendations and assess financial risks. The course's focus on date and time data types, conversion functions, and date/time manipulations will provide you with a foundation for understanding and analyzing temporal financial data. Understanding how to use functions like DATEADD() and additional functions will be beneficial in performing financial modeling and forecasting, where time-based calculations are crucial.
Actuary
Actuary
Actuaries assess and manage financial risks and uncertainties. The course's coverage of date and time data types, conversion functions, and date/time manipulations will provide you with a foundation for understanding and analyzing temporal financial data. Understanding how to use functions like DATEADD() and additional functions will be beneficial in performing actuarial calculations and modeling, where time-based factors play a critical role.
Market Researcher
Market Researcher
Market Researchers gather and analyze data to understand consumer behavior and market trends. The course's coverage of date and time data types, conversion functions, and date/time manipulations will equip you with the skills to effectively manage and analyze temporal data. Understanding how to use functions like DATEPART() and DATEFROMPARTS() will be particularly valuable in identifying trends and patterns in consumer behavior over time.
Epidemiologist
Epidemiologist
Epidemiologists investigate and analyze the distribution and patterns of health events and diseases in populations. The course's coverage of date and time data types, conversion functions, and date/time manipulations will provide you with a foundation for understanding and analyzing temporal health data. Understanding how to use functions like DATEADD() and additional functions will be beneficial in performing epidemiological studies and modeling, where time-based factors are crucial.
Data Scientist
Data Scientist
Data Scientists use statistical methods and machine learning techniques to extract insights from data. The course's coverage of date and time data types, conversion functions, and date/time manipulations will provide you with a foundation for understanding and analyzing temporal data. Understanding how to use functions like DATEPART() and DATEFROMPARTS() can be beneficial in developing machine learning models that can handle temporal data effectively.
Healthcare Analyst
Healthcare Analyst
Healthcare Analysts collect and analyze data to improve healthcare delivery and outcomes. The course's coverage of date and time data types, conversion functions, and date/time manipulations will provide you with a foundation for understanding and analyzing temporal healthcare data. Understanding how to use functions like DATEADD() and additional functions will be beneficial in performing healthcare analytics and modeling, where time-based factors play a critical role.
Technical Writer
Technical Writer
Technical Writers create and maintain technical documentation, such as user manuals, white papers, and training materials. The course's focus on string literals, conversion functions, and date/time manipulations can provide a foundation for understanding and documenting technical concepts involving dates and times. Understanding how to use functions like DATEPART() and DATEFROMPARTS() can be beneficial in creating clear and concise documentation that accurately conveys temporal information.
Project Manager
Project Manager
Project Managers plan, execute, and deliver projects within defined constraints. While the course's focus on date and time data types and functions may not be directly applicable to all project management roles, it can provide a foundation for managing projects that involve temporal constraints. Understanding how to use functions like DATEADD() and additional functions can be beneficial in scheduling tasks, tracking progress, and managing deadlines.
Business Analyst
Business Analyst
Business Analysts gather and analyze business requirements to improve business processes and systems. While the course's focus on date and time data types and functions may not be directly applicable to all business analysis roles, it can provide a foundation for understanding and analyzing temporal business data. Understanding how to use functions like DATEPART() and DATEFROMPARTS() can be beneficial in identifying trends and patterns in business data over time.
For more career information including salaries, visit:
OpenCourser.com/course/fty1gn/introduction
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Introduction to Dates and Times in SQL Server.
Provides a deep dive into the internals of SQL Server 2012. It includes a section on date and time data types and functions that good resource for additional reading for someone who wants to learn more about the topic.
Is considered to be one of the best general references for SQL Server 2012. It has a section on date and time data types and functions that good resource for additional reading.
Provides a comprehensive overview of execution plans in SQL Server 2012. It includes a section on date and time data types and functions that good resource for additional reading for someone who wants to learn more about the topic.
More general book about SQL server administration, but it has a good chapter that details date and time data types in SQL Server 2012. It provides a good background for the concepts that the course offers.
Contains a collection of articles on a variety of SQL Server topics, including date and time data types and functions. It good resource for additional reading for someone who wants to learn more about the topic.
Provides a comprehensive overview of SQL Server 2012 programming, including a section on date and time data types and functions.
Save
Is another more general book about T-SQL fundamentals, but like the previous book, it has a few sections covering date and time data types and functions.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/fty1gn/introduction
Share
Similar courses
Here are nine courses similar to
Introduction to Dates and Times in SQL Server.
Excel 2016 Time and Date Function Playbook
OpenCourser.com/course/dsadxa/excel
Excel 2016 Time and Date Function Playbook
Most relevant
SQL Server Time Series Essentials: Foundations and Query Techniques
OpenCourser.com/course/angjwi/sql
SQL Server Time Series Essentials: Foundations and Query...
Most relevant
Working with Dates and Times in Python
OpenCourser.com/course/k2avxe/working
Working with Dates and Times in Python
Most relevant
Core Python 3: Numeric Types, Dates, and Times
OpenCourser.com/course/23yn30/core
Core Python 3: Numeric Types, Dates, and Times
Most relevant
Dates and Times in .NET 2
OpenCourser.com/course/wtl5pm/dates
Dates and Times in .NET 2
Most relevant
Date and Time in .NET
OpenCourser.com/course/kmyjsy/date
Date and Time in .NET
Most relevant
70-461, 761: Querying Microsoft SQL Server with Transact-SQL
OpenCourser.com/course/qq8nay/70
70-461, 761: Querying Microsoft SQL Server with Transact...
Most relevant
SQL Server: Installing and Configuring SQL Server 2016
OpenCourser.com/course/pz05gx/sql
SQL Server: Installing and Configuring SQL Server 2016
Most relevant
SQL Date Time Functions
OpenCourser.com/course/71tyf6/sql
SQL Date Time Functions
Time
178 hours
Level
Intermediate
Via
Pluralsight
Instructor
Scott Hecht
Language
English
Good to know
Teaches introduction to dates and times in SQL Server
Covers date, time, smalldatetime, datetime, datetime2 data types
Develops date and time-related functions
Provides quick start guide and essential concepts
Includes additional functions and date/time manipulations
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser