A beginners guide to writing SQL Functions
4.5 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,773 students enrolled
Wishlisted Wishlist

Please confirm that you want to add A beginners guide to writing SQL Functions to your Wishlist.

Add to Wishlist

A beginners guide to writing SQL Functions

Learn how to write various types of SQL functions to perform several tasks
4.5 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,773 students enrolled
Last updated 12/2016
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • You should have a basic understanding of Relational Databases like Oracle,SQL Server
  • You should have a basic understanding SQL
  • You should have a database setup ( We'll cover how to download and install Oracle)
  • You should have a database connection ( We'll cover how to download and TOAD)
Description

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.

Who is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:36:39
+
Lab Setup
8 Lectures 36:06



Add Sample Schema and Tables
05:09

Download TOAD
03:36

Install TOAD
04:08

Connect TOAD to Oracle Database
05:21

Explore TOAD and it's editor
05:41
+
Aggregate Functions
6 Lectures 20:39
Introduction To Aggregate Functions
01:38

AVG () Aggregate Functions
03:20

COUNT () Aggregate Function
04:40

MAX () Aggregate Function
03:13

MIN () Aggregate Function
02:48

SUM () Aggregate Function
05:00
+
Single Row Functions
5 Lectures 26:04
Introduction to single row functions
00:59

Character Functions
07:50

Conversion Functions
06:48

Date Functions
05:02

Numeric Functions
05:25
+
Analytic Functions
12 Lectures 01:13:50
Introduction to Analytic functions
06:43

Syntax for Analytic functions
04:07

the Partition Clause
08:04

Order By Clause
05:48

Windowing Clause
02:10

Row number Functions
09:26

Rank Function
06:04

Dense Rank Function
05:57

Lag Function
03:37

ListAgg Function
06:14

Lead Function
06:44

First and Last Functions
08:56
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,559 Reviews
35,114 Students
85 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.