12 STD || PART-2 || CH-12- STRUCTURED QUERY LANGUAGE

 

 

 

 

 

Introduction to SQL

Th e Structured Query Language (SQL) is a standard programming language to access and manipulate databases. SQL allows the user to  reate, retrieve, alter, and transfer information
among databases. It is a language designed for managing and accessing data in a Relational
Data Base Management System (RDBMS).

Th ere are many versions of SQL. Th e original version was developed at IBM’s Research centre and originally called as Sequel in early 1970’s. Later the language was changed to SQL.

In 1986, ANSI (American National Standard Institute) published an SQL standard that was
updated again in 1992, the latest SQL was released in 2008 and named as SQL 2008.

==================

 

 

 

 

VIDEO LINK:

 

12 STD ||  PART-2  ||  CH-12- STRUCTURED QUERY LANGUAGE 

 

 

==================

 

 

==================

 

 

YOUTUBE LINK:

 

 

 

CLICK HERE  

 

 

 

 

12 STD || CH: 11- Network Examples and Protocols || Internet, Intranet,Extranet

 Introduction

Internet Protocol (IP) is the principle of the communications protocol in the Internet protocols for layering on datagram across boundaries of other networks. The main function is to allows Internet working and boost up the Internet. Internet protocol (IP) will deliver packets from the source host and it will deliver to the destination host via through an IP address in the packets header. Vint Cerf and Bob Kahnin in 1974 introduced IP connection less datagram service was in the transmission control program. 

 

Now the IP is referred as TCP/IP Transmission Control Protocol/Internet Protocol.

 

 

 இது கொஞ்சம் பெரியவீடியோ . இந்த பாடம் நன்றாக புரிய வேண்டும் என்றால் சிரமம் பார்க்காமல் நேரம் எடுத்து பார். 

வீடியோவில் 12,24,34,44,50 நிமிடங்களில் SCREENSHOT எடுத்து குருப்பில் போடு.

GOOGLE MEET நடக்கும் போது இதில் இருந்து கேள்விகள்கேட்கப்படும்.

 

 

VIDEO LINK:

 

 

 12 STD || CH: 11- Network Examples and Protocols  || Internet, Intranet,Extranet

 

 

YOUTUBE LINK:

 

 

CLICK HERE

12 STD || PART-1 || CH-12- STRUCTURED QUERY LANGUAGE

 

 

 

 

 

Introduction to SQL

Th e Structured Query Language (SQL) is a standard programming language to access and manipulate databases. SQL allows the user to  reate, retrieve, alter, and transfer information
among databases. It is a language designed for managing and accessing data in a Relational
Data Base Management System (RDBMS).

Th ere are many versions of SQL. Th e original version was developed at IBM’s Research centre and originally called as Sequel in early 1970’s. Later the language was changed to SQL.

In 1986, ANSI (American National Standard Institute) published an SQL standard that was
updated again in 1992, the latest SQL was released in 2008 and named as SQL 2008.

==================

 

 

 

 

VIDEO LINK:

 

12 STD ||  PART-1  ||  CH-12- STRUCTURED QUERY LANGUAGE 

 

 

==================

 

 

==================

 

 

YOUTUBE LICK:

 

 

 

CLICK HERE  

 

 

 

 

12 STD || PART-4 || CH: 11 DATABASE CONCEPTS || COMPUTER SCIEN

 

Relational Algebra in DBMS

What is Relational Algebra?

Relational Algebra, was first created by Edgar F Codd while at IBM. It was used for modeling the data stored in relational databases and defining queries on it.

Relational Algebra is a procedural query language used to query the database tables using SQL. Relational algebra operations are performed recursively on a relation (table) to yield an output. The output of these operations is a new relation, which might be formed by one or more input relations. Relational Algebra is divided into various
groups 

 

 

Unary Relational Operations

SELECT ( symbol : ó)

PROJECT ( symbol : Ð)

 

 

 

VIDEO LINK:

 

 12 STD ||  PART-4  ||  CH: 11  DATABASE CONCEPTS  || COMPUTER SCIENCE

 

========

 

 

YOUTUBE LINK:

 

 

CLICK HERE

 

 

 

 

 

12 STD || PART-3 || CH: 11 DATABASE CONCEPTS || COMPUTER SCIENCE

 

Relational Algebra in DBMS

What is Relational Algebra?

Relational Algebra, was first created by Edgar F Codd while at IBM. It was used for modeling the data stored in relational databases and defining queries on it.

Relational Algebra is a procedural query language used to query the database tables using SQL. Relational algebra operations are performed recursively on a relation (table) to yield an output. The output of these operations is a new relation, which might be formed by one or more input relations. Relational Algebra is divided into various
groups 

 

 

Unary Relational Operations

SELECT ( symbol : ó)

PROJECT ( symbol : Ð)

 

 

 

