Queries SQL

Queries SQL смотреть последние обновления за сегодня на .

Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners 1/3

1600928
40139
908
00:17:40
11.11.2020

WATCH PART 2 HERE: 🤍 WATCH PART 3 HERE: 🤍 NEW NAVICAT TUTORIAL - 🤍 In this SQL tutorial for beginners, you'll learn how to write basic SQL queries to ask for data from databases in just 15 minutes. To become a business intelligence analyst, you'll need to know this valuable skill! Here I'll teach you what is SQL. What you learn over the course of these videos can be applied to MySQL, PostgreSQL, SQL Server and others. ☕️ WANT TO SAY A QUICK THANK YOU? Why not Buy Me A Coffee? Thanks for your support! 🤍 🔵 LEARNSQL.COM A comprehensive set of 56 hands-on online SQL courses for teams and individuals 🤍 🎓 SKILLSHARE - Get a 30-day free trial of Skillshare Premium! 🤍 ✅ Navicat - Get 5% Off With This Link 🤍 📊 DATA HUBS FOR GOOGLE DATA STUDIO, EXCEL AND MORE: Power My Analytics: 🤍 Windsor.ai - 🤍 🔴 Don't forget to subscribe: 🤍 00:00 Introduction 01:12 Why learn SQL for BI? 02:22 Tutorial start 03:43 SQL SELECT statement 05:07 AS field alias 05:32 WHERE clause 09:54 ORDER BY clause 10:54 INNER JOIN 13:08 Aliasing tables 14:00 GROUP BY clause 15:58 HAVING clause 16:49 Outro 🙏 SUPPORT THE CHANNEL 🙏 Paypal Donations - 🤍 👀 RECOMMENDED WATCHING 👀 - Business Intelligence For Beginners Playlist 🤍 🎓 VITAMIN BI EDUCATION ONLINE COURSES 🎓 LEARN BUSINESS INTELLIGENCE WITH DATA STUDIO 🤍 🛠 TOOLS AND SERVICES I RECOMMEND 🛠 🧰 The tool I use to help me manage my channel, get video ideas, rank videos and more: 🤍?afmc=7ho 📹 Everything I use to make videos and stream: 🤍 📖 ⬇️ FREE EBOOKS TO DOWNLOAD ⬇️ 📖 7 Steps to Landing Your First BI Analyst Job 🤍 7 Top Tips For Better Dashboard Design 🤍 The Skills You Need To Succeed In Business Intelligence 🤍 📖 THE DATA VISUALISATION BIBLE 📖 🤍 🎥 MY YOUTUBE GEAR My Camera - 🤍 Most Used Lens - 🤍 B-Roll Lens - 🤍 Main Tripod - 🤍 Vlogging Tripod - 🤍 Main Key Light - 🤍 Softbox - 🤍 LED Panel Kit - 🤍 Teleprompter - 🤍 Main Microphone - 🤍 Mic Boom Arm - 🤍 Lavelier Microphone - 🤍 C-Stands - 🤍 Computer - 🤍 Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏 ✅ LET'S CONNECT: For business inquiries visit 🤍 Sign up for my mailing list to be the first to hear about new videos and special offers 🤍 Twitter - 🤍learnbi_online Facebook - 🤍learnbionline Get the database here - 🤍 mysql #sqltutorial #sql #learnsql

5 Basic SELECT Statement Queries in SQL

85664
1449
24
00:06:43
04.01.2020

Here are 5 Basic SELECT Statement Queries in SQL so you can begin pulling the information you need out of your database and tables! Query demos: 1) Select ALL from a table: SELECT * FROM table 2) Select certain columns from a table: SELECT column1, column2, column3 FROM table 3) Select all the unique or distinct rows in a column from a table. Another way to think of it is "removing duplicates": SELECT DISTINCT column FROM table 4) Change the displayed name of your columns by adding Aliases: SELECT column1 AS alias1, column2 AS alias 2 FROM table 5) Add arithmetic in your SELECT statement by using mathematical expressions: SELECT quantity*price AS total_price FROM table Get the Northwind Database: 🤍 Support the Channel: 1) Subscribe: 🤍 2) DataCamp: 🤍 3) Udacity: 🤍

Learn how to write SQL Queries(Practice Complex SQL Queries)

1335628
30302
1062
00:49:56
22.08.2021

Learn how to write SQL Queries(Practice Complex SQL Queries) In this video, I will explain the thinking behind writing an SQL query. We shall go through five different complex SQL queries and try to solve it. The intention is to practice complex SQL queries. The idea is to not just write SQL Queries but also to explain you the thinking behind how to choose a particular approach to solve a SQL query and how to choose different SQL functions or concepts to solve a problem. Link to my blog where I have posted all of these SQL Queries: 🤍 In this blog, you will find 9 SQL queries along with all the scripts to create the table, load data into these tables and also the solved SQL Queries. Out of these 9 SQL Queries, In this video, I have only solved 5 of them in order to reduce the video length. Timeline: 00:00 Intro 01:36 Intro about the blog 03:25 SQL Query to fetch duplicate records from a table using window function 09:27 SQL Query to fetch doctors working in same hospital using self join 15:55 SQL Query to fetch users who logged in consecutively 3 or more times 25:10 SQL Query to fetch days when the temperature was very cold for consecutively 3 or more days 36:13 SQL Query to fetch top 2 accounts with maximum patients per month Learning SQL Concepts and practically writing SQL queries are two different things. You may be familiar with the concept such as window function but until and unless you apply these concepts to write SQL queries, you will never truly understand SQL. May of the queries I am going to solve in this video, I will be using window function such as LEAD, LAG, RANK, ROW_NUMBER etc. However, some of the queries are solved using self join, sub queries or inner joins. The idea behind making this video, is to explain the thinking behind solving an SQL question. How to read the question and understand the problem statement and then analyze the existing data so that we can come up with an approach to write a query which can return the required result. These steps are very important in order for us to determine the different SQL concepts or functions to be used to solve the problem. Please comment below your feedback if you liked this kind of video or if you have any doubts on any other queries mentioned in the blog. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

236257
10336
123
00:05:57
16.05.2023

Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: 🤍 Animation tools: Adobe Illustrator and After Effects. Checkout our bestselling System Design Interview books: Volume 1: 🤍 Volume 2: 🤍 The digital version of System Design Interview books: 🤍 ABOUT US: Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.

Advanced SQL Tutorial | Subqueries

277380
6538
188
00:08:37
20.04.2021

Take my Full MySQL Course Here: 🤍 In today's Advanced SQL lesson we walk through how to use Subqueries. Link to Code: 🤍 SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! RESOURCES: Coursera Courses: Google Data Analyst Certification: 🤍 Data Analysis with Python - 🤍 IBM Data Analysis Specialization - 🤍 Tableau Data Visualization - 🤍 Udemy Courses: Python for Data Analysis and Visualization- 🤍 Statistics for Data Science - 🤍 SQL for Data Analysts (SSMS) - 🤍 Tableau A-Z - 🤍 *Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* SUPPORT MY CHANNEL - PATREON/MERCH Patreon Page - 🤍 Alex The Analyst Shop - 🤍 Websites: GitHub: 🤍 *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

SQL Tutorial for Beginners

1442123
28076
1047
00:44:57
22.03.2022

