CS200 - SQL Security and Procedures Bootcamp

Course Description

The SQL Security and Procedures Bootcamp is the pinnacle of SQL training courses, designed to equip participants with expert-level knowledge and skills in querying, database management, and database security. This bootcamp focuses on advanced querying techniques, creating and using stored procedures, utilizing loops and cursors, and implementing cybersecurity measures. Participants will learn advanced data manipulation, optimize queries for performance, and construct intricate data solutions. The program also covers how to secure databases and queries from both external and internal threats. By the end of this bootcamp, participants will be adept at utilizing the full potential of SQL to solve complex data challenges, make strategic data-driven decisions, and protect data integrity. Completing this bootcamp will result in earning the SQL Security and Procedures digital badge, which can be showcased on platforms like LinkedIn.

Note that Intermediate Applications of SQL, or equivalent knowledge and experience with SQL, is a prerequisite for this bootcamp. If you would like to enroll directly into the SQL Security and Procedures bootcamp, please contact info@skillslab.umsl.edu to discuss, and we will be glad to speak with you.

Who Should Enroll in This Bootcamp?

This bootcamp is ideal for SQL Developers, Report Writers, Cybersecurity Specialists, Database Administrators, and IT Managers who use SQL in their daily roles. It is also beneficial for employees and job seekers looking to enhance their database management skills and ensure data accuracy and security. These skills are crucial for professional development and improving competency in data management.

Core Skills Developed

• Stored Procedures: Learn to create and modify stored procedures to simplify end-user interactions with databases.
• Error Trapping: Acquire techniques for catching and handling SQL errors in unusual situations.
• Information Logging: Master the ability to log deletions, inserts, and updates, enabling tracking of data changes by user and time.
• Cursors and Loops: Gain the skills to create or modify cursors and loops, allowing SQL commands to be executed in a specific order, which is beneficial for handling data in busy databases or across multiple databases.
• Indexing for Performance: Learn to create and manage indexes to enhance database performance and speed up query response times.
• Database Security: Develop an understanding of database security practices to protect sensitive information and ensure compliance with data protection regulations.

Requirements

The bootcamp includes a series of three progressive courses: Introduction to SQL Stored Procedures, Intermediate SQL Stored Procedures, and Introduction to SQL Security. Completing this bootcamp will result in earning the SQL Security and Procedures digital badge, which can be showcased on platforms like LinkedIn.

Course Schedule

The bootcamp may be taken online synchronously or in person at our training center in Des Peres, St. Louis County, Missouri. Employers and job centers may also request training held at an offsite location. Please contact info@skillslab.umsl.edu for further information.

Pathways

This bootcamp fulfills 19.5 hours of coursework required for the UMSL Chancellor’s Certificate in Database Technology. Each course is valued at 0.65 Continuing Education Units (CEUs).

For More Information

For more information and registration details, please visit the dedicated area on our website or contact our support team at info@skillslab.umsl.edu.