SQL for Everyone (edX)

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.
This course is part of the Business Intelligence Essentials Professional Certificate.

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

Syllabus

Module One - 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.

Module Two - Entity Relationships, Cardinality, Normalization, and Schemas
Introduction to database design, including an ER Model to show how a database should work.

Week 3: Module Three -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.