In this step-by-step tutorial, learn how you can write your own SQL queries. You don't need any prior knowledge and we're going to use all free tools. By the end of this video, you'll know how to retrieve data from databases. At the end, I'll show you a neat trick to write some of the most complex queries with very little effort. SQL stands for structured query language. It's a language that you can use to talk to your database. You can also use it to retrieve, filter, sort, combine, add, update, and delete data in a database. It's basically a language you can use to interact with the database. The great thing is that anyone can learn how to write SQL queries. You definitely don't need a degree in computer science. And once you know it, you'll have another superpower that you can use at work. 👋 Additional resources - Download & install Microsoft SQL Server: 🤍 - Download & install SQL Server Management Studio (SSMS): 🤍 - Sample database to follow along: 🤍 - Sample data in Excel format including flat file and tables: 🤍 - SQL Functions: 🤍 ⌚ Timestamps 0:00 Introduction 0:37 Why learn SQL? 1:49 What is SQL? 2:25 What is a database? 3:09 Relational database management systems 4:11 Install Microsoft SQL Server 6:51 Install SQL Server Management Studio 7:26 Connect to server 8:13 Object Explorer 9:26 Restore sample database 10:42 Tables 14:33 Primary keys 15:57 Database diagrams 17:57 Data types 18:30 Select 24:50 Filtering with where 32:02 Inner join & outer join 38:21 Order by 39:01 Functions including getdate, sum, count 41:02 Group by 41:20 Bonus: Query designer 44:09 Wrap up 📃 Watch related playlists - Playlist with all my videos on SQL: 🤍 🚩 Connect with me on social - LinkedIn: 🤍 - Discord: 🤍 - Twitter: 🤍 - Facebook: 🤍 - TikTok: 🤍 - Instagram: 🤍 🙏 Request How To Tutorial Videos 🤍 🔔 Subscribe to my YouTube channel 🤍 🎬 Want to watch again? Navigate back to my YouTube channel quickly 🤍 🛍 Support me with your Amazon purchases: 🤍 ⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel the price to you is the same. #stratvert

SQL Tutorial - Full Database Course for Beginners

16866043
320868
10763
04:20:39
02.07.2018

In this course, we'll be looking at database management basics and SQL using the MySQL RDBMS. Want more from Mike? He's starting a coding RPG/Bootcamp - 🤍 The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we'll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. You can get PopSQL to follow along here: 🤍 🔗Company Database Code: 🤍 ⭐️ Contents ⭐ ⌨️ (0:00) Introduction ⌨️ (2:36) What is a Database? ⌨️ (23:10) Tables & Keys ⌨️ (43:31) SQL Basics ⌨️ (52:26) MySQL Windows Installation ⌨️ (1:01:59) MySQL Mac Installation ⌨️ (1:15:49) Creating Tables ⌨️ (1:31:05) Inserting Data ⌨️ (1:38:17) Constraints ⌨️ (1:48:11) Update & Delete ⌨️ (1:56:11) Basic Queries ⌨️ (2:08:37) Company Database Intro ⌨️ (2:14:05) Creating Company Database ⌨️ (2:30:27 ) More Basic Queries ⌨️ (2:26:24) Functions ⌨️ (2:45:13) Wildcards ⌨️ (2:53:53) Union ⌨️ (3:01:36) Joins ⌨️ (3:11:49) Nested Queries ⌨️ (3:21:52) On Delete ⌨️ (3:30:05) Triggers ⌨️ (3:42:12) ER Diagrams Intro ⌨️ (3:55:53) Designing an ER Diagram ⌨️ (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: 🤍 🐦Follow Mike on Twitter: 🤍 🔗The Giraffe Academy website: 🤍 Learn to code for free and get a developer job: 🤍 Read hundreds of articles on programming: 🤍

Approach to Complex SQL Queries

116064
1983
0
00:08:33
28.09.2020

How to approach more complicated SELECT statements in Structured Query Language.

SQL Querying for Beginners Tutorial

201198
3391
194
02:45:17
07.01.2022

SQL Querying for Beginners Tutorial Get Ad-Free Training by becoming a member today! 🤍 Exercise Files: 🤍 SQL Express Download Link: 🤍 Northwindsql Link: 🤍 Northwind Alternate: 🤍 If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute. Who it's for: This course has been designed for individuals who wish to learn how to use SQL to query databases and extract information. What it is: SQL stands for Structured Query Language. It’s a common language for gathering, organizing, and exporting data stored in relational databases. What you'll learn: In this course, you’ll learn basic SQL usage and terminology, as well as how to execute simple queries and queries using criteria conditions. Next, you’ll learn how to summarize, organize, and export valuable query data and results. Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: 🤍 Exercise Files: 🤍 SQL Express Download Link: 🤍 Northwindsql Download Link: 🤍 If you are having issues with the Northwind DB pleases delete lines 24 and 25 and execute. For Private Group Trainings please visit: 🤍 Manuals: 🤍 Username: manuals Password: password Start 0:00 Introduction 0:03 Introduction to SQL 0:30 Installing SQL Server 4:27 SQL Keyword Command Language and Hierarchy 8:26 Connecting to a SQL Database 13:35 Creating and Saving a Query 22:44 Using One or More Query Conditions 32:43 Applying AND OR Operators 40:36 NULL NOT NULL 46:48 Range of Values 49:28 Querying Data Using Wildcard Characters 58:04 Formatting Column Headings with Aliases 1:04:48 Formatting Query Data Results 1:10:06 Performing Date Calculations - DateDifDateAdd 1:14:10 Summarizing Data Using Aggregate Functions AVG COUNT SUM min max 1:22:39 Manipulating Text Results with String Functions CONCAT_SUBSTR 1:30:26 Sorting Data Order BY and GROUPBY 1:38:07 RANK and HAVING 1:46:24 Mathematical Financial Expressions 1:52:23 PIVOT 1:58:24 JOIN 2:07:27 Union ALL 2:20:30 Except Clause 2:26:30 Sub Queries 2:28:25 Exports 2:40:41 Conclusion 2:44:04 #SQL #Query (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.

Learn SQL for Data Analysis in one hour (with sample dataset + 50 queries)

797863
27689
694
00:58:22
23.08.2022

SQL is one of the most important skills to have for data people. In this comprehensive video, learn how to use SQL to perform common data analysis tasks. You will learn: ◈ How to use SELECT statement to answer business questions ◈ Working with WHERE clause ◈ Using AND, OR, NOT and combining them to create complex queries. ◈ Sorting query results using ORDER BY ◈ Combining data from two or more tables using JOINS ◈ Creating reports with GROUP BY ◈ More than 50 example queries, tips and ideas 🚨 PRE-REQUISITES: You need any SQL console (I am using the FREE MySQL Community Edition and you can download it from 🤍 ) You also need the Awesome Chocolates Dataset. See 🤍 for the sample files, instructions on data import and other SQL resources for you. 😃 Basic intro: If you want a simple introduction to SQL (for an interview or to brush up), see this video instead - 🤍 ⏱ IN THE VIDEO: 0:00 - Introduction 0:43 - Data setup, explanation & basic queries 6:24 - Adding calculated columns in SELECT 8:39 - Our first WHERE clause 10:28 - Ordering query results with ORDER BY 13:24 - More Where clause examples 16:42 - Between conditions 19:06 - Working with Dates 21:50 - Using other tables 23:47 - IN clause 24:36 - Pattern matching in SQL 26:30 - CASE operator and branching logic 30:30 - JOINS 36:32 - LEFT Join vs. RIGHT Join ~ EXPLAINED 38:28 - More Join examples 42:10 - Adding conditions to Joins 47:30 - GROUP BY and creating reports with SQL 54:50 - Showing Top 10 Products by Amount 57:12 - Closing remarks & next steps for you 📚 RESOURCES TO LEARN MORE SQL: 1) Practice the problems and scenarios discussed in the video with the awesome chocolates dataset. 2) Solve homework problems listed here - 🤍 3) Get one or two SQL books. My recommendations are here - 🤍 4) Consider going for an SQL course. Check the same page for my course suggestions. 5) PRACTICE, PRACTICE, PRACTICE! 🙄SQL ALTERNATIVES: If you don't want to learn SQL but still wish to work with data, then consider learning POWER QUERY, which offers similar capabilities as SQL. See this video 👉🤍 😎WATCH NEXT: Now that you know a bit of SQL, why not use it with Power BI to do visual data analysis? If you are new to Power BI, see my Power BI video to get started with that. 👇 🤍 ~ 😍FOLLLOW ME Apart from YouTube, I regularly share content on below places. Feel free to check them out and give a follow. 💻 WEBSITE - 🤍 📃 WEEKLY DATA TIPS NEWSLETTER - 🤍 📷 INSTAGRAM - 🤍 🐤 TWITTER - 🤍 ~ Select "good day" from days where person = "you" 😃 #sql #tutorial

Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorial

