eagletapllc

Sign in
Register Now
Sign in
Register
0 (0 Ratings)

SQL & PL/SQL Master Class March 3rd Batch

Categories Courses, Live Trainings
Wishlist

What I will 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 Curriculum

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
$500.00
  • Level
    Intermediate
  • Duration
    30 hours
  • Last Updated
    February 13, 2025
  • Certificate
    Certificate of completion

A course by

Eagletap LLC

Tags

Development

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

✕