Managing Data(bases) Using SQL

Course Objectives

• Understand the SELECT statement including its main clauses, such as FROM, WHERE, ORDER BY
• Discover the various data types and its associated functions, including complex types such as objects, collections and records
• Understand the data dictionary and learn how to query it for database metadata
• Learn how to perform various different table joins, such as INNER, OUTER, FULL, CROSS and more
• Discover database SET operations, such as INTERSECT, EXCEPT/MINUS and UNION
• Learn about the powerful aggregate functions for data summary and analysis
• Use SQL subqueries and Subquery Factoring techniques to develop modular, complex SQL statements
• Update database data by using Data Manipulation Language (DML) statements (INSERT, UPDATE, DELETE, MERGE)
• CREATE Data Definition Language (DDL) statements to construct database objects (CREATE TABLE)
• Discover some advanced SQL features, such as Analytic functions, Recursive Subquery Factoring, OLAP and regular expression usage in databases

What You’ll Learn

• Data normalization concepts
• Null values and NULL concept
• SELECT statement including all main sub clauses
• Database data types including complex types
• Simple and complex SQL SELECT queries
• SELECT commands UNION, INTERSECT and EXCEPT/MINUS
• Subqueries and nested queries
• Data aggregation using GROUP BY and aggregate functions
• Updating database data
• Creating database objects
• Advanced SQL features

How You’ll Learn

• Lectures
• Group discussions
• Review of homework problems
• Assigned textbook chapters
• Homework assignments

Is This Course Right for You?

If you want to learn SQL from a beginner level or if you want to take your beginner level skills further by getting introduced to some more advanced SQL features, then this course is right for you. It is geared towards anyone wanting to learn SQL (beginner through intermediate), database developers, application developers interacting with databases, and data scientists and analysts.