784160
18004
1052
01:10:44
01.02.2022

Visit 🤍 to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription. This is the SQL Subquery Tutorial video which gives you a complete understanding of subqueries in SQL. We start with explaining what a subquery is and then writing a sample SQL query containing a subquery and then explaining how SQL processes a query statement containing a subquery. In this video we shall also look at the different types of subquery in SQL by writing SQL queries which uses these different types of subqueries. We shall look at single row subquery, multiple row sub query, single column subquery, multiple column subquery and also the correlated subqueries. This video will also explain about the different Clauses in SQL query where it is allowed to have a subquery and we shall look at example queries to explain these differences. Finally, we will look at the SQL commands like INSERT, UPDATE and DELETE where it is allowed to use subqueries. Hopefully, this videos gives you a complete understanding of what subqueries are, how to use them and where to use them. My recommended SQL Course: 🤍 [All the scripts and SQL queries used in this video is shared in my Discord server. You can join my discord by clicking on the below link. It's FREE] Join my Discord Server: 🤍 FTC disclaimer: This video was sponsored by Brilliant. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 THANK YOU, Thoufiq

SQL Basics Tutorial for Beginners (Practice SQL Queries)

954374
20656
632
01:10:21
11.12.2020

SQL Basics Tutorial for Beginners is made to help you learn SQL the right way. Video also includes Practice SQL Queries which can be downloaded from my blog (link mentioned below). This is a complete SQL Tutorial covering all the SQL Basics including how to write simple SQL Queries. This Basic SQL Tutorial is aimed at beginners who are new to SQL programming language or are just exploring an easy programming language to get started. This SQL Tutorial for Beginners not only explains the concept of SQL but also go through all the different types of queries that can be written using the basic SQL concepts. Timestamps: 00:00 Intro 01:42 What is SQL 03:14 Different types of SQL Commands 03:36 What is Data Definition Language (DDL) 04:46 What is Data Type in SQL 06:11 What are Constraints in SQL 08:33 What is Data Manipulation Language (DML) 09:40 Practice SQL Commands (DDL, DML) 21:10 What is Data Query Language (DQL) 23:13 Practice simple SQL Queries 25:18 Operators in SQL (Comparison Operators, Arithmetic Operators, Logical Operators) 34:48 Case Statement in SQL 36:15 Different ways to write queries in SQL 42:30 UNION and UNION ALL Operators in SQL 47:18 GROUP BY Statement in SQL 56:10 Sub Queries in SQL 58:55 Aggregate Functions in SQL (AVG, MIN, MAX, COUNT, SUM) 01:01:56 SQL Joins (Inner Join, Left Join, Right Join, Full Outer Join) At 70 minutes this video tries to cover all of the Basic SQL concepts and SQL Queries which are required to get started with SQL. We cover the following: 1. Introduction to SQL • Why is it important to learn SQL. 2. What is SQL? 3. SQL Commands • DDL (Data Definition Language) i. CREATE Table ii. ALTER Table iii. DROP Table iv. TRUNCATE Table • DML (Data Manipulation Language) i. INSERT ii. UPDATE iii. DELETE • DCL (Data Control Language) i. GRANT ii. REVOKE • TCL (Transaction Control Language) i. COMMIT ii. ROLLBACK iii. SAVEPOINT • DQL (Data Query Language) i. SELECT 4. Different SELECT Query functionalities: • SQL Operators i. Logical Operators ii. Comparison Operators iii. Arithmetic Operators • CASE Statement • Two ways of writing SQL Queries i. Using comma separator ii. Using JOIN • UNION & UNION ALL Operators • GROUP BY Statement i. HAVING Clause • Subquery • Aggregate Functions i. COUNT ii. AVG iii. MIN iv. MAX v. SUM • SQL JOINS i. INNER JOIN ii. OUTER JOIN 1. LEFT OUTER JOIN 2. RIGHT OUTER JOIN 3. FULL OUTER JOIN In this video, I am using PostgreSQL to practice and execute the SQL commands and SQL Queries. However the SQL syntax and SQL concepts are applicable to any other Relational Database or RDBMS (Relational Database Management System). Download Link: Download the SQL Scripts (DDL, DML and all SELECT Queries) from here: 🤍 From this link click on: 1) “Download DDL & DML” button to download a “.sql” file which has all the Create table and Insert Table scripts to create required tables and to insert meaningful data into it. 2) “Download SELECT Queries” button to download another “.sql” file which contains all the SELECT Queries which we practiced in this video. My Blog: 🤍 Where you can find useful blog related to SQL, Database and many more in near future. Reference Links: If you wish to know more about SQL then I suggest going through the below links: PostgreSQL All supported Data Types: 🤍 PostgreSQL Tutorial blog: 🤍 SQL Tutorial blog: 🤍 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍

SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

1068420
24189
351
00:05:02
30.09.2019

In this video, we’ll solve sql queries for practice. Important SQL interview queries. ✨Work related mails can be sent on: work.sadiasiddiqui🤍gmail.com ✨If you appreciate my work and would like to donate to support our channel, you can do so here: 🤍

Learn SQL In 60 Minutes

1920964
48025
973
00:56:24
17.11.2018

In this video we will cover everything you need to know about SQL in only 60 minutes. We will cover what SQL is, why SQL is important, what SQL is used for, the syntax of SQL, and multiple examples of SQL. SQL is the standard language for interacting with and manipulating data in a relational database system, and is one of the most important concepts you can learn in programming. It allows you to create, read, update, and delete data which is something nearly every application will need to do. IMPORTANT: Exercises Worksheet Repository: 🤍 How to Install MySQL: 🤍 Outline: [00:00] - Intro [05:10] - SQL Syntax [07:30] - Create Database [09:20] - Drop Database [10:34] - Use Database [11:22] - Create Table [13:01] - Alter Table [14:47] - Drop Table [15:08] - Create Table (Part 2) [15:35] - Band Table [15:55] - Not Null [16:10] - Primary Key/ID/Auto Increment [18:40] - Album Table [20:05] - Foreign Key/Table Relationships [23:05] - Insert Into [25:40] - Select [26:27] - Limit [26:52] - Specific Columns [27:18] - As/Alias Columns [28:20] - Order By [29:24] - Insert Into (Part 2) [32:04] - Distinct Select [33:07] - Update [33:40] - Where [33:15] - Less Than [33:55] - Like String Filter [37:26] - Or [38:04] - And [38:40] - Between [39:20] - Is Null [39:46] - Delete [41:00] - Join [43:25] - Inner/Left/Right Comparison [46:42] - Aggregate Functions [48:05] - Group By [50:40] - Combined With Join [51:15] - Alias Tables [53:57] - Having vs Where Learn X in Y Minutes Playlist: 🤍 Twitter: 🤍 GitHub: 🤍 CodePen: 🤍 #SQL #LearnSQL #MySQL

SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1

674784
16070
989
00:35:23
06.01.2022

