HOT
blank

A beginners guide to writing SQL Functions

Development

A beginners guide to writing SQL Functions, available at $19.99, has an average rating of 3.85, with 32 lectures, based on 20 reviews, and has 1853 subscribers.

Rating3.9
Enroll Now

You will learn about Develop your creative and SQL skills to write useful functions to perform various tasks Write Aggregate functions to compute a single value Write single row functions Write Analytic functions that use aggregate functions Write functions to performing calculations on data. This course is ideal for individuals who are This course is for app developers who want to acquire some SQL skills or This course is for aspiring database administrator who want to acquire some SQL skills or This course is for data analyst who want to acquire some SQL skills or This course is for aspiring data warehouse professionals who want to acquire some SQL skills or This course is for aspiring programmers who want to acquire some SQL skills It is particularly useful for This course is for app developers who want to acquire some SQL skills or This course is for aspiring database administrator who want to acquire some SQL skills or This course is for data analyst who want to acquire some SQL skills or This course is for aspiring data warehouse professionals who want to acquire some SQL skills or This course is for aspiring programmers who want to acquire some SQL skills.

Enroll now: A beginners guide to writing SQL Functions

Summary

Title: A beginners guide to writing SQL Functions

Price: $19.99

Average Rating: 3.85

Number of Lectures: 32

Number of Published Lectures: 32

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

  • Develop your creative and SQL skills to write useful functions to perform various tasks
  • Write Aggregate functions to compute a single value
  • Write single row functions
  • Write Analytic functions that use aggregate functions
  • Write functions to performing calculations on data.

Who Should Attend

  • This course is for app developers who want to acquire some SQL skills
  • This course is for aspiring database administrator who want to acquire some SQL skills
  • This course is for data analyst who want to acquire some SQL skills
  • This course is for aspiring data warehouse professionals who want to acquire some SQL skills
  • This course is for aspiring programmers who want to acquire some SQL skills

Target Audiences

  • This course is for app developers who want to acquire some SQL skills
  • This course is for aspiring database administrator who want to acquire some SQL skills
  • This course is for data analyst who want to acquire some SQL skills
  • This course is for aspiring data warehouse professionals who want to acquire some SQL skills
  • This course is for aspiring programmers who want to acquire some SQL skills

SQL has many built-in functions  .In this course we will be learning about the SQL functions built in into Oracle Database that are available for use in various appropriate SQL statements. There are various types of SQL functions used to perform calculations on data and manipulate other aspects of data within the database.

Understanding SQL functions will help improve your skills and make your work much easier as a database professional. In this course we will be learning about the following types of SQL functions:

Aggregate  Functions
Aggregate functions return a single result row based on groups of rows, rather than on single rows. Aggregate functions can appear in select lists and in ORDER BY and HAVING clauses. They are commonly used with the GROUP BY clause in a SELECT statement, where Oracle Database divides the rows of a queried table or view into groups. In a query containing a GROUP BY clause, the elements of the select list can be aggregate functions, GROUP BY expressions, constants, or expressions involving one of these. Oracle applies the aggregate functions to each group of rows and returns a single result row for each group.

Single Row Functions:
Single-row functions return a single result row for  every row of a queried table or view. These functions  can appear in select lists, WHERE clauses, START WITH and CONNECT BY clauses, and HAVING clauses.

Numeric Functions
Numeric functions accept numeric input and return numeric values. Most numeric functions that return NUMBER values that are accurate to 38 decimal digits

conversion functions
convert a value from one datatype to another.

Analytic Functions
Analytic functions are commonly used to compute cumulative, moving, centered, and reporting aggregates.
Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group.

Course Curriculum

Chapter 1: Lab Setup

Lecture 1: Introduction

Lecture 2: Download Oracle Database

Lecture 3: Installing Oracle Database

Lecture 4: Add Sample Schema and Tables

Lecture 5: Download TOAD

Lecture 6: Install TOAD

Lecture 7: Connect TOAD to Oracle Database

Lecture 8: Explore TOAD and it's editor

Chapter 2: Aggregate Functions

Lecture 1: Introduction To Aggregate Functions

Lecture 2: AVG () Aggregate Functions

Lecture 3: COUNT () Aggregate Function

Lecture 4: MAX () Aggregate Function

Lecture 5: MIN () Aggregate Function

Lecture 6: SUM () Aggregate Function

Chapter 3: Single Row Functions

Lecture 1: Introduction to single row functions

Lecture 2: Character Functions

Lecture 3: Conversion Functions

Lecture 4: Date Functions

Lecture 5: Numeric Functions

Chapter 4: Analytic Functions

Lecture 1: Introduction to Analytic functions

Lecture 2: Syntax for Analytic functions

Lecture 3: the Partition Clause

Lecture 4: Order By Clause

Lecture 5: Windowing Clause

Lecture 6: Row number Functions

Lecture 7: Rank Function

Lecture 8: Dense Rank Function

Lecture 9: Lag Function

Lecture 10: ListAgg Function

Lecture 11: Lead Function

Lecture 12: First and Last Functions

Lecture 13: Thank You

Instructors

Rating Distribution

  • 1 stars: 0 votes
  • 2 stars: 1 votes
  • 3 stars: 4 votes
  • 4 stars: 10 votes
  • 5 stars: 5 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Ethical AI Courses to Learn in November 2024

Top 10 Game Development Courses to Learn in November 2024

Top 10 Software Testing Courses to Learn in November 2024