Video description
If you’re looking for "just enough” SQL knowledge to wrangle data and do sophisticated analysis, this course is for you. You’ll get a solid understanding of basic database design principles and normalization. You’ll learn how to pipeline data to other analysis tools (R, Python, even Excel). You’ll be able to prototype a database that suits your business needs. and form accurate queries and database updates in several SQL environments--all without getting bogged down in the deeply technical aspects of SQL that you will never use.
Table of contents
- Getting Started With Databases And SQL
- Using SQL To Select And Filter Data
- Functions, Grouping And Summarizing
- Joining Tables
- Data Modification
- Creating And Altering Database Objects
- SQL Summary
- Conclusions
- The Warm Up
- Useful Skills
- The Subquery
- The CASE Statement
- Numbering And Ranking
- Functions
- Views
-
Stored Procedures
- What Is A Stored Procedure?
- Creating A Stored Procedure
- Running A Stored Procedure
- Stored Procedures Within Stored Procedures
- The Global Variables @@Identity And @@Rowcount
- Looping With WHILE And IF
- Dynamically Build SQL Statements
- TRY And CATCH For Error Trapping
- Cursors In Use - Part 1
- Cursors In Use - Part 2
- Use Of Transactions
- Conclusions
- Getting Started
- Data Model Development Process
- Basic Data Modeling
- Advanced Data Modeling
-
Create A UML Data Model
- Problem Statement
- Finding Classes
- Finding Associations - Part 1
- Finding Associations - Part 2
- Finding Generalizations
- Iterating And Refining The Model - Part 1
- Iterating And Refining The Model - Part 2
- Adding Attributes
- Cleaning Up Layout
- Simplifying The Model
- Evolving A Model - Part 1
- Evolving A Model - Part 2
- Enterprise Architect Techniques - Part 1
- Enterprise Architect Techniques - Part 2
- Enterprise Architect Techniques - Part 3
-
Translate A UML Data Model Into An IE Data Model
- Creating Subject Areas
- Creating Entity Types
- Creating Domains
- Adding Attributes - Part 1
- Adding Attributes - Part 2
- Creating Relationship Types - Part 1
- Creating Relationship Types - Part 2
- Creating Relationship Types - Part 3
- Subtyping
- Adding Alternate Keys
- Cleaning Up The Layout
- ERwin Techniques - Part 1
- ERwin Techniques - Part 2
- Model Quality
- Kinds Of Data Models
-
Database Design
- Schema Adjustments
- Attribute Details - Part 1
- Attribute Details - Part 2
- Attribute Details - Part 3
- Primary And Alternate Keys
- Indexes
- Referential Integrity - Part 1
- Referential Integrity - Part 2
- Check Constraints - Part 1
- Check Constraints - Part 2
- Views
- Other Aspects Of Design
- Self Assessment Test - Database Design
- Create A SQL Server Database
- Create An MS-Access Database
- Software Engineering
- Data Modeling Patterns
- Database Reverse Engineering
- Conclusion
- Introducing The Relational Database
-
Installing And Configuring MySQL
- Introduction To MySQL
- MySQL Features
- Installing MySQL - Introduction
- Downloading MySQL
- Installing MySQL - Part 1
- Installing MySQL - Part 2
- Configuring MySQL
- Setting The System Path - Part 1
- Setting The System Path - Part 2
- Installing MySQL On The Mac
- The Sakila Database
- Installing The Sakila Database
- Connecting To MySQL And Creating Your First Database
- Introducing MySQL's Data Types
- Primary And Foreign Keys
- Introducing phpMyAdmin, MySQL Workbench, SQLyog
- Creating, Retrieving, Updating And Deleting Data
- Using String, Numeric, Temporal And Stored Functions
- Introducing Subqueries
- Introducing SQL Joins
- Optimizing MySQL
- Importing, Exporting And Backing Up MySQL Databases
- Managing MySQL User Privileges
- Using PHP And MySQL
- About The Author
- Install And Setup MSSQL
- Exploring Adventureworks With SSMS
-
Answering Questions By Querying A Database
- Answering The Question Of Pay Inequality
- Inspecting Dependencies
- Inspecting Foreign Keys
- Executing Multiple Queries In Query Editor
- Counting Results From A Query
- Select Distinct
- Group By And Having
- Joining Tables
- Aliasing Tables In A Query
- Validating Joins And Join Types
- Computing The Average Pay Rate
- Order By
- Where
- Variables
- Querying Current Rate Change Date
- Join To A Sub Query
- Inequality In Current Wages
- Recap
- Advanced Querying To Answer Subtleties
- Reporting From A Database
-
Creating Databases
- National Stock Number Extract
- Create Database
- Drop Database
- SSMS Table Designer
- Create Table
- Drop Table
- Data Types
- Create Table National Stock Numbers
- Stored Procedures - SP_Rename
- Alter Table
- Importing Data - National Stock Number Extract
- Troubleshooting Importing Data
- Import Alternatives
- Backing Up The Database
- Backup With Select Into
-
Developing Applications With MSSQL
- Visual Studio Community Edition
- New Console Application
- Connecting To MSSQL
- Querying Data Old School
- Create Table In Code
- Create A Foreign Key
- Inserting Data Old School
- Installing Entity Famework
- Querying With Entity Framework
- SQL Server Profiler - What Is EF Doing
- EF Querying Data
- EF Inserting Data
- EF Updating Data
- EF Deleting Data
- Other Programming Languages
- Course Wrap Up
- Introduction
- SQL With Single Table Results Sets
- SQL With Multiple Tables
- R Packages And SQL-Like Results Set Processing
- Data Artifacts Using SQL And R
- Data Sources And Connections
- Additional Topics
- Conclusion
- Introduction
- Introduction To NoSQL
- Introduction To Phoenix
- Using Phoenix
- Advanced Phoenix
- Conclusion
Product information
- Title: SQL for Business Users
- Author(s):
- Release date: December 2016
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491979280
You might also like
video
SQL Fundamentals for Business Intelligence
Many of us know a bit of SQL. But when it comes to answering real-world business …
book
SQL for Data Analysis
With the explosion of data, computing power, and cloud data warehouses, SQL has become an even …
video
SQL for Any IT Professional
15+ Hours of Video Instruction Top-to-Bottom SQL Instruction in 15+ Hours of Video Training Overview Strong …
book
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by …