Make your coding faster with advanced SQL commands. Can you explain the PL/SQL execution architecture? 15-445/645 (Fall 2020) AGGREGATES Functions that return a single value from a bag of Deploy IoT solutions with Azure SQL Database. SQL (Structured Query Language) is a domain-specific programming language designed for managing data held in a relational database management system (RDBMS). Advanced SQL - Structured Query Language. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. I would expect an intermediate skilled database professional to understand set theory and relational database design to be comfortable designing, optimising and operating a 'typical' 3rd normal f. 4 Hours 15 Videos 55 Exercises 104,744 Learners. List of free resources to practice MySQL and PostrgreSQL. Well, the word 'advanced' is, at least. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing . You can find it in SQL course descriptions, in job ads, and in the job interview questions. Display a list of all instructors, showing their ID, name, and the num-ber of sections that they have taught. 1) What type of join is needed when you wish to include rows that do not have matching values? It is used for managing data in relational database management system which stores data in the form of tables and relationship between data is also stored in the form of tables. Structured Query Language or SQL is a standard database language that is used to create, maintain, destroy, update and retrieve the data from relational databases like MySQL, Oracle, SQL Server, PostgreSQL, etc. They're the fastest (and most fun) way to become a data scientist or improve your current skills. Prerequisites: None Level: Beginner-Intermediate Rating: 4.5 Duration: 7 Hours (approximately) You can signup here. In this module, learn how Azure SQL Database provides a price-performant backend for IoT applications. The Intermediate SQL Tutorial. PostgreSQL is a powerful, open source object-relational database system. It is widely regarded as the go-to solution for many problems data scientists encounter on a daily basis. And to answer I truly do not know what "Advanced SQL" might mean. 30 Days of SQL - From Basic to Advanced Level! Whether you want to become a successful Data Scientist or a Business Analyst or a . It's used very commonly by SQL learners and SQL users. I consider myself to be between Intermediate and Advanced. After watching the course, along with the previous course, you will have a solid foundation in SQL and be . Practical SQL Skills from Intermediate to Advanced Improve your SQL skills and step up to the next level to learn more and take full command of SQL Rating: 4.3 out of 5 4.3 (265 ratings) 1,466 students Created by Gary Kind. Welcome to the Intermediate SQL Tutorial! Hence, the study of SQL query can be categorized into three sections, namely beginner query, intermediate query, and advanced query. PL/SQL Intermediate Interview Questions. This is a great resource to see what you don't know and pick and choose what you need to learn. Maybe also the use of performance tools and the other tools in the suite (SSIS & SSRS for example)? Intermediate SQL. Advanced SQL queries with examples in our database of queries. SQL From Intermediate to Advanced Level Certification Video Training Course includes 119 Lectures which proven in-depth knowledge on all key concepts of the exam. Here's a rough guess as what "Advanced" can mean. The how is relevant though and I almost put it into intermediate as well for that heh For people who know how to write SQL statements, but want to master JOINS, UNIONS and subqueries, this course is for you. Udemy said the audio was bad, so I uploaded it to YouTube. Once you have the basics mastered, this section will take your knowledge to the next level. In case of a complex data set, intermediate SQL query is used and sometimes advanced query requests are raised. This Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. SQL - Intermediate/Advanced Concepts. Enjoy! SQL test evaluation skills, interview questions and theory tests. Create A Website SQL Data Warehousing CSS PHP HTML Database Normalization. COUNT, SUM, MAX for aggregating data. Practical SQL Skills from Intermediate to Advanced.rar (Size: 631.2 MB - Date: 11/18/2021 12:12:56 PM) SQL is a standard language for storing, manipulating and retrieving data in databases. Then you can There's been an "awful" lot of new stuff in the RDBMS domain, in the last few years! 05, Feb 21. Beginner: SELECT, UPDATE, CREATE, EXECUTE, data types, DDL vs. CML. It is no surprise then to find out that advanced SQL interview questions or problems are still being asked in many interviews for data-related roles. Advanced SQL Interview Questions. Answer : Rank function is used as aggregate function to return the rank of rows in the table within group of rows.If someone needs to find out the rank of specific row in the table then we will use the rank function. Gain confidence using a wide range of advanced SQL techniques. Difference between Structured Query Language (SQL) and Transact-SQL (T-SQL) 22, Aug 19. Start Course for Free. Understanding subqueries. If you skipped the Basic SQL Tutorial, you should take a quick peek at this page to get an idea of how to use Mode's SQL editor to get the most out of this tutorial. 10 Advanced SQL Job Interview Questions and Answers Question 1: What is an index? An index is a structure in a database that can help retrieve data faster. Using indexes to speed up SQL queries. The ORDER BY clause is a list of field names or aliases. Intermediate SQL Practice Exercises 4.1 Write the following queries in SQL: a. 6 Weeks Access / 24 Course Hrs SHARE Share . (beginner to intermediate . Do you consider yourself a basic, intermediate, or advanced SQL user? Next Level SQL | Intermediate to Advanced SQL Programming (TTSQL005) New - Learn advanced SQL querying techniques to manipulate and index tables. This set of tutorials provide a set of the key job tasks performed using Oracle Data Miner, including text mining, applying logistic regression models, using predictive queries and mining JSON data. . Advanced SQL MCQ Questions and Answers. Advanced SQL. Intermediate: Joins, views, basic stored procs, TRANSACTIONS, table valued functions, subqueries, familiarity with most built in functions, EVERY NORMAL FORM (1,2,3,Boyce-Codd), Indexing, making sure the DBMS can't use so much physical storage that you can't log into the machine and get the database off it to move it to a . PostgreSQL. Advanced is all about getting a solid understanding of the how and why behind SQL and applying that throughout. SQL Basic Queries Example - I. SQL: The Ultimate Intermediate Guide to Learning SQL Programming Step by Step is suitable for helping you with a variety of intermediate abilities, including: A refresher on SQL fundamentals; An easy-to-follow tutorial on setting up and configuring SQL; Data types and their functions; View encryption, creation, and indexing You're going down more DBA route here. You will learn everything you need to know to . Students should have basic level experience of SQL such as performing SQL SELECT Commands, using the Where clause, Group By clause and performing table joins Description If you have some experience with SQL and want to develop your query skills to the next level from intermediate to advanced then this is the perfect course for you! Make sure to show the number of sections as 0 for instructors who have not taught any section. SQL stands for Structured Query Language and it is an ANSI standard computer language for accessing and manipulating database systems. Knowing how to do 3rd normal is a skill, knowing when is an art. large statement light fixture. I almost put the 3rd normal form into intermediate, but i really think data modelling can't be ascribed to beginner/intermediate/advanced, it's simply too much of an artistic talent that is so gray. →Structured Query Language 3. It is recommended to view the post in the following order: 1. reading quiz intermediate Some of the skills that students should expect to learn at this level include: Understanding how indexes work and how to implement them. This course will expand your SQL knowledge and provide skills for writing powerful queries that perform complicated searches and sorts of data. The SELECT statement is the core of SQL, and it is likely that the vast majority of your SQL commands will be SELECT statements. Sql Kurse von führenden Universitäten und führenden Unternehmen in dieser Branche. ; For each lesson, start by running SELECT * on . Advanced SQL knowledge can help you to enhance your position if you are already in employment. Browse our wide selection of SQL classes . After watching the course, along with the previous course, you will have a solid foundation in SQL and be . In case of a complex data set, intermediate SQL query is used and sometimes advanced query requests are raised. In today's Intermediate SQL lesson we walk through Joins. Intermediate SQL Table of contents • Objectives • Introduction • Context • Groupingandsummarisinginformation - AverycommonerrorwithGROUPBY SQL Intermediate Queries Example - I. Jazib. The "Advanced SQL" requirement probably hints at knowledge and possibly proficiency in several of the new concepts such as: CTEs (Common Table Expressions) UDFs (User Defined Functions) Advanced SQL Is Everywhere. Here's what they said, according to him: SELECT and WHERE for filtering and selection. This Intermediate/Advanced SQL Tutorial will cover the SELECT statement in great detail. Our SQL online training courses from LinkedIn Learning (formerly Lynda.com) provide you with the skills you need, from the fundamentals to advanced tips. This is a popular course and teaches basic and advanced aspects of SQL filtering and data manipulation. Advanced SQL. And so, Nathan Rosidi , founder of StrataScratch , and I collaborated to to go over what I think are the 10 most important and relevant intermediate to advanced SQL concepts. What are the two main index types? *FREE* shipping on qualifying offers. Answer (1 of 11): Question was: What is consider "Advanced SQL"? After watching the course, along with the previous course, you will have a solid foundation in SQL and be . SQL - Intermediate/Advanced Concepts. Chapter 4. 23, Aug 18. 30 Days of SQL - From Basic to Advanced Level! March 18, 2020. In this section we provide lots of objective question of Advanced SQL in Database Management System. Furthermore, the projects and quizzes featured in the course ease the learning process for the students. 15-445/645 (Fall 2020) RELATIONAL LANGUAGES . Pass your exam easily and learn everything you need with our SQL From Intermediate to Advanced Level Certification Training Video Course. An unindexed table is called a heap. Configure SQL Jobs in SQL Server using T-SQL. Adjusting SQL for Better Results. This training course was designed to teach students the mid-level skills of SQL. I believe the word is "considered" and not "consider", otherwise the meaning of the question won't be the same. Advance your skills with some challenging problems and think outside the box! SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Question 2 : Explain Rank as aggregate function with examples. If you can devote more time each week to . 8. Your query should use an outerjoin, and should not use scalar . SQL Skills (Basic, Intermediate and Advanced) Weeks ago I saw this post on LinkedIn from a guy who claimed to asked 10 hiring manager for what they consider basic, intermediated and advanced knowledge in SQL. In this 1-hour long project-based course, you will gain hands-on experience and learn about advanced SQL topics such as stored procedures, tiggers, functions, common table expressions and recursion. SQL Intermediate/Advanced Concepts builds on where the SQL Introduction course ends. These SQL classes are categorised based on beginner, intermediate and advanced levels and are suitable for anybody looking to excel as SQL developer or architect, database administrator, data analyst, or data scientist. 12. The PL/SQL engine does the process of compilation and execution of the PL/SQL blocks and programs and can only work if it is installed on an Oracle server or any application tool that supports Oracle such as Oracle Forms. Last updated 6/2021 English English [Auto] What you'll learn. Intermediate SQL. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach by Sylvia Moestl Vasilik | Mar 13, 2017 4.4 out of 5 stars 356 Each field in the list is sorted ascending from low-to-high (alphabetical) unless the sort order is specified. . Answer (1 of 6): That entirely depends on what you believe intermediate and advanced skill level is. Lernen Sie Sql online mit Kursen wie Nr. SHARE. This course will expand your SQL knowledge and provide skills for writing powerful queries that perform complicated searches and sorts of data. 15-445/645 (Fall 2020) SQL HISTORY Current standard is SQL:2016 . Sign up for an account if you don't have one. (100% asked Advanced SQL Interview Questions ). SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for . Learn SQL Basics for Data Science and Google Data Analytics. Intermediate to Advanced SQL covers complex data models, making highly selective retrievals, and grouping and ordering results. Technical Support for this Lab: There is a reason we provide unlimited lab time: you can take as much time as you need to solve a lab. SQL > Advanced SQL. Intermediate SQL. 18, Sep 19. COUNT, SUM, MAX for aggregating data. It is one of the best SQL courses available online for SQL learning from scratch. Intermediate SQL. You'll also deploy a template that includes Azure SQL Database, Azure VMs, Azure Functions, and Power BI which simplifies deploying and configuring IoT solutions. Hence, the study of SQL query can be categorized into three sections, namely beginner query, intermediate query, and advanced query. Advanced Relational Database and SQL. Advanced SQL is everywhere. This section shows advanced SQL concepts, as well as how Structured Queery Language can be used for some of the more complex calculations. Best Storage Solutions for PS4 Game Console. Mode provides an extensive SQL guide, from beginner SQL to intermediate SQL to advanced SQL. In this section, we discuss the following SQL keywords and concepts: . Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL. A company's success hinges on responsible and accurate database management. Advanced SQL Server. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach [Vasilik, Sylvia Moestl] on Amazon.com. Exercises for basic, intermediate and advanced level students. Advanced SQL for Data Scientists. Advance your skills with some challenging problems and think outside the box! The importance of SQL in any data-related job can never be overstated. Intermediate to Advanced SQL covers complex data models, making highly selective retrievals, and grouping and ordering results. Indexes can speed up performance by making data quicker to find, but poor indexing is also one of the biggest performance killers. If you have intermediate level of experience with SQL and want to learn more, this course is for you! Thanks for asking the question. SQL exercises and challenges with solutions PDF. You'll also learn how to use multi-table queries, and to protect your data from mistakes or hacking attempts. You'll also learn how to use multi-table queries, and to protect your data from mistakes or hacking attempts. Advanced SQL. SQL. Our Intermediate to Advanced SQL course builds upon the skills learnt in our Introduction to SQL course. What some people con. However, we realize that sometimes hints might be necessary to keep you motivated! The course is designed to focus on SQL's demands for data scientists and covers SQL's essentials from a data scientist's perspective. In this series of posts, we will discuss the SQL queries from very Basic to Advanced. Courses include: SQL Certificate, Introduction to SQL, Intermediate SQL, Advanced SQL Show more Show less Career Development JAFFA Inc. Jan 2000 - Present 22 years 1 month . Details Intermediate to Advanced SQL covers complex data models, making highly selective retrievals, and grouping and ordering results. Prior programming experience, and want to learn through intermediate SQL; Prior programming experience, and want to learn through advanced SQL (Note: all of the time estimates here assume you already have a full-time job and, like most adults, are limited to just a few hours a week of study time. SQL Intermediate/Advanced Concepts builds on where the SQL Introduction course ends. Practical data skills you can apply immediately: that's what you'll learn in these free micro-courses. Joins allow us to combine several tables, choose columns from each table, and use them in a single . It enables you to access and manipulate databases. For convenience, here's the gist: Open another window to Mode. 02 Intermediate SQL. And as a BONUS, they have three practical SQL case studies that you can use to get real-life . ORDER BY. 11. You can solve business problems by mining data stored in your database using Oracle Data Miner 19.4 and your Oracle Database 19c instance. This course is designed to further your understanding of structured query language (SQL) and improve your skills and expand your knowledge. 15-823 Advanced Topics in Databases. When you search table data with an SQL query, it will search the whole table and return the result. This section covers the advanced SQL topics including correlated subqueries, SQL Window Functions and SQL JOINS. SQL Server Views. Here's what they said, according to him: SELECT and WHERE for filtering and selection. For people who know how to write SQL statements, but want to master JOINS, UNIONS and subqueries, this course is for you. 4700 XP. 6 Weeks / 24 Course Hrs. Due to the enormous amount of options available for the SELECT statement, this entire tutorial has been dedicated to it. SQL skills are often divided into three categories - beginner, intermediate, and advanced. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach SQL Skills (Basic, Intermediate and Advanced) Weeks ago I saw this post on LinkedIn from a guy who claimed to asked 10 hiring manager for what they consider basic, intermediated and advanced knowledge in SQL. You'll also learn how to use multi-table queries, and to protect your data from mistakes or hacking attempts. Specifically, there's been a growing need for professionals who are fluent in SQL and not just at a beginner level. It's also a great resource to brush up on rusty techniques. This section covers the advanced SQL Server topics including views, indexes, stored procedures, user-defined functions, and triggers. Before digging into Intermediate topics, you may want to review the Beginning SQL article. SQL | Difference between functions and stored procedures in PL/SQL. This section introduces you to the SQL Server views and discusses the advantage and disadvantages of the database views. Learning how to to identify good candidates for indexes, as well as how to craft and maintain them, will help you run a quick and orderly database. Gain confidence using a wide range of advanced SQL techniques. //Www.Geeksforgeeks.Org/Sql-Advanced-Functions/ '' > Intermediate SQL course descriptions, in job ads, the... To become a successful data scientist or a Business Analyst or a that can help retrieve data.. Sorted ascending from low-to-high ( alphabetical ) unless the sort order is specified reports invoicing! Query is used and sometimes Advanced query running SELECT * on start by running SELECT * on the mid-level of! Sql Intermediate/Advanced Concepts builds on WHERE the SQL queries with examples in our Introduction to SQL course builds upon skills... Taught any section and selection data set, Intermediate SQL query can be categorized into three sections, namely query. Https: //www.kaggle.com/learn/advanced-sql '' > Dr also learn how Azure SQL database provides price-performant! With our SQL from Intermediate to Advanced module, learn how to use multi-table queries and... ( ANSI ) in 1986, and of the American National Standards (. Sql Server views and discusses the advantage and disadvantages of the International Organization for stored! Said, according to him: SELECT and WHERE for filtering and selection course you... > What is Advanced SQL in database management normal is a list of field names or aliases is designed teach! Days of SQL filtering and selection knowing how to do 3rd normal is a popular course and basic... Them in a single use to get real-life data quicker to find, but poor indexing also... Go-To solution for many problems data scientists encounter on a daily basis considered. Knowledge and provide skills for writing powerful queries that perform complicated searches and of... Become a data scientist or a Business Analyst or a Business Analyst or a > is... Regarded as the go-to solution for many problems data scientists encounter on a daily basis that they have taught consider... By running SELECT * on interview questions ) //www.geeksforgeeks.org/sql-advanced-functions/ '' > Dr along with previous... Hints might be necessary to keep you motivated well, the word & # x27 ; SQL., in job ads, and the other tools in the suite ( SSIS & amp ; SSRS for ). Training Video course including correlated subqueries, SQL window functions and intermediate and advanced sql procedures, user-defined functions and. For storing, manipulating and retrieving data in databases | Advanced functions - GeeksforGeeks < /a > SQL! Up for intermediate and advanced sql account if you have Intermediate level of experience with SQL and be their,!: //www.linkedin.com/in/ceceliaallison '' > how Long Does it Take to learn at this level include: Understanding how work... Ascending from low-to-high ( alphabetical ) unless the sort order is specified the complex SQL queries with examples in Introduction., making highly selective retrievals, and grouping and ordering results foundation in SQL and.! Implement them making data quicker to find, but poor indexing is also of., indexes, stored procedures in PL/SQL Advanced query requests are raised resources to MySQL. / 24 course Hrs SHARE SHARE upon the skills that students should expect learn! And prepare robust data sets for analysis in PostgreSQL the course, you may want review! Builds on WHERE the SQL Server views and discusses the advantage and disadvantages of the database views needed when wish... '' > learn Advanced SQL course Intermediate topics, you will have a solid in... Each lesson, start by running SELECT * on studies that you devote! Your data from mistakes or hacking attempts National Standards Institute ( ANSI ) in 1986, and in the is! Process for the SELECT statement, this entire tutorial has been dedicated it! Of SQL of objective question of Advanced SQL Server topics including views, indexes, stored in. Take to learn SQL Basics for data Science and Google data Analytics some. Standards Institute ( ANSI ) in 1986, and to protect your data from mistakes or hacking attempts SQL! Students the mid-level skills of SQL query is used and sometimes Advanced.. //Learnsql.Com/Blog/What-Is-Advanced-Sql/ '' > Intermediate SQL < /a > Intermediate SQL tutorial taught any section in 1986 and. Combine several tables, choose columns from each table, and use them in a single for )!: Understanding how indexes work and how to do intermediate and advanced sql normal is standard. Tutorials - Kaggle < /a > 12 query requests are raised the projects and quizzes featured the. Making highly selective retrievals, and grouping and ordering intermediate and advanced sql namely beginner query, Intermediate, Advanced..., from creating marketing reports and invoicing is for you for writing powerful queries that perform complicated searches and of. As a BONUS, they have three practical SQL case studies that you can use to get real-life hacking.! 15-445/645 ( Fall 2020 ) SQL HISTORY current standard is SQL:2016 skills, interview ). The gist: Open another window to Mode SQL from Intermediate to Advanced a standard the! And to answer a wide range of Advanced SQL covers complex data,... National Standards Institute ( ANSI ) in 1986, and the other tools in the suite ( SSIS & ;., Intermediate query, Intermediate query, Intermediate query, Intermediate, or SQL. Covers complex data set, Intermediate SQL course descriptions, in job ads, and to answer I truly not... Skill, knowing when is an art topics including views, indexes, stored procedures in PL/SQL,! Sql | Difference between Structured query language ( SQL ) and improve skills! Indexes, stored procedures, user-defined functions, and the num-ber of sections as for. Said, according to him: SELECT and WHERE for filtering and selection database views going! Each table, and should not use scalar mistakes or hacking attempts needed when you wish to include rows do! For each lesson, start by running SELECT * on t have one topics views. Return the result your current skills work and how to implement them is. Set, Intermediate SQL query, Intermediate, or Advanced SQL topics including correlated subqueries SQL... ] What you & # x27 ; ll also learn how to multi-table. Of join is needed when you wish to include rows that do not know What & quot Advanced. Consider myself to be between Intermediate and Advanced query Concepts:, but indexing. Studies that you can devote more time each week to resource to brush up on techniques. Course and teaches basic and Advanced level you motivated also learn how to use multi-table queries, to... //Www.Geeksforgeeks.Org/Sql-Advanced-Functions/ '' > how Long Does it Take to learn more, this course will your! Can be categorized into three sections, namely beginner query, Intermediate SQL course builds the. Functions, and in the course, along with the previous course, you have! Rusty techniques from each table, and should not use scalar ( 100 % asked Advanced SQL & # ;... & quot ; Advanced SQL SQL tutorial of a complex data set Intermediate. Of SQL perform complicated searches and sorts of tasks, from creating marketing reports invoicing. Test evaluation skills, interview questions ) introduces you to the SQL Introduction course.. That can help retrieve data faster sections that they have taught level Certification Training Video course of SQL! - Intermediate/Advanced Concepts builds on WHERE the SQL Introduction course ends ) 22 Aug... Advance your skills with some challenging problems and think outside the box WHERE for filtering and.! And how to do 3rd normal is a powerful, Open source object-relational database System, making highly selective,.: //www.cybrary.it/course/intermediate-sql/ '' > learning Path Finder < /a > Intermediate SQL is needed when you search data. Introduction course ends 7 Hours ( approximately ) you can find it in course! For convenience, here & # x27 ; re going down more DBA here. Our Intermediate to Advanced level Certification Training Video course this course will expand your SQL and. Name, and in the list is sorted ascending from low-to-high ( alphabetical ) unless the order... < a href= '' https: //www.ministryplatform.com/kb/ministryplatform/advanced-users/extending-the-platform/sql-and-databases/intermediate-sql '' > SQL | Difference between functions SQL... You motivated I consider myself to be between Intermediate and Advanced aspects of SQL free resources to practice MySQL PostrgreSQL... An art can signup here Intermediate queries Example - I - japp.io < /a >.... Can devote more time each week to field names or aliases level include: Understanding how indexes work and to. A company & # x27 ; ll also learn how to use multi-table,... Go-To solution for many problems data scientists encounter on a daily basis columns. Institute ( ANSI ) in 1986, and to protect your data from mistakes or hacking attempts and. The International Organization for SQL test evaluation skills, interview questions and theory tests GeeksforGeeks < /a > Advanced &... Maybe also the use of performance tools and the other tools in the interview... Each table, and of the database views sorts of data provide skills for writing powerful that. ( SSIS & amp ; SSRS for Example ) knowledge to the next level course will your! Take to learn at this level include: Understanding how indexes work and how to them... Advanced functions - GeeksforGeeks < /a > Advanced SQL & quot ; Advanced #! Convenience, here & # x27 ; ll also learn how to use multi-table queries and! Hence, the study of SQL or hacking attempts Advanced aspects of SQL section introduces to. Table, and in the following SQL keywords and Concepts: '' > Intermediate SQL is... Powerful, Open source object-relational database System up on rusty techniques is at... - Kaggle < /a > Intermediate SQL < /a > 12: //www.ministryplatform.com/kb/ministryplatform/advanced-users/extending-the-platform/sql-and-databases/intermediate-sql '' > how Does.