Канал: Steve Conger

Learning SQL with PostgreSQL Chapter 5 SubQueries

Learning SQL with PostgreSQL Chapter 5 SubQueries

Learning SQL with PostgreSQL Chapter 4 Outer Joins

Learning SQL with PostgreSQL Chapter 4 Outer Joins

Learning SQL with PostgreSQL Inner Joins

Learning SQL with PostgreSQL Inner Joins

Learning SQL with PostgreSQL Cross Joins

Learning SQL with PostgreSQL Cross Joins

Learning SQL with PostgreSQL Aggregate Functions

Learning SQL with PostgreSQL Aggregate Functions

Learning SQL on PostgreSQL Date and Time Functions

Learning SQL on PostgreSQL Date and Time Functions

Learning SQL with PostgreSQL Calculations and Math functions

Learning SQL with PostgreSQL Calculations and Math functions

Learning SQL using PostgreSQL Case

Learning SQL using PostgreSQL Case

Learning SQL with PostgreSQL Chapter 2 Single Table Selects

Learning SQL with PostgreSQL Chapter 2 Single Table Selects

Learning SQL with PostgeSQL 1

Learning SQL with PostgeSQL 1

New Start Upcoming videos

New Start Upcoming videos

Methods Example

Methods Example

InstallJavaEclipse

InstallJavaEclipse

Backing up database in PgAdmin

Backing up database in PgAdmin

IT 112 Static files

IT 112 Static files

IT 221 Chapter 11 Administrative commands

IT 221 Chapter 11 Administrative commands

IT 221 Creating Functions and procedures 2

IT 221 Creating Functions and procedures 2

IT 221 SQL Creating Functions and procedures part 1

IT 221 SQL Creating Functions and procedures part 1

IT 120 I do the Normalization Assignment

IT 120 I do the Normalization Assignment

IT 120 My take on the COOP Sample Data

IT 120 My take on the COOP Sample Data

Overview syllabus IT 112

Overview syllabus IT 112

Introduction and Overview IT 221 SQL

Introduction and Overview IT 221 SQL

IT 112 Assignment 10 More tests

IT 112 Assignment 10 More tests

IT 112 Assignment 9 Authorization

IT 112 Assignment 9 Authorization

Assignment 8 Forms

Assignment 8 Forms

IT 112 Django Unit Tests Models

IT 112 Django Unit Tests Models

IT 111 Python classes

IT 111 Python classes

IT 112 Assignment 6 Detail

IT 112 Assignment 6 Detail

IT 112 Assignment 5 Product view

IT 112 Assignment 5 Product view

IT 112 Assignment 4 Models

IT 112 Assignment 4 Models

IT 112 Assignment 3 First View

IT 112 Assignment 3 First View

IT 112 Assignment 2 Setup

IT 112 Assignment 2 Setup

IT 112 Assignment 1

IT 112 Assignment 1

IT 112 First Assignment Video

IT 112 First Assignment Video

Video for Downloading MongoDb and Importing climatetwitter

Video for Downloading MongoDb and Importing climatetwitter

IT 221 Chapter 8 on Views

IT 221 Chapter 8 on Views

IT 221 Creating tables

IT 221 Creating tables

Chapter 6 Manipulating Data

Chapter 6 Manipulating Data

Video for chapter 5 subqueries

Video for chapter 5 subqueries

IT 228 Weekly Check in 8

IT 228 Weekly Check in 8

IT 120 Check in Video 8

IT 120 Check in Video 8

Weekly Check in Video 8

Weekly Check in Video 8

Chapter 4 Joins Video

Chapter 4 Joins Video

Chapter 3 Calculations and functions

Chapter 3 Calculations and functions

SQL Chapter 1 Overview

SQL Chapter 1 Overview

Weekly Check in 7

Weekly Check in 7

IT 120 Week 6 Check in

IT 120 Week 6 Check in

IT 111 Check in video 6

IT 111 Check in video 6

IT 228 Check In Video 5

IT 228 Check In Video 5

IT 120 Week 5 Check in

IT 120 Week 5 Check in

IT 111 Week 4 Check in video

IT 111 Week 4 Check in video

IT 120 Security

IT 120 Security

IT 111 Week four check in

IT 111 Week four check in

IT 228 Check in video 4

