SSNB1 - Introduction to SQL

Learn how to use SQL to store, query, and manipulate data.
  • 0 ratings

Course Overview

This module covers fundamentals of database architecture, database management systems, and database systems; principles and methodologies of database design, and techniques for database application development. In addition, this module covers the SQL to work with the database.

Main Topics Covered:

  1. History of Data Storage and Database
  2. What is Database and Types of databases
  3. Different vendor Database
  4. DBMS & RDBMS
  5. Data, Database and Database Management System
  6. Relational Database - Instance, Schema, Data dictionary and Data types
  7. Relational Database - Table, Record, Field
  8. Relational Database - Primary key, Foreign key, Unique key, Composite Key
  9. Index, Constraints, Triggers
  10. Relationships between Tables
  11. Database Normalization
  12. Introduction to ER diagram
  13. Introduction SQL
  14. Introduction to Data Definition Language (DDL) – Create, Alter, Drop, Truncate, Rename
  15. Introduction to Data Manipulation Language (DML) – Select, Insert, Update, Delete
  16. Introduction to Data Control Language (DCL) – Grant, Revoke
  17. Introduction to Transition Control Language (TCL) – Commit, Savepoint, Rollback
  18. Introduction to Aggregate Functions - GROUP BY, ORDER BY, HAVING, COUNT(*)
  19. Introduction to Aggregate Functions - AVG(), SUM(), MAX(), MIN()
  20. Introduction to SQL Functions – SUBSTR, UPPER, INITCAP, RTRIM, SYSDATE
  21. Introduction to Joins – Equijoin, Inner Join, Outer Join, Non-equijoin
  22. Sub queries, Sub queries in predicates
  23. Introduction to Views
  24. Constructing a view and its usages
  25. Introduction to Stored Procedures
  26. Create Stored Procedures
  27. Call Stored Procedures
  28. Drop Stored Procedures
  • Computer Basic
  • Database management systems
  • Structured Query Language
  • QA

About the Author

Course Curriculum

Introduction to Database and SQL

  • SQL - 1
    02:01:48
  • SQL - 2
    02:33:28
  • SQL - 3
    02:54:36
  • SQL - 4-1
    00:38:40
  • SQL - 4-2
    00:54:17
  • SQL - 5
    02:15:43
  • SQL - 6
    02:43:51
  • SQL - 7
    00:40:25
  • SQL - 8
    02:22:53
  • DB-Norm
    01:43:03

reviews

  • No reviews found