SQL Full Course in 1.5 H: From Basics to Advanced Topics
Date: 11 May 2023 | Posted by: mitsumi
SQL Full Course in 1.5 H: From Basics to Advanced Topics
Published 5/2023
Created by Education Hub
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 45 Lectures ( 1h 21m ) | Size: 537 MB
From SQL query syntax to advanced concepts: indexes, query optimization, normal forms, SQL Injections. Interview prep.
What you'll learn
Exploring free tools to work with SQL (e.g., pgAdmin, VS Code, DBeaver, psql)
Deploy a free tier database with Amazon.
Learn basic SQL commands (ORDER BY ASC / DESC, OFFSET / LIMIT, LIKE, iLIKE, UNION (ALL), COALESCE, DATE, NOW(), INTERVAL, AGE)
Connecting Database to Tableau / Power BI and data visualization
Deploy a free tier database with AWS
Aggregate functions (SUM, ROUND, AVG, MAX, MIN, COUNT)
Searching and deleting duplicates, writing double joins, etc.
Joining multiple tables together (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN)
How to use WHERE and HAVING clauses / DO UPDATE / DO NOTHING
Query optimization and increase performance of queries when working with big tables
How to use (CHECK) CONSTRAINTS, VIEWS, STORED PROCEDURES, TRANSACTIONS, WINDOW FUNCTIONS, COMMON TABLE EXPRESSIONS, FULL-TEXT SEARCH, CASE EXPRESSIONS, TRIGGERS
Exploring relations between tables (ONE TO ONE, ONE TO MANY, MANY TO MANY)
writing JOINS (JOINS: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN)
SQL (NON) NORMAL FORMS (first normal form, second normal form and third normal form)
SQL INJECTIONS on practical examples: Rest API web / Authorization application injection with consequences of exploiting such injection
Pass practical tests to be prepared for an interview
Requirements
No programming experience needed
Description
Throughout this course, we will delve into a variety of essential topics to equip you with the necessary skills to work with SQL:Connecting Database to Tableau / Power BI and data visualization;Deploy a free tier database with Amazon;Exploring the free tools to work with SQL (e.g., pgAdmin, VS Code, DBeaver, psql);Learn basic SQL commands (ORDER BY ASC / DESC, OFFSET / LIMIT, LIKE, iLIKE, UNION (ALL), COALESCE, DATE, NOW(), INTERVAL, AGE);Writing subqueries;Aggregate functions (SUM, ROUND, AVG, MAX, MIN, COUNT);Understand when to use WHERE and HAVING clauses / DO UPDATE / DO NOTHING;How to optimize queries and increase performance of queries when working with big tables;How to use (CHECK) CONSTRAINTS, VIEWS, STORED PROCEDURES, TRANSACTIONS, WINDOW FUNCTIONS, COMMON TABLE EXPRESSIONS, FULL-TEXT SEARCH, CASE EXPRESSIONS, TRIGGERS;Exploring relations between tables (ONE TO ONE, ONE TO MANY, MANY TO MANY);Writing JOINS (JOINS: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN);SQL (NON) NORMAL FORMS (first normal form, second normal form and third normal form);SQL INJECTIONS on practical examples: Rest API web / Authorization application injection with consequences of exploiting such injection.Pass practical tests to be prepared for an interview.Throughout the course, you will receive a detailed presentation with all the queries we discuss. This will help you consolidate your learning and provide you with a reference resource you can use later.I'm excited to guide you through this journey of SQL learning, and I hope that by the end of the course, you will feel confident in your ability to use SQL to solve a variety of problems.
Who this course is for
Data analysts, Database administrators, Software developers and anyone interested in SQL
Download link
rapidgator.net:
uploadgig.com:
nitroflare.com:
1dl.net:
See full article