This is the SQL JOINS Tutorial for complete beginners. In this video we shall cover INNER Join, LEFT Join and RIGHT Join. I’ll be posting the second part of this video next week where we shall cover FULL OUTER Join, SELF Join, CROSS Join and NATURAL Join. Before we talk about different types of Joins in SQL, we shall first understand what are JOINS and why do we need them and then finally write some SQL queries to understand how to use them. We shall practice writing SQL queries using inner, left and right joins in this video. Joins are the most fundamental concepts in SQL and having a clear understanding of Joins is very essential to write good SQL queries. Timeline: 00:00 Intro 02:36 What are JOINS in SQL 05:30 Inner Joins in SQL 13:55 Left Join in SQL 19:59 Right Join in SQL My recommended SQL Course: 🤍 Join my Discord Server: 🤍 Join my FREE live SQL training session: Batch 1 - Started on 03-Jan-2022 (08:00 pm Malaysian Time / 05:30 pm Indian Time) Day: Monday, Tuesday, Thursday, Friday Registration Link: 🤍 Batch 2 - Starts on 17-Jan-2022 (09:30 pm Malaysian Time / 07:00 pm Indian Time) Day: Monday, Tuesday, Thursday, Friday Registration Link: 🤍 Note: Both batch 1 and batch 2 will cover the exact same topics. Just the date and time are different based on the convenience of everyone. How to Join the sessions: 1) Go to 🤍 2) Click the subject "Data Science" 3) Find my session and click on it. The sessions will automatically start 4 mins prior to the scheduled time. Please do subscribe and like this video if you found it useful. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 THANK YOU, Thoufiq

MySQL Tutorial for Beginners [Full Course]

10452421
228359
8945
03:10:19
20.03.2019

MySQL tutorial for beginners - Learn MySQL, the world's most popular open source database. 🔥 Want to master MySQL? Get the full MySQL course: 🤍 👍 Subscribe for more SQL tutorials like this: 🤍 ⭐️Want to learn more from me? Check out these links: Courses: 🤍 Twitter: 🤍 Facebook: 🤍 Blog: 🤍 📕Get my FREE SQL cheat sheet: 🤍 📔Scripts to create the databases in this course: 🤍 TABLE OF CONTENT 0:00:00 Introduction 0:01:02 What is SQL? 0:04:24 Cheat Sheet 0:04:50 Installing MySQL on Mac 0:09:48 Installing MySQL on Windows 0:15:08 Creating the Databases for this Course 0:23:40 The SELECT Statement 0:29:30 The SELECT Clause 0:38:18 The WHERE Clause 0:43:35 The AND, OR, and NOT Operators 0:51:38 The IN Operator 0:54:41 The BETWEEN Operator 0:56:53 The LIKE Operator 1:02:31 The REGEXP Operator 1:11:51 The IS NULL Operator 1:14:18 The ORDER BY Operator 1:21:23 The LIMIT Operator 1:24:50 Inner Joins 1:33:16 Joining Across Databases 1:36:03 Self Joins 1:40:17 Joining Multiple Tables 1:47:03 Compound Join Conditions 1:50:44 Implicit Join Syntax 1:53:04 Outer Joins 1:59:31 Outer Join Between Multiple Tables 2:05:50 Self Outer Joins 2:08:02 The USING Clause 2:13:25 Natural Joins 2:14:46 Cross Joins 2:18:01 Unions 2:26:29 Column Attributes 2:29:54 Inserting a Single Row 2:35:40 Inserting Multiple Rows 2:38:58 Inserting Hierarchical Rows 2:44:51 Creating a Copy of a Table 2:53:38 Updating a Single Row 2:57:33 Updating Multiple Rows 3:00:47 Using Subqueries in Updates 3:06:24 Deleting Rows 3:07:48 Restoring Course Databases If you're looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries in no time. SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information. There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we'll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you'll learn in this course can be transferred to other database management systems.

MySQL - The Basics // Learn SQL in 23 Easy Steps

627862
24950
1410
00:17:17
16.04.2021

JOIN me for a full beginner’s tutorial on MySQL. Learn the basics of relational databases by recreating AirBnb’s database with raw SQL 🤍 Buy the MySQL Pillow 🤍 References Diagram 🤍 Installer 🤍 MySQL Docs 🤍 #mysql #database #tutorial 00:00 0. SQL is King 00:49 1. The Legend of Ted Codd 01:24 2. ORM Magic 02:00 3. What is a RDBMS? 02:37 4. Draw SQL Diagrams 02:56 5. Schemas, Datatypes, & Constraints 04:12 6. Be Normalized 05:00 7. Install MySQL on Windows/Mac 05:50 8. Create a New Database 06:13 9. SQLTools VS Code Extension 06:46 10. comments 07:02 11. Basic SQL Syntax 08:04 12. Primary Key 08:31 13. Varchar vs Text 09:31 14. INSERT New Data 10:28 15. Read or SELECT Data 10:57 16. LIMIT & ORDER 11:23 17. Filtering with WHERE 11:50 18. LIKE pattern matching 12:19 19. INDEX for read speed 12:56 20. JOIN a relationship 15:41 21. Alias AS 16:08 22. JOIN through a middle man 16:58 23. DROP a video Install the quiz app 🤓 iOS 🤍 Android 🤍 Upgrade to Fireship PRO at 🤍 Use code lORhwXd2 for 25% off your first payment. My VS Code Theme - Atom One Dark - vscode-icons - Fira Code Font

SQL Tutorial for Beginners (and Technical Interview Questions Solved)

196140
5638
120
05:25:39
09.05.2023

Welcome to this comprehensive SQL tutorial course. This course covers the basics of relational databases and SQL, including setting up MySQL, inserting data, and working with aggregation, grouping, and pagination in SQL queries. It also covers advanced topics such as combining tables using joins, executing SQL queries using Python and SQL Alchemy, and solving technical interview questions. By the end of this course, you'll have the knowledge and confidence to excel in SQL. ✏️ Course created by🤍jovianhq Important Links 🔗 Relational Databases notebook - 🤍 🔗 Advanced SQL Aggregation & Joins notebook - 🤍 🔗 SQL data file: 🤍 A database is an organized collection of structured information, typically stored in the form of tables (rows & columns). Relational databases allow storing and retrieving different kinds of related information e.g. products, customers, and orders for an online shopping site. Structured Query Language or SQL (pronounced "sequel") is the most widely used language for interacting with relational databases, and is an essential skill for Data Science professionals. ⭐️ Contents ⭐️ ⌨️ (0:00:00) Introduction ⌨️ (0:01:28) Relational Databases & SQL ⌨️ (0:03:05) Setting up MySQL ⌨️ (0:29:23) Inserting Data into the Table ⌨️ (0:56:32) Practice Exercises ⌨️ (1:22:12) Aggregation, grouping & pagination in SQL queries ⌨️ (2:23:17) Mapping and Arithmetic Functions ⌨️ (2:54:53) Working with Dates ⌨️ (3:12:16) Combining Tables using Joins ⌨️ (3:30:14) Executing SQL queries using Python and SQL Alchemy ⌨️ (4:11:06) 3 step approach to Interview Questions ⌨️ (4:36:58) Interview Q - Apple ⌨️ (4:38:59) Interview Q - Linkedin ⌨️ (4:43:09) Interview Q - Meta ⌨️ (4:50:41) Interview Q - Uber ⌨️ (4:59:18) Interview Q - Amazon ⌨️ (5:07:27) Interview Q - Google 🎉 Thanks to our Champion and Sponsor supporters: 👾 davthecoder 👾 jedi-or-sith 👾 南宮千影 👾 Agustín Kussrow 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Justin Hual 👾 Otis Morgan Learn to code for free and get a developer job: 🤍 Read hundreds of articles on programming: 🤍

Raw SQL, SQL Query Builder, or ORM?

75872
3862
319
00:16:19
31.03.2023

