- 109
- 39 269
Gethyn Ellis
United Kingdom
Приєднався 2 січ 2012
We help IT leaders and their team design and manage their Microsoft data platform allowing them the time to drive business value from their data.
We specialise in Microsoft SQL Server and Microsft Azure. We are a Microsoft Partner and offer a range of Microsoft Data Platform Migrations / Upgrades, Training and Consultancy solutions and services to help you manage and maintain your Platform environment.
The Data platform technology includes
SQL Server
Azure SQL Database
Power BI
This is the home of the Putting the Human Into Technology Podcast (The PHIT Podcast)
We specialise in Microsoft SQL Server and Microsft Azure. We are a Microsoft Partner and offer a range of Microsoft Data Platform Migrations / Upgrades, Training and Consultancy solutions and services to help you manage and maintain your Platform environment.
The Data platform technology includes
SQL Server
Azure SQL Database
Power BI
This is the home of the Putting the Human Into Technology Podcast (The PHIT Podcast)
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
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 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 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
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
Why do you pull the data first through powershell instead of connecting directly to the API inside of Powerbi?
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
Can I get the datasets for this to follow?
where you got the data?
"Promo SM" ⭐
Why does it repeat the last portion over and over?
No idea, I'll have to check, ther eis no reason for it to do that
@@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
Great coach and all round nice guy 👍
'promo sm' 🤷
Where can I get the data for practice pls sir
Most of the data comes from a databse called tailspin toys which I think is on the MSFT git hub site
Hi Gethyn, Have just watched your presentation for Chester Data Insights PBI User Group. Is the pbix file you created available for download?
Not yet Steve it’s on my to do list to put on my GitHub site
❤
ᑭᖇOᗰOᔕᗰ 👉
You can read the post here www.gethynellis.com/2022/08/phit-football-the-fpl-show-gameweek-2.html
What field are you using to create the relationship between the player table and the fixtures table?
You can sign up for the Power BI Fun and Games league here fantasy.premierleague.com/leagues/auto-join/meip1y
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?
You probably need another table in your model called club, with a relationship to home and away teams. Probably the place to start.
@@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
You can read the blog with Podcast here www.gethynellis.com/2021/12/dont-get-chased-down-a-path-rob-dobell-phit-podcast.html
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
You can read the blog here too www.gethynellis.com/2021/11/never-turn-an-opportunity-down.html
I really like this question - How would you answer it?
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.
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...
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
Yep its a really interesting conversation
You can read the blog post here www.gethynellis.com/2021/08/power-query-simple-transformations.html
You can also join the league using this code apdxnm
You can read the blog post here www.gethynellis.com/2021/08/phit-football-data-sources-apis-and-powershell.html
You can view the blog post here www.gethynellis.com/2021/07/continous-improvement-tim-golbourn.html
You can read the blog for this post here
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
You can read the blog post to go with this eipsode here www.gethynellis.com/2021/07/the-three-most-important-things.html
You can read the blog post about this episode here www.gethynellis.com/2021/07/its-all-about-communication-john-stenton-part-1.html
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!
Thanks Glenn - yes I probably should make it a bit bigger. I will keep that in mind next time.
You can read the associated blog post here www.gethynellis.com/2021/07/sql-server-2016-is-out-of-mainstream-support.html
Thanks for your valuable time
Thanks Parag, I hope you like it.
You can read the blog here www.gethynellis.com/2021/07/the-top-1-tip-to-better-promote-your-sql-server-blog.html
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
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
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
You can read the blog here www.gethynellis.com/2021/06/you-dont-need-a-degree-to-work-in-it.html
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
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
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
You can read the blog here www.gethynellis.com/2021/05/the-phit-podcast-simon-jones-the-coachs-coach.html
You can signup for the webinar here www.eventbrite.co.uk/e/pay-less-get-more-a-guide-to-sql-server-licensing-tickets-104451760026
If you want to attend please register using this meetup link www.meetup.com/Data-Community-Weekender-Europe/events/269951016/
You can visit the website here www.dataweekender.com/
www.eventbrite.co.uk/e/skypedarts-tournament-tickets-100911509040
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
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