VIDEO LINK:

 

 12 STD ||  PART-3  ||  CH: 11  DATABASE CONCEPTS  || COMPUTER SCIENCE

 

========

 

 

YOUTUBE LINK:

 

 

CLICK HERE

 

 

 

 

 

12 STD || PART-1 ||CH: 11 DATABASE CONCEPTS || COMPUTER SCIENCE

 

 

 

 

 

Introduction:

A database is an organized collection of data, generally stored and accessed electronically from a computer system. The term "database" is also used to refer to any of the DBMS, the database system or an application associated with the database. Because of the close relationship between them, the term "database" is oft en used casually to refer to both a database and the DBMS used to manipulate it. 

 

A school class register is a database where names are arranged alphabetically. Databases have been around since people started recording things. Here we tend to focus on electronic ones

VIDEO LINK:

 

 12 STD ||  PART-1  ||CH: 11  DATABASE CONCEPTS  || COMPUTER SCIENCE

 

 

 

YOUTUBE LINK:

 

 12 STD ||  PART-1  ||CH: 11  DATABASE CONCEPTS  || COMPUTER SCIENCE

 

 

 

WATCH VIDEO HERE:

 

 

12 STD || PYTHON CLASSES AND OBJECTS || PART-3

 

 

 

 

 

 

 

Introduction 

Python is an Object Oriented Programming language. Classes and Objects are the key features of Object Oriented Programming. Th eoretical concepts of classes and objects are very similar to that of C++. But, creation and implementation of classes and objects is very simple in Python compared to C++.

Class is the main building block in Python. Object is a collection of data and function that act on those data. Class is a template for the object. According to the concept of Object Oriented Programming, objects are also called as instances of a class or class variable. In Python, everything is an object. For example, all integer variables that we use in our program is an object of class int. Similarly all string variables are also object of class string.

 

 

 

VIDEO LINK:

 

12 STD || PYTHON CLASSES AND OBJECTS || PART-3

 

 

 

YOUTUBE LINK:

 

 

CLICK HERE

 

 

 

12 STD || PYTHON CLASSES AND OBJECTS || PART-2

 

 

 

 

 

 

 

Introduction 

Python is an Object Oriented Programming language. Classes and Objects are the key features of Object Oriented Programming. Th eoretical concepts of classes and objects are very similar to that of C++. But, creation and implementation of classes and objects is very simple in Python compared to C++.

Class is the main building block in Python. Object is a collection of data and function that act on those data. Class is a template for the object. According to the concept of Object Oriented Programming, objects are also called as instances of a class or class variable. In Python, everything is an object. For example, all integer variables that we use in our program is an object of class int. Similarly all string variables are also object of class string.

 

 

 

VIDEO LINK:

 

12 STD || PYTHON CLASSES AND OBJECTS || PART-2

 

 

 

YOUTUBE LINK:

 

 

CLICK HERE

 

 

 

12 STD || PYTHON CLASSES AND OBJECTS || PART-1

 

 

 

 

 

 

 

Introduction 

Python is an Object Oriented Programming language. Classes and Objects are the key features of Object Oriented Programming. Th eoretical concepts of classes and objects are very similar to that of C++. But, creation and implementation of classes and objects is very simple in Python compared to C++.

Class is the main building block in Python. Object is a collection of data and function that act on those data. Class is a template for the object. According to the concept of Object Oriented Programming, objects are also called as instances of a class or class variable. In Python, everything is an object. For example, all integer variables that we use in our program is an object of class int. Similarly all string variables are also object of class string.

 

 

 

VIDEO LINK:

 

12 STD || PYTHON CLASSES AND OBJECTS || PART-1

 

 

 

YOUTUBE LINK:

 

 

CLICK HERE

 

 

 

12-STD || CH 9- Connecting PHP and MYSQL || CA

 

 

 

 

Connecting PHP and MySQL

Data is important in computer and Internet related applications. Numerous growths of data need a secure and convenient environment to store and manipulate autonomously. All these features are available in Relational Database Management System (RDMS) such as MySQL, Oracle, IBM DB2, and Microsoft SQLSERVER etc. These databases are connected with Programing language and perform major operations like INSERT, SELECT, UPDATE and DELETE using Structured query language (SQL). The combination of PHP and MySQL has become very popular server side web scripting language in Internet.

 

CLICK ANY AD TO DEVELOP THIS SITE 

 

VIDEO LINK:

 

 

12-STD || CH 9- Connecting PHP and MYSQL || CA

 

 

 

YOUTUBE LINK:

 

CLICK HERE

 

 

 

 

 

 

 

12 STD - REVISION -1 - STUDY MATERIALS FOR COMPUTER

 

STUDY MATERIALS ....

COMPUTER SCIENCE

STUDY MATERIALS ....

 

 

COMPUTER APPLICATION

 

 

 

 

12 STD || Part-1 : COMPUTER || Chapter 8 - Strings and String Manipulation

 

