Master 5 Essential Math Functions in SQL Queries!

Опубликовано: 31 Декабрь 2024
на канале: Drop Materialized View
38
2

Learn to perform calculations in your SQL queries! This beginner-friendly SQL tutorial covers essential arithmetic operations like addition, subtraction, multiplication, division, and modulo. Master these operators to analyze data and write more powerful queries.

Video Chapters
00:00 - Introduction
00:49 - Logging into server and starting lesson
01:42 - arithmetic in SQL
03:46 - Modulo function
05:00 - Order of Operations
05:25 - Column Aliases
06:30 - Practice Problem #1 - ten % off Calculation
07:38 - Practice Problem #2 - total calculation

Come learn SQL with me:    • Learn SQL for Free  
GitHub Link with SQL Statements / Notes from the video: https://github.com/edwardpcharles/sql...
Follow me on LinkedIn:   / edward-charles-085025b1  

📚 Books I used to Learn Business Intelligence 📚

📊 Power BI:
Learn Power BI: https://amzn.to/49YiM3C
Definitive Guide to DAX: https://amzn.to/408zI3K

💻 SQL:
SQL in 10 Minutes a Day, Sams Teach Yourself: https://amzn.to/3VZztG2
T-SQL Fundamentals (Developer Reference): https://amzn.to/3Pe5XbC
T-SQL Querying (Developer Reference): https://amzn.to/3Pe5XbC