Computer Skills Complete Course

Introduction to SQL | SQL Basic Tutorial | SQL Interview Questions


Introduction to SQL and use of SQL basic tutorial for beginners includes features of SQL and SQL Interview Questions and answers. This unit gives knowledge of hands on experience to use SQL. It focuses on the creations, modification, deletion and manipulations of tables. The objective of the unit to understand how to create table, Alter The Table, Delete the table, Insert rows into a table, manipulate simple queries, use built in functions and managing multiple tables. SQL Introduction SQL abbreviated “Structured Query Language”. It is pronounced SQL or “Sequel”. It is standard language for creating and querying in relational database. 

The users can manipulate database tables with little experience by applying simple commands. 
SQL commands are implemented on Mainframe computers, client server and personal computers. There are two modes of implementations embedded and interactive. 
Oracle is used for implementations. 


Computer Skills Complete Course | Use of MS-Word MS-Excel Internet Programming C Turbo | Introduction of Computers and History


Computer Skills Complete Course | Use of MS-Word MS-Excel Internet Programming C Turbo | Introduction of Computers and History


INTRODUCTION OF COMPUTER CONCEPTS

Unit No. 1 COMPUTER AND PROCESSORS
a) Definition, Characteristics and history and types of Computer
b) Computer Organization
Introduction of the Unit:
Computer & its uses
Capabilities and limitations of computers
Classification of computers
Types of computers
History and evolution of computers
Basic operations of computers
Organization of computers
What is a computer?
Basic units of computer and their purpose
How computers work
Features of computers
Uses of computers
Types of computers
Generations of computers
Applications of computers
Basic computer operations

Unit No. 2 BUS, PROCESSOR, AND PC PLATE FORM
a) Bus, Port, PC Plate Forms
b) The Processor Characteristics (Word Size, Processor Speed, Ram Capacity)
Introduction of the Unit:
We will introduce you to Computer bus and its types
Serial and parallel ports
Operating systems for computers
Microprocessor and its characteristics
Objectives of the Lesson
Define computer bus
Types of buses and their features
Understand use of different ports
Different PC platforms
Explain
Word size, cache memory, RISC Computing, CISC computing, parallel Processing

Unit. No. 3 BASICS OF DIGITAL COMPUTERS
a) Number System, Basics of Logic Gates
b) Basic of Boolean Algebra
Introduction of the Unit:
Number Systems
Representation of expressions
Number conversion
Learn Boolean algebra
Learn Boolean expressions
Precedence of operators
Truth tables
Representation of logical operations
Logical gates
Objectives of the Lesson
Understand number systems
Represent expressions
Covert numbers
Solve Boolean expressions
Create truth tables
Solve truth table
Understand purpose of logical gates
Unit. No. 4 DATA PROCESSING, STORAGE, AND I/O DEVICES
a) Data Processing Techniques
b) Data Storage (Bit, Byte, Ram, Rom, Cache Memory, And Secondary Storage)
c) Input Devices
1) Keyboard and its types, point and Draw Devices
2) Scanner, Digital Camera, And Speech Recognition System and Multimedia
d) Output Devices
1) Monitor (Graphic Adopter, Size, Resolution, and Types of Monitors)
2) Printers and Types (Dot Matrix, Ink Jet, and Laser), Plotters (Raster & Pen)
3) Presentation Graphics, and Special Function Terminal (ATMs, POSS)
Data processing techniques
Data Storage and their features
Types of computer memory
Primary and secondary storage devices
Input devices
Output Devices
Special Terminals
Objectives of the Lesson
Data Processing techniques
Data Storage and their features
Types of computer memory
Input devices/output devices

Unit No. 5 SOFTWARE
a) Types of Software, Windows Introduction, Understanding Windows Help
b) The Desktop, and Types of Windows (Application, Document, and Dialog)
c) Elements of An application Windows
d) Understanding Folders, Copying, Deleting and Moving Files

Unit No. 6  PROGRAMMING CONCEPTS
a) Programming Languages, Main components of Program
b) Simple Program Construction, Program Exercises In any High Level Language
Introduction of the Unit:
Programming languages and their features
Simple program construction
Main components of a program
Turbo C integrated development environment
Writing program in C languages
Objectives of the Lesson
Use suitable programming language to write program like C/C++.
Construct simple program
Identify main components of a program
Use turbo C integrated environment to
Write, Save, Compile and execute programs.

Unit No. 7  WORD PROCESSING (MS WORD)
a) Basic Concepts and Features, Creating, Saving, Editing, Formatting
b) Printing Documents, Working on Multiple Documents
Introduction of the Unit:
In this unit we will introduce you to:
Basic concept and features of MS Word
Advance features of MS word
Creating new document
Saving Editing text Selecting Word, line, text Deleting text
Formatting Work Document
Print preview and printing
Working with multiple documents

Unit No. 8 ELECTRONIC SPREADSHEET (MS EXCEL)
a) Basic Concepts and Features, Creating, Saving Excel Sheet, Editing The Sheet
b) Managing Formula, Formatting and Printing the Sheet, Working on Workbook
Objectives of the Lesson
After completing this unit you must be able to:
Microsoft excel
Basic features of MS Excel
Creating and save a workbook
Edition work sheet contents
Perform mathematical calculation
Apply formatting to work sheet content
Print work sheet and workbook

Unit No. 9  BASIC OF INTERNET USAGE
a) Introduction, World Wide Web and Web Sites
b) Introduction To Internet Based Services, and Use of Email
Objectives of the Lesson
After completing this unit you should be able to:
Define internet and World Wide Web
Brows popular websites
Utilize internet based services
Send and receive E-Mail


Subscribe Here: https://www.youtube.com/channel/UCiV37YIYars6msmIQXopIeQ

Like Facebook Page: https://web.facebook.com/Computer-Education-for-All-1484033978567298