edX This course is a continuation of the basic concepts, organization, and implementation models taught in the Introduction to Databases and Advanced Database Queries courses. Among the topics covered are the development of objects in the database such as databases, tables, indexes, views, stored procedures and functions. Applied labs expand on the lectures to provide students with hands-on experience with a relational database management system (DBMS) and structured query language (SQL).
Course Objectives:
- Develop queries in SQL to create databases, tables and indexes
- Develop queries in SQL that create views
- Develop queries in SQL that create stored procedures
- Understand concurrent database processing through the use of transactions and locking
- Develop queries in SQL that create functions.
Recommended Background
- Recommended for individuals in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs.
Course ID
ED080
Skill Focus
Intermediate
Instructor(s)
edX
Employee Type
New applicants,Leadership, Change leaders
Method of Delivery
Online
Estimated Effort
40 hrs
Cost
Contact for Pricing
Certification is paid for $ 166.00 ; Full financial aid available for certification