Databases: Advanced Topics in SQL

Databases are incredibly prevalent -- they underlie technology used by most people every day if not every hour. Databases reside behind a huge number of websites; they're a crucial component of telecommunications systems, banking systems, video games, and just about any other software system or electronic device that maintains some amount of persistent information. In addition to persistence, database systems provide a number of other properties that make them exceptionally useful and convenient: reliability, efficiency, scalability, concurrency control, data abstractions, and high-level query languages. Databases are so ubiquitous and important that computer science graduates frequently cite their database class as the one most useful to them in their industry or graduate-school careers.


Course Objectives:

  • Creating indexes for increased query performance
  • Using transactions for concurrency control and failure recovery
  • Database constraints: key, referential integrity, and "check" constraints
  • Database triggers
  • How views are created, used, and updated in relational databases
  • Authorization in relational databases.


Recommended Background

  • Recommended for individuals heading towards a career in data science or information technology / currently in a business data analyst/ data scientist role.
Register Now

Course ID

ED142

Skill Focus

Smart Technology

Instructor(s)

Stanford University

Employee Type

New applicants, Operations teams, Leadership

Method of Delivery

Digital

Estimated Effort

40 hrs

Cost

Audit Free


Certification is paid for $ 50.00 ; Full financial aid available for certification