Login Sign Up

PostgreSQL and MySQL for Beginners

Via Udemy

Udemy based on 238 ratings

Share

0

Overview

Learn most popular SQL dialects, PostgreSQL & MySQL. Learn SQL concepts, practice & compare syntax of PostgreSQL & MySQL What you'll learn: How to write SELECT queries to fetch relevant data in PostgreSQL and MySQLHow to filter and sort the data using WHEN, logical operators and ORDER BYHow to group and aggregate data in PostgreSQL and MySQLHow to apply joins and combining queries in PostgreSQL and MySQLString, mathematical, date-time functions and pattern matching in PostgreSQL and MySQLUnderstanding of VIEWS...

Syllabus

  • Introduction
  • Course Resources
  • Setting up PostgreSQL and PGAdmin
  • Installing MySQL
  • Fundamental SQL statements
  • Restore and Back-up in PostgreSQL
  • Restore and Back-up in MySQL
  • Selection commands: Filtering
  • Selection commands: Ordering
  • Aliases


PostgreSQL and MySQL for Beginners
Go to Class

via Udemy

10 hours 1 minute

Certificate Available

English

On-Demand

Beginner

Instructor

Start-Tech Trainings

Reviews

No reviews yet. Be the first to review!