0基础学做账：Part 2 - SQL实际操作

8小时 E-Learning (1年学习权限) & 2小时线上跟老师 Zoom Live Q&A 附送 SQL Accounts 软件学习版本

Created by

Super Admin

10:04:46 Hours

68 Enrolled

    • (0 Reviews)

Chinese

Last updated

Fri, 04-Jul-2025

Course description

文凭：

SQL Mastery 官方文凭 (需通过官方考试)


课程模块与内容：

1. 设立新账号
• 创建数据库
• 公司档案
• 设置会计期间 (Financial Period)
• 单据编号 (Document Number)
• 会计科目表 (Chart of Account)
• 供应商列表
• 顾客列表
• 期初余额 (Opening Balance)


2. 通过情景例子记录各种买卖与花费

 

3. 银行对账单（Bank Reconciliation)

 

4. 期末账项调整

 

Bonus Topic!

5. 变卖与报废固定资产 (Fixed Assets Disposal / Write-Off)

 

6. 检查财务报表（Financial Statements)
• 整体检阅（High-Level Review）
• 比率分析（Financial Ratios）

 

7. 利润分配（Profit Distribution)
• 宣告与支付红利 /股息
• 盈利分配账户 (Appropriation Account)

Course Gallery

Super Admin

View profile

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: default-new/course_page_instructor.php

Line Number: 21

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 21
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

https://www.hawklass.com.micfronthub.com/uploads/user_image/placeholder.png">

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: default-new/course_page_instructor.php

Line Number: 26

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 26
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: default-new/course_page_instructor.php

Line Number: 26

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 26
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: default-new/course_page_instructor.php

Line Number: 27

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 27
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: default-new/course_page_instructor.php

Line Number: 28

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 28
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: Trying to access array offset on value of type null

Filename: default-new/course_page_instructor.php

Line Number: 31

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 31
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

A PHP Error was encountered

Severity: 8192

Message: json_decode(): Passing null to parameter #1 ($json) of type string is deprecated

Filename: default-new/course_page_instructor.php

Line Number: 31

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 31
Function: json_decode

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

A PHP Error was encountered

Severity: Warning

Message: foreach() argument must be of type array|object, null given

Filename: default-new/course_page_instructor.php

Line Number: 31

Backtrace:

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page_instructor.php
Line: 31
Function: _error_handler

File: /home/micfront/hawklass.com/application/views/frontend/default-new/course_page.php
Line: 158
Function: include

File: /home/micfront/hawklass.com/application/views/frontend/default-new/index.php
Line: 102
Function: include

File: /home/micfront/hawklass.com/application/controllers/Home.php
Line: 331
Function: view

File: /home/micfront/hawklass.com/index.php
Line: 295
Function: require_once

View profile

Past Experience Gallery 11

RM330

RM1200

Lectures

34

Skill level

Beginner

Expiry period

12 Months

Certificate

Yes
Remove from cart Add to cart Buy now

Related courses

Beginner

E-Invoicing Implementation (English & Bahasa)

0

(0 Reviews)

Compare

7 hours e-Learning (1 Year Unlimited Access) + 2 hours Live Q&A with Trainer

RM700

RM1500

05:42:13 Hours

Beginner

HR 2 in 1 for Beginners: Employment Act & Payroll Management (English & Bahasa)

0

(0 Reviews)

Compare

7 hours e-Learning (1 Year Unlimited Access) + 2 hours Live Q&A with Trainer

RM700

RM1700

07:21:14 Hours

Beginner

HR 2 in 1：实战劳工法令 & Payroll速成班 (中文班)

0

(0 Reviews)

Compare

7小时 E-Learning (1年Access) + 2小时跟老师 Live Q&A

RM700

RM2400

07:29:34 Hours

Beginner

E-INVOICING 电子发票基础班 (中文班)

0

(0 Reviews)

Compare

RM700

RM1500

02:14:05 Hours

Beginner

0基础学做账：Part 1 - Full Set Accounts

0

(0 Reviews)

Compare

14.5 小时 E-Learning (1年学习权限) & 2小时线上跟老师 Zoom Live Q&A

RM520

RM1700

14:27:00 Hours

Advanced

CHRP Module (UTM) - Managing Discipline, Misconducts & Domestic Inquiry

0

(0 Reviews)

Compare

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

RM1650

08:36:47 Hours

Advanced

CHRP Module (UTM) - Writing HR Policies, SOP & Employee Handbook

0

(0 Reviews)

Compare

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

RM1650

09:27:33 Hours

Advanced

CHRP Module (UTM) - HR as Driver of Corporate Vision & Mission

0

(0 Reviews)

Compare

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

RM1650

07:34:42 Hours

Advanced

CHRP Module (UTM) - Recruitment & Selection Mastery

0

(0 Reviews)

Compare

7 hours E-Learning Video + 2 to 4 hours Live Session with Trainer

RM825

RM1650

07:29:18 Hours

Advanced

CHRP Module (UTM) - Termination, Dismissal & Retrenchment

0

(0 Reviews)

Compare

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

RM1650

08:17:15 Hours

Advanced

FREE PREVIEW: HR COMPLIANCE PRACTICAL GUIDE & BEST PRACTICES - CHRP Module (UTM) - Managing Discipline, Misconducts & Domestic Inquiry - Sexual Harassment

0

(0 Reviews)

Compare

FREE PREVIEW

RM0

00:13:48 Hours

Beginner

免费试课：0基础学做账 Full Set Accounts —— 收入认列原则 Revenue Recognition Principle

0

(0 Reviews)

Compare

免费试课

RM0

00:11:13 Hours

Embrace a Better Version of Yourself Every Day

Top categories

Useful links

Help

Subscribe to our newsletter