Learning Path: SQL for Business Users

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 
– Conclusions 
– Getting Started 
– Data Model Development Process 
– Basic Data Modeling 
– Advanced Data Modeling 
– Create a UML Data Model 
– Translate A UML Data Model Into An IE Data Model
– Model Quality 
– Kinds Of Data Models 
– 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 
– Connecting To MySQL And Creating Your First Database 
– Introducing MySQL’s Data Types 
– Primary And Foreign Keys 
– Introducing PHP Joins – Introducing Subqueries – Introducing Subqueries – Introducing Subqueries – Introducing phpMyAdmin, MySQL Workbench, SQLyog 
– Creating, Retrieving, Updating And Deleting Data 
– Using String, Numeric, Temporal And Stored Functions

– 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 
– Advanced Querying To Answer Subtleties 
– Reporting From A Database 
– Creating Databases 
– Developing Applications With MSSQL 
– 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