SQL Queries
(SQL-Queries.AD2) / ISBN : 978-1-64459-504-6
Über diesen Kurs
SQL-Abfragen helfen Ihnen beim Erlernen des Abrufens, Manipulierens und Verwaltens von Daten in Datenbanken. Entdecken Sie die Leistungsfähigkeit von SQL-Abfragen, von einfachen SELECT-Anweisungen bis hin zu erweiterten Operationen wie JOINs und Unterabfragen. Lernen Sie, wie Sie Daten effektiv organisieren und analysieren und legen Sie so den Grundstein für eine effiziente Datenbankverwaltung. Durch praktische Übungen und Beispiele aus der Praxis gewinnen Sie das nötige Selbstvertrauen, um reale Szenarien zu meistern.
Fähigkeiten, die Sie erwerben werden
Holen Sie sich die Unterstützung, die Sie brauchen. Melden Sie sich für unseren Kurs mit Lehrer an.
Unterricht
13+ Unterricht | 3+ Übungen | 45+ Tests | 111+ Karteikarten | 111+ Glossar der Begriffe
Testvorbereitung
62+ Fragen vor der Beurteilung | 4+ Ausführliche Tests | 64+ Fragen nach der Bewertung | 120+ Testfragen zur Praxis
Praktische Übungen
42+ LiveLab | 36+ Videoanleitungen | 40+ Minutes
Executing a Simple Query
- TOPIC A: Connect to the SQL Database
- TOPIC B: Query a Database
- TOPIC C: Save a Query
- TOPIC D: Modify and Execute a Saved Query
- Summary
Performing a Conditional Search
- TOPIC A: Search Using One or More Conditions
- TOPIC B: Search for a Range of Values and NULL Values
- TOPIC C: Search Data Based on Patterns
- Summary
Working with Functions
- TOPIC A: Perform Date Calculations
- TOPIC B: Calculate Data Using Aggregate Functions
- TOPIC C: Manipulate String Values
- Summary
Organizing Data
- TOPIC A: Sort Data
- TOPIC B: Rank Data
- TOPIC C: Group Data
- TOPIC D: Filter Grouped Data
- TOPIC E: Summarize Grouped Data
- TOPIC F: Use PIVOT and UNPIVOT Operators
- Summary
Retrieving Data from Multiple Tables
- TOPIC A: Combine the Results of Two Queries
- TOPIC B: Compare the Results of Two Queries
- TOPIC C: Retrieve Data by Joining Tables
- Summary
Exporting Query Results
- TOPIC A: Generate a Text File
- TOPIC B: Generate an XML File
- Summary
Using Subqueries to Perform Advanced Querying
- TOPIC A: Search Based on Unknown Values
- TOPIC B: Compare a Value with Unknown Values
- TOPIC C: Search Based on the Existence of Records
- TOPIC D: Generate Output Using Correlated Subqueries
- TOPIC E: Filter Grouped Data Within Subqueries
- TOPIC F: Perform Multiple-Level Subqueries
- Summary
Manipulating Table Data
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
- Summary
Manipulating the Table Structure
- TOPIC A: Create a Table
- TOPIC B: Create a Table with Constraints
- TOPIC C: Modify a Table's Structure
- TOPIC D: Back Up Tables
- TOPIC E: Delete Tables
- Summary
Working with Views
- TOPIC A: Create a View
- TOPIC B: Manipulate Data in Views
- TOPIC C: Create Aliases
- TOPIC D: Modify and Delete Views
- Summary
Indexing Data
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
- Summary
Managing Transactions
- TOPIC A: Create Transactions
- TOPIC B: Commit Transactions
- Summary
Appendix A
- The FullerAckerman Database
- Schema
Executing a Simple Query
- Connecting to a Database
- Saving a Query and Modifying and Executing the Saved Query
Performing a Conditional Search
- Comparing Column Values in a Table
- Searching Using Simple and Multiple Conditions
- Searching for a Range of Values and NULL Values
- Retrieving Data Based on Patterns
Working with Functions
- Performing Date Calculations
- Using Aggregate Functions
- Manipulating String Values in a Table
Organizing Data
- Sorting Data in a Table
- Ranking Data in a Table
- Grouping Data in a Table
- Filtering Grouped Data in a Table
- Summarizing Grouped Data
- Using the PIVOT and UNPIVOT Operators
Retrieving Data from Multiple Tables
- Combining the Results of Two Queries
- Comparing the Results of Two Queries
- Retrieving Data by Joining Tables
Exporting Query Results
- Saving the Query Results in the CSV Format
- Generating an XML File
Using Subqueries to Perform Advanced Querying
- Searching for Records Based on Unknown Values
- Searching for Records by Comparing Them with Unknown Values
- Searching for Records Based on Their Existence in Another Table
- Generating Output Using Correlated Subqueries
- Filtering Grouped Data Within a Subquery
- Generating Output Using Nested Subqueries
Manipulating Table Data
- Inserting, Modifying, and Deleting Data
Manipulating the Table Structure
- Creating a Table
- Creating a Table with Constraints
- Adding and Dropping Columns in a Table
- Adding and Dropping Constraints in a Table
- Modifying the Column Definition in a Table
- Backing Up a Table
- Deleting a Table
Working with Views
- Creating a View
- Creating Views with Schema Binding
- Manipulating Data in Views
- Creating Aliases
- Modifying and Deleting Views
Indexing Data
- Creating Indexes
- Dropping Indexes
Managing Transactions
- Creating and Committing Transactions