SQL & Database
Explore database queries, relational data fundamentals.
learningStructured
lessonsCareer
guidance
DurationAsk the centre
Content2 core topics
ModeIn-centre
Skills you can put to work.
Explore the core areas of SQL.
- Database queries
- Relational data fundamentals
Your course. Every step.
Build your skills one topic at a time, with room to practise.
- 1.Tables, rows, keys and relationships
- 2.Data types and relational modelling
- 3.Create a practice database and load sample data
- 4.design a student-record schemaPractice
- 1.SELECT, aliases and expressions
- 2.WHERE, ORDER BY and DISTINCT
- 3.Aggregates, GROUP BY and HAVING
- 4.answer questions about a sales tablePractice
- 1.Inner and outer joins
- 2.Null values and conditional expressions
- 3.Subqueries and common table expressions
- 4.combine customers, orders and productsPractice
- 1.INSERT, UPDATE and DELETE with scoped conditions
- 2.Constraints and referential integrity
- 3.Transactions, indexes and basic query plans
- 4.safely update a sample inventoryPractice
- 1.Design tables from a small business brief
- 2.Write reports with joins and window functions
- 3.Validate results and document queries
- 4.deliver a reproducible reporting databasePractice
Proposed curriculumProposed syllabus drafted for this course. The centre should confirm the content and batch schedule before enrolment.
A person to learn with.
Get to know the trainer for your batch.
Meet your course trainer
Your instructor is assigned by batch. Contact the centre to meet your trainer and discuss how the course is taught.
A skill for your
next step.
Students
Add practical digital skills to your studies.
Job seekers
Explore skills that connect with your career plans.
Working professionals
Build on the tools you use in everyday work.
New to this subject? Ask us about the right starting level and eligibility for SQL.
Check course requirementsA little clarity before you start.
Contact the centre for the current course duration and batch schedule.
Fees and eligibility depend on the course. Ask the centre for current details before enrolling.
Confirm the teaching language for your preferred batch with the centre.
Ask the centre about the certificate, issuing body and completion requirements for this course.
This page is for classroom learning at CT Training Centre in Pakur. Contact the centre about any other available formats.
No. Career support includes resume guidance and interview preparation, but does not guarantee employment.
Keep your curiosity going.
More skills to explore at CT.