IT 228 Check in video 4

IT 120 Week 4 Check in

IT 120 Week 4 Check in

Using SQL to Test Database

Using SQL to Test Database

IT 228 Week 3 Check in

IT 228 Week 3 Check in

IT 120 Check In Video Week 3

IT 120 Check In Video Week 3

IT 111 Week 3 Check in Video

IT 111 Week 3 Check in Video

IT 228 Week 2 Overview Video

IT 228 Week 2 Overview Video

Week 2 Overview Video

Week 2 Overview Video

Week 2 What's coming up

Week 2 What's coming up

Populating the coop database

Populating the coop database

Syllabus and overview IT 111

Syllabus and overview IT 111

Syllabus and overview IT 120

Syllabus and overview IT 120

Introduction and overview Fall 2020

Introduction and overview Fall 2020

Quick overview of relational design

Quick overview of relational design

Video for creating co-op database and tables

Video for creating co-op database and tables

Video for co-op Entity Design

Video for co-op Entity Design

Normaliztion Example

Normaliztion Example

Overview of relational Design

Overview of relational Design

Quick first look at relational databases

Quick first look at relational databases

New Video on Testing in python

New Video on Testing in python

IT 225 Check In video 5

IT 225 Check In video 5

Populating the data warehouse

Populating the data warehouse

Create Data Warehouse

Create Data Warehouse

Tableau report student grades for a section

Tableau report student grades for a section

Automating Database functions

Automating Database functions

New Video on indexes and optimization

New Video on indexes and optimization

Quick Play through of Tableau

Quick Play through of Tableau

Video for Availability and Backup

Video for Availability and Backup

IT 223 Syllabus and Overview

IT 223 Syllabus and Overview

IT 225 Brief Introductory Video

IT 225 Brief Introductory Video

Introduction IT 222

Introduction IT 222

Users, Roles and Security

Users, Roles and Security

Creating the climate Change Database

Creating the climate Change Database

Climate Change ERD

Climate Change ERD

Weekly Check in May 11th

Weekly Check in May 11th

Object Relationships

Object Relationships

A quick overview ojbects

A quick overview ojbects

ITC 255 Syllabus and Overview

ITC 255 Syllabus and Overview

ITC 285 Syllabus and overview

ITC 285 Syllabus and overview

ITC 222 Overview and Syllabus

ITC 222 Overview and Syllabus

ITC 172 Overview and Syllabus

ITC 172 Overview and Syllabus

Better Django Setup through first view

Better Django Setup through first view

First steps: Installation

First steps: Installation

Pizza ERD Assignment

Pizza ERD Assignment

Normalization Assignment

Normalization Assignment

Organize Pizza Assignment Video

Organize Pizza Assignment Video

First Day ITC 220 video

First Day ITC 220 video

ITC222 First Day

ITC222 First Day

Login and security PostgreSQL

Login and security PostgreSQL

Running Mongo Climate queries

Running Mongo Climate queries

SQL on Posgresql

SQL on Posgresql

Entering data in Postgresql

Entering data in Postgresql

Assignment 8

Assignment 8

Apartment database with LucidCharts and Postgres

Apartment database with LucidCharts and Postgres

Video for assignment 7

Video for assignment 7

Peer assignment 8

Peer assignment 8

if and while blocks

if and while blocks

Peer assignment 7

Peer assignment 7

Creating the Database and Entering data

Creating the Database and Entering data

The Vincent's Vinyl ERD Assignment

The Vincent's Vinyl ERD Assignment

MySql Workbench Model and Forward Engineering

MySql Workbench Model and Forward Engineering

Chapter six video

Chapter six video

Chapter Five Video

Chapter Five Video

Another video on Normalization

Another video on Normalization

Data in Entities

Data in Entities

Car shop ERD Video afternoon

Car shop ERD Video afternoon

Chapter three video

Chapter three video

Chapters 1 and 2

Chapters 1 and 2

First Python

First Python

TestnewComputer

TestnewComputer

Quick view of a relational database

Quick view of a relational database

peer 6 code along

peer 6 code along

Peer exercise 5

Peer exercise 5

Peer Exercise 4 Code Along

Peer Exercise 4 Code Along

Code along for peer assignment3

Code along for peer assignment3

Peer Programming 2 Video