Introduction 

       String is a data type in python, which is used to handle array of characters. String is a sequence of Unicode characters that may be a  combination of letters, numbers, or special
symbols enclosed within single, double or even triple quotes.

‘Welcome to learning Python’
 

“Welcome to learning Python”
 

‘‘‘ “Welcome to learning Python” ’’’
 

Example
 

In python, strings are immutable, it means, once you defi ne a string, it cannot be changed during execution.

 

 

VIDEO LINK:

 

 12 STD || COMPUTER || Chapter 8 - Strings and String Manipulation || Part-1

 

 

 

WATCH HERE:

 

 

 

 

 

YOUTUBE LINK:

 

CLICK HERE

12 STD || PHP || PART-1 INTRODUCTION TO PHP

 

In the evolution of network architecture, various critical networks related problems are getting resolved by client server architecture model. The client server architecture introduces application sharing  mechanism between two different hardware systems over the network (Internet/intranet). In 1990’s Internet was emerging in the computer network field. The main objective of Internet implies that an application is shared by more than one hardware either it could be a server or client machine. 

 

 

The server is a high performance hardware machine which can run more than one application concurrently. The client is a separate hardware machine which is connected with server in the network  (Internet/intranet). It could send the request and receive the response from the server hardware. The Server and client are also called as service provider and service requester respectively..

 

 

VIDEO LINK:

 

 12 STD || PHP || PART-1  INTRODUCTION TO PHP

 

 

==================

 

VIEW VIDEO HERE:

 

 

 

 

 

==================== 

YOUTUBE LINK :

 

CLICK HERE

12 CA || CH: 4 || PART-2 || Introduction to Hypertext Pre-Processor

 

         The Web based Internet application ensures the success of critical business in real world competitions. Th e legacy programing languages didn’t meet out the expectations of latest Internet concepts and executions.

PHP (Hypertext Pre-processor) is a one of the important server side Weband general purpose scripting language invented by Rasmus Lerdorf in 1994. It is very simple and lightweight open source server side scripting language. It can easily embed with HTML and other client side scripting languages like CSS (Cascading Style Sheets) and Java script. It also creates dynamic and interactive Webpages in the real time Web development projects.

 

CLICK THIS AD:

 

 

***********

VIDEO LINK:

 

 https://youtu.be/kegXI0W7_tU

 

===============

WATCH VIDEO HERE

 

 

 

 

 

=================

 

YOUTUBE LINK:

 

 

CLICK HERE

12 STD || CH: 7 || PYTHON || BUILD IN FUNCTIONS || COMPUTER SCIENCE

 

 

 

What is Composition in functions?

The value returned by a function may be used as an argument for another function in a nested manner. This is called composition. For example, if we wish to take a numeric value or an expression as a input from the user, we take the input string from the user using the function input() and apply eval() function to evaluate its value.

 

 

VIDEO LINK:

 

CLICK HERE

 

 

 

WATCH VIDEO HERE:

 

 

 

 

YOUTUBE LINK:

 

12 STD || CH: 7 ||  PYTHON || BUILD IN FUNCTIONS || COMPUTER SCIENCE

 

 

 

12 STD || CH: -7 || FUNCTIONS IN PYTHON || COMPUTER SCIENCE

 

 

Defining Functions.

Functions must be defined, to create and use certain functionality. There are many built-in functions that comes with the language python (for instance, the print() function), but you can also define your own
function. When defining functions there are multiple things that need to be noted;

• Function blocks begin with the keyword
“def” followed by function name and
parenthesis (). 

 

 VIDEO LINK

CLICK HERE

WATCH VIDEO HERE:

YOUTUBE LINK:

12 STD || FUNCTIONS IN PYTHON || COMPUTER SCIENCE

 

 

 

 

 

12 STD || CH: 7 || PART-1 || FUNCTION IN PYTHON INTRO

 

 

 

Introduction.

Functions are named blocks of code that are designed to do specifi c job. When you want to perform a particular task that you have defi ned in a function, you call the name of the function responsible for it. If you need to perform that task multiple times throughout your program, you don’t
need to type all the code for the same task again and again; you just call the function dedicated to handling that task, and the call tells Python to run the code inside the function. You’ll fi nd that using functions makes your programs easier to write, read, test, and fix errors. 

 

 

VIDEO LINK:

 

CLICK HERE

 

 

 

WATCH VIDEO HERE:

 

 

 

YOUTUBE LINK:

 

 12 STD || CH: 7 || PART-1 ||  FUNCTION IN PYTHON INTRO

 

 

12 std || PART-2 || PYTHON || JUMP STATEMENT

 

Jump Statements in Python

The jump statement in Python, is used to unconditionally transfer the control from one part of the program to another. There are three keywords to achieve jump statements in Python : break, continue, pass. The following flowchart illustrates the use of break and continue.

VIDEO LINK:

12 std || PART-2 || PYTHON || JUMP STATEMENT 

WATCH VIDEO HERE: