Course description
SQL for Business Intelligence
Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data. This is the second course in a two-part series. The second portion of the course covers referential integrity and structured query language (SQL). You will learn how to use SQL statements “SELECT,” “FROM,” “WHERE,” and “JOINS.” These SQL statements will help you filter, compare, and analyze the data in your database. You will learn how to implement basic processing functionalities to create new structured database environments and analyze the results of queries constructed to address data requirements.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
None
Outcome / Qualification etc.
What you'll learn
- Generate tables in a database
- Modify databases and tables
- Perform database process queries
- Apply SQL fundamentals to load and query data
- Implement queries to address database needs
- Analyze scripts and query outputs for data requirements
- Utilize database best practices on queries
- Analyze and troubleshoot SQL queries
Training Course Content
Referential Integrity and the Structured Query Language
Introduction to fundamental concepts of the relational data model and properties of a table, constraints of a relational model, and basic functions and applications of SQL.
Project Part 2/Sandbox
As part of the sandbox, setting up schemas with data types, practicing SQL, and improving skills through the project.
SQL Continued
Introduction to classification of database management systems, including a centralized system, a homogeneous distributed system, and other database management system types.
Complete Project/Sandbox
As part of sandbox, set-up a schema with the Airport data then a separate schema with the World data, this will help you gain extra practice and confirm your understanding of your SQL skills.
Course delivery details
This course is offered through Southern New Hampshire University, a partner institute of EdX.
5-10 hours per week
Expenses
- Verified Track -$99
- Audit Track - Free