| |
The SQL is essintial for creating and modifying the database.
The key elements of this course are
- Querying with Unions and Advanced Joins
- Querying Multiple Tables with Unions
- Advanced Joins
- Calculating with Compute
- System Performance
- Querying with Subqueries
- Subqueries
- Adding Data
- Inserting Data and Select Into
- Updating and Removing Data
- Updating Records
- Deleting Records and Deleting the Contents of Tables
- Manipulating Tables and Views
- Creating Tables
- Modifying Tables
- Deleting Tables
- Adding and Removing Views
- Manipulating Indexes
- Adding and Removing Indexes
- Ensuring Data Integrity with Transactions
- Transactions
- Creating Databases
- Creating a Database with SQL
- Creating basic reports
- Using the set commands
- Column wrapping
- Creating breaks and summaries
- Adding prompts to queries
- Function Count(*), Sum, Avg, Min & Max
- Using the group by clause
- Nested Loop join
- Re-writing SQL queries
- Using parallel query to improve performance, Tuning sub-queries
|
|
