SQL Certificate
Email
PrintStructured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst.
You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data.
This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.
Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
This Certificate must be taken in the following order:
- Introduction to SQL
- Intermediate SQL
- Advanced SQL
Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.
Intermediate SQL
Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.
Advanced SQL
Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.
Registration Deadline: Registration for this course is open five days after the initial start date. You can participate in this online course offered in partnership with LERN any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. There are no live real-time requirements or meetings. You decide when you participate. However, for the best learning, participants should log into the course on 2-3 different days of the week.
Cancellation/Refund Policy: VCU Continuing and Professional Education offers this class/certificate in partnership with LERN. Therefore, you may cancel your registration up until you receive your login and password from LERN and receive a full refund minus any credit card processing fees. Cancellations must be received via email at ocpe@vcu.edu
In the unlikely event that this program is cancelled or postponed due to insufficient enrollments or unforeseen circumstances, the university will fully refund registration fees, but cannot be held responsible for any other expenses, including change or cancellation charges to include but not limited to airlines, hotels, travel agencies, or other organizations.
Online courses offered with the Learning Resources Network (LERN) continue to run, as scheduled during inclement weather. If there are changes to meeting status, you will receive an email at the address you provided upon registration informing you of the cancelation.
*exempt-this offering is ineligible for waiver use
Student/Participant Conduct:
Participants are subject to all university policies applicable to students, unless a specific university or VCU Continuing and Professional Education policy explicitly states otherwise. University policies governing students are available at https://vcu.public.doctract.com including:
Student Code of Conduct
Honor System and Standards of Academic Conduct
Preventing and Responding to Discrimination
Title IX Sexual Harassment Policy-Interim
Sex-Based Misconduct Policy-Interim
For Academic Accommodations, please visit https://ocpe.vcu.edu/courses/policies.html#accommodations
There are still openings remaining at this time.