Beschreibung
ANSI/ISO SQL Fundamentals
The ANSI/ISO SQL course covers the basics of SQL and relational databases, including creating and modifying tables, inserting and updating data, and querying data with SELECT statements. Participants will learn about the different types of joins, built-in functions, grouping and filtering data with GROUP BY and HAVING clauses, and working with subqueries. Additionally, the course covers advanced topics such as database design, normalization, transactions, and security. By the end of this SQL course, participants should have a strong foundation in SQL and be able to perform basic and advanced database operations.Kommende Starttermine
Inhalte / Module
- 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
Zielgruppe / Voraussetzungen
Hinweis: Dieser Kurs richtet sich an Mitarbeitende aus Unternehmen und Institutionen.
Für Privatpersonen ist dieser Kurs leider nicht geeignet.
Eine Informationsanfrage zu diesem Kurs ist nur für Beteiligte aus dem B2B-Bereich sinnvoll.
Abschlussqualifikation / Zertifikat
Infos anfordern
GFU Cyrus AG
Erweitern Sie Ihre IT-Skills mit einem offenen IT-Training oder ganz nach Ihren Bedürfnissen durch eine individuelle IT-Schulung. Programmiersprachen (C#, Python, Java, …), Microsoft Office 365, Anforderungsmanagement, Projektmanagement, Business Intelligence, Data Science, Künstliche Intelligenz, IT-Sicherheit , Administration & Datenbanken, Softwareentwicklung, Testmanagement...
Erfahren Sie mehr über GFU Cyrus AG und weitere Kurse des Anbieters.