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
Who should attend?
Prerequisites
None
Training 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
Costs
- Verified Track -$99
- Audit Track - Free
Certification / Credits
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
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...