Learn SQL for Beginners: The Comprehensive Hands-on Bootcamp (Udemy.com)

Master Database Theory & Application Using PostgreSQL - Preparation for Employment as a SQL Developer

Created by: Todd McLeod

Produced in 2021

icon
What you will 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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

icon
Course 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 PostgreSQLwhich 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 studentMaster database fundamentalsBuild a database for tracking movie rentalsUnderstand schema, data hierarchy, and normalizationLearn validation, data integrity, and ACIDtransactionsMaster using key fields and ensuring referential integrityLearn how to do SQL commands at the terminal and in code editorsSolidify concepts with abundant hands on exercises which also have video solutions providedAcquire the ability to read PostgreSQLdatabase documentationLearn how to install PostgreSQLon Windows, Linux, and MacMaster building databases, tables, and relationships between tablesMaster creating, reading, updating, inserting, and deleting recordsGain the ability to do subqueries and aggregate functionsMaster using grouping, having, limit, fetch, and offsetLearn how to use JSONinside SQLusing PostgreSQLMaster joins to query multiple setsMaster filtering records in queriesMASTERSQL&PostgreSQL!
This is an amazing course! This course will change your life. Being skilled at using relational databases and SQLwill 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.

icon
Instructor Details

Todd McLeod

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 Teachers 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 worlds leading trainer in Googles new programming language which is one of the fastest growing, highest paying programming languages in America. In addition, Ihave 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.

icon
More courses by Todd McLeod

Microsoft Excel - From Beginner to Expert in 6 Hours

$11.99

Web Development w/ Google's Go (golang) Programming Language

$11.99

Learn How To Code: Google's Go (golang) Programming Language

$11.99

Master Computers - From Beginner to Expert in One Week

$11.99

How to Create A Website: An HTML Tutorial and CSS Tutorial

$11.99

Microsoft Excel for Mac - From Beginner to Expert in 7 Hours

$11.99

icon
More sql courses

SQL Server - zapytania. Querying. Exam 70-761

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

$11.99

Introduction to Structured Query Language (SQL)

Free

Learn C# With Windows Forms and SQL Server

$11.99

Microsoft Access SQL: SQL for Non-Programmers

$11.99

The Ultimate Oracle SQL Course

$11.99

icon
Reviews

4.5

43 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By chetan kachare on 10/19/2020

I'm excited to learn more.

By Christine on 10/12/2020

Yes, easy to follow and informative

By Suraj Moolya on 8/11/2020

noiceeeeeeeeeeeeeeeee

By Joel Cortes-Cortes on 8/7/2020

No prior experience; the online instructor seems knowledgeable.

By Dominic Walls on 8/4/2020

perfect!

By Anthony on 8/3/2020

Thank you.

By Hamza Shahid on 7/15/2020

A very detailed course. explained each and every topic precisely. Will definitely recommend this course.

By Ade Putra on 6/24/2020

Thanks Daniel Hoffmann & Todd McLeod for this special SQL courses, because now I feel I can do everything in SQL database :D

By Roger on 6/23/2020

great SQL course

By Nathan Kratzmeyer on 6/17/2020

I got a couple of videos in and realized that the instructor spent way too much time on irrelevancies. Also, drawing terrible diagrams with a stylus? Why? Even as a free course, I decided to abandon it.

By Shiraz Malik on 6/5/2020

Todd is a gifted teacher. Amazing way of teaching and i believe he can make anyone learn anything. Thank you!

By Felix Hernandez Sanchez on 6/1/2020

Excelente curso para conocer las bases de SQL y de postgresql