Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 16 Minute(s)
Language
English
Taught by
Gaurav Chauhan
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
2 views
Course Overview
Learn SQL through PostgreSQL and Microsoft Access. Only Course which provides two SQL courses at price of one!
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!
Course Content
- 18 section(s)
- 122 lecture(s)
- Section 1 PostGreSQL - Database Management System
- Section 2 Microsoft Access - Database Management System
- Section 3 Microsoft Access Basics
- Section 4 Microsoft Access Functions Basic
- Section 5 Tables in Microsoft Access
- Section 6 Forms in MS Access
- Section 7 SQL Overview in Excel
- Section 8 SELECT Statement in MS Access
- Section 9 WHERE Clause - Microsoft Access
- Section 10 GROUP By Clause - Microsoft Access
- Section 11 HAVING Clause - Microsoft Access
- Section 12 ORDER BY Clause - Microsoft Access
- Section 13 Text Functions in Microsoft Access
- Section 14 Numeric Functions in Microsoft Access
- Section 15 Date Functions in MS Access
- Section 16 SELECT INTO Function in Microsoft Access
- Section 17 JOINs and UNIONs in Microsoft Access
- Section 18 Bonus Lectures
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.
