SQL Mathematical Functions
Welcome to this project-based course, SQL Mathematical Functions. In this project, you will learn how to use SQL Mathematical Functions to manipulate tables in a database. By the end of this 2-hour-long project, you will be able to use different Mathematical Functions to retrieve the desired result from a database. In this project, you will learn how to use SQL Mathematical Functions like CEIL(), FLOOR(), RANDOM(), SETSEED(), ROUND(), TRUNC(), SQRT(), CBRT(), and POWER() to manipulate data in the employees database.
Buy Now Free
- Level Professional
- المدة 2 ساعات hours
- الطبع بواسطة Coursera Project Network
-
Offered by
عن
Welcome to this project-based course, SQL Mathematical Functions. In this project, you will learn how to use SQL Mathematical Functions to manipulate tables in a database. By the end of this 2-hour-long project, you will be able to use different Mathematical Functions to retrieve the desired result from a database. In this project, you will learn how to use SQL Mathematical Functions like CEIL(), FLOOR(), RANDOM(), SETSEED(), ROUND(), TRUNC(), SQRT(), CBRT(), and POWER() to manipulate data in the employees database. In this project, we will move systematically by first introducing the functions using a simple example. Then, we will write slightly complex queries using the Mathematical Functions in real-life applications. Also, for this hands-on project, we will use PostgreSQL as our preferred database management system (DBMS). Therefore, to complete this project, it is required that you have prior experience with using PostgreSQL. Similarly, this project is an intermediate SQL concept; so, a good foundation for writing SQL queries is vital to complete this project. If you are not familiar with writing queries in SQL and want to learn these concepts, start with my previous guided projects titled “Querying Databases using SQL SELECT statement," and “Performing Data Aggregation using SQL Aggregate Functions.” I taught these guided projects using PostgreSQL. So, taking these projects will give the needed requisite to complete this SQL Mathematical Functions project. However, if you are comfortable writing queries in PostgreSQL, please join me on this wonderful ride! Let’s get our hands dirty!الوحدات
Practical Application via Rhyme
-
3
Readings
-
1
Plugin
-
1
Lab
-
1
Assignment
1
Assignment
- Graded Quiz: SQL Mathematical Functions
1
Labs
- SQL Mathematical Functions
3
Readings
- Project-based Course Overview
- SQL files for project
- PostgreSQL Mathematical Functions Documentation
Auto Summary
Embark on a dynamic learning experience with the "SQL Mathematical Functions" course, designed to enhance your database manipulation skills in IT & Computer Science. In just 2 hours, this hands-on, project-based course will teach you how to effectively use SQL Mathematical Functions to extract and manipulate data from databases. Guided by an experienced instructor, you'll delve into functions such as CEIL(), FLOOR(), RANDOM(), SETSEED(), ROUND(), TRUNC(), SQRT(), CBRT(), and POWER(). Through a systematic approach, you'll start with simple examples and advance to more complex queries, all within real-life applications using the PostgreSQL database management system. Ideal for learners with a foundational knowledge of SQL and experience in PostgreSQL, this intermediate-level course is perfect for those looking to sharpen their skills. If you're new to SQL, consider starting with the instructor's previous projects, "Querying Databases using SQL SELECT statement" and "Performing Data Aggregation using SQL Aggregate Functions," to build the necessary background. Available for free on Coursera, this course is your gateway to mastering SQL Mathematical Functions and enhancing your database management capabilities. Join now and get ready to get your hands dirty with practical SQL applications!
Arimoro Olayinka Imisioluwa