Sql (Structured Query Language) Basics

SQL (Structured Query Language) Basics

What you'll learn

Inserting, Updating, and Deleting Data

Working with Multiple Tables

Aggregate Data Functions

Data Types and Constraints

Creating and Modifying Tables

Requirements

No programming experience is required

Description

SQL or the Structured Query Language is a standard programming language used to manage and manipulate data in relational databases. It allows users to interact with databases by querying, inserting, updating, and deleting data. SQL is used by all database management systems like MySQL, PostgreSQL, SQL Server and Oracle etc.In this course you will learn core concepts of SQL or the Structured Query Language. You will learn how to use SQL to Store, Read and Manipulate data.Learn how to retrieve, manipulate, and manage data in relational databases using essential SQL commands like SELECT, INSERT, UPDATE, DELETE, and JOIN.Here's a breakdown of what you'd typically learn:1. Introduction to Databases and SQLWhat is a database? Understanding what databases are and why they are used.What is SQL? The role of SQL in interacting with databases.Relational database concepts like tables, rows, columns, and keys.2. Basic SQL CommandsSELECT Statement: How to retrieve data from a table.WHERE Clause: Filtering data based on conditions.ORDER BY: Sorting data in ascending or descending order.LIMIT: Restricting the number of rows returned.3. Inserting, Updating, and Deleting DataINSERT INTO: Adding new records to a table.UPDATE: Modifying existing records.DELETE: Removing records from a table.4. Working with Multiple TablesJOINs: Combining data from multiple tables (INNER JOIN, LEFT JOIN, RIGHT JOIN, etc.).GROUP BY: Grouping data based on certain columns, often with aggregation.HAVING: Filtering grouped data (similar to WHERE, but for aggregated results).5. Aggregate FunctionsUsing functions like COUNT(), SUM(), AVG(), MIN(), and MAX() to perform calculations on data.6. Data Types and ConstraintsUnderstanding common data types (e.g., INT, VARCHAR, DATE).PRIMARY KEY: Ensuring each record is unique.FOREIGN KEY: Enforcing relationships between tables.NOT NULL: Ensuring that a column cannot contain null values.7. Creating and Modifying TablesCREATE TABLE: Creating new tables in a database.ALTER TABLE: Modifying the structure of an existing table (e.g., adding new columns).DROP TABLE: Deleting a table from the database.By the end of this course you will have an excellent understanding of the SQL i.e. the Structured Query LanguageYou should be able to write simple queries to retrieve and manipulate data in relational databases, as well as understand how to design and modify database structures.

Overview

Section 1: Introduction

Lecture 1 Welcome to the world of SQL !!

Lecture 2 Course Format

Lecture 3 Introduction to Databases and SQL

Section 2: Tables - School Management System

Lecture 4 Tables - School Management System

Lecture 5 Data Types

Lecture 6 Table Creation

Lecture 7 Primary and Foreign Keys

Section 3: SELECT Statements

Lecture 8 Simple SELECT Statements

Lecture 9 Aggregate Functions and Grouping Data

Section 4: Joins - Combining Data from Multiple Tables

Lecture 10 Inner and Left Joins

Lecture 11 Right Join, Full Outer Join, Cross Join and Self Join

Section 5: SubQueries

Lecture 12 Subqueries

Lecture 13 Correlated Subqueries

Programmers, Managers, IT Students