[vc_row type="in_container" full_screen_row_position="middle" column_margin="default" column_direction="default" column_direction_tablet="default" column_direction_phone="default" scene_position="center" text_color="dark" text_align="left" row_border_radius="none" row_border_radius_applies="bg" overflow="visible" overlay_strength="0.3" gradient_direction="left_to_right" shape_divider_position="bottom" bg_image_animation="none"][vc_column column_padding="no-extra-padding" column_padding_tablet="inherit" column_padding_phone="inherit" column_padding_position="all" column_element_spacing="default" background_color_opacity="1" background_hover_color_opacity="1" column_shadow="none" column_border_radius="none" column_link_target="_self" column_position="default" gradient_direction="left_to_right" overlay_strength="0.3" width="1/1" tablet_width_inherit="default" tablet_text_alignment="default" phone_text_alignment="default" animation_type="default" bg_image_animation="none" border_type="simple" column_border_width="none" column_border_style="solid"][image_with_animation image_url="2911" image_size="full" animation_type="entrance" animation="Fade In" hover_animation="none" alignment="" border_radius="none" box_shadow="none" image_loading="default" max_width="100%" max_width_mobile="default"][/vc_column][/vc_row][vc_row type="in_container" full_screen_row_position="middle" column_margin="default" column_direction="default" column_direction_tablet="default" column_direction_phone="default" scene_position="center" text_color="dark" text_align="left" row_border_radius="none" row_border_radius_applies="bg" overflow="visible" overlay_strength="0.3" gradient_direction="left_to_right" shape_divider_position="bottom" bg_image_animation="none"][vc_column column_padding="no-extra-padding" column_padding_tablet="inherit" column_padding_phone="inherit" column_padding_position="all" column_element_spacing="default" background_color_opacity="1" background_hover_color_opacity="1" column_shadow="none" column_border_radius="none" column_link_target="_self" column_position="default" gradient_direction="left_to_right" overlay_strength="0.3" width="1/1" tablet_width_inherit="default" tablet_text_alignment="default" phone_text_alignment="default" animation_type="default" bg_image_animation="none" border_type="simple" column_border_width="none" column_border_style="solid"][tabbed_section style="default" alignment="left" spacing="default" tab_color="Accent-Color" vs_content_animation="fade" vs_link_animation="opacity" vs_navigation_alignment="left" vs_navigation_width_2="25%" vs_navigation_func="default" vs_navigation_width="regular" vs_navigation_spacing="15px" vs_navigation_mobile_display="visible" vs_tab_spacing="5%"][tab icon_family="none" title="SECTION 1" id="1675828905277-3" tab_id="1675828905278-7"][vc_column_text]<strong>Motivation and relational DBMS overview </strong>
<ul>
 	<li>Motivation: the importance of data, data management, and data management systems.</li>
 	<li>Overview: different types of data, data models, and data management systems (relational, XML, text, small/large), etc.</li>
 	<li>Relational DBMSs overview: the lifetime of a query, DBMS architecture overview</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 2" id="1675828905309-4" tab_id="1675828905310-10"][vc_column_text]<strong>Using relational DBMSs</strong>
<ul>
 	<li>SQL: how to create a database, load data, insert/delete, and ask queries (including aggregation, subqueries, etc).</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 3" id="1675828905323-0" tab_id="1675828905323-7"][vc_column_text]<strong>Modeling a real problem using a database</strong>
<ul>
 	<li>Conceptual design: ER diagrams, functional dependencies</li>
 	<li>Views and integrity constraints.</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 4" id="1675828905341-0" tab_id="1675828905342-3"][vc_column_text]. <strong>Transactions </strong>
<ul>
 	<li>Transactions: what they are and how to use them</li>
 	<li>Different levels of isolation and possible anomalies</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 5" id="1675828905359-9" tab_id="1675828905360-6"][vc_column_text]<strong>Advanced features</strong>
<ul>
 	<li>Indexes and how to use them</li>
 	<li>Security and access control</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 6" id="1675828905378-9" tab_id="1675828905378-1"][vc_column_text]<strong>Other data models: XML, Text, and multimedia</strong>[/vc_column_text][/tab][tab icon_family="none" title="SECTION 7" id="1675828905394-1" tab_id="1675828905395-5"][vc_column_text]<strong>Data on the web</strong>
<ul>
 	<li>Data integration</li>
 	<li>Information retrieval</li>
 	<li>Asking structured queries over the web</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 8" id="1675828905414-0" tab_id="1675828905415-6"][vc_column_text]<strong>Data warehousing (OLAP) and data mining</strong>
<ul>
 	<li>Data cleaning and extract transform load pipelines</li>
 	<li>Data cubes</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 9" id="1675828905434-5" tab_id="1675828905434-6"][vc_column_text]<strong>Big data processing and cloud computing</strong>
<ul>
 	<li>Parallel DBMSs and MapReduce</li>
 	<li>Databases as a service (SimpleDB, etc.)</li>
</ul>
[/vc_column_text][/tab][tab icon_family="none" title="SECTION 10" id="1675828905454-8" tab_id="1675828905455-5"][vc_column_text]Buffer[/vc_column_text][/tab][/tabbed_section][/vc_column][/vc_row]