SQL Made Simple- SQL Server Queries for Non-Programmers

SQL Made Simple: SQL Server Queries for Non-Programmers, available at $54.99, has an average rating of 4.4, with 120 lectures, based on 513 reviews, and has 4200 subscribers.

You will learn about Course SQL Script Included! SQL queries broken down into ACTIONABLE STEPS. Before you know it, youll 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! This course is ideal for individuals who are 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. or This SQL course is not for you if you are already 100% comfortable with SQL. or This SQL course is for SQL Server user who are looking to query databases. or This SQL course is not for SQL user who are looking for information about database administration, or security policies. It is particularly useful for 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. or This SQL course is not for you if you are already 100% comfortable with SQL. or This SQL course is for SQL Server user who are looking to query databases. or This SQL course is not for SQL user who are looking for information about database administration, or security policies.

Enroll now: SQL Made Simple: SQL Server Queries for Non-Programmers

Summary

Title: SQL Made Simple: SQL Server Queries for Non-Programmers

Price: $54.99

Average Rating: 4.4

Number of Lectures: 120

Number of Published Lectures: 120

Number of Curriculum Items: 120

Number of Published Curriculum Objects: 120

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Course SQL Script Included!

SQL queries broken down into ACTIONABLE STEPS.

Before you know it, youll 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!

Who Should Attend

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.

Target Audiences

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.

Learn SQL

Querying SQL is an Essential?Skill for Any?Aspiring Database Professional.?

By the end of this course you will be able to BUILD QUERIES, CREATE TABLES, and PERFORM AGGREGATE CALCULATIONS.

You will learn how to JOIN TABLES together for more robust reporting, and how to CREATE VIEWS, and STORED PROCEDURES that let you save and reuse your queries.

So whether you are brand new to SQL, or need a refresher, this is SQL Made Simple, you will find this course highly useful, and easy to learn.

R E?S?O?U?R?C?E?S

? At the end of each section, you will find the SQL script used in that section, as well as Questions, to help reinforce what you learn and of course, the Answers. ?

? At the end of the course, you will find a Test Your Skills with even more questions and answers.

? Look for the Glossary of Terms Used In This Course to help you talk the talk.

Your SQL resources are here, so let’s get started!

T-SQL, SQL Server, Microsoft SQL

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: What is SQL?

Lecture 3: Getting Familiar with SQL Server Management Studio

Lecture 4: Installing the Exercise Databases

Lecture 5: Steps for a Successful Course

Chapter 2: SQL: SELECT

Lecture 1: The SELECT Syntax

Lecture 2: SELECT Statements

Lecture 3: Aliasing Columns

Lecture 4: DISTINCT

Lecture 5: Section SQL: SELECT

Lecture 6: Exercise: Lesson Lab Questions

Lecture 7: Exercise: Lesson Lab Answers

Chapter 3: SQL: WHERE

Lecture 1: The WHERE Syntax

Lecture 2: Understanding LIKE, %

Lecture 3: Understanding [ ]

Lecture 4: Understanding NOT, ^

Lecture 5: Understanding BETWEEN AND

Lecture 6: Understanding IN

Lecture 7: Understanding NULL, NOT NULL

Lecture 8: WHERE (1)

Lecture 9: WHERE (2)

Lecture 10: Section SQL: WHERE

Lecture 11: Exercise: Lesson Lab Questions

Lecture 12: Exercise: Lesson Lab Answers

Chapter 4: SQL: ORDER BY

Lecture 1: The ORDER BY Syntax

Lecture 2: ORDER BY

Lecture 3: Section SQL: ORDER BY

Lecture 4: Exercise: Lesson Lab Questions

Lecture 5: Exercise: Lesson Lab Answers

Chapter 5: Introduction to Aggregate Functions in SQL

Lecture 1: Aggregate Functions

Lecture 2: SUM

Lecture 3: COUNT

Lecture 4: MIN, MAX and AVG (Average)

Lecture 5: Section SQL: Aggregate Functions

Lecture 6: Exercise: Lesson Lab Questions

Lecture 7: Exercise: Lesson Lab Answers

Chapter 6: SQL: Date and Time Functions

Lecture 1: Displaying the Current System Date and Time

Lecture 2: Formatting Dates and Times Using CONVERT

Lecture 3: DAY, MONTH, YEAR Functions

Lecture 4: DATEPART

Lecture 5: DATEADD

Lecture 6: DATEDIFF

Lecture 7: Section SQL: Date and Time Function

Lecture 8: Exercise: Lesson Lab Questions

Lecture 9: Exercise: Lesson Lab Answers

Chapter 7: SQL: String Functions

Lecture 1: CONCAT

Lecture 2: LOWER and UPPER

Lecture 3: LEFT and RIGHT

Lecture 4: SUBSTRING

Lecture 5: LEN

Lecture 6: LTRIM, and RTRIM

Lecture 7: REPLACE

Lecture 8: Section SQL: String Functions

Lecture 9: Exercise: Lesson Lab Questions

Lecture 10: Exercise: Lesson Lab Answers

Chapter 8: SQL: Subqueries

Lecture 1: Subqueries

Lecture 2: Using EXISTS with Subqueries

Lecture 3: Section SQL: Subqueries

Lecture 4: Exercise: Lesson Lab Questions

Lecture 5: Exercise: Lesson Lab Answers

Chapter 9: Joining Tables Using SQL

Lecture 1: Introduction to Joins

Lecture 2: Common Types of Joins

Lecture 3: The JOIN Syntax

Lecture 4: Inner Joins

Lecture 5: Outer Joins

Lecture 6: Examples of Three or More Table Joins – UPDATED

Lecture 7: Aliasing Tables in Joins

Lecture 8: Union Joins

Lecture 9: Self Joins

Lecture 10: FAQ: Subqueries v. Joins

Lecture 11: Section SQL: Joining Tables with SQL

Lecture 12: Exercise: Lesson Lab Questions

Lecture 13: Exercise: Lesson Lab Answers

Lecture 14: How are you enjoying the course?

Chapter 10: SQL: Views

Lecture 1: Introduction to Views

Lecture 2: Creating Views

Lecture 3: Schemabinding

Lecture 4: Altering Views

Lecture 5: Dropping Views

Lecture 6: Section SQL: Views

Lecture 7: Exercise: Lesson Lab Questions

Lecture 8: Exercise: Lesson Lab Answers

Chapter 11: SQL: Stored Procedures

Lecture 1: Introduction to Stored Procedures

Lecture 2: Creating Stored Procedures

Lecture 3: Modifying Stored Procedures

Lecture 4: Dropping Stored Procedures

Lecture 5: Section SQL: Stored Procedures

Lecture 6: Exercise: Lesson Lab Questions

Lecture 7: Exercise: Lesson Lab Answers

Instructors

IsáBel .
Microsoft Certified IT Professional. Trainer of 21 Years

Rating Distribution

1 stars: 9 votes

2 stars: 9 votes

3 stars: 43 votes

4 stars: 180 votes

5 stars: 272 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!