LP-SQL - Cognitio Platform

Home » Courses » LP-SQL

Course Content

Expand All

Lesson 1: Understanding Core Database Concepts (Flat files, database, relational databases and system architecture) 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Topic 1.1: Intro to SQL Part 1

Topic 1.2: Intro to SQL Part 2

Topic 1.3: Comments

Topic 1.4: SQL DataTypes

Topic 1.5 : SQL operators

Topic 1.6: Queries and Subquery (external resource)

Lesson 2: Relational Algebra

Lesson 3: SQL Data Types 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Topic 3.1: What are Data Types? Why use data types?

Topic 3.2: Numeric Data Types: Int, Float

Topic 3.3 String : Char, Varchar

Topic 3.4 Date, Time

Lesson 4: SQL Operators 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Topic 4.1 What are operators?

Topic 4.1.1: Arithmetic Operators

Topic 4.1.2: Logical operators

Topic 4.1.3: Comparison operator

Lesson 5: SQL Comments 1 Topic

Expand

Lesson Content

0% Complete 0/1 Steps

Topic 5.1: Comments

Lesson 6: SQL – Data Definition Language

Lesson 7: SQL – Data Manipulation Language (includes joins and views)

Lesson 8: SQL – Data Control Language Commands

Lesson 9: SQL Queries and Sub Queries (nested queries) 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Topic 9.1: What is Query?

Topic 9.2: What is SubQuery?

Topic 9.3: Commands used in SubQueries

Topic 9.3.1: Select, Insert, Update, Delete

Topic 9.4: Rules of Subqueries

Lesson 10: Normalization

MTA 98-364 Quiz