SQL Made Simple: SQL Server Queries for Non-Programmers

Master SQL Queries, and Data Manipulation Without Any Programming Experience

Created by: IsáBel .
Microsoft Certified IT Professional. Trainer of 25 Years

What Will I Learn?

• Course SQL Script Included!
• SQL queries broken down into ACTIONABLE STEPS.
• Before you know it, you'll be scripting SQL queries on your own!
• WRITE SQL Queries in Your SQL Server Databases
• CREATE Select Queries
• FILTER with the WHERE Clause
• SORT Your Database Records
• GROUP Your Records
• USE Aggregate Functions
• LEARN Different Date Functions
• GET Familiar with Functions You Can Use with Strings
• LEARN How to Join Tables
• CREATE Subqueries
• CREATE Tables Using SQL
• INSERT Records Into Your Tables
• CREATE Views
• ... and more!

Requirements

• Download the databases to follow along. This is covered in the lecture, "Installing the Exercise Databases"
• Access to one of the following versions of SQL Server & SQL Server Management Studio
• ---------------------
• SQL Sever 2017
• SQL Server 2016
• SQL Server 2014
• SQL Server 2012
• SQL Server 2008 R2
• SQL Server 2008

Target audience

• This SQL course is for new SQL Server users who are not yet familiar with SQL syntax. This course is for those who will be gathering and mining for data, not for database administrators looking to learn about implementation, or security. No prior programming knowledge is needed. This course is probably not for you is you are looking to learn super advanced queries.
• This SQL course is not for you if you are already 100% comfortable with SQL.
• This SQL course is for SQL Server user who are looking to query databases.
• This SQL course is not for SQL user who are looking for information about database administration, or security policies.