SQL level III guides students through advanced techniques in order to effectively create and maintain a highly efficient database. In SQL level III, you'll build a database that you'll use throughout the course to practice and refine your database management skills, including exporting data from external sources, creating temporary tables in lieu of unnecessary filtering, incorporating security measures to protect your data, and implementing stored procedures to maximize consistency and efficiency.

By mastering the skills taught in SQL III, you'll be able to confidently add advanced SQL to your portfolio of skills in web development, and you'll even be prepared to launch a career in database management!

SQL Level III is taught at our affiliate school, NYIM Training, in Midtown Manhattan.

Continue reading

This course has a prerequisite

SQL proficiency equivalent to our SQL Level 2 course is required, including outer joins, subqueries, and logic statements.

What You’ll Learn

  • Create a database and tables
  • Import data from Microsoft Access and Microsoft Excel
  • Write code to import, edit, and delete data
  • Use security features to protect data integrity
  • Develop database diagrams
  • Make local and global temporary tables
  • Implement stored procedures to automate workflows
    • .tb_button {padding:1px;cursor:pointer;border-right: 1px solid #8b8b8b;border-left: 1px solid #FFF;border-bottom: 1px solid #fff;}.tb_button.hover {borer:2px outset #def; background-color: #f8f8f8 !important;}.ws_toolbar {z-index:100000} .ws_toolbar .ws_tb_btn {cursor:pointer;border:1px solid #555;padding:3px} .tb_highlight{background-color:yellow} .tb_hide {visibility:hidden} .ws_toolbar img {padding:2px;margin:0px}