Browse Library

Topics

    Top Courses

Membership

Free

View Courses

Basic

View Courses

Premium

View Courses

Elite

View Courses

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

What are the requirements? -+

  • Computer Basic

What am I going to get from this course? -+

  • Database management systems
  • Structured Query Language

What is the target audience? -+

  • 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

Share

Instructor

iivaan

more course by Iftekhar Ivaan

SSMB12 - Selenium Webdriver With Java
SSMB12 - Introduction to Java
SSMB12 - Introduction to STLC

Students

Recently Viewed Courses

Introduction to Software Development Lifecycle
$ 600.00
Introduction to Computer Fundamentals
$ 800.00
Shift Public Speaking
Free

  • Best learning experience for everyone, anywhere

  • Top Rated Courses

    • No Top Rated
Copyright © 2017, ShiftVision. All rights reserved. | Terms of Use | Privacy Policy