Certificate in SQL
Structured Query Language (SQL) is the industry-standard language for database programming. It is one of the most in-demand skills in jobs that require interaction with data and analyzing data. Learning SQL can lead to database administration jobs and occupations that are specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst.
Following your completion of this certificate, you will understand relational database structures and the history and uses of Structured Query Language. You will be able 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. Although you will start by creating simple SQL queries that query a single table, by the end, you will be able to query multiple tables simultaneously. Finally, you will be able to practice techniques that enable you to write powerful queries that perform complicated scans and sorts of data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.
- Start date February 3
Class ID #9458
- Start date March 2
Class ID #9459
- Start date April 6
Class ID #9460
- Start date May 4
Class ID #9461
- Start Date June 1
Class ID #9462
- 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.
- 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.
Questions? Call toll-free 1-888-336-3907, email email@example.com or contact the college nearest you and ask to speak to an advisor.
- Clinton Community College, 563-244-7000
- Muscatine Community College, 563-288-6000
- Scott Community College, 563-441-4000
It is the policy of Eastern Iowa Community College District not to discriminate in its programs, activities, or employment on the basis of race, color, national origin, sex, disability, age, sexual orientation, gender identity, creed, religion, and actual or potential family, parental or marital status, as required by the Iowa Code §§216.6 and 216.9, Titles VI and VII of the Civil Rights Act of 1964 (42 U.S.C. §§ 2000d and 2000e), the Equal Pay Act of 1973 (29 U.S.C. § 206, et seq.), Title IX (Educational Amendments, 20 U.S.C. §§ 1681-1688), Section 504 (Rehabilitation Act of 1973, 29 U.S.C. § 794), and Title II of the Americans with Disabilities Act (42 U.S.C. § 12101, et seq.). If you have questions or complaints related to compliance with this policy, please contact Debora J. Sullivan, Equal Employment Opportunity Officer/Equity Coordinator, Eastern Iowa Community College District, 101 West Third Street, Davenport, Iowa 52801, 563-336-3487, firstname.lastname@example.org or the Director of the Office for Civil Rights, U.S. Department of Education, Citigroup Center, 500 West Madison Street, Suite 1475, Chicago, Illinois 60661-7204, phone number 312-730-1560, fax 312-730-1576, OCR.Chicago@ed.gov.