Not sure if you should use Raw SQL, a SQL query builder, or an ORM for your next project? In this video, I’ll explore the pros and cons of each option, allowing you to make an informed decision based on your specific needs. Choosing the wrong technology for your project can be a costly mistake, so it's crucial to understand these tools. Code example on GitHub: 🤍 ✍🏻 Take a quiz on this topic: 🤍 🚀 Next-Level Python Skillshare Class: 🤍 👷 Join the FREE Code Diagnosis Workshop to help you review code more effectively using my 3-Factor Diagnosis Framework: 🤍 🎓 Courses: The Software Designer Mindset: 🤍 The Software Designer Mindset Team Packages: 🤍 The Software Architect Mindset: Pre-register now! 🤍 Next Level Python: Become a Python Expert: 🤍 The 30-Day Design Challenge: 🤍 🛒 GEAR & RECOMMENDED BOOKS: 🤍 If you enjoyed this content, give this video a like. If you want to watch more of my upcoming videos, consider subscribing to my channel! 💬 Discord: 🤍 🐦Twitter: 🤍 🌍LinkedIn: 🤍 🕵Facebook: 🤍 📱Instagram: 🤍 ♪ Tiktok: 🤍 👀 Code reviewers: - Yoriz - Ryan Laursen - James Dooley - Dale Hagglund 🎥 Video edited by Mark Bacskai: 🤍 💻 Code example by Henrique Branco: 🤍 🔖 Chapters: 0:00 Intro 1:18 Code example 2:09 Main options 2:44 raw SQL 7:12 ORM 12:49 SQL query builder 14:30 Final thoughts 16:01 Outro #arjancodes #softwaredesign #python DISCLAIMER - The links in this description might be affiliate links. If you purchase a product or service through one of those links, I may receive a small commission. There is no additional charge to you. Thanks for supporting my channel so I can continue to provide you with free content each week!

Practice SQL Interview Query | Big 4 Interview Question

95498
3427
180
00:14:47
12.09.2022

The first 1,000 people to use the link will get a 1 month free trial of Skillshare: 🤍 In this video, I will be solving a REAL SQL Interview Questions asked during an interview by one of the BIG 4 Accounting firms (PwC, EY, KPMG, Deloitte). This is a very common question asked during SQL Interviews hence we shall look at the approach and the thinking you need to have when solving these kind of SQL problems. All the dataset, scripts and SQL queries used in this video can be downloaded for free from my website. Link below: 🤍 Timestamp: 00:00 Intro 00:28 Understanding the problem statement 02:21 Approach to solve similar SQL Problem 06:05 Free Skillshare promo link 07:41 Solution to SQL Problem FTC disclaimer: This video was sponsored by Skillshare. 🔴 My Recommended courses 👇 ✅ FREE SQL Practice course (valid only until 30-Sep-2022): 🤍 ✅ Learn complete SQL: 🤍 ✅ Practice SQL Queries: 🤍 ✅ Learn Python: 🤍 ✅ Learn Power BI: 🤍 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

Solving SQL Interview Query for Data Analyst asked by a Product based company

472159
10579
317
00:18:37
07.12.2022

In this video let's solve a real SQL Interview query asked for Data Analyst position by a Product Based company. Download the dataset and scripts from below: 🤍 🔴 My Recommended courses 👇 ✅ Learn complete SQL: 🤍 ✅ Practice SQL Queries: 🤍 ✅ Learn Python: 🤍 ✅ Learn Power BI: 🤍 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

Lecture 10: Common SQL Queries for Interviews

239735
3799
334
01:17:47
13.08.2022

This Video gives a complete understanding of Common SQL questions asked in Interviews. There is a lot to learn, Keep in mind “ Mnn bhot karega k chor yrr apne se nahi hoga ya maza nahi aara, Just ask 1 question “ Why I started ? “ Notes/Slides/DB Link: 🤍 Discord Server Link: 🤍 Do provide you feedback in the comments, we are going to make it best collectively. Connect with me here: Instagram: 🤍 Twitter: 🤍 Telegram Group Link: Love Babbar CODE HELP 🤍 Connect with Lakshay: Instagram: 🤍 LinkedIn: 🤍 My Editor: 🤍 Intro Sequence: We have bought all the required Licenses of the Audio, Video & Animation used. #DBMSBusted #LoveBabbar #Lakshay

Recursive SQL Queries Tutorial | Learn to write SQL Queries using Recursion

148988
3838
266
00:33:52
23.03.2022

Visit 🤍 to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription. All the scripts and dataset used in this video can be downloaded for free from my discord. Link to join my discord below: Discord link: 🤍 In this video, let's learn how to write Recursive SQL Queries. Learn to write SQL Queries using Recursion by solving different SQL queries. This video will explain the syntax to be followed to write recursive sql queries and we shall look at the difference in syntax in PostgreSQL, Oracle, MySQL and MSSQL. I will also explain the process SQL follows to execute recursive sql query. Then we shall solve 3 different SQL queries using recursion. I will execute the queries in all the major RDBMS such as PostgreSQL, Oracle, MySQL and Microsoft SQL Server. My recommended platform to practice SQL queries: 🤍 My recommended platform for SQL Course: 🤍 Consider SUBSCRIBING to my channel if you wish to learn SQL, Python and Data Analytics concepts. FTC disclaimer: This video was sponsored by Brilliant. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 THANK YOU, Thoufiq

SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression)

431500
10546
597
00:24:48
05.09.2021

SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression) In this video, we shall understand how to write SQL Queries using WITH Clause. We will go through the syntax of using WITH Clause and I will also explain how SQL treats and executes SQL Queries containing With Clause. SQL WITH Clause is also referred to as CTE which stands for Common Table Expression and can also be referred to as Subquery Refactoring. This video will also provide what are the advantages of using With Clause while writing SQL Queries and also mention few scenarios when you should be using With Clause while writing SQL Queries. Download all the scripts and SQL Queries used in this video from my blog. Link below: 🤍 Timeline: 00:00 Intro 00:34 Query 1: Simple example of writing SQL Query using With clause 06:25 Query 2: Ideal Scenario for writing SQL Query using With clause 20:29 Advantages of using WITH Clause in SQL 22:19 When to use With Clause in SQL If you are new to SQL then you might have assumed that SQL Queries must always start with SELECT clause but that's not true because we can also start SQL Queries using WITH Clause. Understanding With clause can really help you to solve some of the tricky problems in SQL. In this video, we shall first see a simple example of using with clause within SQL query. The query no 2 explained in this video will be most suitable scenario for using WITH clause in SQL Query. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

Solving SQL Interview Queries | Tricky SQL Interview Queries

227040
5750
430
00:37:22
16.03.2022

In this video, I will explain and solve 3 tricky SQL Interview Queries. These are the SQL Queries which can be expected during SQL Interviews for both beginners and experience level interviews. Many times, SQL Queries given during SQL Interviews are more tricky than complex. The solution to the SQL question may be simple but understanding the question and dataset and analyzing the data will play the most important role when solving such SQL queries. Hence mentioning the tricky SQL queries which you may expect during SQL interviews. My email id: techtfq🤍gmail.com All the Dataset, SQL scripts and queries written in this video can be found in my blog. Link to my blog: 🤍 My recommended platform to practice SQL queries: 🤍 My recommended platform for SQL Course: 🤍 Consider SUBSCRIBING to my channel if you wish to learn SQL, Python and Data Analytics concepts. 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 THANK YOU, Thoufiq

Nested Queries | SQL | Tutorial 18

156927
3743
143
00:10:23
22.12.2017

🦒❤️ 🤍

Top 9 SQL queries for interview | SQL Tutorial | Interview Question

558264
14048
370
00:11:43
04.08.2020

