Author Archive Slide Scope

BySlide Scope

Create Read Update Delete in PHP with Source Code

Source Code of Create, Read, Update and Delete in Php.

Source code of config.php

<?php
$conn = mysqli_connect(“localhost”, “root”, “”, “northwind”) OR die(“CNC”);
?>

Showcustomers.php

<?php
include ‘config.php’;
$sqlshow = “SELECT `CustomerID`, `CompanyName`, `ContactName`, `ContactTitle` FROM `customers` “;
$results = mysqli_query($conn, $sqlshow);
echo “<table border=’1′ width=’100%’><tr><th>ID</th> <th>CompanyName</th> <th>ContactName</th> <th>ContactTitle</th></tr>”;
foreach($results as $result){
?>
<tr>
<td><?php echo $result[‘CustomerID’];?></td>
<td><?php echo $result[‘CompanyName’];?></td>
<td><?php echo $result[‘ContactName’];?></td>
<td><?php echo $result[‘ContactTitle’];?></td>
<td>
<a href=”editcustomers.php?cust_id=<?php echo $result[‘CustomerID’];?>”>Edit</a>
</td>
</tr>
<?php
}
echo “</table>”;
?>

Editcustomers.php

<?php
include ‘config.php’;
$custid = $_GET[‘cust_id’];
$sqlshow = “SELECT `CustomerID`, `CompanyName`, `ContactName`, `ContactTitle`
FROM `customers`
WHERE CustomerID = ‘$custid’;
“;
$results = mysqli_query($conn, $sqlshow);
foreach($results as $result){
?>

<form>
<input type=”hidden” name=”contid” value=”<?php echo $_GET[‘cust_id’];?>”><br/>
<input type=”text” name=”cmpname” value=”<?php echo $result[‘CompanyName’];?>”><br/>
<input type=”text” name=”contname” value=”<?php echo $result[‘ContactName’];?>”><br/>
<input type=”text” name=”contitle” value=”<?php echo $result[‘ContactTitle’];?>”><br/>
<input type=”submit” name=”update” value=”Update”>
</form>
<?php
}
echo $_GET[‘cust_id’];
?>

Download Sql from here

 

https://www.aspsnippets.com/Articles/Download-and-Install-Microsoft-Northwind-Sample-database-in-MySql.aspx

BySlide Scope

R Programming Course in Lucknow for Data Science

What is R Programming for Data Science?

  • R is a simple programming language
  • R is a software environment for statistical analysis
  • R is Used for graphics representation
  • R is used for Reporting
  • R can be used for Data Analytics, Business Intelligence and Data Visualization

What are the benefits of Doing R Programming Course for Data Science?

  • R is an easy to learn language, no programmers can easily learn R for Data Analytics and Business Intelligence.
  • R has a huge community of programmers, you will get answers to all your queries in forums and video libraries.
  • R is Opensource, free to install and use.
  • R is Cross Platform Compatible.
  • R is flexible and ‘fun to learn’.
  • Advanced visualizations are possible in R Language.
  • R can be connected almost all types of data sources like:
    • JSON
    • HTML
    • SQL
    • XML etc.

Who needs to learn R Programming Language?

Individuals who want to build their career in the field of:

  • Statistics
  • Data Analytics
  • Big Data
  • Business Intelligence
  • Digital Marketing

Syllabus of R Programming Language Course?

  • Overview of R,
  • R data types and objects
  • Reading and writing data in R
  • Control structures and functions in R
  • Scoping rules, Dates and Times in R
  • Loop functions in R Programming
  • Debugging tools in R
  • Statistical Simulation and Code Profiling in R
  • Graphics and Visualization in R

Why you should chose Slidescope™ for R Programming Course?

We have a pool of experienced professionals with decades of working experience in the field of Sales, Marketing, IT Consulting, Software Development, Marketing Research and Business Analytics.

We are working as Digital Marketing Consultant for leading Manufacturing, Trading and Consulting Companies in Uttar Pradesh, India.

You will learn R programming language on Live Projects.

If you are interested in Joining the Course you can Contact Us

 

BySlide Scope

Latest Google Algorithm Updates – January 2019

We are sharing our view on latest google algorithm updates in January 2019. These updates are based on our research and assumptions.

Here are the Latest Google Algorithm Updates

  1. Articles with content of 800 Words or more are performing better in search results.
  2. Google Business Pages with more than 5 punctuation marks – (Eg – Social, Web-Designing, Web-Development, Hosting, Digital Marketing Company . In this company name more than 5 punctuation marks are used.) are getting suspended by google team.
  3. Do not use | symbol in your google business name.

Latest google algorithm changes

