Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Two SQL Database in Two Days!
Rating: 4.2 out of 5(20 ratings)
1,217 students

Two SQL Database in Two Days!

Learn SQL through PostgreSQL and Microsoft Access. Only Course which provides two SQL courses at price of one!
Created byGaurav Chauhan
Last updated 7/2020
English

What you'll learn

  • Two Database Management System - PostgreSQL and Microsoft Access
  • Good Understanding of database management system concepts
  • Added Advantage in professional career towards the field of data analytics.
  • Lifetime access to lectures, E-Books and Practices files.

Course content

18 sections • 122 lectures • 9h 16m total length

  • Introduction6:43
  • Setting up PostgreSQL5:46
  • *** Udemy Review Update ***0:41
  • PgAdmin 4 Overview6:42
  • PostgreSQL - Course Files
  • Import Database in PostgreSQL4:11
  • SELECT6:59
  • ORDER BY5:34
  • SELECT DISTINCT9:37
  • WHERE6:07
  • LIMIT4:44

    Learn how the limit clause narrows a select result to a subset of rows, use offset to skip initial rows, and see how limit zero returns the full result set.

  • FETCH4:46

    Discover how the fetch clause compares to the limit clause in SQL, including fetch first, offset, and practical examples with select, from, and order by.

  • LIKE7:28
  • IN CLAUSE9:01
  • BETWEEN AND ALIAS- AS7:24
  • IS NULL5:40

    Explore null and not null in sql by building a contacts table, enforcing not null on names, and querying with is null and is not null to handle missing data.

  • JOINS INTUITION18:40
  • INNER JOIN9:22
  • LEFT JOIN3:34
  • FULL OUTER JOIN8:13
  • GROUP BY5:18
  • HAVING CLAUSE3:51
  • UNION6:13
  • Aggregate Functions - Average,Count12:45
  • Aggregate Functions - Min, Max and Sum15:45
  • Date and Time Functions18:12
  • String Functions13:19

Requirements

  • You should have basic understanding of Computers
  • You should have Microsoft Access 2010 or higher installed on your computer

Description

  Learn how to use SQL quickly and effectively with this course with two different database management system. First we will start with PostgreSQL and then we will move to Microsoft Access.

You'll learn how to read and write complex queries to a database (PostgreSQL & Microsoft Access) using one of the most in demand skills - SQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!


Who this course is for:

  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!

  • Anyone interested in learning Microsoft Access!
           

 

Who this course is for:

  • Anyone who is interested in field of data analytics
  • Anyone who wants to learn Microsoft Access 2013 to enhance their career
  • Anyone Interested in Learning PostgreSQL or SQL

Report abuse