We are just a few days from our big launch.  
 
+91-8090978001 | Blog

SQL Programming

Ratings (4.5)
40 Hours
Live Classes
Training mode
Online or Offline by Instructor
Labs
Hands-on Labs
Real-World Case Study
Learn to Implement
Digital Notes
Doubt Clear Session
Make Enquiry

About the Course

SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. Here are some common use cases for SQL:

SQL is used for
  1. Data retrieval: SQL is commonly used to retrieve data from a database. With SQL, you can write queries to extract specific data or perform complex data analysis.
  2. Data manipulation: SQL can be used to manipulate data in a database. You can add, update, or delete records from a database using SQL commands.
  3. Database administration: SQL can be used to create, modify, and manage databases. SQL commands can be used to create tables, indexes, and other database objects.
  4. Data analysis: SQL can be used to analyze large datasets. SQL commands can be used to join tables, group data, and perform calculations.
  5. Business intelligence: SQL is often used in business intelligence applications. SQL queries can be used to extract data from a database and generate reports and dashboards.
  6. Web development: SQL can be used to interact with databases in web applications. SQL commands can be embedded in web pages to retrieve or update data in a database.
  7. Overall, SQL is a powerful tool for managing and manipulating relational databases, and is essential for many businesses and organizations that rely on data-driven decision making.
Training Objective

In this hands-on self-paced course, you will learn:

Understanding Entity , Entity relationship ,rows , columns, data types in SQL, Converting ER diagram into relational database objects .Creating table understanding DDL, DML, DCL, TCL & various aggregate function. Writing stored procedure,indexes,joins, tigers,cursors,function,views and transaction handling in SQL database.

Syllabus

Introduction to SQL
  1. What is SQL?
  2. Create Table Statement
  3. ALTER TABLE Statements
  4. Rename Columns of a Table
  5. Modify Column DataType
  6. Drop Columns from Table
  7. Rename Tables
  8. Drop Tables

  1. Select Query
  2. WHERE Clause
  3. GROUP BY Clause
  4. HAVING Clause
  5. ORDER BY Clause

  1. SQL Joins
  2. Inner Join
  3. Left Join
  4. Right Join
  5. Full Join

  1. BETWEEN
  2. IN
  3. LIKE
  4. INTERSECT
  5. MINUS
  6. UNION
  7. UNION ALL
  8. DISTINCT
  9. ANY, SOME
  10. ALL

  1. AVG()
  2. COUNT()
  3. MAX()
  4. MIN()

  1. Subqueries and nested queries
  2. Joins (inner, outer, left, right)
  3. Transactions and concurrency control
  4. Stored procedures and functions
  5. Views (simple and complex)
  6. Window functions
  7. Common table expressions
  8. Indexes and performance tuning
  9. Advanced aggregate functions (GROUPING SETS, CUBE, ROLLUP)
  10. Temporal data querying and analytics (date/time functions, windowing functions)
  11. Recursive queries (CTE)
  12. Partitioning and sharding
  13. Full-text search and indexing
  14. Spatial data types and queries (geography, geometry)
  15. Data warehousing concepts (fact and dimension tables, ETL)
  16. Analytics and reporting (OLAP, SSRS, Power BI)
  17. Data security and access control (roles, permissions, encryption)

Watch Video

© Escon Info Systems. All rights reserved.

Video Chat with Us