Peer Programming 2 Video

peer Excercise 1

peer Excercise 1

Testing code

Testing code

writing code from class diagrams

writing code from class diagrams

Creating a data warehouse

Creating a data warehouse

Tableau 3

Tableau 3

System queries

System queries

Advanced Queries

Advanced Queries

Activity Diagrams

Activity Diagrams

Tableau 2

Tableau 2

Tableau public in class

Tableau public in class

Getting started with Tableau

Getting started with Tableau

Use Cases

Use Cases

Lock ERD

Lock ERD

ITC 255 Syllabus and Overview

ITC 255 Syllabus and Overview

ITC226PgAdminOverview

ITC226PgAdminOverview

ITC226OverivewandSetup

ITC226OverivewandSetup

224SetupDatabasesAndImportExport

224SetupDatabasesAndImportExport

224 syllabus and overview

224 syllabus and overview

Basic XML

Basic XML

JSON Type and Export

JSON Type and Export

LucidExport

LucidExport

LucidChartsImport

LucidChartsImport

queryExplain

queryExplain

ImportExportCSV

ImportExportCSV

ITC255_UnitTesting

ITC255_UnitTesting

Databases1

Databases1

ITC255_coding

ITC255_coding

ITC172_FormTests

ITC172_FormTests

InstallingPostGres

InstallingPostGres

ITC255_SequenceDiagrams

ITC255_SequenceDiagrams

ITC172_Authorization

ITC172_Authorization

ITC172_Testing

ITC172_Testing

ITC172_ProductAndDetails

ITC172_ProductAndDetails

ITC172_ViewWithData

ITC172_ViewWithData

ITC255_ActivityDiagrams

ITC255_ActivityDiagrams

ITC172_Models

ITC172_Models

ITC255_ERDandReviewofUseCase

ITC255_ERDandReviewofUseCase

ITC172_FirstView

ITC172_FirstView

ITC172Spring_Configuration

ITC172Spring_Configuration

ITC255_InitialDiscussion

ITC255_InitialDiscussion

ITC172_Setup

ITC172_Setup

Django_Class_Projects

Django_Class_Projects

ITC285_Overview

ITC285_Overview

ITC2203112019_Security

ITC2203112019_Security

ITC222352019_AdminCommands

ITC222352019_AdminCommands

ITC2205272019_mongo2

ITC2205272019_mongo2

ITC2222262019_FunctionsTriggers

ITC2222262019_FunctionsTriggers

ITC2202252019_mongoinstall

ITC2202252019_mongoinstall

ITC1722252019_Logins

ITC1722252019_Logins

ITC2222212019_ViewsAndMisc

ITC2222212019_ViewsAndMisc

ITC2202202019_SQL2

ITC2202202019_SQL2

ITC1722202019_Forms

ITC1722202019_Forms

ITC1722132019_Tests

ITC1722132019_Tests

ITC2222122019_CreateAlterTables

ITC2222122019_CreateAlterTables

ITC220262019_MySQLInstall

ITC220262019_MySQLInstall

ITC172262019_lsitanddetail

ITC172262019_lsitanddetail

ITC2221312019_INSERTUPDATEDELETE

ITC2221312019_INSERTUPDATEDELETE

ITC2201302019_SQL1

ITC2201302019_SQL1

ITC1721282019_productView

ITC1721282019_productView

ITC2201252019_subqueries

ITC2201252019_subqueries

ITC2201232019_Installing_SQLServerAndMore

ITC2201232019_Installing_SQLServerAndMore

ITC2221172019_Joins

ITC2221172019_Joins

ITC1721162019_Models

ITC1721162019_Models

ITC172_CleanWalkThroughTechReviewApp

ITC172_CleanWalkThroughTechReviewApp

ITC2221102019_functions

ITC2221102019_functions

ITC172192019_FirstView

ITC172192019_FirstView

ITC220172019_RelationalDesign1

ITC220172019_RelationalDesign1

ITC172-222_Installing postgreSQL_and_django

ITC172-222_Installing postgreSQL_and_django

ITC222182019_Selects

ITC222182019_Selects

ITC172172019_Configuration

ITC172172019_Configuration

ITC172132019_InstallingDjangoUbuntu

ITC172132019_InstallingDjangoUbuntu