Одну секунду
Что-то сучилось. Попробуйте еще раз.
Sql basics queries смотреть последние обновления за сегодня на .
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
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: 🤍
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: 🤍
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
🔥 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.
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
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.
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: 🤍
SQL Server Query writing strategies is something I have yet to find in any book. When enthusiastic SQL students do this, they experience a revelation. The number of errors drops significantly and the speed at writing complex queries increases immediately. Knowing how to narrow down what we are looking for amongst a vast list of choices helps immensely. Grabbing the right tables first and then the fields second is akin to grabbing the right menu before ordering an item from it. In fact, one student named Tim took this back to his team of SQL developers and they immediately implemented this process. We are all used to following steps. Most of the time, actions are sequential from top to bottom or left to right. Other times we complete things in phases. The two phases we are going to use in this exercise apply to joining tables. This is easy to implement as we only need remember to organize first and clean up second. When visiting a new restaurant, we will ask to see the menu, because we want to see all they have to offer. The odds are that we might be interested in half of the items, but only need a few dishes for our group at the table. Looking at the menu is like starting a query with a ‘SELECT *’ statement. Once we have looked at all the fields, we narrow our choice(s) to only the items we want at the time. Sometimes restaurants have multiple menus. My favorite restaurant has a kids’ menu, an adult menu, a gluten-free menu and a drink menu. These menus were each gathered at our table. Ultimately, in my head, a selection was narrowed to what was needed. Phase I: Organize. When building a new query from many tables, we often find ourselves wondering, “Where do I start?” First, lay the steps out by identifying which tables contain the essential data. Second, get all the table joins working with a basic ‘SELECT *’ statement. Third, add any basic filtering criteria. Phase II: Itemize. Once all joins and criteria, such as SELECT, FROM and WHERE are working, we are ready for Phase II. This entails going back and changing our ‘SELECT *’ to an itemized SELECT field list as the final step. Let’s explore how this two-phase process of Organize and then Itemize can be a big time-saver. We are going to use one of the challenges from the last lab. In Lab 3.2 (Outer Joins), Skill Check 2, we needed to get four fields from two different tables. If we were to list all four desired fields and test one table at time, we will get an error as seen on the right side of the figure below. In the figure below we write a SELECT statement and part of the FROM clause. When completed, the FROM clause will have two tables, but for now we just want to get the Location table working. By using the ‘SELECT *’ strategy, we remove any possible errors from line 1. From there, we can focus on the more complicated logic used for joining tables together. We can add tables one at a time until everything is working. This is the Organize phase. NOTE: SELECT * never results in an Error message stating “invalid column name”, however; a SELECT list with itemized field(s) can have this error. After our query is organized and working, we can go back and itemize the SELECT field list to display only the fields that are necessary. This is done during Phase II (Itemize). The steps for this system are broken down as follows: Since SELECT is always the first statement in a query, it’s natural to want to write the field names before writing the FROM clause. However; we can save time and trouble by using the ‘*’ until the entire query is working properly. When this is complete, it is very easy to itemize the field list, with the confidence of knowing it will not cause any problems. Exercise: Simple membership for a club: Table1 (id_Member,name_Member, email_member, title, age, company) Table2 (id_Club,club_name, club_Location, address) Table3 (id_club, id_member,membership_date) Q1: Show all member names, email, age, and company from Table1 Q2: Show all club name, location, and address data Q3: Show member name, club name, club location (hint: Use joins and all 3 tables) You can find all other classes related to this video here: 🤍 Enroll Today & Get the First Month for only $1! Use code: YOUTUBE1
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: 🤍
We can write a basic SQL statement using SELECT and FROM. The SELECT statement is the most common command in SQL.
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
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*
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
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
This video contains the step by step guide on how to learn SQL. I mention all the concepts you need to cover in order to learn SQL and also mention the sequence in which you should be learning these SQL concepts. This is how I would recommend anyone to learn SQL from scratch. Link to my blog: 🤍 /* */ Join my LIVE SQL Training for writing Intermediate to Complex SQL Queries: During this class, I will be solving around 15 - 25 SQL Queries ranging from intermediate to complex level. I will be explaining how to solve these queries and the thinking behind solving these queries using different SQL concepts. Anyone looking to improve your SQL Query writing skills can benefit from these classes. Class Summary: Date: From 07-Mar, 08-Mar, 10-Mar, 14-Mar, 15-Mar and 17-Mar. Days: Monday, Tuesday & Thursday Time: 07:30 PM IST / 09:00 AM EST Duration: 1.5 to 2 hrs each session Total sessions: 6 Total SQL Queries to be solved: 15-25 Cost: $10 (INR 750) for all the 6 sessions. Class held on: Lighthall.co Who can join: Anyone with basic understanding of SQL. Link to register for the class: 🤍 OR Just go to 🤍 and find my class under the Data Science category and register. /* */ SQL Learning Resource mentioned in the video: - W3Schools (for SQL syntax): 🤍 - LearnSQL.com (for SQL course): 🤍 - StrataScratch (for practicing SQL queries): 🤍 - LeetCode (for practicing simple SQL queries): 🤍 🔴 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
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link 🤍 to make a donation. Thanks for watching! By Andrew Gould 🤍 - Learn how to write basic queries in Microsoft SQL Server. This video teaches you the absolute basics of the SELECT and FROM statements using SQL Server Management Studio, including how to use aliases to refer to fields. You can view a written version of this tutorial at: 🤍 You can download the script to create the Movies database used in this video at the following link: 🤍 You can see the range of resources and courses we offer in SQL Server here: 🤍 Visit 🤍wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL. PREREQUISITES You will need a database to practice on. The training uses SQL Server Developer Edition, but you can use MySQL, Oracle or any other relational database. Install SQL Server Developer Edition: 🤍 You will also need a tool to write the SQL that you will send to the database. You can use SQL Server Management Studio (SSMS), Oracle Developer, TOAD, PHPMyAdmin, or any other tool you would like. I am using SSMS in this video. Install SQL Server Management Studio (SSMS) 🤍 TABLE OF CONTENTS 00:00 - Intro 00:48 - Overview 03:27 - Discuss Management Studio 05:10 - Create Database 07:26 - Create Table 10:29 - Insert Data 17:43 - Select Statement 19:00 - Where Clause 22:25 - Update Statement 24:33 - Delete Statement 27:41 - Adding Comments 29:33 - Adding Columns 32:38 - Drop Table 33:17 - Add Primary Key 36:00 - Create Products Table 38:54 - Create Orders Table 45:37 - Foreign Keys 50:30 - Joins 56:50 - Functions/Group By READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE 🤍 YOUTUBE NEWS UPDATES 🤍 VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS 🤍 SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! 🤍 SUBSCRIBE TO OUR EMAIL LIST! 🤍 LET'S CONNECT! Facebook: 🤍 Twitter: 🤍 Linkedin: 🤍 SQLTrainingOnline: 🤍
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: 🤍
Keep your database of accounts and passwords secure by using DashLane! Sign up now at 🤍 and use the code networkchuck50 to get 50% off dashlane at checkout! We know databases sound scary, but luckily NetworkChuck is here to hold your hand as he walks you through the mystical world of relational databases. He will show you how to use the love language of relational databases, SQL. You will even learn how to create your very own database! So buckle in, grab a cup of coffee and get ready to conquer your fear of databases! Walkthrough/Commands ⏩🤍 🔥🔥Join the NetworkChuck Academy!: 🤍 Sponsored by Dashlane SUPPORT NETWORKCHUCK - ➡️NetworkChuck membership: 🤍 ☕☕ COFFEE and MERCH: 🤍 Check out my new channel: 🤍 🆘🆘NEED HELP?? Join the Discord Server: 🤍 STUDY WITH ME on Twitch: 🤍 READY TO LEARN?? - -Learn Python: 🤍 -Get your CCNA: 🤍 FOLLOW ME EVERYWHERE - Instagram: 🤍 Twitter: 🤍 Facebook: 🤍 Join the Discord server: 🤍 0:00 ⏩ Intro 3:06 ⏩ What is SQL? 7:02 ⏩ Let’s make our own database! 10:36 ⏩ and let’s add some tables 16:47 ⏩ Challenge: create some tables by yourself 19:33 ⏩ Let’s remove the imposter in our data! 20:20 ⏩ How do I update my tables? 21:05 ⏩ What if I want to change the order? 21:42 ⏩ How to alter your table 23:39 ⏩ This puts the relation in relational databases 24:19 ⏩ Outro AFFILIATES & REFERRALS - (GEAR I USE...STUFF I RECOMMEND) My network gear: 🤍 Amazon Affiliate Store: 🤍 Buy a Raspberry Pi: 🤍 Do you want to know how I draw on the screen?? Go to 🤍 and use code NetworkChuck to get 20% off!! #SQL #Database #Relational
Creating and dropping database - create table - alter table - delete table - insert values to table - basic select #SQL #SQLinTamil Notion notes link - 🤍 Github CodeLink - 🤍 courses and playlists SQL playlist - 🤍 DS and ALGO in C/CPP: 🤍 DS and ALGO in Java: 🤍 Python Full Course with game: 🤍 Java Playlist: 🤍 Java one video: 🤍 C Interview program playlist: 🤍 C programming in one video: 🤍 C programming playlist: 🤍 C Playlist link: 🤍 English channel link: 🤍
Complete SQL in One Video SQL Tutorial for Beginners Complete MYSQL in One Video Command/Query: Create, insert, update, alter, like, pattern condition, aggregate function, join operation. Python important interview question: 🤍 Python download and install: 🤍 Python Path set Link -🤍 Java important interview question: 🤍 Database important question: 🤍 Python Playlist Link - 🤍 Channel Subscription: 🤍 👍 LIKE ✍ COMMENT ✉ SHARE ❤ SUBSCRIBE
Topic : SQL Joins and Sub Queries ######################### Udemy Courses: ######################### Manual Testing+Agile with Jira Tool ► 🤍 Selenium with Java+Cucumber ► 🤍 Selenium with Python & PyTest ► 🤍 Selenium with python using Robot framework ► 🤍 API Testing(Postman, RestAssured & SoapUI) * ► 🤍 Web & API Automation using Cypress with Javascript ► 🤍 Playwright with Javascript ► 🤍 Jmeter-Performance Testing ► 🤍 SDET Essencials(Full Stack QA) * ► 🤍 Appium-Mobile Automation Testing ► 🤍 Java Collections * ► 🤍 Python Programming * ► 🤍 Cucumber BDD Framework * ► 🤍 Protractor with Javascript * ► 🤍 #################################### Youtube Playlists: #################################### Manual Testing & Agile * ► 🤍 ► 🤍 SQL ► 🤍 ► 🤍 ► 🤍 linux & Shell Scripting ► 🤍 ► 🤍 Java ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Java+Cucumber ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Python ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python,Pytest&Behave * ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selenium With Python Using Robert Framework (Web&API Testing) * ► 🤍 ► 🤍 API Testing (Postman,SoapUi,&Rest Assured) ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 Mobile App Testing Appium ► 🤍 Performance Testing Jmeter * ► 🤍 Maven,Jenkins,Git,Github,CI/CD * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 SQL,DB Testing&ETL,Bigdata * ► 🤍 ► 🤍 ► 🤍 ► 🤍 ► 🤍 JavaScript Based Automation Tools ► 🤍 ► 🤍 ► 🤍 ► 🤍 Selector Hub Tools ► 🤍 GraphQL ► 🤍 Cypress API Testing ► 🤍 Cypress Web Testing ► 🤍 Playwright with Javascipt ► 🤍 #SQLJoins #SubQueries #SQLTutorial #DatabaseJoin #InnerJoin #OuterJoin #LeftJoin #RightJoin #FullOuterJoin #SelfJoin #CrossJoin #NaturalJoin #SQLQueries #QueryOptimization #DatabaseSkills #LearnSQL #SQLBasics #SQLMastery #SQLDatabase #StructuredQueryLanguage #SQLSyntax #DatabaseManagement #SQLSkills #JoiningData #SQLCoding #SQLForBeginners #SQLTips #SQLTricks #SQLExamples #SQLCommunity #DatabaseDesign #SQLDevelopment #DataAnalysis #SQLLearning #SQLPractice #DatabaseQueries #SQLServer #SQLExpress #DataManipulation #SQLPerformance #DatabaseNormalization #AdvancedSQL #SQLQuerying #QueryOptimization #SQLConcepts #DatabaseJoining #SubQueryExamples #SQLStudents #JoiningTables #SQLPro
SQL Tutorial for Beginners - Learn complete SQL from basics to advance in one video. This course is for beginners (with zero knowledge in sql) and through this course we'll be learning various topics including sql basics in hindi, data types, database structure, basic CRUD operations, functions, operators, aggregation, nested queries, joins, cte and much more. 📢ALL csv files and queries are in PDF 📢 ⭐ Download SQL PDF document used in this course: 🤍 👍 Subscribe for more SQL tutorials like this: 🤍 👉 GitHub link (all files): 🤍 Getting bored- "Khud se pucho ki shuru kyu kiya tha, career mei kuch bada karna hai" ? ➖➖➖➖➖➖➖➖➖➖➖➖➖ Want to connect with me? Check out these links: Instagram: 🤍 LinkedIn: 🤍 Twitter: 🤍 ➖➖➖➖➖➖➖➖➖➖➖➖➖ Timestamps: 00:00 SQL Course Intro 01:13 Introduction to SQL 08:26 Data Types, Primary-Foreign Keys & Constraints 16:50 Create Table In SQL & Create Database 25:35 INSERT UPDATE, DELETE & ALTER Table 31:40 SELECT Statement & WHERE Clause 38:50 How To Import Excel File (CSV) to SQL 42:16 Functions in SQL and String Functions 49:47 Aggregate Functions 54:46 Group By and Having clause 1:05:21 Time Stamp, Date Time and Extract Function 1:12:22 JOINS in SQL, Types and Syntax 1:33:06 SELF JOIN, UNION & UNION ALL 1:41:25 Sub Query in SQL 1:53:04 Window Function 2:14:25 Case Statement/Expression 2:23:18 CTE-Common Table Expression 2:33:53 SQL Course Outro ➖➖➖➖➖➖➖➖➖➖➖➖➖ Other Useful Videos: Data Analyst Roadmap, Skills and Jobs: 🤍 Excel Course: 🤍 ➖➖➖➖➖➖➖➖➖➖➖➖➖ Hope you liked this SQL for beginners course and learned SQL completely from basic to advance. As a next step you can practice more sql queries, interview questions and answers and follow my roadmap to learn SQL :) See You Soon, until then Bye-Bye!
00:00:00 INTRODUCTION TO SQL 00:12:19 SQL DATATYPES 00:27:42 CREATE COMMAND IN SQL 00:49:03 INSERT COMMAND IN SQL 01:06:45 CONSTRAINTS IN SQL 01:54:13 ALTER COMMAND IN SQL 02:10:14 DROP & TRUNCATE COMMANDS IN SQL 02:16:04 SELECT COMMAND IN SQL 02:51:18 UPDATE & DELETE COMMANDS IN SQL 03:04:18 SQL AGGREGATE FUNCTIONS 03:15:23 GROUP BY & HAVING CLAUSE IN SELECT COMMAND 03:35:28 CREATION & INSERTION OF DATA TO SAILORS , RESERVES & BOATS TABLE 03:54:17 QUERIES ON SAILORS , RESERVES & BOATS TABLE 04:15:08 VIEWS IN SQL - 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 #Database #SQLTutorial #LearnSQL #DatabaseManagement #SQLQueries #SQLServer #MySQL #DatabaseDevelopment #DataManipulation #DataRetrieval #DataAnalysis #DatabaseDesign #SQLSyntax #SQLTips #SQLTricks #SQLProgramming #SQLJoin #SQLFunctions
#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 🤍
🔥 𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐒𝐐𝐋 𝐂𝐨𝐮𝐫𝐬𝐞 𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 (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 on their SQL skills. The following topics are covered in this SQL Full Course Tutorial: 00:00:00 Introduction to SQL Full Course 00:02:23 Agenda 00:02:35 What is SQL 00:16:32 Data & Database 00:23:58 Basic SQL Queries 00:50:51 Normalization in SQL 01:01:44 Triggers in SQL 01:11:23 Advantages & Disadvantages of Triggers 01:12:33 Joins in SQL 01:33:28 Functions in SQL 02:18:19 Stored procedure 02:43:02 User-Defined Functions 03:02:13 SQL vs MySQL 03:07:36 SQL vs NoSQL 03:39:41 SQL Interview Question & Answers 04:31:17 SQL For Data Science 05:06:27 PostgreSQL 05:17:00 SQL Command Categories 05:24:31 ER Diagram 05:43:34 Keys in Database 05:46:53 Constraints in Database 05:53:44 Normalization 05:59:26 DML Commands 06:18:36 Operators in SQL 06:47:54 Joins in SQL 06:51:52 Views in SQL 07:06:19 DCL Commands 07:15:23 SQL Server 07:21:28 Features of SQL Server 07:36:50 DDL Commands in SQL 08:30:07 Operators 08:55:50 Exception handling in SQL 08:59:55 SQL Server Interview Question & Answer 🔴 Subscribe to our channel to get video updates. Hit the subscribe button above: 🤍 🔴 𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐎𝐧𝐥𝐢𝐧𝐞 𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 𝐚𝐧𝐝 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬 🔵 DevOps Online Training: 🤍 🌕 AWS Online Training: 🤍 🔵 React Online Training: 🤍 🌕 Tableau Online Training: 🤍 🔵 Power BI Online Training: 🤍 🌕 Selenium Online Training: 🤍 🔵 PMP Online Training: 🤍 🌕 Salesforce Online Training: 🤍 🔵 Cybersecurity Online Training: 🤍 🌕 Java Online Training: 🤍 🔵 Big Data Online Training: 🤍 🌕 RPA Online Training: 🤍 🔵 Python Online Training: 🤍 🌕 Azure Online Training: 🤍 🔵 GCP Online Training: 🤍 🌕 Microservices Online Training: 🤍 🔵 Data Science Online Training: 🤍 🌕 CEHv12 Online Training: 🤍 🔵 Angular Online Training: 🤍 🔴 𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐑𝐨𝐥𝐞-𝐁𝐚𝐬𝐞𝐝 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 🔵 DevOps Engineer Masters Program: 🤍 🌕 Cloud Architect Masters Program: 🤍 🔵 Data Scientist Masters Program: 🤍 🌕 Big Data Architect Masters Program: 🤍 🔵 Machine Learning Engineer Masters Program: 🤍 🌕 Business Intelligence Masters Program: 🤍 🔵 Python Developer Masters Program: 🤍 🌕 RPA Developer Masters Program: 🤍 🔵 Web Development Masters Program: 🤍 🌕 Computer Science Bootcamp Program : 🤍 🔵 Cyber Security Masters Program: 🤍 🌕 Full Stack Developer Masters Program : 🤍 🔵 Automation Testing Engineer Masters Program : 🤍 🌕 Python Developer Masters Program : 🤍 🔵 Azure Cloud Engineer Masters Program: 🤍 🔴 𝐄𝐝𝐮𝐫𝐞𝐤𝐚 𝐔𝐧𝐢𝐯𝐞𝐫𝐬𝐢𝐭𝐲 𝐏𝐫𝐨𝐠𝐫𝐚𝐦𝐬 🌕 Professional Certificate Program in DevOps with Purdue University: 🤍 🔵 Advanced Certificate Program in Data Science with E&ICT Academy, IIT Guwahati: 🤍 🌕 Artificial and Machine Learning PGD with E&ICT Academy NIT Warangal: 🤍 📢📢 𝐓𝐨𝐩 𝟏𝟎 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐢𝐧 2023 𝐒𝐞𝐫𝐢𝐞𝐬 📢📢 ⏩ NEW Top 10 Technologies To Learn In 2023 - 🤍 📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: 🤍 📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: 🤍 📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: 🤍 📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: 🤍 📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: 🤍 📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: 🤍 📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: 🤍 📌𝐌𝐞𝐞𝐭𝐮𝐩: 🤍 📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: 🤍 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.co or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information.
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
"*Note: 1+ Years of Work Experience Recommended to Sign up for Below Programs⬇️ 🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 This video on SQL Basics for Beginners will help you understand databases and what SQL is. You will learn the crucial SQL features and their applications and look at some of the important SQL commands in this SQL tutorial for beginners video. You will implement these commands using the MySQL workbench. The following are the topic covered in this SQL Basics for Beginners video: 00:00:00 What is DataBase? 00:01:03 What is the Need of a Database? 00:01:35 What is SQL? 00:01:52 SQL Query 00:02:33 Features of SQL 00:02:58 Applications of SQL 00:03:40 Basic Queries in SQL ✅Subscribe to our Channel to learn more about the top Technologies: 🤍 To access the slides, click here: 🤍 ⏩ Check out the Design Thinking training videos: 🤍 #SQLBasics #SQLBasicsForBeginners #SQLTutorial #SQlTutorialForBeginners #SQLCourse #SQLTraining #Simplilearn What is SQL? SQL is a Structured Query Language to communicate with relational databases. Some of the popular databases available are MySQL, Oracle, MS SQL Server, and PostgreSQL. Using SQL, you can store, retrieve, update, delete and manipulate data. You can permit users to perform specific tasks on tables, procedures, and views. 🔥Explore our FREE Courses: 🤍 ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688 🎓Enhance your expertise in the below technologies to secure lucrative, high-paying job opportunities: 🟡 AI & Machine Learning - 🤍 🟢 Cyber Security - 🤍 🔴 Data Analytics - 🤍 🟠 Data Science - 🤍 🔵 Cloud Computing - 🤍
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.
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
👉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
"*Note: 1+ Years of Work Experience Recommended to Sign up for Below Programs⬇️ 🔥Post Graduate Program In Data Analytics: 🤍 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥Data Analyst Masters Program (Discount Code - YTBE15): 🤍 This video on SQL Advanced Tutorial will help you learn the important advanced SQL queries for performing complex operations. Advanced SQL Tutorial With Examples will help you learn how to write subqueries and stored procedures. You will get an idea about triggers and views in SQL. Finally, we'll explore some of the important window functions in MySQL. Following are the topics covered in this SQL for beginners video: 00:00:00 SQL Advanced Tutorial 00:11:19 Stored Procedures 00:28:05 Triggers in SQL 00:35:36 Views in SQL 00:44:25 Windows Functions in SQL Dataset Link - 🤍 ✅Subscribe to our Channel to learn more about the top Technologies: 🤍 ⏩ Check out the SQL training videos: 🤍 #SQLAdvancedTutorial #SQLTutorial #SQLTutorialForBeginners #SQLCourse #SQLTraining #SQLForBeginners #SQLCourse #SQLTraining #Simplilearn ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: 🤍 🔥Caltech Data Analytics Bootcamp(US Only): 🤍 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688 🎓Enhance your expertise in the below technologies to secure lucrative, high-paying job opportunities: 🟡 AI & Machine Learning - 🤍 🟢 Cyber Security - 🤍 🔴 Data Analytics - 🤍 🟠 Data Science - 🤍 🔵 Cloud Computing - 🤍
In this video you will learn the following - Intro 00:00 Introduction to Database & SQL 01:00 Clarifications about SQL 05:36 Select statement 08:01 Select distinct statement 11:43 Where clause 14:20 AND/OR/NOT operators 17:52 Order By clause 22:53 Insertion statement 26:44 You can tap the timestamp and directly get to that section. All this is discussed in telugu so please spread the knowledge by sharing it. ................................................................................. Data Structures in Telugu 🤍 C in telugu 🤍 C language in telugu 🤍 Coding in C in Telugu for Beginners 🤍 C Language in one video 🤍 JAVA in one shot 🤍 ............................................................................... My Social Media Handles... Instagram: 🤍 Twitter: 🤍 LinkedIn: 🤍 Github: 🤍 Blog: 🤍 ............................................................................... Get notes for Vamsi Bhavani Videos and do much more on VAMSI BHAVANI APP Play Store: 🤍 ............................................................................... #SQL #sqlInTelugu #sqltutorial #vamsi_bhavanitutorials #vamsibhavani Jai Hind!!!
Learn the fundamentals of Structured Query Language SQL! Even though it's over 40 years old, the world's most popular databases still run on SQL. Foreign key basics 🤍 #dev #database #100SecondsOfCode Draw SQL Diagrams 🤍 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
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
SQL Full Course 👇👇 🤍 Don't forget to tag our Channel...! #sqlintroduction #sqlfullcourse #oracledatabase #oracle #sql #sqlddlcommand #sqldmlcommand #sqldqlcommand #sqltclcommand #ddlcommands #dmlcommands #dql commands #tclcommands #oraclesql #oracle11g #ask4help #LearnCoding || Content || 1. voice 🔊 :- akhilesh 2. writer ✍ :- ankush Thank You 👌👌👌
.svg){kind=small}
