SQL Essential Training
Focused View
Walter Shields
4:43:42
93 View
001. The data-driven world.mp4
00:46
002. What you should know.mp4
02:25
003. Relational database theory.mp4
02:50
004. The SQLite database engine.mp4
03:04
005. WSDA Music (sample database).mp4
02:17
006. The DB Browser software.mp4
01:16
007. How to install DB Browser.mp4
01:53
008. Learning tips.mp4
01:41
009. How to access the DB Browser for SQLite software.mp4
01:06
010. Load the sample database file.mp4
02:29
011. Getting familiar with a database.mp4
02:59
012. The browse data area.mp4
02:11
013. The query writing area.mp4
02:32
014. Query commenting.mp4
01:54
015. The Query Concept.mp4
04:06
016. Query composition.mp4
07:53
017. Query composition best practices.mp4
03:12
018. Column custom names.mp4
04:23
019. Sorting query results.mp4
04:12
020. Limiting query results.mp4
03:12
021. Types of SQL operators.mp4
02:39
022. Filter and analyze numeric data.mp4
04:41
023. BETWEEN and IN operators.mp4
04:32
024. Filter and analyze text data.mp4
05:28
025. Search records without an exact match.mp4
07:02
026. Filter and analyze using dates.mp4
06:30
027. Filter records based on more than one condition.mp4
03:47
028. Logical operator OR.mp4
02:51
029. Brackets and order.mp4
06:17
030. IF THEN logic with CASE.mp4
11:09
031. Joins explained.mp4
01:49
032. How tables share a relationship Part 1.mp4
06:18
033. How tables share a relationship Part 2.mp4
04:49
034. Simplifying JOINs.mp4
05:51
035. Types of JOINs.mp4
02:55
036. The INNER JOIN.mp4
02:31
037. The LEFT JOIN.mp4
03:12
038. The RIGHT JOIN.mp4
03:47
039. Tables and Entity Relationship diagrams.mp4
04:43
040. Joining many tables.mp4
05:52
041. Calculating with functions.mp4
01:43
042. String, date, and aggregate function types.mp4
00:43
043. Connecting strings.mp4
05:14
044. Separating text.mp4
04:36
045. UPPER and LOWER string functions.mp4
02:12
046. Date functions.mp4
05:53
047. Aggregate functions.mp4
04:44
048. Nesting functions.mp4
03:10
049. Grouping your query results.mp4
00:58
050. Filtering with a grouped condition.mp4
05:59
051. Grouping with the WHERE clause.mp4
02:14
052. Grouping with the HAVING clause.mp4
04:40
053. Grouping with the WHERE and HAVING clause.mp4
03:14
054. Grouping by many fields.mp4
03:13
055. Subqueries and aggregate functions.mp4
01:22
056. SELECT clause subquery.mp4
06:01
057. WHERE clause subquery.mp4
05:43
058. Non-aggregate subqueries.mp4
03:35
059. IN clause subquery.mp4
04:03
060. DISTINCT clause subquery.mp4
06:56
061. View introduction.mp4
01:31
062. Creating a view.mp4
04:52
063. Editing a view.mp4
04:15
064. Joining views.mp4
03:18
065. Deleting views.mp4
02:11
066. Analysis and administration.mp4
01:38
067. Inserting data.mp4
05:52
068. Updating data.mp4
03:55
069. Deleting data.mp4
03:17
070. Project challenges.mp4
02:13
071. Project solution Part 1.mp4
03:20
072. Project solution Part 2.mp4
08:48
073. Project solution Part 3.mp4
07:16
074. Next steps and tips.mp4
01:59
Description
The ubiquity of big data means that now, more than ever, there is a burning need to warehouse, access, and understand the contents of massive databases quickly and efficiently. Attaining proficiency in SQL is essential to prepare for our data-driven present and future. It is also crucial to furthering your skills as a data analyst or application developer. In this course, Walter Shields teaches you: the basic structure of databases—what they are, how they work, and how to successfully navigate them; how to use SQL to retrieve and understand data no matter the scale of a database; and how to master the most important SQL query syntax, along with how and when to use it best.
More details
User Reviews
Rating
average 0
Focused display
Walter Shields
Instructor's CoursesWalter Shields is known as a Best-Selling Author, Mentor and SME in Data Analytics. He has over 25 years of experience training students and managing data systems for startups to Fortune 500 companies, from law to healthcare to big-box retail. Through his educational books and courses, Walter reaches a growing number of students and corporate organizations, training them to master skills and tools in data management, analysis, and visualization.
An expert in data analysis training & solutions, Walter is a published and Best-Selling Author of “SQL Quickstart Guide”.
Current partnerships include:
• Manning Publishing - New Data Analytics book to be published in 2023
• LinkedIn Learning Course Author - SQL and Data Analytics course to be released in 2023
• Microsoft Learn Partner - Power BI Data Visualization courses
With his passion for teaching, Walter continues to create simplified, uncomplex, fun and effective ways for his students to confidently command skills in data analytics.
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 74
- duration 4:43:42
- English subtitles has
- Release Date 2023/04/29
