Visit uwm.edu/sce/coronavirus for information about spring 2021.

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.

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
  • Insert, Update and Delete 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: Wed-Fri, Feb 10-12, 2021

Delivery Method: Live Online

Time: 8:30am-4pm CT

Platform: Zoom

Instructor: Rajani Madeti

Fee:

$845 by Jan 27, 2021
$895 after Jan 27, 2021

CEUs: 2.1

Enrollment Limit: 20

Program Number: 5020-12974

Note: Participants will receive instructions and course links approximately one week prior to first class.

Registration Deadline: Feb 2, 2021

Register Now

Share