This project-based course, SQL Time Functions, is now open. This project will teach you how to use SQL Date Time Functions for manipulating tables that have data types in a database. By the end of this 2-and-a-half-hour-long project, you will be able to use different Date Time Functions to retrieve the desired result from a database. This project will teach you how to use SQL Date Time Functions such as CURRENT_DATE and CURRENT_TIMESTAMP to manipulate date-like data within the employees table. We will begin by introducing the functions with a simple example. Next, we will use the Date Time Functions to create more complex queries in real-life apps. You will also learn how to convert a date into a string, and vice versa. PostgreSQL will be our preferred database management software (DBMS) for this hands-on project. To complete this project, you must have some experience using PostgreSQL. This project also requires advanced SQL concepts. Therefore, you must have a solid foundation in writing SQL queries to be successful. If you don't know how to write SQL queries and SQL joins, I have previously guided you through the following projects: "Querying Databases with SQL SELECT statement," and "Performing Data Aggregation with SQL Aggregate Functions." These guided projects were taught using PostgreSQL. These projects will provide the necessary knowledge to complete the SQL Date Time Functions project. If you're comfortable writing queries in PostgreSQL then please join me for this amazing ride! Let's get our hands dirty!
