Introduction to MySQL - Overview

 

MySQL101 Database Management Module1

Introduction

• What is Database?
• Understanding RDBMS
• Understanding Tables
• Record and Fields
• SQL Language
• Installation of XAMPP Software
• Customers Data in CSV Format
• Creation of Database
• Creation of Table Customers
• Import Data in CSV file/s Customers

MySQL101 Database Management Module2

• Creating Security to XAMPP
• Select Statement
• Select Distinct
• SQL Language
• Creation of Table Products
• Import Data Products

MySQL101 Database Management Module3

• AND Operators
• SQL ORDER by Keyword
• OR Operators
• NOT Operators

MySQL101 Database Management Module4

• UPDATE Syntax
• DELETE Syntax
• LIMIT Syntax
• TOP Syntax
• ROWNUM Syntax
• MS SQL
• MS Access
• Oracle

MySQL101 Database Management Module5

• SQL MIN() AND Max() Functions
• SQL COUNT(), AVG() and SUM() Functions
• SQL LIKE Functions
• Wildcards
• Operators

MySQL101 Database Management Module6

• MySQL Wildcards More Search
• MySQL IN
• MySQL BETWEEN
• How to Import SQL Files Directly?
• SQL Files: Orders, Customers, Products, and Shippers Data

MySQL101 Database Management Module7

• MySQL Aliases
• MySQL Join
• MySQL Inner Join
• Sample Data in SQL: Customers, and Customers ID

Introduction to Financial Accounting - Overview

Module 1

Introduction

• The History of Accounting
• Branches of Accounting
• The Difference Between Accounting and Bookkeeping
• Double Entry Accounting
• Keeping Good Accounting Records
• Debits and Credits
• Accrual vs Cash Basis Accounting
• The Accounting Process
• Balance Sheet (Statement of Financial Position)
• Income Statement
• Statement of Changes in Owners Equity
• Statement of Cash Flows
• Financial Reporting
• Disclosure
• What's Included in the Notes
• International Financial Reporting Standards (IFRS)
• The Federal Accounting Standards Advisory Board (FASAB)
• The Government Accounting Standards Board (GASAB)

Module 2

What is Accounting?

• Why do we need financial information?
• Accounting is the Language of Business
• Difference of Financial accounting, Managerial accounting, and Tax Accounting
• Internal and External Users
• Bookkeeping vs. Accounting
• Why is it Important to Study Accounting?
• Forms of Business Organizations
• Types of Activities Performed By Business Organizations
• Ethical Behavior of Accountants
• Case Study: The Sarbanes-Oxley Act

Module 3

Short Answer Questions, Exercises AND Problems

• Beyond The Numbers—Critical thinking
• Glossary
• Accounting Principles And Practices
• GAAP - Generally Accepted Accounting Principles
• Historical cost principle
• Revenue recognition principle
• Constraints
• Account Types

Module 4

The Accrual Basis And Cash Basis Accounting

• Cash Versus Accrual Basis Accounting
• Classes And Types of Adjusting Entries
• Adjusting For Accrued Items
• Preparing An Adjusted Trial Balance
• Preparing Financial Statements
• Closing Entries
• Accounting In The Headlines

Module 5

Accounting For a Merchandising Enterprise

The Accrual Basis And Cash Basis Of Accounting

• Payment Terms
• Shipping Terms
• Merchandise Inventory
• Perpetual Inventory
• Periodic Inventory

  Buyer Entries Under Perpetual Method

• Inventory Purchases
• Shipping on Inventory Purchases
• Purchase returns and allowances
• Paying for Inventory Purchased on Credit

  Seller Entries Under Perpetual Inventory Method

• Cost of goods sold
• Recording Sales
• Shipping on Sales
• Sales Returns and Allowances
• Receiving Payment from Customers

  Buyer Entries Under Periodic Inventory System

• Inventory Purchases under Periodic
• Shipping on Inventory Purchases
• Purchase returns and allowances
• Paying for Inventory Purchased on Credit
• Paying for Inventory Purchased on Credit

  Seller Entries Under Periodic Inventory Method

• Sales and Return Allowances
• Receiving Payment from Customers
• Cost of Goods Sold

  Glossary

Module 6

Financial Reporting For A Merchandising Enterprise

Adjusting Entries

• Perpetual Inventory Method
• Periodic Inventory Method

  Financial Statements

