• views: 125
• date: 16 May 2023
• posted by: voska89

From SQL query syntax to advanced concepts: indexes, query optimization, normal forms, SQL Injections. Interview prep.
Free Download 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
Homepage

https://www.udemy.com/course/sql-full-course-in-1-hour-from-basics-to-advanced-topics/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.