About Course
Training classes videos
Course Content
Introduction to SQL
-
Introduction to databases and their importance in organizing and storing data.
-
Understanding the purpose of databases in various applications, from small-scale systems to large enterprises.
-
Exploring different types of databases, such as relational databases (e.g., MySQL, PostgreSQL), NoSQL databases (e.g., MongoDB, Cassandra), and NewSQL databases.
-
Introduction to SQL (Structured Query Language) as the standard language for interacting with databases.
-
Overview of SQL syntax elements, including keywords, clauses, and statements.
-
Explanation of essential SQL commands such as Select, INSERT, UPDATE, DELETE, and their usage in querying and manipulating data.
-
Understanding data types and their significance in defining the structure of tables and columns in a database.
-
Overview of common data types in SQL, including numeric data types (e.g., INTEGER, DECIMAL), character data types (e.g., VARCHAR, CHAR), date and time data types (e.g., DATE, TIMESTAMP), and boolean data type (e.g., BOOLEAN).
-
Explanation of how data types determine the format and storage requirements of data values, and their impact on database performance and efficiency.
-
DDL Statements
Retrieving Data with SELECT
Working with Data
Joins and Subqueries
Grouping and Aggregating Data
Data Manipulation Language (DML)
Introduction to PL/SQL
PL/SQL Control Structures
Exception Handling
Advanced PL/SQL Concepts
Overview of logical operators (e.g., AND, OR, NOT) for combining conditions and creating complex search criteria in SQL WHERE clauses.
Student Ratings & Reviews
No Review Yet