• GT Bharat & Learning & Development Academy

Certification in SQL E-learning

Certification in SQL E-learning

In today’s data-driven world, structured query language (SQL) is the backbone of modern database management, powering everything from small-scale applications to large enterprise systems. As the standard language for relational database management systems, it enables users to efficiently store, manipulate and retrieve data. Mastering SQL is crucial for professionals working across various industries, including finance, healthcare, e-commerce and technology, as it allows them to extract valuable insights and drive informed decision-making.

LearninGT by Grant Thornton Bharat is pleased to launch its ‘Certificate in SQL’ to empower participants with the intricacies of SQL in managing huge databases. It will help participants store and retrieve information from different data sets.

Learning outcomes

  • Gain a solid understanding of the fundamentals of SQL
  • Manage data effectively with transactions, constraints, views and indexes
  • Develop skills to tackle data cleaning, analysis and best practices
  • Perform bulk data imports and exports and gain insights into essential database administration tasks
  • Master core SQL commands along with filtering, joins, aggregation and the use of subqueries

Who should attend

  • Data analysts and data scientists
  • Database administrators
  • Business analysts and business intelligence professionals
  • Developers, programmers and software engineers
  • Project managers
  • Students

Programme deliverables

  • 16 hours of learning content
  • Extensive course material
  • Case studies
  • Quizzes and assessments
  • Query resolution from an expert within 24 hours
  • Certificate of completion post final assessment

Programme coverage

  • Introduction to SQL
    • Overview of SQL
    • History and evolution of SQL
    • Setting up the database environment
    • Mini project: Create a database and basic queries
  • SQL basics
    • Data definition language (DDL) and data manipulation language (DML)
    • Basic SQL commands: SELECT, INSERT, UPDATE and DELETE
    • Filtering data with WHERE clause
    • Mini project: Create a table and insert data
  • Advanced SQL queries
    • Joins: INNER JOIN, LEFT JOIN and RIGHT JOIN
    • Aggregation functions: COUNT, SUM, AVG, MAX and MIN
    • Subqueries and nested queries
    • Mini project: Perform joins and aggregations
  • Manipulation in SQL
    • Updating and deleting records
    • Transactions and rollbacks
    • Constraints: NOT NULL, UNIQUE, PRIMARY KEY and FOREIGN KEY
    • Mini project: Implement constraints and transactions
  • Working with multiple tables
    • Complex joins and multi-table queries
    • Set operations: UNION, INTERSECT and EXCEPT
    • Views and indexes
    • Mini project: Utlise views and indexes
  • Data modelling and normalisation
    • Entry relationship (ER) model
    • Normalisation: 1NF, 2NF and 3NF
    • Denormalisation and performance optimisation
    • Mini project: Design a database schema
  • Stored procedures and functions
    • Creating stored procedures
    • User-defined functions
    • Triggers and cursors
    • Mini project: Implement stored procedures
  • Data import, export and working with a database
    • Importing data from external sources
    • Exporting data to different formats
    • Bulk operations
    • Database administration
    • Data modelling
    • Mini project: Import and export data
  • Real-world cases
    • SQL for data cleaning and analysis
    • SQL best practices
    • SQL security
  • Additional topics
    • Stored procedures and triggers
    • Views

Fees and schedule

Programme fees: INR 15,000 plus 18% GST

Cancellation and refund policy

  • 50% refund for cancellations up to five days before the start date
  • No refunds for cancellations within five days of the start or no-shows
  • Cancellations must be emailed; participants may join future batches at no extra cost upon early request