Your cart is empty.
Keep shopping
Teach on Udemy
Turn what you know into an opportunity and reach millions around the world.
Learn MoreTwo SQL Database in Two Days!
Rating: 4.2 out of 54.2(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
English [Auto],
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.
Explore related topics
Course content
18 sections • 122 lectures • 9h 16m total length
- Introduction6:43
Explore Postgres SQL, an open source, cross-platform database with a simple, common SQL syntax. Learn its wide adoption, low total cost of ownership, and portability across Unix, macOS, and Windows.
- Setting up PostgreSQL5:46
Install PostgreSQL on Windows and macOS by downloading the latest installer from the PostgreSQL website or EnterpriseDB, set a memorable password, and configure port 5432 with pgAdmin.
- *** Udemy Review Update ***0:41
- PgAdmin 4 Overview6:42
Explore PgAdmin 4 to manage databases, schemas, tables, and tablespaces, and learn about views, functions, and inheritance as you import the DVD rental database in the next lecture.
- PostgreSQL - Course Files
- Import Database in PostgreSQL4:11
Download and unzip the DVD rental database, create the database, and restore the backup to populate its tables. Verify the data by inspecting tables and refreshing the view.
- SELECT6:59
Explore select syntax in SQL to specify columns, pull data from tables like customer and country, and run queries using FROM, STAR, and semicolon conventions.
- ORDER BY5:34
Use the order by clause to sort query results in ascending or descending order, selecting columns from a table and demonstrating with first name, last name, and customer id.
- SELECT DISTINCT9:37
Learn how the distinct clause removes duplicate values in a select statement, using single-column and multi-column examples, and explore how order by affects results.
- WHERE6:07
Learn the where clause in sql, filtering rows with =, >, <, >=, <=, !=, and, or, with case-sensitive string comparisons, using customer and payment tables.
- 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
Master the SQL like operator with wildcards % and _ to match strings, including patterns that start with specific letters and single-character variations, using practical customer table examples.
- IN CLAUSE9:01
learn how the in clause matches a value within a list, and how a Kuwaiti inside another Kuwaiti demonstrates it, with examples from rental and customer data.
- BETWEEN AND ALIAS- AS7:24
Explore the between operator and not between to filter data by ranges, and learn the as alias syntax to rename columns and simplify joins.
- 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
Explore how SQL joins combine columns from multiple tables using common keys, covering inner, left, right, full outer, cross, natural, and self joins with practical examples.
- INNER JOIN9:22
Learn how inner joins combine matching rows from two tables, such as customers and payments, and extend to three-table joins, with practical data selection and ordering examples.
- LEFT JOIN3:34
Learn how the left join combines all rows from the film table with matching inventory rows, demonstrating left outer join usage and retrieving film descriptions and inventory details.
- FULL OUTER JOIN8:13
Explore how a full outer join returns all rows from both tables, with nulls when there is no match, as shown in the departments and employees example.
- GROUP BY5:18
Learn how the group by clause groups rows by a column to compute aggregates such as sum and count, and use order by to sort the results.
- HAVING CLAUSE3:51
Explore how the having clause filters grouped results after aggregation using group by, sum, and count. See examples where payments exceed 150 and groups with counts over 300.
- UNION6:13
learn how union and union all combine two queries into a single result set, with duplicate handling and column compatibility rules, demonstrated using simple sales tables.
- Aggregate Functions - Average,Count12:45
Explore aggregate functions such as average and count, with distinct values and inner joins. Learn about having clauses, null handling, and grouping for analytics using payment and customer tables.
- Aggregate Functions - Min, Max and Sum15:45
Explore how to use aggregate functions max, min, sum, greatest, and least in SQL, with practical examples on grouping, having clauses, and querying the payment and film tables.
- Date and Time Functions18:12
Explore date and time functions in sql, including current date, current timestamp with time zone, date_part, local time, and string-to-date conversions with to_date and to_timestamp.
- String Functions13:19
Explore SQL string functions, including ASCII, CHR, CONCAT and CONCAT_WS, FORMAT, and case changes with LOWER and UPPER, plus LEFT, LENGTH, POSITION, SUBSTRING, SPLIT_PART.
- What is Microsoft Access?2:06
Explore the basics of microsoft access, a database management system in the microsoft office 2013 suite, as a central repository to create and manipulate data using forms.
- What is a Database?2:50
Learn what a database is: a central repository for storing data, from servers to global storage, and how database structures have evolved over time.
- What is a Database Management System?2:24
Discover what a database management system is and how it acts as an intermediary between users and the database, enabling efficient data entry, retrieval, and organization.
- What is Data?2:52
Define data as anything that goes into a computer, from video and image files to content, and show how MS Access stores this data as zeros and ones in tables.
- How is Data Stored?3:26
Explore how data is stored in computers, from characters represented as numbers to decimal and hexadecimal forms. Learn how storage choices influence database access and optimization in sql databases.
- Data and Formats4:39
Explore how formats affect data presentation in Excel and Access, showing how currency and number formatting change appearance without altering the underlying values stored in the back end.
- Create a Blank Database1:52
Create a blank database in Microsoft Access from the home screen, locate the file on the C drive, and note the A.S.C. extension and the default ID table.
- Opening an Existing Database2:24
Open an existing MS Access database by using the start menu, open other files, or browse from OneDrive or computer; view tables and objects, with security prompts.
- Difference Between Excel and Access2:42
Compare Excel and Access: Excel accepts any data type in a column, while Access requires declared field types, shaping how tables store numbers, text, dates, and currency.
- Overview of MS Access 20134:01
Explore the Microsoft Access 2013 welcome screen, including templates for asset tracking, issue tracking, and project management, and understand how Access stores data and supports mobile web and apps.
- Introduction to Data Types4:09
Discover Microsoft Access data types, from number and short text to date/time and yes/no, and see how field choices determine valid data entry.
- Numeric and Text Data6:02
Explore numeric and text data types in MS Access, detailing number and currency fields, decimal points, and when to use short, long, or rich text, including zip codes.
- Primary Keys5:58
Discover how the primary key ensures unique identity and data integrity in a table, enforced by not null, no duplicates, and indexing to support joins and unions.
- Creating New Variables3:31
Create new fields in an MS Access table, such as salary. Learn how to choose data types like number, currency, and date/time, and understand the default ID field that auto-increments.
- Adding date and Caption and Default4:32
Explore how to add attributes to table columns in MS Access by setting a field's name, caption, and default value, and distinguish between label and variable name.
- Using Functions in Expressions Builder3:50
Explore how to use functions in the expression builder of MS Access to set default values for fields, including date and time functions, to auto-populate new records.
- Converting Between Data Types Part 13:21
Learn how to convert data types in a table and how Access handles numeric versus text fields, with examples like employee numbers and salaries.
- Converting Between Data types Part 21:51
Examine the ID field in an MS Access table, showing how auto increment and default values interact, and how altering its integer properties changes its behavior.
- Fields Validation3:41
Explore field validation rules in MS Access tables, including required and unique, to ensure complete data entry and prevent duplicates.
- Sort Ascending and Descending2:44
Learn how to sort a table in MS Access using ascending and descending order, including sorting by last name and age to reorganize records.
- Design View of Table4:26
Explore the design view in MS Access for a table, adjusting currency format to euros, decimal places, captions, and default values, and note upcoming primary keys.
- Update Table Statement5:15
Learn to use the update statement to modify specific rows with set and where clauses, updating fields such as first name, last name, and salary via a sequence number.
- Delete a Table2:06
Learn to delete a table in ms access using drop table, including closing a locked table and removing the sample table with fields sequence number, first name, last name, salary.
- Export Data6:04
Export data from MS Access to Excel by selecting the export destination, choosing a file format, and considering encoding. Explore options like CSV or text files for efficient sharing.
- Forms Part 12:52
Learn to create and use forms in MS Access for safe data entry and editing, ensuring data consistency, and discover four form creation methods, including the popular form wizard.
- Forms Part 28:05
Learn to create forms in Microsoft Access with bound and unbound options, selecting variables from a paycheck table and choosing columnar, tabular, or datasheet layouts to enter and view records.
- Importing Excel Data Into Access Part 15:52
Learn how to import an Excel sheet into Access to create a new table, adjust field properties, and set a primary key, including handling duplicates and choosing import options.
- Importing Excel Data into access Part 24:10
Import Excel data into Access in part 2 of the two days sql database course, guiding you through practical steps to integrate and manage external data efficiently.
- Insert Into Statement4:54
Learn to use the insert into statement to add a new row in a table by specifying the table, column names, and values, including first name, last name, and salary.
- Overview of SQL in MS Access3:17
Explore how SQL in MS Access streamlines database manipulation, from creating tables and inserting values to using select queries for efficient data management.
- SQL its Classification1:58
Explore the core SQL categories, including DDL for defining structures and DCL for security, while learning basic SQL syntax, querying and joining tables, and best practices for efficient data management.
- Basic SQL Syntax0:54
Learn basic sql syntax for MS Access by using select, from, and where clauses to extract and subset data from a table, with upcoming sessions covering operators.
- Select Variables From6:45
Learn to write a simple SQL query in Microsoft Access that selects specific variables from the salary table, using design view and the run button.
- Variables Position in Results2:42
Explore how the position of variables in a select statement shapes query results in MS Access, with id, first name, last name, salary, and bonus appearing in the chosen order.
- All Variables from Table2:27
Learn how to select all variables from a table in MS Access using the select star syntax, avoiding listing each variable, and maintain the original order.
- Create New Variables5:40
Learn how to create new variables in a select clause by calculating monthly salaries from annual pay (salary divided by 12) and aliasing the results for clear per-record output.
- Where Clause Part 15:15
Explore how the where clause filters an employee database to retrieve first name, last name, and salary. Build and run conditional queries to see targeted results.
- Where Clause Part 24:10
Use a where clause to subset data by salaries over 95000, selecting first name, last name, salary, bonus, and monthly salary from the paycheck table.
- Where Clause Part 35:04
Master the where clause by combining first name, last name, salary, and bonus with and/or conditions to filter records where salary exceeds 95000, using George Lucas as an example.
- Operators1:42
Explore SQL operators, including comparison and logical operators, and learn to negate and combine conditions using where clauses. Future sessions will cover each operator type one by one.
- Arithmetic Operators1:59
Learn arithmetic operators in SQL databases, including the less operator, minus operator, multiplication operator, and division, through a salary calculation using a small data set and variables.
- Comparison Operators5:01
Learn the core SQL comparison operators =, !=, >, <, >=, <= and how they combine, demonstrated with salary examples.
- Operators in Operators3:42
Learn how the in operator simplifies SQL conditions by comparing a value to a list, using paycheck data to filter first names like David or Chevy.
- Like Operator4:34
Explore the like operator and wildcard patterns in SQL, compare strings that begin with certain letters using wildcards, including the start and question mark operators, with MS Access examples.
- Between Operator3:04
Explore how the between operator in SQL works with the where clause to filter rows by a salary range, selecting values between 95000 and 97000 inclusive.
- Not Operator3:39
Learn how the not operator negates conditions in sql, using it with between, greater-than, and less-than to filter values outside 94000–98000, and apply not with like and null checks.
- Group By Part 13:21
Learn to use the group by statement in ms access to apply aggregate functions in a select query and group by designation to count occurrences.
- Group By Part 27:00
Group by clause to aggregate employees by years with us and by first name, count rows, and interpret unique name-year combos in SQL.
- Group BY Part 35:49
Explore using the group by clause in MS Access, apply aggregate functions like sum to salaries grouped by designation, and understand variable usage in select with group by.
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