ANSI/ISO SQL Fundamentals

Seminarziel

The goal of the ANSI/ISO SQL course is to provide a  comprehensive understanding of the SQL language and its application in  managing and querying relational databases. The course aims to equip  participants with the knowledge and skills necessary to design and  create efficient, effective, and secure databases, as well as to  retrieve and manipulate data using SQL. By the end of the course,  participants should be able to design and implement a complete database  system, write complex SQL queries, and perform database administration  tasks such as user management and data backup and recovery.

Inhalt

• Introduction to SQL and Basic Operations
  • Introduction to SQL and Relational Databases
  • Overview of Database Management Systems
  • Basic SQL Operations: SELECT, INSERT, UPDATE, DELETE
  • Introduction to Tables, Attributes, and Primary Keys
  • Querying Data with SELECT Statement
  • Sorting Data with ORDER BY Clause
• Advanced SELECT Statements and Filtering Data
  • Introduction to SELECT Statement
  • Retrieving Data with SELECT
  • Querying Data from Multiple Tables using JOINs
  • Using Built-in Functions in SELECT Statement
  • Filtering Data with WHERE Clause
  • Sorting Data with ORDER BY Clause
  • Limiting Results with LIMIT and OFFSET Clauses
• Aggregating Data and Working with Subqueries
  • Grouping Data with GROUP BY Clause
  • Filtering Grouped Data with HAVING Clause
  • Working with Subqueries in SELECT Statement
  • Modifying Data with SELECT Statement
  • Creating and Managing Views
  • Understanding Transaction Control Statements
• Table Design and Database Administration
  • Understanding Database Design and Normalization
  • Creating and Modifying Tables and Indexes
  • Understanding Database Constraints
  • Working with Data Types
  • Managing Transactions and Locks
  • Backup and Recovery Procedures
• Advanced Joins and Performance Tuning
  • Understanding Different Types of Joins: INNER, OUTER, CROSS, and SELF
  • Advanced Join Techniques: Using Subqueries and Correlated Subqueries
  • Understanding Indexes and Query Optimization
  • Performance Tuning Techniques
  • Understanding SQL Execution Plans
  • Entity-Relationship Diagrams and Data Modeling
  • Creating Tables and Constraints: PRIMARY KEY, FOREIGN KEY, CHECK
  • Altering and Dropping Tables and Constraints
• Working with Views and Stored Procedures optional
  • Introduction to Views: Creating and Managing Views
  • Creating and Managing Stored Procedures
  • Implementing Triggers
  • Working with Transactions: COMMIT, ROLLBACK, SAVEPOINT
  • Managing Transactions: Locking, Deadlocks, Isolation Levels