Advanced Database Queries

Focused View

Aspen Olmsted

2:11:58

10 View

1. Introduction

1. Introduction.mp4

04:25

2. Week 6 - Aggregate Queries

1. Topic Introduction.mp4

10:35

2. Roll Up & Window Functionality.mp4

08:26

3. Resources.html

4. Week 6 - Lab 1.html

5. Week 6 - Lab 2.html

6. Week 6 - Lab 3.html

7. Week 6 - Lab 4.html

8. Week 6 - Lab 5.html

9. Week 6 Quiz.html

3. Week 7 - Subqueries

1. Topic Introduction.mp4

14:28

2. Common Table Expressions.mp4

04:25

3. Resources.html

4. Week 7 - Lab 1.html

5. Week 7 - Lab 2.html

6. Week 7 - Lab 3.html

7. Week 7 - Lab 4.html

8. Week 7 Quiz.html

4. Week 8 - Data Types

1. Topic Introduction.mp4

15:44

2. Converting Data Types.mp4

04:56

3. Week 8 - Lab 1.html

4. Week 8 - Lab 2.html

5. Week 8 Quiz.html

5. Week 9 - Functions

1. Topic Introduction.mp4

13:14

2. Date & Time Functions.mp4

10:58

3. Decision Branching Functions.mp4

04:31

4. Regular Expression Functions.mp4

04:06

5. Window Functions.mp4

05:37

6. Week 9 - Lab 1.html

7. Week 9 Quiz.html

6. Week 10 - Database Design

1. Topic Introduction.mp4

12:07

2. Normalization.mp4

14:27

3. EER Diagrams.mp4

03:59

4. Week 10 Quiz.html

Description

The next step in programming Relational Databases

What You'll Learn?

Utilize different data types to store data in the database
Develop queries that utilize other subqueries to solve problems
Aggregate data to understand the underlining detail data better
Design Databases that can provide correct results

Who is this for?

Beginning programmers

What You Need to Know?

Completed Introduction to Database Queries Course or Equivalent

More details

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.

Course Objectives
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.

This is the 2nd course of 3 in the program and focuses on more advanced querying of the database.Â We will drill into aggregation, subqueries, data types, function and database design.

Who this course is for:
Beginning programmers

User Reviews

Rating

average 0

Total votes0

Focused display

Aspen Olmsted is an Associate Professor at the Wentworth Institute of Technology. Aspen earned a Ph.D. inComputer Science and Engineering from The University of SouthCarolina. Before his academic career, he was CEO of Alliance SoftwareCorporation. Alliance Software developed N-Tier enterpriseapplications for the performing arts and humanities market. Aspen’sresearch focuses on developing algorithms and architecturesfor distributed enterprise solutions that can guarantee security andcorrectness while maintaining high availability. In his Secure DataEngineering Lab at the Simmons University, Aspen, mentors over adozen graduate and undergraduate students yearly.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.