All fall 2020 courses and programs will be offered online. For more information, visit uwm.edu/sce/coronavirus.

Share

SQL – Introduction

Learning how to retrieve information from a database can be perplexing. It requires an understanding of how to query a database properly and effectively, and how to translate the question or task into the correct query. Without these skills, incorrect data and ineffective queries can result.

Learn how to properly query a database and translate questions or tasks into the correct query.

Courses involve lecture, demonstration and hands-on practice. A comprehensive textbook is included with the course fee.

This course can be applied to the Data Analysis Certificate.

Instructor

Rajani Madeti

Rajani Madeti

Rajani Madeti has worked with SQL for more than 20 years and has experience in Oracle, Db2, SQL Server and MongoDB databases. She is currently an IS systems development specialist for the University of Wisconsin-Milwaukee Information Technology Services. She has ... read more

Who Should Attend

Anyone who needs to extract data from a database. No experience necessary.

Course Outline/Topics

  • Relational Databases
  • Select Statement
  • Column Aliases
  • Derived Columns
  • Conditional Operators
  • Logical Operators
  • Nulls
  • Where Clause
  • Order by Clause
  • Expressions
  • Inner, Outer, Mixed and Self Joins
  • Aggregate Functions
  • Grouping
  • Having Clause
  • Subqueries
  • Unions
  • Append, Delete and Edit Queries

Prerequisites

Experience using Windows and a web browser.

Testimonials

"Rajani was amazing! She handled the class and the information perfectly and was extremely helpful!"  —  Khizar Jawaid, U.S. Strategic Pricing Analyst, FedEx, 2019

"I wish all my college instructors had been like this!"  —  Janessa Doucette, Research Specialist, Milwaukee Public Schools, 2019

Date: Sept 23-25

Delivery Method: Face-to-Face

Time: 8:30am-4:30pm CT

Location: UWM School of Continuing Education

Instructor: Rajani Madeti

Fee:

$724 by Sept 9
$749 after Sept 9

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5020-12969

Registration Deadline: Sept 23

Register Now

Date: Feb 24-26, 2021

Delivery Method: Face-to-Face

Time: 8:30am-4:30pm CT

Location: UWM School of Continuing Education

Instructor: Rajani Madeti

Fee:

$724 by Feb 10, 2021
$749 after Feb 10, 2021

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5020-12974

Registration Deadline: Feb 24, 2021

Register Now

Share