Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Introduction to Database Queries

person icon Aspen Olmsted

4

Introduction to Database Queries

Learning to Program Relational Databases

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Aspen Olmsted

category icon Database Management,Databases,Database Administration,MySQL

Lectures -26

Quizzes -5

Duration -3 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This program will teach you everything you need to know to use a relational database management system in the Web, the Cloud, and embedded applications. Database development and administration skills are required in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs. The courses utilize the open-source relational database MySQL. MySQL and its open-source fork, MariaDB, are used in millions of web apps to persist the application data and provide query processing. Students gain valuable hands-on experience programming SQL queries in the labs. In addition to the applied SQL labs, you will also gain an understanding of relational databases in general, learning how to design your database so it's robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data, and query that data through extensive hands-on practices.


This self-paced program provides an undergraduate-level introduction to database programming and administration that will help prepare students for advanced undergraduate computer science, information technology, or cybersecurity coursework.


This is the 1st course of 3 in the program and focuses on learning to query a database.  We will drill into tools, single-table queries, multiple-table queries, and queries that modify data in the database. 


Goals

By the end of this program, students should be able to:

  • Apply queries in relational algebra to retrieve data.

  • Apply queries in SQL to create, read, update, and delete data in a database.

  • Apply the concepts of entity integrity constraint and referential integrity constraint (including the definition of the concept of a foreign key).

  • Describe the normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) of a relation.

  • Apply normalization to a relation to create a set of BCNF relations and denormalize a relational schema.

  • Describe functional dependency between two or more attributes that are a subset of a relation.

  • Understand multi-valued dependency and identify examples in relational schemas.

  • Sketch conceptual data models (including ER) to describe a database structure.

  • Apply SQL to create a relational database schema based on conceptual and relational models.

  • Apply stored procedures, functions, and triggers using a commercial relational DBMS.

  • Describe concurrency control and how it is affected by isolation levels in the database.

Prerequisites

Just an interest to learn

Introduction to Database Queries

Curriculum

Check out the detailed breakdown of what’s inside the course

Welcome
2 Lectures
  • play icon Welcome Message
  • play icon Course Welcome 17:31 17:31
Week 1 - Database Overview
5 Lectures
Tutorialspoint
Week 2 - Database Tools
5 Lectures
Tutorialspoint
Week 3 - Querying the database - Single Table
5 Lectures
Tutorialspoint
Week 4 - Querying the database - Multiple Tables
5 Lectures
Tutorialspoint
Week 5 - Modifying the database
4 Lectures
Tutorialspoint

Instructor Details

Aspen Olmsted

Aspen Olmsted

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515