Penn State Classifieds>Penn State Online Courses>Introduction to Structured Query Language (SQL)

Introduction to Structured Query Language (SQL)

About this Course

In this course, you\'ll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You\'ll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you\'ll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Created by: University of Michigan


Related Online Courses

This Specialization is intended for the learner with no previous programming experience or the career changer transitioning to software development. JavaScript is generally the first programming... more
In this course, you learn how to design APIs, and how to use OpenAPI specifications to document them. You learn about the API life cycle, and how the Apigee API platform helps you manage all... more
At the end of this project, you will be able to customize your formatting in Microsoft Excel. You will also be able to use basic conditional formatting to ensure a seamless use of Microsoft Excel... more
The first course, Healthcare Marketplace Overview, covers all of the major sub-sectors of the healthcare industry including the physician, hospital, insurer and medical technology markets,... more
This Docker course is intended for individuals seeking to develop proficiency in Docker and containerization techniques. The course is aligned with the Docker Certified Associate (DCA) exam... more

CONTINUE SEARCH

FOLLOW COLLEGE PARENT CENTRAL