#mysql #oracle #dbms #query #top #sqlserver #database In this video we will see #Top 9 #SQL query Which are very important for the #PlacementPreparation 👉The TOP 9 SQL query are- ✅Find the third-highest salary from the EmployeeInfo table. ✅Find the Nth highest salary from the table without using TOP/limit keyword. ✅Find duplicate rows in a table. ✅Calculate the even and odd records from a table. ✅Display the first and the last record from the EmployeeInfo table. ✅How do you copy all rows of a table using SQL query? ✅Retrieve the list of employees working in the same department. ✅Retrieve the last 3 records from the EmployeeInfo table. ✅Fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains five alphabets. ⭐Part 2:Top 9 SQL queries for interview - 🤍 Please like 👍, subscribe and share...... Follow us on Instagram - 🤍 🙏Thank you so much for watching and your support.. ⭐Encapsulation in java- 🤍 ⭐DBMS vs RDMS 🤍 ⭐Keys in DBMS 🤍 ⭐Normalization in DBMS- 🤍 ⭐class and object in java- 🤍 ⭐Types of key in DBMS- 🤍 ⭐how to install java- 🤍 ⭐Introduction of java:- 🤍 ⭐Features of java:- 🤍 ⭐JVM JRE JDK:- 🤍 ⭐MySQL Database - 🤍 ⭐JVM architecture- 🤍 ⭐Difference between oop and pop 🤍

Solving SQL Interview Query using a "VERY IMPORTANT SQL concept"

101790
2472
183
00:09:38
19.09.2022

In this video, we look at another SQL interview query. We shall solve this problem using "VERY IMPORTANT SQL concept". The problem statement might seem complex but the solution is pretty simple. I will explain how the problem can be solved, the logic and thinking behind solving such SQL problems during interviews. Download the dataset and SQL queries used in this video for free from my blog. Link below: 🤍 Timestamp: 00:00 Intro 00:29 Understanding the problem statement 01:53 Coming up with the logic to solve the problem 06:34 Solution to SQL Problem 🔴 My Recommended courses 👇 ✅ FREE SQL Practice course (valid only until 30-Sep-2022): 🤍 ✅ Learn complete SQL: 🤍 ✅ Practice SQL Queries: 🤍 ✅ Learn Python: 🤍 ✅ Learn Power BI: 🤍 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka

2216666
40074
408
00:27:51
04.10.2019

🔥 Edureka SQL Course Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): 🤍 This Edureka video on 'SQL Basics for Beginners' will help you understand the basics of SQL and also sql queries which are very popular and essential.. In this SQL Tutorial for Beginners you will learn SQL from scratch with examples. Following topics have been covered in this SQL tutorial: 0:57 Introduction to SQL 3:48 Data and Database 6:25 How to Create a Database 7:37 Drop the Database 8:01 Table 9:55 Create a Table 10:47 Drop a Table 11:09 SQL Basic Queries 11:46 SELECT 12:33 WHERE 13:06 AND, OR, NOT 15:04 INSERT INTO 16:06 AGGREGATE FUNCTIONS 18:53 GROUP BY, HAVING, ORDER BY 21:26 NULL 22:57 UPDATE & DELETE 24:26 IN & BETWEEN OPERATORS 25:51 ALIASES IN SQL - To subscribe to our channel and hit the bell icon to never miss an update from us in the future: 🤍 📢📢 𝐓𝐨𝐩 𝟏𝟎 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐢𝐧 𝟐𝟎𝟐𝟒 𝐒𝐞𝐫𝐢𝐞𝐬 📢📢 ⏩ NEW Top 10 Technologies To Learn In 2024 - 🤍 📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: 🤍 📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: 🤍 📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: 🤍 📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: 🤍 📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: 🤍 📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: 🤍 📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: 🤍 📌𝐌𝐞𝐞𝐭𝐮𝐩: 🤍 📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: 🤍 #Edureka #Edurekasql #sqlbasics #sqltutorialsforbeginners #sqldbms - How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. At the end of the training, you will be working on a real-time project for which we will provide you with a Grade and a Verifiable Certificate! About The Course MySQL is the most popular open-source database. This training is your first step towards gaining a strong foundation and hands-on experience in using and administering this open-source relational database. You will gain an understanding of the core concepts and advanced tools and techniques to manage data and administer the MySQL Database. Through this training, you will gain the ability to create and administer your own MySQL Database and manage data. Who should go for this course? This course can be beneficial for people having the below professional background: • Database Developers • Application Developers • Database Designers • Database Administrators - Why learn MySQL DBA? Edureka's MySQL Administration training is based on the MySQL Database 5.6 version. This is your first step in getting to know this open-source relational database with extensive hands-on learning. You will get a general understanding of relational databases and techniques to design an efficient database system. You will learn the powerful Structured Query Language (SQL) to build a database and manipulate data. You will also learn the various administration skills required to manage the database. - Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. Please write back to us at sales🤍edureka.in or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information.

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

773637
24121
1253
00:24:55
21.05.2021

This video is about Window Functions in SQL which is also referred to as Analytic Function in some of the RDBMS. SQL Window Functions covered in this video are RANK, DENSE RANK, ROW NUMBER, LEAD, LAG. Also, we see how to use SQL Aggregate functions like MIN, MAX, SUM, COUNT, AVG as window function. This video is focused on teaching how to write SQL Queries using different window functions or analytic functions. We go through the syntax of using rank, dense_rank, row_number, lead, lag and max functions as window function. Over clause is explained in detail in this video. Over clause is used in SQL when we need to use window function. Inside Over clause, we also use Partition By clause and also Order by clause. Partition By clause is used to specify the column based on which different windows needs to be created. The window function you learn in this video is applicable to any RDBMS since these functions are commonly used across most of the popular RDBMS such as Oracle, MySQL, PostgreSQL, Microsoft SQL Server etc. Download all scripts and Queries used in this video from below link: 🤍 Click on the "Download SQL Script" button to download scripts. Timestamp: 00:00 Intro 01:33 Understanding Aggregate function 03:16 Syntax to write SQL Query using Window Function 06:33 ROW_NUMBER() Window Function in SQL 11:57 RANK() Window Function in SQL 15:43 DENSE_RANK() Window Function in SQL 17:10 Difference between RANK, DENSE RANK and ROW NUMBER in SQL 17:59 LEAD() and LAG() Window Function in SQL I hope this video was helpful and gives you a good understanding of how to write SQL Queries using window functions or analytic functions. If you liked what you saw, then please make sure to like, subscribe and comment any feedback you may have. Also please do not hesitate to share the video with your friends and colleagues who may be interested in learning SQL 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

SQL - Complete Course in 3 Hours | SQL One Shot using MySQL

2642922
54393
2512
03:16:14
18.08.2023

You can join the NEW Web Development batch using the below link. 🔥Delta 3.0(Full Stack Web Development) : 🤍 Early bird offer for first 5000 students only! International Student (payment link) - 🤍 - 📌 Details about the Delta 3.0 Batch : - Start Date : 7th November, 2023 - Alternate day lectures (at 8PM) - Duration - 4.5 months - Each Class duration : 1.5 hour-2hour (alternate days) - Access to the course is for 2 years - Complete Frontend Development with HTML, CSS, Javascript & ReactJs - Complete Backend Development (NodeJs, ExpressJs) - Complete Database -( SQL & MongoDB) - Complete MERN Stack (MongoDB, Express, React, Node) - Real Life and Industry Grade Projects - Live Mentorship Sessions - 500+Topic Videos - Certificate will be given on Completion. Link for SQL Notes : 🤍 SQL Timestamps: Start - 00:00 Introduction to SQL - 01:43 01:48 What is database? 03:45 Types of databases 08:03 Installation of MySQL 13:03 Database Structure 14:21 What is table? 16:29 Creating our first database 22:41 Creating our first table 29:49 SQL Datatypes 37:11 Types of SQL Commands 40:09 Database related queries 43:43 Table related queries 46:11 SELECT Command 47:22 INSERT Command 51:19 Practice Questions 56:25 Keys 01:01:26 Constraints 01:13:04 SELECT Command in Detail 01:15:10 Where Clause 01:21:19 Operators 01:25:21 Limit Clause 01:26:48 Order By Clause 01:29:12 Aggregate Functions 01:32:33 Group By Clause 01:37:51 Practice Questions 01:43:35 Having Clause 01:47:18 General Order of Commands 01:50:31 UPDATE Command 01:56:40 DELETE Command 01:58:41 Revisiting Foreign Keys 02:06:35 Cascading Foreign Keys 02:12:30 ALTER Command 02:15:06 CHANGE and MODIFY Commands 02:20:33 TRUNCATE Command 02:24:00 JOINS in SQL 02:51:23 UNION in SQL 02:53:54 SQL Sub Queries 03:11:26 MySQL Views

