Brief Introduction
Discover Structured Query Language (SQL) programming basics in relation to database management and data manipulation. This course can provide you with an overview of topics like joins, database schemas, database design and importing data into a database.
Description
Develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis. Learn about types of data and types of databases to store data, as well as design for scalability. You’ll also learn to prepare digital data storage using the relational model, including resolving integrity constraints, and proper assignments of primary and foreign keys. In addition, you’ll construct and analyze queries to address data requirements.
By completing this course and the final exam, you will:
-
Demonstrate knowledge of the relational model
-
Build skills in SQL
-
Construct SQL queries
-
Read and develop database schemas
-
Apply the concept of normalization to a dataset or database
-
Understand how to add/export data to existing schemas and SQL joins
-
Learn how to troubleshoot SQL code
If you’re looking to advance your career, you should take this course if you’re interested in data analytics, data engineering, database design or business intelligence. Structured query language (SQL) is the fundamental cornerstone to extract, transact and load data necessary for analysis using a relational database.
This is the second course in the introductory, undergraduate-level offering that makes up the larger Data Management with Python and SQL MicroBachelors program. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.
-
Scripting with Python - starting February 2021
-
Structured Database Environments with SQL - starting February 2021
NOTE : While this is generally a non-credit-bearing course, you may be able to use this class with proper completion for 3 credits (1 course) toward a bachelor's degree at Southern New Hampshire University.
Coaching
If you are enrolled in the verified track (paid track) in any course that is a part of a MicroBachelors program, including this course, you are eligible for coaching at no additional cost. Please note that coaching is only available via SMS to U.S. phone lines.
Our coaches (real humans) are ready to help you with career exploration, navigating resources, staying motivated, and solving problems along the way to your goals.
Learn more about the value of coaching directly from one of our coaches, Erin.
Knowledge
- Understanding what SQL is
- How to use SQL statements such as:
- Select
- From
- Where
- Having
- Group by
- Order by
- Max
- Min
- Count
- Count distinct
- Joins
- Import/export
- Reading schemas
- Creating database schemas
- Importing/exporting data
- Troubleshooting queries
- Modifying tables and data structures
- Analyzing SQL outputs
Beginner Data Analysis Using SQL and Microsoft SQL Server
- 3
-
![]()
![]()
![]()
![]()
![]()
Learn Hands-On how to build Real World SQL Queries to answer questions with data. SQL Server is a relational database management system -RDBMS developed and owned by Microsoft....
The Complete Ethical Hacker Certification Exam Prep Course
- 4.3
-
![]()
![]()
![]()
![]()
![]()
This Course WILL provide EVERYTHING Needed to allow you to Pass your Ethical Hacking Exam v11 Dive into hands-on projects, and defend yourself from would-be-attackers....
The Complete Oracle SQL Course
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn Oracle SQL: From Beginner to An Oracle Certified Associate - Helpful for Oracle Exam 1Z0-071 Quick Info: With FULL Subtitles for all the video lessons...
Structured Database Environments with SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Discover Structured Query Language (SQL) programming basics in relation to database management and data manipulation. In addition, you’ll construct and analyze queries to address data requirements....
