
Learning Path: SQL for Business Users – Learn SQLE for Business Users
Business users and analysts want quick, practical knowledge. Regarding SQL and database topics, they are more interested in how to use data rather than create it (this means SELECT statement is very relevant to them). As they progress they will likely want to know how to create their own databases, but only to a certain extent. The business logic of database design is likely to be what they are interested in. They may want to understand basic table design principles and a high level understanding of normalization. But security, administration, data theory, and other DBA / engineering tasks will probably not be relevant to them. Typically, when business users create a database for their business needs, they might hand it off to a DBA to put it into production if it is considered critical for the business.
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
Screenshot Tutorials/Courses
Info Tutorials/Courses
Manufacturer: O’Reilly / O’Reilly
Language of instruction: English
Lecturer: O’Reilly Media
education levels: elementary, intermediate, advanced
training time: 34 hours + 18 minutes
File size: 6480 MB
Download Tutorials/Courses
Download Link Google Drive Download Link Google Drive 2
Download Link OneDrive Download Link Mshare
Password : freetuts.download