Gain hands-on expertise to work with SQL for Data science with the SQL for Data Analytics course and lab. Lab simulates real-world, hardware, software, and command-line interface environments and can be mapped to any textbook, course, or training. The SQL course and lab will teach everything from the basics of SQL for Analytics to SQL for Data preparation, aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

The SQL course and lab will teach everything from the basics of SQL for Analytics to SQL for Data preparation, aggregate functions for Data analysis, importing and exporting data; analytics using complex data types, and more.

1

  • Understanding and Describing Data

  • Introduction
    The World of Data
    Methods of Descriptive Statistics
    Statistical Significance Testing
    Summary
2

  • The Basics of SQL for Analytics

  • Introduction
    Relational Databases and SQL
    Basic Data Types of SQL
    Reading Tables: The SELECT Query
    Creating Tables
    Updating Tables
    Deleting Data and Tables
    SQL and Analytics
    Summary
3

  • SQL for Data Preparation

  • Introduction
    Assembling Data
    Transforming Data
    Summary

Audience

Experienced data professionals will benefit from this course.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...