IT Auditing: Improving Work Efficiency with SQL + Python

Name: IT Auditing: Improving Work Efficiency with SQL + Python
ISBN: 9787121433467

涂佳兵Publishing House of Electronics Industry · ChinaJun 2022

3.6

Word count: 85K words
Chapters: 63
ISBN: 9787121433467

Report an error Find this book

Summary

This book explains how to use SQL and Python to improve the efficiency of audit work. Auditors and accountants alike face questions about how to obtain and analyze data, and sometimes want to build automated tools or use programming techniques to handle repetitive tasks.

Starting from the real work scenarios of auditors and accountants, this book covers learning techniques for IT auditing, SQL fundamentals and practical techniques, Python fundamentals and practical techniques, and data visualization techniques. It is suitable for students who wish to develop a career in computer auditing, as well as frontline computer auditing professionals who are troubled by tedious, repetitive work.

Editor's review

This book places SQL and Python skills in the real working contexts of auditors and accountants. Its starting point is not programming for its own sake but solving concrete problems: extracting data, analyzing it and reducing repetitive work. It begins with approaches to learning IT auditing, then covers SQL fundamentals and practical techniques, Python fundamentals and practical techniques, and data visualization, forming a complete chain from data acquisition to presenting results. The book emphasizes using programming skills to assist with repetitive work and even build small automation tools, which has practical reference value for frontline staff long troubled by cumbersome data organization. You need not read all the syntax in one go; instead, take your own audit tasks and consult the relevant chapters, learning while applying. Readers without programming basics should allow time to build up basic SQL and Python syntax before moving to the practical sections, which will make the gains more evident.

Who it's for

A good fit for

Students and newcomers who wish to develop in computer auditing
Auditors and accountants who handle large amounts of data daily and want to improve efficiency
Frontline practitioners troubled by repetitive data work who want to learn automation methods
Multidisciplinary professionals with some finance or audit background who are willing to learn SQL and Python

Not a good fit for

Readers with no auditing or finance background who only want to learn programming languages
Senior developers already proficient in SQL and Python seeking advanced algorithms and architecture
Those who want to study data science theory systematically rather than workplace applications

Reading tips

First identify a specific data-processing pain point in your own work, read the corresponding chapter with that question in mind, and put it into practice immediately after learning.
Readers with weak programming foundations should first focus on SQL queries and basic Python syntax, then move on to the audit practical techniques section.
Adapt the book's examples to your own organization's real data structures for practice, deepening your understanding of the data retrieval and analysis process.
After reading the data visualization section, try turning a routine audit task into a repeatable small tool, then review and optimize it.

About the publisher

Publishing House of Electronics Industry China · Founded in 1982

The Publishing House of Electronics Industry is a comprehensive publisher distinguished by its focus on electronic information and related fields. Judging from the more than 3,000 titles in its catalogue, its publishing covers programming and design, artificial intelligence, computer science, finance and economics, photography, and social sciences, attending both to cutting-edge technology and to general readers. Representative titles include Factor Investing: Methods and Practice, x86 Assembly Language: From Real Mode to Protected Mode, The RISC-V Reader, Artificial Intelligence: Speech Recognition, Understanding and Practice, Phased Array Radar Technology, Radar Target Characteristics, and 100 Go Mistakes and How to Avoid Them, most of which centre on technical methods and engineering practice. Its authors include Shi Chuan, Li Zhong, Wang Xiaobo, David Patterson, Andrew Waterman, and Yu Zihao, among others from China and abroad. Owing to limited public information, no further publishing features are elaborated here.

版权信息
作者简介
前言
自序
第1章学习之路
1.1 零基础学习编程的注意事项
1.2 面向搜索编程
1.3 Git
1.4 搭建自己的知识库
1.5 数据分析在IT审计中的应用
第2章 SQL基础
2.1 MySQL安装
2.2 Navicat配置
2.3 导入数据
2.4 导出数据
2.5 SQL查询
2.6 SQL练习
2.7 数据透视和数据去重
2.8 快速查询之索引
2.9 随机抽样
2.10 分层抽样
2.11 关于时间
2.12 关于文本
第3章 SQL实战
3.1 固定资产折旧计算
3.2 编号连续性分析
3.3 接口测试
3.4 收入真实性分析
第4章 Python基础
4.1 Anaconda安装和使用
4.2 VS Code安装
4.3 什么是代码
4.4 读写文件
4.5 数据结构
4.6 条件判断
4.7 循环
4.8 函数
4.9 调试及常见错误类型
4.10 模块与包
4.11 处理二维表数据
4.12 访问MySQL数据库
4.13 关于时间
4.14 执行终端命令
4.15 多线程和多进程
4.16 面向对象编程
第5章 Python实战
5.1 计算稳定性
5.2 银行流水核对
5.3 公司名称模糊匹配
5.4 BOM穿透
5.5 邮件回函真实性验证
第6章数据可视化
6.1 Plotly使用方法
6.2 散点图
6.3 折线图
6.4 柱状图
6.5 饼图
6.6 旭日图
6.7 桑基图
6.8 直方图
6.9 瀑布图
6.10 蜡烛图
反侵权盗版声明

FAQ

Can someone with no programming background read this book directly?

Yes, but extra time is needed. The book includes basic SQL and basic Python content. Beginners should first carefully absorb these two parts of syntax before entering the practical techniques chapters; learning while practicing works better. Those with programming experience can focus directly on the application sections for audit scenarios.

Is this book about programming or auditing?

It combines both. Starting from the actual work scenarios of auditors and accountants, the book explains how to use SQL and Python to improve audit efficiency. The focus is on using programming methods to solve problems in data retrieval, data analysis, and repetitive work, rather than teaching programming languages or audit theory separately.

Does the book include data visualization content?

Yes. The information shows that in addition to IT audit learning techniques, SQL basics and practice, and Python basics and practice, the book also explains data visualization techniques, so readers can present analysis results in a more intuitive form.

Is this book useful for someone doing accounting work but not auditing?

Yes. The book is aimed at both auditors and accountants. The data retrieval, data analysis, and automation techniques it covers are equally applicable to data processing in daily accounting work, helping reduce repetitive work and improve efficiency.

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

涂佳兵 Author

Tu Jiabing: publicly available information about this author is limited. He is currently known only as the author of IT Auditing: Using SQL + Python to Improve Work Efficiency, a book classified under general computing. This work suggests that the author focuses on combining information technology with audit practice, with particular attention to using tools such as SQL and Python to streamline daily workflows and boost professional efficiency. The writing is oriented toward practical application and tends to solve specific problems in IT auditing through technical means, making it suitable for practitioners who wish to improve their data processing and automation skills. Because only one work by this author is included in the database, and details such as nationality, birth and death years, and English name are unknown, a complete biography and writing trajectory cannot be presented; readers may refer to the book itself to understand the author's basic orientation in IT auditing and the use of technical tools.