YoVDO

SQL for Beginners - Database Tutorial

Offered By: Simon Sez IT via YouTube

Tags

SQL Courses PostgreSQL Courses Relational Databases Courses Data Sorting Courses Data Filtering Courses Database Management Courses SELECT Statements Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into a comprehensive SQL tutorial for beginners, focusing on mastering the SELECT statement using PostgreSQL v11 and pgAdmin. Learn essential components of SELECT statements, filtering with WHERE clauses, grouping with GROUP BY, setting conditions with HAVING, and sorting with ORDER BY. Explore string functions, date and time operations, and practice with downloadable course files. Cover topics including SQL introduction, predicates, operators, case expressions, and various string and date/time functions across multiple sections. Gain practical skills to manipulate and manage relational databases effectively in this hour-long video tutorial.

Syllabus

- Simon Sez IT Intro
- Course Overview
- Introduction to SQL
- Predicates, Operators, and Case Expression
- String Functions Part 1
- String Functions Part 2
- String Functions Part 3
- Working With Date & Time Part 1
- Working With Date & Time Part 2


Taught by

Simon Sez IT

Related Courses

Introduction to Databases
Meta via Coursera
Intro to Relational Databases
Udacity
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam
Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera
Web Application Development: Basic Concepts
University of New Mexico via Coursera