techprolog

Menu
Menu

Structured query language (sql)

4.3 (253 user ratings)
★★★★★ 4.3/5
Specialization
Key Features
Videos

About Specialization:

Structured Query Language (SQL)

SQL (Structured Query Language) is a standardized programming language used for managing relational databases. It provides a way to interact with databases by defining, manipulating, and querying data. SQL is commonly used in a wide range of applications, including web development, data analysis, and enterprise software systems. SQL is widely used across various database management systems (DBMS), including MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, SQLite, and others. It is considered a fundamental skill for database administrators, data analysts, software developers, and anyone working with relational databases.

Key Features/Course content

  1. Introduction Database
  2. Understanding DBMS vs RDBMS
  1. How to use select statement in different ways to retrieve records?
  2. Working with Column alias
  3. Working with Table alias
  4. Clauses and its types in oracle
    1. Where clause
    2. Having clause
    3. From clause
    4. Group by clause
    5. Order by clause
    6. Using clause
    7. Constraint clause
    8. For update clause
  1. Table creation using CREATE statement
  2. Creating table from another table
  3. Dropping a table using DROP command
  4. Altering the column of a table
  5. Modifying the column datatype in a table
  6. Renaming the column of a table
  7. Renaming an entire table
  8. Using truncate command
  9. Difference between Delete and Truncate command
  1. How to copy data from one table to another table?
  2. How to copy the structure alone from a table?
  3. Different types of inserting row to an existing table
  4. Updating any value of with in a record using UPDATE command
  5. Deleting a particular record from a table
  6. Using merge & insert all command
  1. How to declare column level constraints?
  2. How to declare row level constraints ?
  3. How to add constraints to an existing table?
  4. Types of integrity constraints
  5. Not null
  6. Unique key
  7. Primary key
  8. Referential integrity
  9. Check integrity
  10. How to enable and disable constraints?
  11. How to get information about constraints?
  1. Understanding Single row functions
  2. How to use single row functions using dummy table?
  3. Types of single row functions
  4. String functions
  5. Date functions
  6. Mathematical functions
  7. Conversion functions
  8. Special functions
  9. Analytical functions
  10. Working with multi row functions
  1. Working with aggregate function
  2. Count()
  3. Sum()
  4. Max()
  5. Min()
  6. Avg()
  7. Working with group by clause
  8. Working with having clause
  9. Difference between WHERE and HAVING clause
  1. Understanding joins and its uses
  2. Types of joins
  3. Equi join
    Non - equi join
  4. Self join
  5. Outer join
  6. Left & Right outer join
  7. Full outer join
  1. How to use set operators in a single table content?
  2. Working with set operator types
    1. UNION
    2. UNION ALL
    3. INTERSECT
    4. MINUS
  3. Working with pseudo columns using the following:
    1. ROWID
    2. ROWNUM
  1. Importance of sub queries
  2. Using different types of sub queries
  3. Single row sub queries
  4. Multi row sub queries
  5. Nested queries
  6. Multi column sub queries
  7. Correlated sub queries

Videos

Scroll to Top