SQL - Structured Query Language

Course Title: Introduction to SQL for Beginners

Course Duration: 6 Weeks (24 Hours)

Course Format: Online Live Training

Next Start Date: TBC

This online live-training course on SQL is designed to provide participants with a comprehensive understanding of Structured Query Language (SQL) and its practical applications in database management. The course will be conducted in real-time by experienced instructors, allowing for interactive learning and immediate feedback.

https://www.oracle.com/uk/database/technologies/appdev/sql.html

Course Structure

Module 1: Introduction to SQL and Databases

• Lesson 1.1: Understanding Databases and SQL

  • What is a database?

  • Types of databases (Relational vs Non-Relational)

  • Introduction to SQL (What, Why, and How)

• Lesson 1.2: Setting Up a SQL Environment

  • Installing a database (MySQL/PostgreSQL)

  • Introduction to database management tools (SQL Workbench, pgAdmin)

  • Creating your first database

• Lesson 1.3: SQL Syntax and Structure

  • SQL syntax and keywords

  • Data types and constraints

  
  

Module 2: Basic SQL Queries

• Lesson 2.1: Retrieving Data with SELECT

  • Basic SELECT statements

  • Using WHERE for filtering

  • Sorting data with ORDER BY

  • Limiting results with LIMIT

• Lesson 2.2: Working with Multiple Tables

  • Introduction to Joins

  • Understanding INNER JOIN

  • Introduction to LEFT JOIN and RIGHT JOIN

• Lesson 2.3: Basic Data Aggregation

  • Counting, summing, and averaging (COUNT, SUM, AVG)

  • Grouping data with GROUP BY

  • Filtering groups with HAVING

Module 3: Data Manipulation

• Lesson 3.1: Inserting Data

  • The INSERT INTO statement

  • Inserting multiple records

• Lesson 3.2: Updating and Deleting Data

  • The UPDATE statement

  • The DELETE statement

  • Handling transactions and rollbacks

• Lesson 3.3: Advanced Joins and Subqueries

  • Introduction to FULL OUTER JOIN

  • Using subqueries

  • Correlated subqueries

    
    

Learning Objectives

By completing each module, students will achieve the following:

Module 1: Introduction to SQL and Databases

• Explain the purpose and functionality of databases and SQL.

• Set up and configure a basic SQL environment.

• Create and define basic database structures using SQL.

Module 2: Basic SQL Queries

• Retrieve specific data from one or more tables using SELECT statements.

• Use WHERE clauses to filter data based on conditions.

• Apply basic joins to retrieve data from multiple related tables.

Module 3: Data Manipulation

• Insert, update, and delete data in a relational database using appropriate SQL commands.

• Manage transactions to ensure data integrity.

• Execute more advanced SQL queries using subqueries and complex joins.

Learning Outcomes

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

• Understand the basic concepts of relational databases and how SQL interacts with them.

• Write basic and intermediate SQL queries to retrieve, filter, and sort data.

• Perform data manipulation tasks such as inserting, updating, and deleting records.

• Use various types of joins to work with multiple tables in a relational database.

• Employ aggregation functions and grouping techniques to analyze data.

• Apply best practices in database normalization and query optimization for performance.

• Use advanced SQL features like views, subqueries, and stored procedures to manage complex data operations.

Vacancies on Top Job Websites

Indeed

LinkedIn

CV-Library

Register Now