Deprecated: add_custom_background is deprecated since version 3.4.0! Use add_theme_support( 'custom-background', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Deprecated: add_custom_image_header is deprecated since version 3.4.0! Use add_theme_support( 'custom-header', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the jquery handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the smoothscroll handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Deprecated: The called constructor method for WP_Widget in Yoko_SocialLinks_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5177
Intro to Databases, Video Lecture 1: Intro | Megan Taylor

Megan Taylor

front-end dev, volunteacher, news & data junkie, bibliophile, Flyers fan, sci-fi geek and kitteh servant

Intro to Databases, Video Lecture 1: Intro

Database Management system (DBMS) provides efficient, reliable, convinient and safe multi-user storage of and access to massive amounts of persistent data.

efficient – performance, thousands of queries/updates per second
reliable – 99.99999% uptime
convinient – physical data independence, high-level query languages, declarative
safe – hardware, software, power, users
massive – terabytes
persistent
multi-user – concurrency control

Database applications may be programmed via frameworks (Django, Rails)

DBMS may run run in conjunction with “middleware” (app servers, web servers)

Data-intensive applications may not use DBMS at all

Course focuses on DBMS itself

Key concepts:
Data model – set of records, XML, graph
schema vs. data – types vs. variables
data definition language (DDL) – set up schema/structure for a database
data manipulation or query language (DML) – querying and modifying

Key people:
DBMS implementer – builds system
database designer – establishes schema
database application developer – programs that operate on database
database administrator – loads data, keeps running smoothly

October 13, 2011 | Comments Off on Intro to Databases, Video Lecture 1: Intro | Categories: Posts | Permalink

Comments are closed.


Notice: Undefined index: host in /home/pqmz7qzy9yt5/public_html/wp-content/plugins/jetpack/modules/stats.php on line 209