Google algorithm updates explained

 

Contact Us

BySlide Scope

Quiz MCQ 1

Fill In the blanks

 

Verification

BySlide Scope

Complete Facebook Page Setup Guide and Tutorial

This is a step by step or a Complete Facebook Page Setup Guide and Tutorial which covers following steps:

  1. Creating a Facebook Business Page
  2. Basic settings of a Facebook Page.
  3. Roles Management in Facebook Page
  4. Automatic Message Responding in Facebook Business Page.
  5. Settings Link Tabs
  6. Choosing the best template as per the type of business.
  7. Setting Cover Images in FB Page.
  8. Setting Logo Image in FB Page.
  9. An overview of insights in Facebook Page.
  10. Posting images and videos in a Facebook page.

BySlide Scope

Setup and Configuration of a Blogspot blog on Blogger.com

This video tutorial will guide in setting up your blogspot blog.

BySlide Scope

Ultimate Steps Needed for Digital Marketing of Any Project

In this article we will discuss about all the steps needed for Digital Marketing of any project.

It will include keyword research On Page SEO, off Page SEO, Social Media Optimization(SMO) and Marketing(SMM), Website Indexing in search engines and web data analytics for future plans.

We will share name and links of useful tools with steps.

This article will be useful for revision of Digital Marketing Course as well.

Note: Basic understanding of all the modules is necessary to understand the steps mentioned in this article.

Here are the Steps Needed for Digital Marketing of Any Project

Step 1 – Analyze the technology in which the website is developed.

You can this tool – www.builtwith.com

This tool will give you a list of programming languages in which the website is created. – Eg: HTML5, CSS3, Bootstrap | PHP, ASP.Net etc.

It will also tell you the name of CMS. – Eg: WordPress, Magento, Opencart etc.)

Most of the websites are built using languages like:

CASE A – HTML, CSS, JS. (Including Bootstrap)

CASE B – WordPress / Magento

CASE C – PHP with MySql

CASE D – ASP.NET with MSSql Server

On Page SEO for CASE A

Consider this template :

<html>

<head>

<!– SEO TAGS ARE WRITTEN HERE –>

<!—Go to SEO Meta Tags Generator Tool  and Generate SEO Tags and Paste here

Eg : <meta charset=”utf-8″>

<title>Digital Marketing Executive</title>

<meta name=”description” content=”This is description”>

<meta name=”author” content=”Ankit”>

Important : Title Tag has focused keywords separated by , or | or – or any other separator.

These keywords can be obtained from Keyword Research Based on the Services of Website.

For Keyword Research: Go to https://keywordtool.io/google , search targeted keywords and get suggestions.

Use suggested keywords you want to target, in your:

  • Meta Title
  • Meta Description
  • Headings
  • Opening Paragraphs
  • Image Alternate Text

–>

</head>

<body>

<h1>Targeted Keyword</h1>

<img src=”path of image” alt=”Targeted Keyword” title=”Targeted Keyword Variation”>

<p>First line of First Paragraph – Targeted Keyword</p>

<h2>Suggested Keywords or Secondary Keywords </h2>

<img src=”Path” alt=”Secondary Keyword” title=”Secondary Keyword Variation”>

<p>Paragraph explaining Keyword used in respective H2 </p>

Note: There can be more than one Secondary Keywords and hence we can use many H2 Tags containing secondary keywords.

</body>

</html>

Pretty Urls – Save the page with focused keyword in its name.

Eg: best-website-designing-company.html

Note: Do not use spaces in page name.

Image Optimization: After adding Images make sure that image size should not exceed 100 KB

For this compression of size you can use following tool:

Image Compression Tool

Social Media Optimization

Facebook has developed a Protocol Named – Open Graph Protocol (OG)

It enables website developers to control the information that is automatically fetched from website urls when they are shared on Social Media Sites like: Facebook, Google Plus, Linked In and even whatsapp.

Twitter has it’s own SMO protocol known as Twitter Cards.

For OG Meta Tags

Go to OG Meta Tags Generator

Eg:

<meta property=”og:title” content=”Title for Social Media”>

<meta property=”og:description” content=”Description for Social Media “>

<meta property=”og:image” content=”Image to be displayed in Social Media”>

<meta property=”og:url” content=”URl Where you will paste this code”>

Note: Image dimensions should be 2(Width):1(height). Eg: 800px * 400 px

For Twitter Card Meta Tags

Go to Twitter Cards Generator 

Eg:

<meta name=”twitter:card” content=”summary”>

<meta name=”twitter:site” content=”@slide_scope”>

<meta name=”twitter:title” content=”Slidescop Digital Marketing Tutorial”>

