Advanced Database Administration

Course
en
English
30 h
This content is rated 0 out of 5
Source
  • From www.edx.org
Conditions
  • Self-paced
  • Free Access
  • Fee-based Certificate
More info
  • 5 Sequences
  • Intermediate Level

Their employees are learning daily with Edflex

  • Safran
  • Air France
  • TotalEnergies
  • Generali
Learn more

Course details

Syllabus

Week 1

Creating databases, tables and indexes

Introduction to how to formulate and issue queries that create databases, tables and indexes

Week 2

Creating views

Introduction to how to formulate and issue queries that create views

Week 3

Creating stored procedures

Introduction to how to formulate and issue queries that create stored procedures

Week 4

Transactions and locking

Introduction to how to a database manages correctness with concurrent transactions

Week 5

Creating Functions

Introduction to how to formulate and issue queries that create functions

Prerequisite

This is the 3rd course in the introductory, undergraduate-level offering that makes up the larger Introduction to Databases MicroBachelors Program. We recommend taking them in order, unless you have a background in these areas already and feel comfortable skipping ahead.

These topics build upon the learnings that are taught in the introductory-level Computer Science Fundamentals MicroBachelors program, offered by the same instructor.

Instructors

Aspen Olmsted
Program Director and Professor of Practice
Simmons University

Platform

Harvard University, the Massachusetts Institute of Technology, and the University of California, Berkeley, are just some of the schools that you have at your fingertips with EdX. Through massive open online courses (MOOCs) from the world's best universities, you can develop your knowledge in literature, math, history, food and nutrition, and more. These online classes are taught by highly-regarded experts in the field. If you take a class on computer science through Harvard, you may be taught by David J. Malan, a senior lecturer on computer science at Harvard University for the School of Engineering and Applied Sciences. But there's not just one professor - you have access to the entire teaching staff, allowing you to receive feedback on assignments straight from the experts. Pursue a Verified Certificate to document your achievements and use your coursework for job and school applications, promotions, and more. EdX also works with top universities to conduct research, allowing them to learn more about learning. Using their findings, edX is able to provide students with the best and most effective courses, constantly enhancing the student experience.

This content is rated 4.5 out of 5
(no review)
This content is rated 4.5 out of 5
(no review)
Complete this resource to write a review