Lessons 1: 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
Lessons 2: 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
Lessons 3: Working with Functions
- TOPIC A: Perform Date Calculations
- TOPIC B: Calculate Data Using Aggregate Functions
- TOPIC C: Manipulate String Values
Lessons 4: Organising Data
- TOPIC A: Sort Data
- TOPIC B: Rank Data
- TOPIC C: Group Data
- TOPIC D: Filter Grouped Data
- TOPIC E: Summarise Grouped Data
- TOPIC F: Use PIVOT and UNPIVOT Operators
Lessons 5: 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
Lessons 6: Exporting Query Results
- TOPIC A: Generate a Text File
- TOPIC B: Generate an XML File
Lessons 7: 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
Lessons 8: Manipulating Table Data
- TOPIC A: Insert Data
- TOPIC B: Modify and Delete Data
Lessons 9: 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
Lessons 10: Working with Views
- TOPIC A: Create a View
- TOPIC B: Manipulate Data in Views
- TOPIC C: Create Aliases
- TOPIC D: Modify and Delete Views
Lessons 11: Indexing Data
- TOPIC A: Create Indexes
- TOPIC B: Drop Indexes
Lessons 12: Managing Transactions
- TOPIC A: Create Transactions
- TOPIC B: Commit Transactions
Appendix A
- The FullerAckerman Database
- Schema
Hands-on LAB Activities
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
Organising Data
- Sorting Data in a Table
- Ranking Data in a Table
- Grouping Data in a Table
- Filtering Grouped Data in a Table
- Summarising 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 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
Working with Views
- Creating Views
- 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 Comitting Transactions
Exam FAQs
FAQ's are not Available for this course.Summary
Standard:
SQL Querying
Lessons:
13+ Lessons
Delivery Method:
Online
Language:
English