Top Five Things to Know in SQL

Focused View

Walter Shields

2:21:25

89 View

01 - Introduction

01 - Why data The role of SQL and how you can get involved.mp4

01:23

02 - What you should know Microsoft SQL Server and installation.mp4

06:58

03 - Environment orientation.mp4

05:25

02 - 1. How to Optimize Your DB Software

01 - Tweaking your settings.mp4

08:57

02 - Loading the database file.mp4

06:09

03 - 2. Get Familiar with your Database and Its Data

01 - Getting familiar with your database.mp4

07:32

02 - The basic query structure.mp4

12:44

03 - Aliases and sorting.mp4

07:02

04 - Common mistakes.mp4

06:44

04 - 3. Understand Simple and Powerful Syntax to Filter and Analyze Data

01 - The WHERE clause Finding numeric data.mp4

06:51

02 - WHERE clause Operators IN and BETWEEN.mp4

06:06

03 - The WHERE clause Finding text data and using Wildcards.mp4

06:54

04 - The WHERE clause Finding data using dates.mp4

08:09

05 - 4. Filter Data Based on More than One Condition

01 - Introducing the AND and OR.mp4

06:57

02 - Challenge The heist!.mp4

01:16

03 - Solution The heist!.mp4

21:14

06 - 5. Analyze Data with Flexibility, Efficiency, and Calculated Fields

01 - Calculated columns.mp4

14:52

02 - The CASE statement.mp4

04:23

07 - Conclusion

01 - Where to go from here.mp4

01:49

Description

Now, more than ever, businesses need people who know data—how to warehouse, access, and analyze it quickly and efficiently. Getting up to speed with Microsoft SQL Server—the widely used database management system—can help you become a key player in today’s data-driven business world. In this course, instructor Walter Shields teaches you the five most important skills to know if you want to be a true SQL master.

Explore the basic structure of relational databases, how they work, their importance to business, and how to navigate them successfully to gather insights at any scale. Discover the top SQL queries you should know, and how and when to best use them on your own, including the WHERE clause and the operators IN, BETWEEN, AND, and OR. By the end of this course, you’ll be prepared to analyze big data more efficiently with ease.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Walter Shields

Instructor's Courses

Walter 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 Learning

LinkedIn 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.