<meta name=”twitter:description” content=”This is a twitter card description”>

<meta name=”twitter:image” content=”https://slidescope.com/wp/wp-content/uploads/2018/06/slidescope-logo-digital.png”>

<meta name=”twitter:image:alt” content=”Digital Marketing Tutorial”>

Note: Twitter card is of 4 types – Summary, Summary With Large Image, App Card, Player Card

For Summary with large image use image with 2(Width):1(height).

For Summary use square image.

BySlide Scope

11th & 12th (Commerce) Accounts Coaching Classes in Lucknow

We provide professional coaching for 11th & 12th (Commerce) Accounts in Lucknow.

We have experienced faculty in the field of Commerce and Management Science with 8+ years of expertise in the field of Business Administration and Economics.

Here is the syllabus of Financial Accounting for Class 11th

This Syllabus is of CBSE Board

Part A: Financial Accounting – I (50 Marks)

Unit 1: Theoretical Framework

Introduction to Accounting

  • Accounting: objectives, advantages and limitations, types of accounting information; users of accounting information and their needs.
  • Basic accounting terms: business transaction, account, capital, drawings, liability (Non – current and current); asset (Non – current; tangible and intangible assets and current assets), receipts (capital and revenue), expenditure (capital, revenue and deferred), expense, income, profits, gains and losses, purchases, purchases returns, sales, sales returns, stock, trade receivables (debtors and bills receivable), trade payables (creditors and bills payable), goods, cost, vouchers, discount – trade and cash.

Theory Base of Accounting

  • Fundamental accounting assumptions: going concern, consistency and accrual.
  • Accounting principles: accounting entity, money measurement, accounting period, full disclosure, materiality, prudence, cost concept, matching concept and dual aspect.
  • Accounting Standards and IFRS (International Financial Reporting Standards): concept and objectives
  • Double entry system of accounting.
  • Bases of accounting – cash basis and accrual basis.

Unit 2: Accounting Process

Recording of Transactions

  • Accounting equation: analysis of transactions using accounting equation.
  • Rules of debit and credit: for assets, liabilities, capital, revenue and expenses
  • Origin of transactions- source documents (invoice, cash memo, pay in slip, cheque), preparation of vouchers – cash (debit and credit) and non cash (transfer).
  • Books of original entry: format and recording – Journal.
  • Cash Book: Simple Cash Book, Cash Book with Discount Column and Cash Book with Bank and Discount Columns, Petty Cash Book.
  • Other books: purchases book, sales book, purchases returns book, sales returns book and journal proper.

Preparation of Bank Reconciliation Statement, Ledger and Trial Balance.

  • Bank reconciliation statement- calculating bank balance at accounting date: need and preparation. Corrected cash book balance.
  • Ledger – format, posting from journal, cash book and other special purpose books, balancing of accounts.
  • Trial balance: objectives and preparation

(Scope: Trial Balance with balance method only)

Depreciation, Provisions and Reserves

  • Depreciation: concept need and factors affecting depreciation; methods of computation of depreciation: straight line method, written down value method (excluding change in method)
  • Accounting treatment of depreciation: by charging to asset account, by creating provision for depreciation/ accumulated depreciation account, treatment of disposal of asset.
  • Provisions and reserves: concept, objectives and difference between provisions and reserves; types of reserves- revenue reserve, capital reserve, general reserve and specific reserves.

Accounting for Bills of Exchange

  • Bills of exchange and promissory note: definition, features, parties, specimen and distinction.
  • Important terms : term of bill, due date, days of grace, date of maturity, discounting of bill, endorsement of bill, bill sent for collection, dishonour of bill, noting of bill, retirement and renewal of a bill.
  • Accounting treatment of bill transactions.

Rectification of Errors

  • Errors: types-errors of omission, commission, principles, and compensating; their effect on Trial Balance.
  • Detection and rectification of errors; preparation of suspense account.

Part B: Financial Accounting – II (40 Marks)

Unit 3: Financial Statements of Sole Proprietorship

  • Financial Statements: objective and importance.
  • Trading and profit and loss account: gross profit, operating profit and net profit.
  • Balance Sheet: need, grouping, marshalling of assets and liabilities.
  • Adjustments in preparation of financial statements : with respect to closing stock, outstanding expenses, prepaid expenses, accrued income, income received in advance, depreciation, bad debts, provision for doubtful debts, provision for discount on debtors, manager’s commission, abnormal loss, goods taken for personal use and goods distributed as free samples.
  • Preparation of Trading and Profit and Loss Account and Balance Sheet of sole proprietorship.
  • Incomplete records: use and limitations.
  • Ascertainment of profit/loss by statement of affairs method.

