Why learn SQL ?

SQL is the language that you use to talk to your database. It provides quick answer of your question related to any dataset. SQL is a high level programming language resembles to natural language. So its quite easy to learn it. It is a common standard for all relational databases. Almost every organization needs SQL-fluent pros. This knowledge is essential for every professional, like developers and administrators, accountants, financial analysts, data analysts, data scientists, Big Data engineers, and even marketing specialists can use SQL.

This course includes :

  • More than 5 hours of on-demand videos

  • Five downloadable resources

  • Unlimited access for 12 months

  • Certificate of Completion

What you 'll learn

  • Detailed understanding of relational database.

  • Filtering and summarizing data with SQL code

  • Working with mutiple tables and creating table joins

  • Subqueries and modifying datasets.

  • Who should learn

    Anyone who need to deal with big data, data analytics and business intelligence.

  • Pre-requisites

    Basic knowledge of any database. No programming or coding experience is required.

  • Requirements

    Microsoft Access 2016 or later. MS Access 365 is preferred.

Course curriculum

  • 1

    Structured Query Language - SQL

    • What is SQL?

    • Why should you learn SQL?

    • The SELECT statement

    • Syntax of SELECT statement.

    • Eliminating DUPLICATE rows.

    • Sorting information

    • Review and Practice

    • What is an Expression in SQL?

    • Specifying Explicit Values

    • Types of SQL Expressions

    • Naming the Expression

    • Examples

    • Review and Practice

    • Filtering your data

    • Review and Practice

    • Data Sets

    • Inner Joins

    • Review and Practice

    • Outer Joins

    • Unions

    • Subqueries

    • Aggregate Functions

    • Grouping Data

    • Top Values

    • Connecting to another Database

    • Alias names to Tables

    • Modifying Data - UPDATE statement

    • Modifying Data - INSERT statement

    • Modifying Data - DELETE statement

    • Creating Table in SQL

Buy now

One year subscription