Gethyn Ellis
Gethyn Ellis
  • 109
  • 39 269
SQL Essentials An Introduction to Writing SQL Queries
Are you new to the data profession? Are you looking to build your career in the data space but don’t know where to start?
Regardless of the type of job you want to pursue in the data industry, whether you are a DBA, Developer, BI Analyst, Data Engineer or data scientist, you will probably have to work with relational data and databases in some capacity. So you will need to know SQL.
In this session, I will introduce you to the Structured Query Language (SQL) to provide you with a place to start and begin your journey in learning SQL.
The session will use SQL Server and Transact-SQL, and we will get you started writing SQL Queries. You will learn
- Database fundamentals why it’s important to understand the database design and schema
- Simple SELECTS - Writing a SELECT statement from a single table
- Column Expressions - Column expressions and aliases
- Filter rows with WHERE
- Using LIKE for Wildcard searches
- Using ORDER BY to sort our results,
- Understanding NULLs and how to handle them
- Inner Joins - The most common type of join, we will retrieve data from more than one table in the same Query
If you want to begin writing SQL queries then this session is for you
Переглядів: 73

Відео

PHIT Webinars Real time Monitoring the SQL Server platform for FREE with TIG 20240222 125305 Meeting
Переглядів 12411 місяців тому
PHIT Webinars Real time Monitoring the SQL Server platform for FREE with TIG 20240222 125305 Meeting
SQL Monitoring Webinar With Rod Edwards
Переглядів 2011 місяців тому
SQL Monitoring Webinar With Rod Edwards
SQL Week Epsiode 3 Order By and NULL Values
Переглядів 13Рік тому
SQL Week Epsiode 3 Order By and NULL Values
Mastering SQL Queries Column expressions, WHERE Clause and the LIKE Statement
Переглядів 36Рік тому
Mastering SQL Queries Column expressions, WHERE Clause and the LIKE Statement
Mastering SQL: A Comprehensive Guide for Beginners - Simple SELECT
Переглядів 57Рік тому
Mastering SQL: A Comprehensive Guide for Beginners - Simple SELECT
Lessons Learned from writing our book - Building a Data Driven Culture: A Step by Step Guide
Переглядів 17Рік тому
Lessons Learned from writing our book - Building a Data Driven Culture: A Step by Step Guide
How to lead data driven change, the high level steps Webinar 20231019 123350 Meeting Recording
Переглядів 35Рік тому
How to lead data driven change, the high level steps Webinar 20231019 123350 Meeting Recording
PL 300 Row-level Security Demo
Переглядів 100Рік тому
PL 300 Row-level Security Demo
PL 300 Create Dashboard Demo
Переглядів 90Рік тому
PL 300 Create Dashboard Demo
PL 300 Manage Files and Datasets in Power BI Demo
Переглядів 71Рік тому
PL 300 Manage Files and Datasets in Power BI Demo
PL 300 Create and Manage Workspaces in Power BI Demo
Переглядів 105Рік тому
PL 300 Create and Manage Workspaces in Power BI Demo
PL 300 Identify Patterns and Trends in Power BI Demo
Переглядів 789Рік тому
PL 300 Identify Patterns and Trends in Power BI Demo
PL 300 Create Reports Demo
Переглядів 106Рік тому
PL 300 Create Reports Demo
PL 300 Optimize Model Performance Demos
Переглядів 81Рік тому
PL 300 Optimize Model Performance Demos
PL 300 Create Measures using DAX in Power BI Demo
Переглядів 202Рік тому
PL 300 Create Measures using DAX in Power BI Demo
PL 300 Design a Data Model in Power BI Demos | Build a Unified Data Model
Переглядів 273Рік тому
PL 300 Design a Data Model in Power BI Demos | Build a Unified Data Model
PL 300 Clean, Transform, and Load Data in Power BI | Power Query | ETL
Переглядів 883Рік тому
PL 300 Clean, Transform, and Load Data in Power BI | Power Query | ETL
PL 300 Prepare Data in Power BI Demos | Power Query
Переглядів 320Рік тому
PL 300 Prepare Data in Power BI Demos | Power Query
PL 300 Getting started with Power BI - Demo 1
Переглядів 81Рік тому
PL 300 Getting started with Power BI - Demo 1
A Step-by-Step Guide to Building a Data-Driven Culture in Your Business with Power BI
Переглядів 62Рік тому
A Step-by-Step Guide to Building a Data-Driven Culture in Your Business with Power BI
Explore Azure Synapse Analytics
Переглядів 365Рік тому
Explore Azure Synapse Analytics
Row level security in Power BI
Переглядів 1 тис.Рік тому
Row level security in Power BI
PHIT Football | The FPL Show | Gameweek 3
Переглядів 1592 роки тому
PHIT Football | The FPL Show | Gameweek 3
What is Power BI? | How can help with FPL? | Build a Killer Fantasy Football Team
Переглядів 3922 роки тому
What is Power BI? | How can help with FPL? | Build a Killer Fantasy Football Team
The Fantasy Premier League Show | Gameweek 2 | Putting the Human Into Technology | No Haaland no Cry
Переглядів 962 роки тому
The Fantasy Premier League Show | Gameweek 2 | Putting the Human Into Technology | No Haaland no Cry
Picking your Fantasy Premier League team | FPL Kickoff | PHIT Football show
Переглядів 962 роки тому
Picking your Fantasy Premier League team | FPL Kickoff | PHIT Football show
Don’t reject anything | Matt Simms | The Phit Podcast | Series 2
Переглядів 472 роки тому
Don’t reject anything | Matt Simms | The Phit Podcast | Series 2
Don’t wait for opportunities | The PHIT Podcast | Series 2 | Matt Simms
Переглядів 472 роки тому
Don’t wait for opportunities | The PHIT Podcast | Series 2 | Matt Simms
SQL Hour | Introduction to Writing SQL Queries | SELECTs | JOINS | WHERE | ORDER BY | NULL
Переглядів 592 роки тому
SQL Hour | Introduction to Writing SQL Queries | SELECTs | JOINS | WHERE | ORDER BY | NULL

