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: Sigha
    SQL Fundamentals for beginners

    SQL Fundamentals for beginners
    .MP4 | Video: 1280x720, 30 fps(r) | Audio: AAC, 48000 Hz, 2ch | 2.15 GB
    Duration: 6 hours | Genre: eLearning Video | Language: English

    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 System

    Connecting to PostgreSQL Default Database

    Load sample database

    Creating database and tables

    Using constraints

    Retrieving data from database table

    Updating data inside a table

    Deleting data inside a database table

    Filtering data returned from a database table

    Sorting data returned from a database table

    Retrieving data using various operators

    Combining data from multiple tables

    Using aggregate functions to manipulate data.

    Using subqueries

    Who this course is for:

    Beginners to SQL
    Beginners to database

    SQL Fundamentals for beginners