SQL for Business Intelligence Developers Training Course

This course provides delegates with the technical skills required to write basic SQL queries using Microsoft SQL Server.

SQL for Business Intelligence Developers

This 1-day instructor led SQL for Business Intelligence Developers Training Course provides delegates with the technical skills required to write basic SQL queries using Microsoft SQL Server.

  • Duration: 1 Day
  • Dates: Please select

Goals

Enable delegates to write basic SQL queries using Microsoft SQL Server
Learn how to filter and query data
Joining  data from multiple tables and working with sub queries
Using Advanced querying techniques

Audience

The course is intended for business intelligence developers and analysts who are responsible for writing SQL queries.

Prerequisites

Experience with these subject areas is strongly recommended:
• Basic Relational database knowledge

Locations

  • London
  • Warwick
  • Glasgow
  • Onsite at Your Office
  • Virtual

Content

1. Getting Started with Databases and SQL
• Overview of SQL server databases
• Overview and syntax elements SQL
• Working with SQL scripts
• Using SQL querying tools
• Using SQL server management studio

2. Querying and Filtering Data
• Using the SELECT statement
• Filtering data
• Working with NULL values
• Formatting result Sets
• Performance considerations for writing queries
• Querying and filtering data

3. Joining Data from Multiple Tables
• Querying multiple tables by using joins
• Applying joins for typical reporting needs
• Combining and limiting result set

4. Grouping & Summarising Data
• Summarising data by using aggregate functions
• Summarising grouped data
• Ranking grouped data
• Creating crosstab queries
• Grouping and summarising data

5. Working with Sub-queries
• Writing basic sub queries
• Writing correlated sub queries
• Comparing sub queries with joins and temporary tables
• Using common table expressions (CTE)
• Working with sub-queries

6. Modifying Data in Tables
• Inserting data into tales
• Deleting data from tables
• Updating data in tables
• Overview of transactions
• Modifying data in tables

7. Using programming objects for Data Retrieval
• Creation of views
• Creation of user-defined functions
• Creation of stored procedures
• Overview of triggers
• Writing distributed queries

8. Using Advanced Querying Techniques
• Considerations for querying data
• Working with data types
• Maintaining query files


Contact
Contact

For any questions please feel free to contact us.