Certificate in SQL
Empowering your data journey from query to insight
About the programme
In today’s data-driven world, an immense volume of data is
generated daily, with each piece of information intricately
linked to others in diverse ways. This interconnectedness
has led to the creation of numerous databases to house
these vast datasets. Sometimes, these databases are
scattered and contain so much information that analysis or
interpretation becomes challenging.
In such situations, the Structured Query Language (SQL)
can be the indispensable skill that unlocks the potential
of data manipulation and insight extraction. Being the
universal language for relational databases, SQL empowers
users to interact with these databases in a structured and
efficient manner, fostering informed decision-making. It
also reduces errors and helps uncover hidden patterns and
trends in the data.
LearninGT by Grant Thornton Bharat is pleased to launch
its ‘Certificate in SQL’ to empower participants with the
intricacies of the SQL language in managing massive
databases. This course will help participants gain deep
insights into the real-world applications of SQL through
advanced cases and examples.
Learning outcomes
After completing the course, the participants will be able to:
• Gain a solid understanding of the fundamentals of SQL,
including its setup procedures.
• 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
2 Certificate in SQL
Programme coverage
Introduction to SQL Data modelling and normalisation
• Overview of SQL • Entry relationship model (ER model)
• History and evolution of SQL • Normalisation: 1NF, 2NF, 3NF
• Setting up the database environment • Denormalisation and performance optimisation
• Mini project: Creating a database and basic queries • Mini project: Designing a database schema
SQL basics Stored procedures and functions
• Data Definition Language (DDL) and Data • Creating stored procedures
Manipulation Language (DML)
• User-defined functions
• Basic SQL commands: SELECT, INSERT, UPDATE, DELETE
• Triggers and cursors
• Filtering data with the WHERE clause
• Mini project: Implementing stored procedures
• Mini project: Creating a table and inserting data
Data import, expert, and working
Advanced SQL queries with database
• Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN • Importing data from external sources
• Aggregation functions: COUNT, SUM, AVG, MAX, MIN • Exporting data to different formats
• Subqueries and nested queries • Bulk operations
• Mini project: Performing joins and aggregations • Database administration
• Data modelling
Manipulation in SQL • Mini project: Importing and exporting data
• Updating and deleting records
• Transactions and rollbacks Real-world cases
• Constraints: NOT NULL, UNIQUE, PRIMARY KEY, • Stored procedures and triggers
FOREIGN KEY
• Views
• Mini project: Implementing constraints and
transactions
Career prospects and applications
Working with multiple tables • Applications
• Careers to pursue
• Complex joins and multi-table queries
• Set operations - UNION, INTERSECT, EXCEPT
• Views and indexes
• Mini project: Utlising views and indexes
Certificate in SQL 3
Programme details:
Duration
16 hours
Format
Self-paced e-learning
Fees
INR 15,000 + taxes
For further queries, please contact:
Surubhi Sharma
Consultant
M: 7827337057
E: surubhi.sharma@in.gt.com
Programme deliverables
• Extensive course material and case studies
• Quizzes and assessments
• Hands-on projects for real-world practice
• Access to Grant Thornton Bharat’s LMS for one year
• Query resolution from an expert within 24 hours
• Certificate of completion post-final assessment
4 Certificate in SQL
LearninGT
LearninGT is an upskilling service offering of Grant Thornton Bharat. We aim to empower individuals with the most sought-after
skills for thriving in today’s evolving professional landscape. By leveraging the expertise of industry-leading professionals and
innovative teaching methodologies, we help participants acquire the proper knowledge and skills to drive success.
200+
18,000+ 9,60,000+
corporate 250+
trained training
training batches
professionals hours
sessions
Why Grant Thornton Bharat?
Ranked No.1 Access to a Globally Customised Amongst the
in Training & network of accepted and cost- largest fully
Development in international training effective integrated
India amongst firms in methodology solutions with assurance, tax,
accounting firms: post-training and advisory
145+ countries
Universum 2017 support firms in India
with 68,000+
people.
Certificate in SQL 5
For further queries, please contact:
Pradeep Pandey Kapil Arora Rohit Gupta
Director Director Associate Director
M: +91 7838000185 M: +91 9654190274 M: +91 9891395363
E: Pradeep.pandey@in.gt.com E: Kapil.arora@in.gt.com E: Rohit.gupta1@in.gt.com
Best
Workplaces™
in Professional Services
INDIA
2023
We are
Shaping Vibrant Bharat
Our offices in India
Ahmedabad Bengaluru Chandigarh Chennai Scan QR code to see
our office addresses
Dehradun Delhi Goa Gurgaon Hyderabad www.grantthornton.in
Kochi Kolkata Mumbai Noida Pune
Connect @Grant-Thornton-Bharat-LLP @GrantThorntonBharat @GrantThornton_Bharat
with us on @GrantThorntonIN @GrantThorntonBharatLLP GTBharat@in.gt.com
© 2024 Grant Thornton Bharat LLP. All rights reserved.
“Grant Thornton Bharat” means Grant Thornton Advisory Private Limited, a member firm of Grant Thornton International Limited (UK) in India, and those legal entities which are its related parties
as defined by the Companies Act, 2013, including Grant Thornton Bharat LLP.
Grant Thornton Bharat LLP, formerly Grant Thornton India LLP, is registered with limited liability with identity number AAA-7677 and has its registered office at L-41 Connaught Circus,
New Delhi, 110001.
References to Grant Thornton are to Grant Thornton International Ltd.(Grant Thornton International) or its member firms. Grant Thornton International and the member firms are not a worldwide
partnership. Services are delivered independently by the member firms.
7021 | AK | AK2
