Course curriculum
-
1
Section 1
- Welcome
- Introduction
- Role of Databases in Application Development
- Tables and Relationships
- Database Constraints
-
2
Section 2
- Introduction to Querying
- The ANSI SQL Standard
- Main SQL Commands
- Query Tools
-
3
Section 3
- The Select Statement
- Filtering Selects
- Formatting Selects
- Column Aliases
-
4
Section 4
- The Where Clause
- Filter Conditions
- Combining Multiple Filter Conditions
- More Filter Operations
-
5
Section 5
- Counting Records
- Aggregate Functions
- Consolidating Data: Do's and Don'ts
- Multiset Consolidation Features
-
6
Section 6
- The Group-By Clause
- The Having Clause
- Grouping: Do's and Don'ts
-
7
Section 7
- Table Aliases
- Inner Joins
- Outer Joins
- Self Joins
- Complex Joins
-
8
Section 8
- Subqueries as Filter Conditions
-
9
Section 9
- Transactions
- Initiating Transactions
- Completing Transactions
-
10
Section 10
- Creating Tables
- Views
- Stored Procedures
- Triggers
Pricing options
Explain how different pricing options might be valuable to different segments of your audience.
-
Get started now
$99.00
Regular price
