• Classroom Training   • Online Training   • Corporate Training  • Live Projects & Guidance 

Database Management with SQL

Courses Information

This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle.This course teaches you everything you need to know to begin working with databases today!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - MySQL . These skills are also applicable to any other major SQL database, such as PostgreSQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Curriculum
Module 1 - Introduction to Basic Database Concepts
  • What is Data, Field, Record and database?
  • Limitations of File Management System
  • Basic Concepts of Advantages of DBMS
  • Exploring Relational DBMS
Module 2 – Introduction to SQL
  • Installing SQL
  • Basics of SQL Types of SQL Statements
  • DDL, DML, DQL, DCL and TCL
  • Create Database
  • Datatypes in SQL
  • Exploring DDL Statements on Table
Module 3 – DDL and DML Statements
  • Create, Alter and Drop Table
  • Insert, Update and Delete Statement
  • Truncate Statement
Module 4 – Working with Queries (DQL)
  • Understanding Select Statement
  • Usage of Top, Distinct, Null etc...Keyword
  • Using String and Arithmetic Expressions
  • Exploring Where Clause with Operators
  • Sorting data using Order By clause
  • Working with basic of Sub Queries
Module 5 – Aggregate Functions
  • Using functions in Queries
  • Count, Sum, Min, Max, Avg Group By and Having Clause
Module 6 – Joins and Set Operations
  • Introduction to Joins
  • Inner Join
  • Self Join
  • Outer Join
  • Cross Join
  • Set Operations using Unions, Intersect
Module 7 – Implementing Views
  • Introduction & Advantages of Views
  • Creating, Altering, Dropping Views
Module 8 – Data Control language (DCL)
  • Creating Users
  • Granting & revoking of privileges
  • Managing users
Module 9 – Working with Indexes
  • Introduction
  • Creating and Dropping Indexes
Module 10 – Transaction Control Language (TCL)
  • Transactions process
  • Working with commit, rollback and savepoint
Module 11 – Working with Stored Procedures
  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping Stored Procedure
Module 12 – Implementing Triggers
  • Introduction to triggers
  • Creating, Altering, Dropping triggers
  • Before and after triggers
Module 13 – Built-in functions in SQL
  • Working with character, date and number functions
    Module 14 – Backup and Restore
    • Backing up database
    • Restoring databases
    • Migrating Databases
    Module 15 – Introduction to PL/SQL
    • PL/SQL Overview
    • Generate Output from a PL/SQL Block
    Module 16 – PL/SQL Program Structure
    • PL/SQL OverviewConditional and Sequential Control IF Statements
    • CASE Statements and Expressions
    • The GOTO Statement
    Module 17 – Loop
    • The Simple Loop
    • The WHILE Loop
    • The FOR Loop
    Module 18 – Exception Handlers
    • Exception-Handling Concepts and Terminology
    • Defining Exceptions
    • Handling Exceptions
    Module 19 – Data Retrieval
    • Cursor Basics
    • Working with Implicit Cursors
    • Working with Explicit Cursors
    Module 20 – Procedures, Functions, and Parameters
    • Procedure
    • Functions and parameters
    Module 21 – Triggers
    • DML Triggers
    • DDL Triggers
    • Database Event Triggers
    Module 22 – Using and Managing Packages
    • Creating Package
    • Managing Package Concepts
    Module 23 - Debugging PL/SQL Programs

      Trending Courses