Solving a Complex SQL Interview problem | Practice SQL Queries

43969
1240
114
00:32:09
21.03.2023

In this video, let us solve a complex SQL interview problem. This is a REAL SQL Interview question that might seem impossible to solve just by using SQL at first. But during the video, I will simplify the problem by breaking it into multiple parts. We shall first determine an approach that can solve such problems easily and then write the SQL query to solve this problem. You can download the dataset, scripts, and solution from my website below: 🤍 🔴 My Recommended courses 👇 ✅ Learn complete SQL: 🤍 ✅ Practice SQL Queries: 🤍 ✅ Learn Python: 🤍 ✅ Learn Power BI: 🤍 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

SQL Full Course | SQL Tutorial For Beginners | Learn SQL (Structured Query Language) | Edureka

2231981
32084
367
04:07:51
26.05.2019

🔥 Edureka SQL Course Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎"): 🤍 This Edureka SQL Full Course video will cover all the topics of Structured Query Language (SQL) starting from scratch. This SQL tutorial for beginners is great for beginners who want to learn SQL and for professionals who want to brush up their SQL skills. The following topics are covered in this SQL tutorial: 00:00 Introduction 2:00 What is RDBMS? 2:54 Normalization in DBMS 3:44 Normalization Types in DBMS 10:00 Data Types in SQL *Database Commands* 17:03 Create Database Objects 25:04 Alter Table Statements 30:47 Drop Table Statements 32:05 Various Constraints 57:54 Creating Views *Table Commands* 1:02:18 Insert Statements 1:07:47 Insert – As- Select Statement 1:13:58 Update Statements 1:20:05 Delete Statements 1:22:47 Select Statement 1:28:01 Select Statement: Alias 1:31:39 Select Statement: Distinct Values 1:32:49 Sorting 1:36:20 Filtering *Comparison Operators* 1:45:29 NOT IN 1:45:58 IN 1:48:10 Symbols 1:49:21 Example 1:29:29 LIKE 1:52:37 CASE Expression *Joins* 1:56:23 Joins 1:57:15 Self-Join 1:58:36 Inner Join 2:14:24 Left outer Join 2:19:46 Right outer Join 2:24:32 Full outer join 2:28:12 Cross Join *Functions* 2:34:17 SQL Built-in Functions 2:37:20 Conversion Function 2:42:16 Logical Functions 2:48:44 Math Function 2:54:45 Aggregate Functions 3:02:28 String Functions 3:09:00 Date & Time Functions 3:11:55 Custom Functions 3:19:01 Stored Procedure 3:43:44 User Defined Functions 4:02:57 Triggers Subscribe to our Edureka YouTube channel and hit the bell icon to get video updates: 🤍 📢📢 𝐓𝐨𝐩 𝟏𝟎 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐢𝐧 𝟐𝟎𝟐𝟒 𝐒𝐞𝐫𝐢𝐞𝐬 📢📢 ⏩ NEW Top 10 Technologies To Learn In 2024 - 🤍 📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: 🤍 📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: 🤍 📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: 🤍 📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: 🤍 📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: 🤍 📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: 🤍 📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: 🤍 📌𝐌𝐞𝐞𝐭𝐮𝐩: 🤍 📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: 🤍 - How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project 3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 4. You will get Lifetime Access to the recordings in the LMS. 5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate! - - - - - - - - - - - - - - About the Course MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data. - - - - - - - - - - - - - - Who should go for this course? This course can be beneficial for people having the below professional background: Database Developers Application Developers Database Designers Database Administrators - - - - - - - - - - - - - - Project In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM:- • Employee list to be maintained having id, name, designation, experience • Salary details having employee id, current salary • Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee • Salary increment to be given by next year if any depending upon constraints • Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted. - - - - - - - - - - - - - - Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For more information, please write back to us at sales🤍edureka,in or call us at IND: 9606058406 / US: 18338555775 (toll-free).

Lec-59: SQL Queries and Subqueries (part-1) | Database Management System

1312175
21101
629
00:08:58
09.09.2018

👉Subscribe to our new channel:🤍 👉Link for DBMS Notes: 🔗File 1: 🤍 🔗File 2: 🤍 🧑‍🎓Contributed by: Anurag Singhal This video is about SQL Queries and Subqueries (part-1) 0:00 - Introduction 1:52 - Question 1 3:38 - Question 2 ► Structured Query Language (SQL)(Complete Playlist): 🤍 Other subject-wise playlist Links: ►Design and Analysis of algorithms (DAA): 🤍 ►Computer Architecture (Complete Playlist): 🤍 ► Theory of Computation 🤍 ►Artificial Intelligence: 🤍 ►Computer Networks (Complete Playlist): 🤍 ►Operating System: 🤍 ►Database Management System(Complete Playlist): 🤍 ►Discrete Mathematics: 🤍 ►Compiler Design: 🤍 ►Number System: 🤍 ►Cloud Computing & BIG Data: 🤍 ►Software Engineering: 🤍 ►Data Structure: 🤍 ►Graph Theory: 🤍 ►Programming in C: 🤍 ►Digital Logic: 🤍 - Our social media Links: ► Subscribe to us on YouTube: 🤍 ►Subscribe to our new channel: 🤍 ► Like our page on Facebook: 🤍 ► Follow us on Instagram: 🤍 ► Follow us on Instagram: 🤍 ► Follow us on Telegram: 🤍 ► Follow us on Threads: 🤍 ►For Any Query, Suggestion or notes contribution: Email us at: gatesmashers2018🤍gmail.com #Subqueries#SqlDBMS#freeEducationGATE

How to Write Basic SQL Statements (SELECT, FROM)

17741
313
6
00:01:40
19.09.2022

We can write a basic SQL statement using SELECT and FROM. The SELECT statement is the most common command in SQL.

QUERIES ON SAILORS, BOATS & RESERVES TABLE IN SQL || QUERIES IN SQL || DBMS

18618
332
10
00:21:29
26.09.2022

