A free video tutorial from Saad Qureshi
Computer Scientist || Freelancer || Programmer
3.9 instructor rating • 8 courses • 8,849 students
Learn more from the full courseSQLite Fundamentals - Comprehensive SQL course on SQLite
A comprehensive course on SQLite Fundamentals and SQL
04:53:21 of on-demand video • Updated August 2019
- Learn to write SQL queries in SQLite database
- Hands on experience of all the major concepts.
- Answer variety of database problems through SQL
- At the end of this course, You will be able to use SQL statements in any database management system.
English [Auto] Hello everyone. Welcome to database overview lecture. We'll start with the concept of data. So what is data. In simple words data can be facts related to any object. For example your name age height are data related to you pictures images and files are also considered to be data. So to store data we need a database. So what is database. A database is a collection of information that is organized so that it can be easily accessed managed and updated in chart in databases. Information is then organized in structure thought to manage databases. We need a proper database management system. So what is database management system. A database management system is system software for creating and managing databases. Database management system provides users and programmers to systematically to create update and retrieve data. So these are some of the popular database management systems might as well. Microsoft Access Teradata. Oracle. So let's see the use of database management system. So for example an online telephone directory would definitely use database management system to store data related to people's phone number and other contact details. Likewise your electricity provider is obviously using database management system to manage billing client related issues and to handle false data et cetera. So in databases information is stored in the form of tables so a table consists of columns and rules. So in this particular example I have three columns in full rules so horizontal cells are known as rules various vertical cells are known as columns. So numbers Gore's name in credit cards. These are columns of this table. So these are rules of this table. First row second row third row and fourth. Okay so in total I'm going to have four rows and three columns. So this is what I have from this lecture. Thank you so much and have a great learning.