Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development PostgreSQL

Learn SQL for Beginners: The Comprehensive Hands-on Bootcamp

Master Database Theory & Application Using PostgreSQL - Preparation for Employment as a SQL Developer
Rating: 4.4 out of 54.4 (299 ratings)
25,432 students
Created by Todd McLeod, Daniel Hoffmann
Last updated 4/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • The ultimate comprehensive course
  • From beginning to advanced concepts
  • Acquire the skills necessary to work with SQL and to work as a SQL developer
  • Learn the fundamentals of databases, database architecture, and relationships
  • Master the nuances of SQL commands including multiple table joins
  • Gain the ability to use SQL at the terminal and in code editors
  • Taught by a university professor
  • Exclusive access to valuable code base
  • Hands-on exercises with solutions
  • Over 2.65 Million students taught
  • Lifetime course access
  • Learn at your own pace
  • 100% satisfaction guaranteed
  • Never expires - lifetime access - forever!
  • This course is tried, tested, and proven
  • Mobile friendly

Course content

44 sections • 211 lectures • 18h 5m total length

  • Preview05:34
  • Credentials
    06:52
  • Course resources
    02:58
  • Course pathway
    02:27

  • Success
    08:45
  • Customization
    01:32
  • Questions
    04:20
  • Principles
    02:25
  • Collaboration
    02:34
  • Exercises
    01:33
  • Anecdotes
    02:54

  • Introduction
    03:06
  • A puzzle
    08:13
  • Implications
    08:52
  • Discussing schema
    04:46

  • Customers table
    07:45
  • Movies table
    03:18
  • Rentals table
    03:52

  • Hands-on exercise #1
    10:57
  • Hands-on exercise #2
    04:53
  • Hands-on exercise #3
    02:45
  • Hands-on exercise #4
    08:27

  • Schema
    04:12
  • Data hierarchy
    02:34
  • Normalization
    02:37
  • Preview01:50
  • Data integrity
    02:32
  • Key field
    01:25
  • Referential integrity
    01:23
  • ACID transactions
    05:09
  • Queries
    03:57

  • Hands-on exercise #1
    14:15
  • Hands-on exercise #2
    11:14
  • Hands-on exercise #3
    06:09

  • Introduction
    02:40
  • The terminal
    06:49
  • Bash on windows
    07:59

  • Working with directories
    07:17
  • Viewing directory details
    05:53
  • Working with files
    03:24
  • Removing items
    02:51
  • Working with permissions
    06:50

  • Introduction
    04:46
  • Setting environment variables - mac, linux
    05:59
  • Setting environment variables - windows
    02:58

Requirements

  • No prerequisite knowledge is required to take this course. This course starts at the very beginning and will teach you everything you need to know to be an outstanding SQL developer.

Description

Understanding relational databases is an essential skill for all developers.

Learning databases and database theory can be easy if you have the right teacher.

This university level course will give you a solid understanding of how databases work and how to use them. In the course, we will be using PostgreSQL which is one of the top two databases most demanded in industry.

This course will advance your skills as a developer.

This course is very practical and applicable. It focuses on teaching you skills you can use.

Presented with high-quality video lectures, this course will visually show you many great things about relational databases and PostgreSQL. This course is taught by two teachers. One of your teachers is a tenured professor in California. Your other teacher is a Professional Developer. Both of these teachers will be on screen, sharing their wisdom and knowledge with you.

This is just some of what you will learn in this course:

  • Learn to succeed as a student

  • Master database fundamentals

  • Build a database for tracking movie rentals

  • Understand schema, data hierarchy, and normalization

  • Learn validation, data integrity, and ACID transactions

  • Master using key fields and ensuring referential integrity

  • Learn how to do SQL commands at the terminal and in code editors

  • Solidify concepts with abundant hands on exercises which also have video solutions provided

  • Acquire the ability to read PostgreSQL database documentation

  • Learn how to install PostgreSQL on Windows, Linux, and Mac

  • Master building databases, tables, and relationships between tables

  • Master creating, reading, updating, inserting, and deleting records

  • Gain the ability to do subqueries and aggregate functions

  • Master using grouping, having, limit, fetch, and offset

  • Learn how to use JSON inside SQL using PostgreSQL

  • Master joins to query multiple sets

  • Master filtering records in queries

  • MASTER SQL & PostgreSQL!

This is an amazing course! This course will change your life. Being skilled at using relational databases and SQL will serve you and your career well. This course will increase your proficiency, productivity, and power as a programmer. You are going to love this course and it will forever change your life.

Your satisfaction is guaranteed with this course.

Join us now and enroll!

Who this course is for:

  • This is a first semester university level SQL database course.
  • This course is ideal for beginners wanting to learn databases & SQL programming.

Instructors

Todd McLeod
Tenured College Professor
Todd McLeod
  • 4.5 Instructor Rating
  • 47,191 Reviews
  • 326,570 Students
  • 19 Courses

I am a tenured professor in California. I have taught at both the college and university level. I have also taught in multiple disciplines including business, information systems, computer science, and online education. In 1997, I was one of the first professors at the university to teach online. I did post-graduate work in online education at UC San Diego. I co-founded and taught in the “Online Teacher’s Training Program” which trained professors how to teach online. In 2008, I was selected as one of the best instructors in the entire California Community College system. Currently, when measured by the number of students served, I am the world’s leading trainer in Google’s new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, I have started three businesses (two of them profitable, so far). My background in business, information systems, computer science, online education, and real-world entrepreneurship has prepared me to teach all of these courses. I look forward to helping you learn great skills to improve your life. Better skills, better life.

Daniel Hoffmann
CTO at Greater Commons
Daniel Hoffmann
  • 4.4 Instructor Rating
  • 815 Reviews
  • 30,835 Students
  • 4 Courses

I am a cloud engineer and software architect at Greater Commons. I have several years of professional experience in the Go programming language and the Google Cloud platform. I specialize in systems that react to outside stimuli, like REST and GRPC servers. I know the basic front-end languages and can make a website from a design.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.