QUERIES FOR FOLLOWING QUESTIONS 1. Finding Names of Sailors who reserved Boat No 3. 2. Finding Names of Sailors who reserved RED Boat. 3. Finding Color of Boats reserved by 'SUNDEEP'. 4. Finding Names of Sailors who have reserved atleast one Boat. HOW TO DOWNLOAD & INSTALL MySQL IN WINDOWS 10 🤍 DATABASE MANAGEMENT SYSTEM 🤍 PYTHON PROGRAMS 🤍 C PROGRAMMING 🤍 CORE JAVA TUTORIAL FOR BEGINNERS || LEARN CORE JAVA IN 15 HOURS || JAVA TUTORIALS FOR BEGINNERS 🤍 HTML TUTORIALS WITH IMPLEMENTATION || LEARN HTML IN 4 HOURS 🤍 LEARN CSS IN 3 HOURS || CASCADING STYLE SHEETS FOR BEGINNERS 🤍 JAVA SCRIPT FOR BEGINNERS IN 7 HOURS || LEARN JAVA SCRIPT IN 7 HOURS || JAVA SCRIPT 🤍 PYTHON TUTORIALS FOR BEGINNERS (తెలుగు లో) 🤍 PYTHON OOPS - MODULES - EXCEPTION HANDLING (తెలుగు లో) 🤍 PYTHON NUMPY TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE NUMPY TUTORIALS IN TELUGU 🤍 PYTHON PANDAS TUTORIAL IN TELUGU (తెలుగు లో) || COMPLETE PANDAS TUTORIALS IN TELUGU || DATA SCIENCE 🤍 MATPLOTLIB LIBRARY - PYTHON PROGRAMMING (ENGLISH) 🤍 PYTHON DATABASE CONNECTIVITY - MYSQL & MS-EXCEL 🤍 DATA STRUCTURES USING PYTHON (ENGLISH) 🤍 Instagram : 🤍

SQL Server Interview Questions and Answers :- What to prepare ?

64842
4886
40
00:00:55
21.07.2023

#shorts Top SQL Server Interview Questions and Answers - 🤍 For more SQL Server Q&A videos Click - 🤍 Subscribe to our channel and keep yourself updated for upcoming Videos and Shorts 🤍 Syllabus covered in this video :- 00:00 Introduction 01:22 Question 1 :- Explain normalization ? 04:45 Question 2 :- How to implement normalization ? 05:44 Question 3 :- What is denormalization ? 07:07 Question 4 :- Explain OLTP vs OLAP ? 10:40 Question 5 :- Explain 1st,2nd and 3rd Normal form ? 18:02 Question 6 :- Primary Key vs Unique key ? 20:02 Question 7 :- Differentiate between Char vs Varchar ? 21:32 Question 8 :- Differentiate between Char vs NChar ? 22:25 Question 9 :- Whats the size of Char vs NChar ? 23:32 Question 10 :- What is the use of Index ? 24:03 Question 11 :- How does it make search faster? 26:36 Question 12 :- What are the two types of Indexes ? 26:51 Question 13 :- Clustered vs Non-Clustered index 29:14 Question 14 :- Function vs Stored Procedures 33:27 Question 15 :- What are triggers and why do you need it ? 34:58 Question 16 :- What are types of triggers ? 36:57 Question 17 :- Differentiate between After trigger vs Instead Of ? 37:03 Question 18 :- What is need of Identity ? 38:10 Question 19 :- Explain transactions and how to implement it ? 42:55 Question 20 :- What are inner joins ? 45:00 Question 21 :- Explain Left join ? 46:25 Question 22 :- Explain Right join ? 46:40 Question 23 :- Explain Full outer joins ? 47:34 Question 24 :- Explain Cross joins ? SQL Interview Questions & Answers - Part 2 :- Question 25:-Why do we need UNION ? Question 26:-Differentiate between Union vs Union All ? Question 27:-can we have unequal columns in Union? Question 28:-Can column have different data types in Union ? Question 29:- Which Aggregate function have you used ? Question 30:- When to use Group by ? Question 31:- Can we select column which is not part of group by ? Question 32:- What is having clause ? Question 33:- Having clause vs Where clause Question 34:- How can we sort records ? Question 35:- Whats the default sort ? Question 36:- How can we remove duplicates ? Question 37:- Select the first top X records ? Question 38:- How to handle NULLS ? Question 39:- What is use of wild cards ? Question 40:- What is the use of Alias ? Question 41:- How to write a case statement ? Question 42:- What is self reference tables ? Question 43:- What is self join ? Question 44:- Explain the between clause ? SQL Interview Questions & Answers - Part 3 :- Question 45:- Explain SubQuery? Question 46:- Can inner Subquery return multiple results? Question 47:- What is Co-related Query? Question 48:- Differentiate between Joins and SubQuery? Question 49:- Performance Joins vs SubQuery? SQL Server Interview Questions & Answers - Part 4 :- Question 50:- Find NTH Highest Salary in SQL. SQL Server Interview Questions & Answers - Part 5 Question 51:- Select the top nth highest salary using correlated Queries? Question 52:- Select top nth using using TSQL Question 53:- Performance comparison of all the methods. See our other Step by Step video series below :- For more such videos subscribe 🤍 JavaScript Interview Questions: 🤍 Learn SQL Server Step by Step 🤍 Learn Angular tutorial step by step 🤍 OOPS interview questions and answers:- 🤍 ASP.NET MVC Core Interview Questions with answers:- 🤍 C# interview questions and answers:- 🤍 C# tutorial for beginners(4 hrs):- 🤍 Learn Azure Step by Step:- 🤍 Azure AZ-900 fundamentals certification :- 🤍 AZ- 204 certification Azure:- 🤍 Learn MVC 5 step by step in 16 hours:- 🤍 Learn Design Pattern Step by Step 🤍 Learn MSBI Step by Step in 32 hours:- 🤍 Python Tutorial for Beginners:- 🤍 Learn Data Science in 1 hour :- 🤍 Learn Power BI Step by Step:- 🤍 PHP Interview Questions : 🤍 For more details contact questpond🤍questpond.com OR call (+91) 99675 90707, (+91) 77009 75156, 022-49786776. #sqlinterviewquestionsandanswers #SQLServerCTE #CTE #CommonTableExpression

Solving a tricky SQL Interview Query

46373
1590
132
00:19:24
21.11.2022

In this video, let's solve an SQL query which can be pretty commonly asked during SQL interviews. This is a basic to intermediate level of SQL interview problem which can be commonly asked during interviews. If not the same problem but problems similar to this can be asked. By practicing to solve these kind of sql queries, you will get to know how to use window functions, frame clause, cte and more importantly how to apply simple logics when solving sql problems. Download the dataset and scripts from my blog below: 🤍 Timestamp: 00:00 Intro 00:11 Understanding the problem statement 04:30 Steps to be taken to solve the SQL problem 05:30 Writing the SQL query 🔴 My Recommended courses 👇 ✅ Learn complete SQL: 🤍 ✅ Practice SQL Queries: 🤍 ✅ Learn Python: 🤍 ✅ Learn Power BI: 🤍 🔴 WATCH MORE VIDEOS HERE 👇 ✅ SQL Tutorial - Basic concepts: 🤍 ✅ SQL Tutorial - Intermediate concepts: 🤍 ✅ SQL Tutorial - Advance concepts: 🤍 ✅ Practice Solving Basic SQL Queries: 🤍 ✅ Practice Solving Intermediate SQL Queries: 🤍 ✅ Practice Solving Complex SQL Queries: 🤍 ✅ Data Analytics Career guidance: 🤍 ✅ SQL Course, SQL Training Platform Recommendations: 🤍 ✅ Python Tutorial: 🤍 ✅ Git and GitHub Tutorial: 🤍 ✅ Data Analytics Projects: 🤍 THANK YOU, Thoufiq

BEST Websites to Learn SQL FAST 🏃🏽‍♂️💨

63458
6100
29
00:00:43
21.03.2023

#shorts #dataengineering #data #airbyte #sql #dataanalytics #docker #coding #tech Subscribe to our newsletter: 🤍 Learn more about Airbyte: 🤍

Назад
Что ищут прямо сейчас на
Queries SQL unreal engine движок КамедиКлаб unreal c Madreselva unnormal car business server lock pubg unmissable unmanned vehicle sergili mashina bozori DJI Mini 3 Pro Specs unlock zong zong device unlock sim in jiofi durdona imron unlock all skin ff olie lek 쫄면 unlink symbolic link seanpenn