Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Sql Fundamentals For Beginners

    Posted By: ELK1nG
    Sql Fundamentals For Beginners

    Sql Fundamentals For Beginners
    Last updated 6/2021
    MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
    Language: English | Size: 2.15 GB | Duration: 6h 11m

    Learn to interact with databases using SQL

    What you'll learn
    Installing PostgreSQL relational database management system
    Connecting to a database
    Loading a sample database
    Creating database and table
    Using constraints to ensure data intergrity
    Using SQL SELECT Statement to retrieve data
    Using SQL CREATE Statement to create a table
    Using SQL UPDATE Statement to modify data
    Using SQL DELETE to remove data
    Using SQL DISTINCT to filter duplicate data
    Filter data using SQL WHERE Clause
    Sort data using SQL ORDER BY
    Manipulating data with various operators
    Retrieve and combine data from multiple tables
    Manipulating data using Aggregate Functions
    Requirements
    Basic knowledge of using a computer
    Basic knowledge of using the internet
    Description
    Almost all applications you interact with on a daily basis involves data which are stored in databases . Applications such as Facebook, Instagram, Whatsapp, Twitter, Hospitals ,Banks etc all interacts with data stored in databases.SQL is the language used to interact with the data inside these databases. SQL skills are always in demand due to the ever increasing use and reliance of data.In this  beginners course, you will learn the building blocks of SQL by interacting with a PostgreSQL database. From creating a brand new table, up through organizing and aggregating data across multiple tables, you will learn the fundamental skills of SQL — and you’ll be prepared to apply them right away.Topics include:Installing PostgreSQL Relational Database SystemConnecting to PostgreSQL Default DatabaseLoad sample databaseCreating database and tablesUsing constraintsRetrieving data from database tableUpdating data inside a tableDeleting data inside a database tableFiltering data returned from  a database tableSorting data returned from a database tableRetrieving data using various operatorsCombining data from multiple tablesUsing aggregate functions to manipulate data.Using subqueries

    Overview

    Section 1: Introduction and Database Setup

    Lecture 1 Introduction

    Lecture 2 What is SQL

    Lecture 3 Basic Database Concepts

    Lecture 4 What is PostgreSQL

    Lecture 5 Download and install PostgreSQL for Windows

    Lecture 6 Download and install PostgreSQL for Mac

    Lecture 7 Connecting to a PostgreSQL Database

    Lecture 8 Load sample database

    Lecture 9 Exploring some database objects

    Lecture 10 Using Constraints for data integrity

    Lecture 11 Create database

    Lecture 12 Create a table with PgAdmin

    Lecture 13 Schema

    Section 2: C R U D Operations

    Lecture 14 Introduction

    Lecture 15 Create a table with SQL

    Lecture 16 Retrieve all data from Table with SQL SELECT

    Lecture 17 Retrieve specific data from Table with SQL SELECT

    Lecture 18 Modify data in table using SQL UPDATE

    Lecture 19 Remove data from table using SQL DELETE

    Lecture 20 Filtering Data using SQL WHERE Clause

    Lecture 21 Ordering data using SQL ORDER BY Clause

    Lecture 22 Subqueries

    Lecture 23 Removing Duplicate Records

    Lecture 24 Truncating a Table

    Lecture 25 Adding new data to table using SQL INSERT

    Section 3: SQL Operators

    Lecture 26 Comparison Operators

    Lecture 27 BETWEEN Operators

    Lecture 28 NOT BETWEEN Operators

    Lecture 29 LIKE Operators

    Lecture 30 NOT Operators

    Lecture 31 OR Operators

    Lecture 32 AND Operators

    Lecture 33 Combining OR | AND Operators

    Lecture 34 IN Operators

    Lecture 35 UNION OPerators

    Lecture 36 UNION ALL Operators

    Lecture 37 INTERSECT Operators

    Section 4: Combining Data From Multiple Tables

    Lecture 38 Introduction to Table Joins

    Lecture 39 SQL INNER Joins

    Lecture 40 SQL LEFT JOIN

    Lecture 41 SQL OUTER JOIN

    Lecture 42 SQL CROSS JOIN

    Lecture 43 SQL NATURAL JOIN

    Section 5: SQL AGGREGATE FUNCTIONS

    Lecture 44 Introduction to aggregate functions

    Lecture 45 SQL AVG Aggregate Function

    Lecture 46 SQL COUNT Aggregate Function

    Lecture 47 SQL MAX Aggregate Function

    Lecture 48 SQL MIN Aggregate Function

    Lecture 49 SQL SUM Aggregate Function

    Lecture 50 Grouping Data using SQL GROUP BY Clause

    Lecture 51 Splitting Groups using HAVING Clause

    Lecture 52 Thank You

    Beginners to SQL,Beginners to database