SQL for Non-Programmers

SQL for Non-Programmers

.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 1h 30m | 265 MB

Instructor: Julianne Thouin
Do you want to learn about SQL but aren't sure where to start? In this beginner-level course, instructor Julianne Thouin covers basic concepts of relational database design and explains how to write simple SELECT statements using joins and proper filtering. Julianne explains what SQL Server is and what it is used for. Next, she shows how tables in a relational database relate to one another through surrogate, primary, and foreign keys. Julianne teaches you how to tackle the most basic query possible. She explains how AND and OR logic applies to filtering queries on more than one data point, then discusses INNER joins and OUTER joins. Julianne covers how to use subqueries for filtering your results. She walks you through some commonly used examples of built-in functions. In conclusion, Julianne shows you how aggregate functions work using the GROUP BY and HAVING clauses.



[Fast Download] SQL for Non-Programmers

Related eBooks:
Big Data Analytics
Data Science and Digital Transformation in the Fourth Industrial Revolution
Text Mining with MATLAB?
Machine Learning and Big Data: Concepts, Algorithms, Tools and Applications
Mastering PostgreSQL 13 - Fourth Edition (Code Files)
Spring Cloud Data Flow: Native Cloud Orchestration Services for Microservice Applications on Modern
Distributed Data Warehousing Using Web Technology
Oracle Service Bus 11g Development Cookbook
Electronically Stored Information : The Complete Guide to Management, Understanding, Acquisition, St
How to Cheat at Securing SQL Server 2005 {Repost}
Data Protection and Privacy
Introduction to Information Visualization : Transforming Data Into Meaningful Information
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.