Database Design & Management Class! - Topic 03, Part 16 - Using Numeric Functions in SQL - COUNT, MIN, MAX, SUM, AVG, and STDEV

Unlock the Power of Databases: From Fundamentals to Advanced SQL Techniques! Dive deep into database purpose, design, and optimization with Dr. Daniel Soper's comprehensive course—your gateway to mastering data management and analytics!

4.0 (6)

45 learners

What you'll learn

Understand the purpose and structure of relational databases
Execute basic and advanced SQL queries for data management
Design and model database schemas incorporating keys and relationships
Implement database security, backup, and recovery methods

This course includes

18.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Full Transcript

Dr. Soper discusses how to use numeric functions (including COUNT, MIN, MAX, SUM, AVG, and STDEV) to compute aggregate values when writing SQL queries. This video is Part 16 of Topic 03 in Dr. Soper's class on Database Design and Management.

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

Direção de Arte no Cinema e Jogos: Fundamentos Essenciais

Transforme sua criatividade em carreira: descubra os segredos da Direção de Arte no cinema, jogos e design gráfico com especialistas e aprenda a criar mundos visuais incríveis. Inscreva-se agora e revolucione sua visão artística!

⭐ 4.0

29 ratings

0 min

30-Day Beginner Guitar Challenge for New Players

Master the Guitar in 30 Days: Your Ultimate Beginner Challenge! Unleash your inner guitarist with step-by-step lessons designed to transform you from novice to confident player. Join Your Guitar Academy and kickstart your musical journey today!

⭐ 4.3

36 ratings

7 hours