КОМЕНТАРІ

  • @nicktode
    @nicktode 5 місяців тому

    Why do you pull the data first through powershell instead of connecting directly to the API inside of Powerbi?

  • @FPLExpression
    @FPLExpression 6 місяців тому

    hello, how to solve "connect-fpl" error if it doesn't work every other parameter seems to bring the values such as Get-FplPlayer, but connect-fpl brings Invoke-webrequest and invalid credential

  • @AhreeharanThinathyalan-ot3ov
    @AhreeharanThinathyalan-ot3ov 7 місяців тому

    Can I get the datasets for this to follow?

  • @jenya7united
    @jenya7united 9 місяців тому

    where you got the data?

  • @isaacr8163
    @isaacr8163 Рік тому

    "Promo SM" ⭐

  • @moreliasosa2358
    @moreliasosa2358 Рік тому

    Why does it repeat the last portion over and over?

    • @gethynellis
      @gethynellis 8 місяців тому

      No idea, I'll have to check, ther eis no reason for it to do that

    • @solomonngwenya9091
      @solomonngwenya9091 6 місяців тому

      @@gethynellis it is repeating, the section where you query the data you connected and display it on a graph, repeats over and over again that specific portion

  • @jpants5144
    @jpants5144 Рік тому

    Great coach and all round nice guy 👍

  • @Sebastian-kr3re
    @Sebastian-kr3re Рік тому

    'promo sm' 🤷

  • @tanas9439
    @tanas9439 Рік тому

    Where can I get the data for practice pls sir

    • @gethynellis
      @gethynellis Рік тому

      Most of the data comes from a databse called tailspin toys which I think is on the MSFT git hub site

  • @stevewilliams9753
    @stevewilliams9753 2 роки тому

    Hi Gethyn, Have just watched your presentation for Chester Data Insights PBI User Group. Is the pbix file you created available for download?

    • @gethynellis
      @gethynellis 2 роки тому

      Not yet Steve it’s on my to do list to put on my GitHub site

  • @alistairsergeant4813
    @alistairsergeant4813 2 роки тому

  • @lynnellbonaguidi3836
    @lynnellbonaguidi3836 2 роки тому

    ᑭᖇOᗰOᔕᗰ 👉

  • @gethynellis
    @gethynellis 2 роки тому

    You can read the post here www.gethynellis.com/2022/08/phit-football-the-fpl-show-gameweek-2.html

  • @LucasCobb
    @LucasCobb 2 роки тому

    What field are you using to create the relationship between the player table and the fixtures table?

  • @gethynellis
    @gethynellis 2 роки тому

    You can sign up for the Power BI Fun and Games league here fantasy.premierleague.com/leagues/auto-join/meip1y

  • @sivaranjjan2491
    @sivaranjjan2491 2 роки тому

    Hi, I hav a table with 3 columns- home team,scorecard,away team. Now i want a slicer to display team names and based on the selection of team from slicer the table visual will display all the matches played in home n away by tht team. how to achieve ths?

    • @gethynellis
      @gethynellis 2 роки тому

      You probably need another table in your model called club, with a relationship to home and away teams. Probably the place to start.

    • @sivaranjjan2491
      @sivaranjjan2491 2 роки тому

      @@gethynellis Thanks for your reply. That makes one relationship active n another inactive. So choosing a team from slicer shows the results of only active relationship table

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog with Podcast here www.gethynellis.com/2021/12/dont-get-chased-down-a-path-rob-dobell-phit-podcast.html

  • @gethynellis
    @gethynellis 3 роки тому

    We have a blog to go with this episode, you can check it out here www.gethynellis.com/2021/12/going-live-is-just-the-beginning-phit-podcast-carl-grieves-part-2.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog here too www.gethynellis.com/2021/11/never-turn-an-opportunity-down.html

  • @gethynellis
    @gethynellis 3 роки тому

    I really like this question - How would you answer it?

  • @markwilliams344
    @markwilliams344 3 роки тому

    Next time we'll fix the video not being a visible as it should…and some don't like the "ticker tape" at the end so maybe we'll try something different for the start / end too…we also "know" that the audio and content need to keep pace with each other and allow enough time for people to "understand it" whether they engage visually, through audibly or through seeing.

  • @markwilliams344
    @markwilliams344 3 роки тому

    Hopefully gets some handy hits and tips across? Thoughts anyone? FYI with these "free guides"...we're trying out our "techniques" for getting knowledge and training across using a combination of Video / Audio / Music and of course engaging Content, in preparation for some higher value project and technical related training content currently work in progress. Hence would much welcome anyone's thoughts on what they like / don't and so on...

  • @markwilliams344
    @markwilliams344 3 роки тому

    Some interesting observations from Joel Abbott and Steve Styles particularly around Skills, Adoption and perhaps…the future convergence of Canvas and Model Drive app's

    • @gethynellis
      @gethynellis 3 роки тому

      Yep its a really interesting conversation

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog post here www.gethynellis.com/2021/08/power-query-simple-transformations.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can also join the league using this code apdxnm

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog post here www.gethynellis.com/2021/08/phit-football-data-sources-apis-and-powershell.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can view the blog post here www.gethynellis.com/2021/07/continous-improvement-tim-golbourn.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog for this post here

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog and get all the links mentioned in the video here www.gethynellis.com/2021/07/blogs-on-the-pod-dataweekender-4-2.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog post to go with this eipsode here www.gethynellis.com/2021/07/the-three-most-important-things.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog post about this episode here www.gethynellis.com/2021/07/its-all-about-communication-john-stenton-part-1.html

  • @GlennBerrySQL
    @GlennBerrySQL 3 роки тому

    Hi Gethyn! If you are going to have a camera view of yourself in the video, you might want to make it slightly larger. I watched this on a desktop system, but think about people watching it on mobile phones. Good luck with your channel!

    • @gethynellis
      @gethynellis 3 роки тому

      Thanks Glenn - yes I probably should make it a bit bigger. I will keep that in mind next time.

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the associated blog post here www.gethynellis.com/2021/07/sql-server-2016-is-out-of-mainstream-support.html

  • @dbamentorparag
    @dbamentorparag 3 роки тому

    Thanks for your valuable time

    • @gethynellis
      @gethynellis 3 роки тому

      Thanks Parag, I hope you like it.

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog here www.gethynellis.com/2021/07/the-top-1-tip-to-better-promote-your-sql-server-blog.html

  • @gethynellis
    @gethynellis 3 роки тому

    There is a blog post with the presentation, you can read it here www.gethynellis.com/2021/07/four-sql-server-problems-you-might-be-suffering-from-petchakutcha-style.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog post associated with Edwin's Back to Basics podcast herewww.gethynellis.com/2021/07/back-to-basics-edwin-sarmiento.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the transacript and the blog post here www.gethynellis.com/2021/06/putting-the-human-into-technology-with-simon-grosse-and-liz-rogers.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog here www.gethynellis.com/2021/06/you-dont-need-a-degree-to-work-in-it.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog post that goes with this video here www.gethynellis.com/2021/05/season-1-episode-1-the-phit_podcast.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read a summary of the blog post here, do remember to subscribe so you get the latest recordings as they are published www.gethynellis.com/2021/06/the-phit-podcast-with-ben-kite-ive-got-a-brand-new-car.html

  • @gethynellis
    @gethynellis 3 роки тому

    The blog that goes with Dave's interview is here www.gethynellis.com/2021/05/the-phit-podcast-with-dave-rawle-the-chief-meddler.html

  • @gethynellis
    @gethynellis 3 роки тому

    You can read the blog here www.gethynellis.com/2021/05/the-phit-podcast-simon-jones-the-coachs-coach.html

  • @gethynellis
    @gethynellis 4 роки тому

    You can signup for the webinar here www.eventbrite.co.uk/e/pay-less-get-more-a-guide-to-sql-server-licensing-tickets-104451760026

  • @gethynellis
    @gethynellis 4 роки тому

    If you want to attend please register using this meetup link www.meetup.com/Data-Community-Weekender-Europe/events/269951016/

  • @gethynellis
    @gethynellis 4 роки тому

    You can visit the website here www.dataweekender.com/

  • @gethynellis
    @gethynellis 4 роки тому

    www.eventbrite.co.uk/e/skypedarts-tournament-tickets-100911509040

  • @gethynellis
    @gethynellis 5 років тому

    SQL Server 2008 and SQL Server 2008 R2 go out of support today. Come and register for my free webinar being held on 31st July at midday UK time to discuss the options you have for upgrading www.eventbrite.co.uk/e/sql-server-2008-r2-d2-the-sequel-tickets-64797326548

  • @gethynellis
    @gethynellis 5 років тому

    SQL Server 2008 and SQL Server 2008 R2 go out of support today. Come and register for my free webinar being held on 31st July at midday UK time to discuss the options you have for upgrading www.eventbrite.co.uk/e/sql-server-2008-r2-d2-the-sequel-tickets-64797326548