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
Who should attend?
Prerequisites
None
Training 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
Costs
- Verified Track -$99
- Audit Track - Free
Certification / Credits
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
Contact this provider
edX
edX For Business helps leading companies upskill their labor forces by making the world’s greatest educational resources available to learners across a wide variety of in-demand fields. edX For Business delivers high-quality corporate eLearning to train and engage your employees...