Sequel or structured based query language is a standard data-based language that is used to create, maintain, and retrieve relational databases. Starting in the 1970’s sequel has become a very important tool in a data scientist toolbox since it is critical in accessing, updating, manipulating, and modifying data. Understanding this, we have come up with “SQL Tutorial For Beginners”
SQL stands for Structured Query Language. SQL is a standard programming language specifically designed for storing, retrieving, managing, or manipulating the data inside a relational database management system (RDBMS). SQL is the most widely-implemented database language and supported by the popular relational database systems, like MySQL, SQL Server, and Oracle. However, some features of the SQL standard are implemented differently in different database systems.
SQL also used to perform operations on the records stored in the database such as updating records, deleting records, creating and modifying tables, views, etc. In this tutorial, we have covered all the important topics such as, What is SQL, What are its features, How to use it, and much more, that will help you to understand this concept with ease.
Following pointers will be covered in this video:
- 00:00:00 Introduction
- 00:00:43 Agenda
- 00:01:02 DBMS
- 00:10:12 Traditional File Approach
- 00:14:57 Database
- 00:28:55 Defining Database Model and its types
- 01:13:47 Data Querying and Manipulation
- 01:47:10 Displaying Data From Multiple Tables Using Joins
- 02:20:40 Joins
- 03:35:50 Set Operators
- 03:37:30 Using Subqueries
- 03:55:09 Group Functions in SubQuery
#sql #database
