Intro to Relational Databases

Course Cover
compare button icon
Course Report - Intro to Relational Databases

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Course Features

icon

Duration

4 weeks

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Teaching Type

Self Paced

Course Description

This course is a quick fun introduction to using a relational database from your code using examples in Python You ll learn the basics of SQL the Structured Query Language and database design as well as the Python API for connecting Python code to a database You ll also learn a bit about protecting your database backed web apps from common security problems After taking this course you ll be able to write code using a database as a backend to store application data reliably and safely

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

You can read and write basic code in Python This course uses programming exercises in Python If you haven\'t worked with Python before, check out our course Programming Foundations with Python\nIf you can understand this code (maybe with the help of the r

What You Will Learn

Data and TablesLearn about how relational databases let you structure data into tablesLearn about the importance of unique keys and relationships between tables

Elements of SQLBegin learning SQL, the Structured Query Language used by most relational databasesLearn about the select and insert statements, the basic operations for reading and writing dataLearn about the operators and syntax available to get the dat

Python DB-APILearn how to access a relational database from Python codeUse a virtual machine (VM) to run a Python web application with a databaseCommon security pitfalls of database applications, including the famous Bobby Tables

Deeper Into SQLLearn how to design and create new databasesLearn about normalized design, which makes it easier to write effective code using a databaseLearn how to use the SQL join operators to rapidly connect data from different tables

Course Instructors

Karl Krueger

Instructor

Instructor
Course Cover