• Multi-Step (or classified) income statement
• Reporting Cost of Goods Sold
• Other financial statements

  Closing Entries

• Close the revenue accounts with credit balances
• Close contra-revenue accounts and expense accounts with debit balances
• Close income summary into retained earnings.
• Close the debit balance of dividends into retained earnings

  Impacts of Inventory Errors On Financial Statements

  Accounting Headlines

Module 7

Merchandise Inventory

Learning Objectives

• What is merchandise inventory?
• Cost of goods sold and Inventory
• Inventory Methods for Ending Inventory and Cost of Goods Sold
• FIFO (First in, First Out)
• LIFO (Last in, First out)
• Weighted Average (or Average Cost)
• Specific Identification

Introduction to Digital Marketing - Overview

 

Module 1

• Digital Marketing - Overview
• What Digital Marketing is Not?
• Why Digital Marketing?
• Digital Marketing - SEO
• Search Engine Crawlers
• Points to Note
• Digital Marketing - Social Media
• SEO and Social Media
• There are two functions of social media for business
• Start Social Media Marketing
• Facebook tops the list of social media strategy
• Optimize for mobile
• Emphasize on human experience
• Digital Marketing - Content
• Content marketing
• Goals of Content Marketing

Module 2

• Start Content Marketing
• Digital Marketing - Email
• Digests
• Lead Nurturing
• Transactional Emails
• Digital Marketing - Mobile
• New Mobile Marketing Channels
• Ways to Drive Conversions
• Use QR codes to streamline user experience
• Use hyperlocal marketing
• Use SMS marketing
• Digital Marketing - Pay Per Click
• Search Engine Advertising
• Advantage of PPC Marketing
• Factors behind Successful PPC Advertising
• Digital Marketing - CRO

Module 3

• What is CRO?
• What CRO is Not
• Why do Companies Use CRO?
• Digital Marketing - Web Analytics
• Web Analytics Tools
• Digital Marketing - Facebook
• Digital Marketing - Pinterest
• Digital Marketing - Twitter
• Digital Marketing - Linkedin
• Digital Marketing - Youtube

Feel free to join to Dropshipping Business Model

• Have Your Own Dropshipping Business

Buy Digital Marketing Books

• Digital Marketing: Integrating Strategy and Tactics with Values
• The Art of Digital Marketing: The Definitive Guide to Creating Strategic, Targeted, and Measurable Online Campaigns
• Digital Marketing Strategy: An Integrated Approach to Online Marketing

facebook.com/ruelpluna.ph
+639226287015

Introduction to Website Design and Development - Overview

 

Module 1

• Definition of Terms
• Dynamics of World Wide Web
• Question and Answer
• Recap

Module 2

• HTML Basic
• HTML Images
• How To View HTML Source
• HTML Elements
• Nested HTML Elements
• HTML is Not Case Sensitive
• HTML Tag Reference
• HTML Attributes
• HREF Attributes
• Arc Attributes
• Width and Height Attributes
• Question and Answer
• Recap

Module 3

• Headings
• Paragraphs
• Styles
• HTML Display
• HTML Horizontal Rules
• HTML Line Breaks
• Pre Elements
• HTML Tag Reference
• HTML Style Attributes
• Background Colors
• Text Colors
• Fonts, Text Size, and Alignment
• Quotations
• Question and Answer
• Recap

Module 4

• HTML Comments
• HTML Colors
• RGB, Hex, HSLA, Color Values
• Question and Answer
• Recap

Module 5

• HTML Styles
• CSS
• HTML Links
• Question and Answer
• Recap

Module 6

• Images
• Images Tags
• Background Images
• Tables
• HTML Lists
• Question and Answer
• Recap

Module 7

• HTML Layout
• HTML Semantics
• HTML Forms
• Question and Answer
• Recap

Module 8

• HTML Canvas
• HTML SVG
• HTML Media
• HTML Video
• HTML Audio
• HTML Plugins
• Youtube
• Question and Answer
• Recap

Module 9

• Creating Your Own Blog Website
• Blogger
• How to Create Your Own Blog Name
• How to Post Your First Blog
• How to Select Your Own Theme
• Blogger Settings
• How to Make Your Blog Earn
• Question and Answer
• Recap

facebook.com/ruelpluna.ph
+639226287015