Structured Query Language (SQL) is the industry standard database programming language and is one of the most in-demand skills in occupations requiring interaction with data. This Certificate Program will enhance your competitiveness as you become more marketable in computer-related career fields that pertain to data analyst and database administration. 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. Then progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously, to altering data in a database and how to gather significant statistics from data stored in a database. Complete the program by learning techniques to enable you to write powerful queries that perform complicated searches and sorts on your data. Three one-month courses.
Introduction to 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.
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.
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.