Class 12 Computer Science/ Informatics Practice Term - 2

Go to Udemy

Database concept and SQL queries

This course is created for the students of class 12 to learn and score more marks in database concept and SQL. All the contents have been taken to represent the syllabus of class 12 Computer Science and Informatics Practices. Students are going to learn and also they are going to become an expert on the said topic. Through practical examples and also through the practical analysis of bugs, students will achieve very high level of thinking.

Database concept is the theoretical topic which provides you to learn various jargons and terminology used in the world of DBMS. You are going to learn all the advantages and disadvantages of various terms.

What is Data?

In simple words, data can be facts related to any object in consideration. For example, your name, age, height, weight, etc. are some data related to you. A picture, image, file, pdf, etc. can also be considered data.

What is Database?

A database is a systematic collection of data. They support electronic storage and manipulation of data. Databases make data management easy.

Here are some popular types of databases.

Distributed databases:

A distributed database is a type of database that has contributions from the common database and information captured by local computers. In this type of database system, the data is not in one place and is distributed at various organizations.

Relational databases:

This type of database defines database relationships in the form of tables. It is also called Relational DBMS, which is the most popular DBMS type in the market. Database example of the RDBMS system include MySQL, Oracle, and Microsoft SQL Server database.

Object-oriented databases:

This type of computers database supports the storage of all data types. The data is stored in the form of objects. The objects to be held in the database have attributes and methods that define what to do with the data. PostgreSQL is an example of an object-oriented relational DBMS.

You are going to understand the essentiality of RDBMS and also the use of SQL.

SQL Queries are very deep learning topic. This course focused on very specific topics required for the students of class 12.

There are different categories of SQL statements that you are going to learn in the course.

Go to Udemy