Udemy – DPA : Data Processing and Analysis VNSGU Sem1 2024-10

Published on: 2024-12-06 16:38:07

Categories: 28

Description

DPA: Data Processing and Analysis VNSGU Sem1 course teaches you the basics of working with Worksheet, Workbook, and Spreadsheet. Also, you will be introduced to managing worksheets, cells, and formatting. This course also teaches you database concepts, database models, and SQL language.

In the Database section, you will learn about database concepts, its different models, and the SQL language. This includes designing a database, defining tables, inserting, modifying, and deleting data, as well as extracting information from the database.

What you will learn

Workbook and Spreadsheet Basics
Manage Worksheets, Cells, and Formatting
Data management (sorting, filtering, conditional formatting, cell validation)
Creating various charts
Using basic and logical functions
Data management
Using mathematical and logical functions (Power, Sqrt, Abs, Floor, Celling, Int, Trunc, Round, sum, average, count, max, min, sumif, pmt, stddev, if, AND, OR, NOT)
Database concepts and models
SQL language and its commands