Numeric & Math Functions

Duration: 4 min

This video lesson is available to enrolled students.

Return to /learn/INFYTQ-PREPARATION/sql/sql/library-functions-math-aggregate-string-date/asset-numeric-math-functions after enrolling

Inside: a video lesson and guided study material.

Module outline

  1. Programming Fundamentals: C Fundamentals, Control Flow, Functions, Arrays & Pointers, Storage Classes, Structures & Enums
  2. Object Oriented Programming: Object Oriented Programming (OOPS)
  3. Data Structures (Basic): Introduction to DS, Array, Stack, Queue, Linked List, Tree, Graphs, Hashing
  4. Algorithms (Basic): Algorithm Analysis, Sorting Algorithms, Greedy Algorithms, Dynamic Programming, Minimum Spanning Trees, Shortest Path Algos, Advanced Algorithms, Time Complexity Analysis
  5. Coding (Basic): Coding Questions by Yash Sir, C Programming by Yash Sir, Java, Python for Placements by Yash Sir, Programming in C++
  6. DBMS: Basics of DBMS, ER Diagram, Relational Model & Functional Dependencies, Keys & Integrity Constraints, Normalization (1NF - BCNF), Decomposition Properties & 4NF, File Organization & Indexing, Relational Algebra, Relational Calculus, Transaction Management, Concurrency Control, Database Recovery, ORDBMS, Database Security & Authorization, Enhanced Data Models, Query Processing & Optimization, Data Warehousing & Mining, Big Data Systems, NoSQL
  7. SQL: SQL
AI summary & chapters

AI Summary

An AI-generated summary of this video lecture.

This video lecture introduces essential SQL mathematical functions for data analysis, covering ABS, ROUND, CEIL, FLOOR, and MOD with practical examples. It then transitions to advanced scientific and trigonometric functions like SIN, COS, TAN, and logarithmic operations, providing a comprehensive toolkit for numerical transformations in SQL queries.

Chapters

  1. 0:00 – 2:00 00:00-02:00

    The instructor introduces SQL's essential math functions, explaining ABS for absolute value, ROUND for decimal rounding, CEIL for ceiling, FLOOR for floor, and MOD for remainder calculation, with clear syntax and examples for each.

  2. 2:00 – 3:34 02:00-03:34

    The lesson progresses to advanced scientific and trigonometric functions, including SIN, COS, TAN, their inverse counterparts, logarithmic functions (LOG, EXP), and random number generation (RAND), with a focus on their application in complex data analysis.

The video systematically teaches SQL's mathematical and scientific functions, starting with basic arithmetic operations and advancing to trigonometric and logarithmic calculations, equipping viewers with tools for precise numerical data manipulation in SQL queries.

Loading lesson…