Course description
SQL for Everyone
Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data.
This is the first course of a two-part series to introduce relational database concepts and help you learn and apply foundational knowledge of SQL. This course will get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning. You will work with real databases, real data science tools, and real-world data sets. You will create a database instance in the cloud. You will practice building and running SQL queries through a series of hands-on labs. No prior knowledge of databases, SQL, R, or programming is required.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
None
Outcome / Qualification etc.
What you'll learn
- Describe a database
- Describe a foundational table structure
- Identify the components of a database
- Analyze table inputs and outputs
- Perform database process queries
- Generate tables in a database
- Use database best practices on queries
- Modify databases and tables
- Implement queries to address database needs
- Analyze scripts and query outputs
- Create a structured database using relational concepts
Training Course Content
Introduction to Databases
Introduction to fundamentals of databases, database history, and benefits of a database, as well as the concept of hierarchical database model and its importance.
Entity Relationships, Cardinality, Normalization, and Schemas
Introduction to database design, including an ER Model to show how a database should work.
Project/Sandbox
Reviewing the ways to develop a database and learning to set up a database correctly, the practice of SQL skills through the project and sandbox.
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