Comprehensive SQL Bootcamp : Beginner to Advanced
- Description
- Curriculum
- FAQ
- Reviews
SQL is a standard language for accessing and manipulating databases.
SQL is one of the most in-demand tech skill used across many industries.
What is SQL?
SQL stands for Structured Query Language
What Can SQL do?
-
SQL lets you access and manipulate databases
-
SQL can execute queries against a database
-
SQL can retrieve data from a database
-
SQL can insert records in a database
-
SQL can update records in a database
-
SQL can delete records from a database
-
SQL can create new databases
-
SQL can create new tables in a database
-
SQL can create stored procedures in a database
-
SQL can create views in a database
-
SQL can filter data returned from a database
-
SQL can sort data returned by a database.
-
SQL can be used to truncate and drop tables.
PostgreSQL is a powerful, open source object-relational database system.
PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.
PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.
What You Will Learn
-
Perform CRUD Operations
-
PostgreSQL Database Objects
-
Database Concepts
-
Creating a database using PostgreSQL GUI
-
Creating tables with PostgreSQL GUI and SQL Commands
-
Inserting Data into tables
-
Query and read data stored inside a table
-
Filter and Sort data from a table
-
Using Sub query to retrieve data
-
Updating existing data stored inside a database
-
Query and eliminate duplicate records
-
Deleting records stored inside database
-
Truncating a database table
-
Dropping a database table
-
Implementing Stored Procedure
-
Joining and querying data from multiple tables
-
Using various aggregate functions and grouping data
-
Using various Operators to query data
-
Creating views
-
Using various Analytic Functions
-
1IntroductionVideo lesson
-
2What is SQLVideo lesson
-
3What is PostgreSQLVideo lesson
-
4Database ConceptsVideo lesson
-
5Installing PostgreSQL on WindowsVideo lesson
-
6Installing PostgreSQL on MacsVideo lesson
-
7Connecting to PostgreSQLVideo lesson
-
8Loading Sample DatabaseVideo lesson
-
9CRUD OperationsVideo lesson
-
26Retrieving all data from a tableVideo lesson
-
27Retrieving data from specific columnsVideo lesson
-
28Retrieving data without duplicatesVideo lesson
-
29Filtering data RetrievedVideo lesson
-
30Sorting data retrievedVideo lesson
-
31Using SubqueriesVideo lesson
-
32Updating DataVideo lesson
-
33Eliminating DuplicatesVideo lesson
-
34Deleting DataVideo lesson
-
35Truncate and Drop TableVideo lesson
-
36Stored ProdeduresVideo lesson
-
43Introduction to Aggregate FunctionsVideo lesson
-
44AVG Aggregate FunctionsVideo lesson
-
45COUNT Aggregate FunctionsVideo lesson
-
46MAX Aggregate FunctionsVideo lesson
-
47MIN Aggregate FunctionsVideo lesson
-
48SUM Aggregate FunctionsVideo lesson
-
49Grouping dataVideo lesson
-
50Having ClauseVideo lesson
-
51Comparison OperatorVideo lesson
-
52Between OperatorVideo lesson
-
53NOT Between OperatorVideo lesson
-
54LIKE OperatorVideo lesson
-
55NOT OperatorVideo lesson
-
56OR OperatorVideo lesson
-
57AND OperatorVideo lesson
-
58Combining AND | OR OperatorsVideo lesson
-
59IN OperatorVideo lesson
-
60UNION OperatorVideo lesson
-
61UNION ALL OperatorVideo lesson
-
62INTERSECT OperatorVideo lesson
-
63EXCEPT OperatorVideo lesson
-
64Introduction to ViewsVideo lesson
-
65Benefits of using ViewsVideo lesson
-
66Creating ViewsVideo lesson
-
67Modifying and deleting viewsVideo lesson
-
68What are Updatable ViewsVideo lesson
-
69Creating Updatable ViewsVideo lesson
-
70Introduction to Materialized ViewsVideo lesson
-
71Creating Materialized ViewsVideo lesson

External Links May Contain Affiliate Links read more