uCertify

CSS3210: SQL

(ANC-CSS3210.AD1)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Executing Simple Query and Performing a Conditional Search

  • 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
  • TOPIC E: Search Using One or More Conditions
  • TOPIC F: Search for a Range of Values and NULL Values
  • TOPIC G: Search Data Based on Patterns
2

Working with Functions and Organizing Data

  • TOPIC A: Perform Date Calculations
  • TOPIC B: Calculate Data Using Aggregate Functions
  • TOPIC C: Manipulate String Values
  • TOPIC D: Sort Data
  • TOPIC E: Rank Data
  • TOPIC F: Group Data
  • TOPIC G: Filter Grouped Data
  • TOPIC H: Summarize Grouped Data
  • TOPIC I: Use PIVOT and UNPIVOT Operators
3

Retrieving Data from Tables and Exporting Query Results

  • TOPIC A: Combine the Results of Two Queries
  • TOPIC B: Compare the Results of Two Queries
  • TOPIC C: Retrieve Data by Joining Tables
  • TOPIC D: Generate a Text File
  • TOPIC E: Generate an XML File
4

Using Subqueries, Manipulating Table Data and Structure

  • 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
  • TOPIC G: Insert Data
  • TOPIC H: Modify and Delete Data
  • TOPIC I: Create a Table
  • TOPIC J: Create a Table with Constraints
  • TOPIC K: Modify a Table's Structure
  • TOPIC L: Back Up Tables
  • TOPIC M: Delete Tables
5

Working with Views, Indexing Data, and Managing Transactions

  • TOPIC A: Create a View
  • TOPIC B: Manipulate Data in Views
  • TOPIC C: Create Aliases
  • TOPIC D: Modify and Delete Views
  • TOPIC E: Create Indexes
  • TOPIC F: Drop Indexes
  • TOPIC G: Create Transactions
  • TOPIC H: Commit Transactions

1

Executing Simple Query and Performing a Conditional Search

  • Connecting to a Database
  • Saving a Query and Modifying and Executing the Saved Query
  • 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
2

Working with Functions and Organizing Data

  • Performing Date Calculations
  • Using Aggregate Functions
  • Manipulating String Values in a Table
  • 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
3

Retrieving Data from Tables and Exporting Query Results

  • Combining the Results of Two Queries
  • Comparing the Results of Two Queries
  • Retrieving Data by Joining Tables
  • Saving the Query Results in CSV Format
  • Generating an XML File
4

Using Subqueries, Manipulating Table Data and Structure

  • 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
  • Inserting, Modifying, and Deleting Data
  • 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
5

Working with Views, Indexing Data, and Managing Transactions

  • Creating Views
  • Creating Views with Schema Binding
  • Manipulating Data in Views
  • Creating Aliases
  • Modifying and Deleting Views
  • Creating Indexes
  • Dropping Indexes
  • Creating and Comitting Transactions

Related Courses

All Course