SQL

Course Information

Duration: 36 Weeks

Time 1 Hour/Week

CI Code: CODE102

Location: Virtual, Live

Course Fee: Free With Membership / $199 Without Membership

Start Date: Course Schedule Below

Course Time: Check Registration

Student Age Eligibility: 8 - 17 Years

CI Courses

0 +

Expert teachers

0 +

Virtual Students

0 +

Course Hours

0 +

Why Coding Institute

Study SQL with CI

Objective: This course provides a comprehensive introduction to SQL (Structured Query Language), a critical language for managing and querying relational databases. Students will learn the fundamentals of SQL syntax, data manipulation, and database design principles to effectively interact with databases.

Methods: Hands-on practice through SQL queries, interactive exercises, and real-world scenarios to build proficiency in database management.

Skills Gained: Ability to create, modify, and query databases, optimize queries, and understand relational database principles.

Understand the fundamentals of relational databases and SQL structure.
Write basic to advanced SQL queries for data retrieval and manipulation.
Design and manage database tables and relationships.
Optimize SQL queries for efficiency and performance.

Available Start Dates & Times

* ALL COURSES ARE 1 HOUR LONG AND FOLLOW EASTERN TIME

Course Details

This Class is a Virtual Live Class

Modules

The modules listed below are those currently intended for delivery in the current academic intake of this course. These may be subject to change in future years as the University regularly revises.

Semester 1

Weeks 1 - 12: Introduction to SQL and Relational Databases

Topics: Overview of SQL, relational database concepts, and use cases, creating tables, basic operators, logical operators.

Register for the full course syllabus

Semester 2

Weeks 1 - 12: Aggregate Functions and Grouping

Topics: COUNT, SUM, AVG, MIN, MAX, GROUP BY, nested queries, FULL JOIN, DELETE commands.

Register for the full course syllabus

Semester 3

Weeks 1 - 12: Database Design and Normalization

Topics: Database design principles, normalization, primary and foreign keys, CASE statements, optimization, emerging trends in database technology.

Register for the full course syllabus

Careers

Learning Outcomes

By the end of this course, students will be able to:

Construct SQL queries to retrieve, filter, and aggregate data.
Implement data manipulation techniques to insert, update, and delete records.
Design normalized databases with efficient table structures and relationships.
Apply indexing and optimization techniques to enhance query performance.

Ready to Apply?

Applying for SQL CODE102

Start Your Journey Today!

I'm A Member Start My Course

Become A Member

Apply As Non-Member

Passive Student

Journey Towards Success

Highlights

Comprehensive Learning:

Detailed study for foundational learning and development in coding.

Interactive Learning:

Virtual labs, simulations, and real-world case studies.

Expert Instruction:

Live teaching from experienced professionals in the field.

Career Preparation:

Foundation for advanced studies and careers in coding.

Want to study at CI?

Apply To Become A Student

Request info

Code Institute uniquely designed to provide the coding experience to students aged 8 – 17. CI does not discriminate on the basis of race, national origin, gender, or disability.