eagletapllc

Sign in
Register Now
Sign in
Register

SQL & PL/SQL Master Class

Categories: Courses, Live Trainings
Wishlist Share
Share Course
Page Link
Share On Social Media

What Will You Learn?

  • Understand Database Concepts
  • Master SQL
  • Work with Data Types & Operators
  • Write Complex Queries
  • PL/SQL Fundamentals
  • Create Stored Procedures and Triggers
  • Error Handling & Transactions

Course Content

Introduction to Databases
What is a Database? Types of databases: Relational vs Non-relational. Importance and uses of databases in the real world. Relational Database Management Systems (RDBMS): What is an RDBMS? (e.g., Oracle, MySQL, PostgreSQL, SQL Server). Structure of relational databases: tables, rows, columns. Differences between tables, views, and schemas. Basic Database Terminology: Table: Collection of data organized in rows and columns. Row: A single record in a table. Column: A field in a table that holds a specific type of data. Primary Key: Uniquely identifies each record in a table. Foreign Key: Links two tables together. Constraint: Rules enforced on data in tables (e.g., NOT NULL, UNIQUE, CHECK).

  • What is a Database?
    00:00
  • Relational Database Management Systems (RDBMS)
    00:00
  • Basic Database Terminology
    00:00

SQL Basics

SQL Data Types and Operators

Retrieving Data with SQL (SELECT)

SQL Joins

Aggregating Data and Grouping

SQL Subqueries

Introduction to PL/SQL

Control Structures in PL/SQL

Error Handling in PL/SQL

PL/SQL Functions and Procedures

Triggers in PL/SQL

Introduction to Transactions

Final Project

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