SQL Server Intelligence: Cracking the Code of Enterprise Data

2h 14mBeginner2024-05-24

Authors

Walter Shields

Tech Educator and Best-Selling Author

Course details

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.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Why data The role of SQL and how you can get involved
02 - What you should know - Microsoft SQL Server and installation
03 - Environment orientation
04 - Introduction to CoderPad

1. How to Optimize Your DB Software

05 - Tweaking your settings
06 - Loading the database file

2. Get Familiar with Your Database and Its Data

07 - Getting familiar with your database
08 - The basic query structure and using aliases
09 - Aliases and sorting
10 - Common mistakes
11 - Solution - Crafting queries

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

12 - The WHERE clause - Finding numeric data
13 - The WHERE clause - Operators IN and BETWEEN
14 - The WHERE clause - Finding text data and using Wildcards
15 - The WHERE clause - Finding data using dates
16 - Solution - Date range and set analysis

4. Filter Data Based on More than One Condition

17 - Introducing AND and OR
18 - Solution - Filtering with logical operators

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

19 - Calculated columns
20 - The CASE statement
21 - Solution - Calculated columns and conditional logic

Conclusion

22 - Next steps