Unit 4: Financial Statements of Not-for-Profit Organizations

  • Not-for-profit organizations: concept.
  • Receipts and Payment account: features.
  • Income and Expenditure account: features. Preparation of Income and Expenditure account and Balance Sheet from the given Receipts and Payments account with additional information.

Scope:

  1. Adjustments in a question should not exceed 3 or 4 in number and restricted to subscriptions, consumption of consumables, and sale of assets/ old material.
  2. Entrance/ admission fees and general donations are to be treated as revenue receipts.
  3. Trading Account of incidental activities is not to be prepared.

Unit 5: Computers in Accounting

  • Introduction to Computer and Accounting Information System {AIS}: Introduction to computers (Elements, Capabilities, Limitations of Computer system),
  • Introduction to operating software, utility software and application software. Introduction to Accounting Information System (AIS), as a part of MIS
  • Automation of Accounting Process. Meaning
  • Stages in automation
    • (a) Accounting process in a computerised environment; comparison between manual accounting process and Computerised accounting process.
    • (b) Sourcing of accounting Software; kinds of software: readymade software; customised software and tailor-made software; Generic Considerations before sourcing accounting software
    • (c) Creation of Account groups and hierarchy
    • (d) Generation of reports -Trial balance, Profit and Loss account and Balance Sheet.

Scope:

  • The scope of the unit is to understand accounting as an information system for the generation of accounting information and preparation of accounting reports.
  • It is presumed that the working knowledge of any appropriate accounting software will be given to the students to help them learn basic accounting operations on computers

Part C: Project Work (10 Marks)

Any One:

  1. Collection of Source Documents,Preparation of Vouchers, Recording of Transactions with the help of vouchers.
  2. Preparation of Bank Reconciliation Statement with the given cash book and the pass book with twenty to twenty-five transactions.
  3. Comprehensive project starting with journal entries regarding any sole proprietorship business, posting them to the ledger and preparation of Trial balance.The students will then prepare Trading and Profit and Loss Account on the basis of the prepared trial balance. Expenses, incomes and profit (loss) are to be depicted using pie chart / bar diagram.

 

BySlide Scope

IoT Training in Lucknow

IoT Stands for Internet of Things. There has been a huge buzz about IoT recently. IoT has a potential of transforming future.

IoT requires sound knowledge of Embedded Systems and Website Coding Technologies.

What is IoT?

IoT is made up of two words primarily, Internet and Things. Things are Electronic Devices and when they are connected to internet to receive and send data a term Internet of Things is used to describe them.

There are 7 Billion Electronic Devices in the world and according to a research this number will be increases to 50 billion by the end of 2020. Most of these devices will be a part of IoT. IPV6 Protocol will be used to provide IP address to these devices.

Explanation:  Sensors and other devices are used to detect physical quantities such as:

  • Temperature,
  • Speed,
  • Luminous Intensity,
  • Pressure, etc.

Data detected from these physical quantities is converted into digital form or machine readable form by integrated circuits.

Digitalized data is supplied to computers by means of communication ports such as USB, Wifi, Bluetooth, Ethernet etc.

Applications or Software are designed to collect and display the data on VDUs.

Data can be transferred to Cloud Hosting Servers. Data on Cloud can be accessed from any other device connected to internet from any location in the world.

Consider an Example to better understand IoT:

You are wearing a smart watch that can detect your health parameters like Blood Pressure, Body Temperature etc. This data is also hosted on cloud and your doctor has the access to your health conditions. He can monitor, warn and consult you in case of problems.

Devices used to collect and convert data into usable formats are as follows:

  • Microcontrollers
  • Computer Peripherals
  • Arduino UNO
  • Shields and Sensors
  • Transducers
arduino-uno-for-iot

Arduino UNO Circuit Board Used for IoT projects

Where is IoT Used?

Internet of Things was first used in 1970 in the Computer Science department at Carnegie Mellon University. Since then IoT is used in following sectors:

  • Retail
  • Manufacturing
  • Transportation
  • Smart Infrastructure
  • Healthcare

What are the Applications of IoT?

IoT has following useful applications:

  • In Residential and Industrial Security Systems
  • Industrial Automation
  • Remote Access of Electronic Devices
  • Monitoring Health Parameters of Body
  • Vehicle Theft Protection

Syllabus of Internet of Things Training Course

This is an overview of the topics that are taught in IoT:

  • Introduction to Internet of things
  • Embedded Systems and their Applications
  • Shields Sensors and Transducers
  • Device Interfacing
  • Arduino UNO
  • Internet Protocols: HTTP
  • Web Development Basics