This course is a follow-up course after PostgreSQL Fundamentals. It is suitable for students who are genuinely interested in PostgreSQL and want to become experts in using PostgreSQL.
This course has PostgreSQL Fundamentals as a prerequisite. If you purchase this course, you will be granted access immediately, but if you have not completed the fundamental course before purchase, you might be lost in the material. You will have access to the course for 6 months from the time you purchase the course.
This course is an online non-credit course and will not show on college transcripts.
The language used to create, manage and query relational databases is SQL, or Structured Query Language. This course will train you in PostgreSQL, the widely used modern variant of SQL. The course is offered through NCLab's learning platform. You will receive an email with login instructions upon registration for the course. You will have access to the course for 6 months from the date of registration.
The course is self-paced, and you will practice each skill or concept as you go. Automatic feedback is built into the course for both practices and quizzes.
The course is divided into four Units, and each Unit is composed of five Sections. Each Section consists of 7 instructional/practice levels, a quiz, and a master (proficiency) level. You can return to any level or quiz for review.
Unit 1: Conditional Expressions
Unit 2: Text Strings
Unit 3: Sets and Subqueries
Unit 4: Advanced Joins
While learning skills in the Data Analytics course, you can practice queries and create portfolio artifacts with NCLab’s PostgreSQL and Python apps. Use a project idea from NCLab or create your own. NCLab provides several practice databases that can be queried with the PostgreSQL app.
This course is the PostgreSQL Advanced PostgreSQL. If you complete both Fundamentals and Advanced courses, you will receive a Certificate of Completion from TMCC. There is also a Data Visualization Course that teaches Python with graphical tools. If you complete all three courses, you will receive a Certificate of Completion for Data Analytics.
If you have any question please reach out to Heather Maye at firstname.lastname@example.org or call 775-857-4997.