Sql For Developers And Analysts

  1. Home
  2. Database-programming
  3. Sql For Developers And Analysts

Tags: Database Programming

Guide for beginners to intermediate using real life examples

Last updated 2022-01-10 | 4.1

- Hands-on learning of SQL and databases using Microsoft SQL Server
- Download a free copy of SQL Server 2017 Edition and setting up a working environment
- A basic structure of a SQL query structure

What you'll learn

Hands-on learning of SQL and databases using Microsoft SQL Server
Download a free copy of SQL Server 2017 Edition and setting up a working environment
A basic structure of a SQL query structure
Different SQL clauses in a way that will make more sense for you to follow
Create various objects in SQL Server including tables
views
functions
and stored procedures
Manage data in SQL Server and protect it
Query data
sort
restrict the output and build sub-queries
Manipulate data insert
delete and update works
Group and summarize your data
Advanced concepts in SQL and how you can be able to build reports using Excel
SSRS
and Tableau
Where to get help when you face errors and some career advice to work as a SQL developer or analyst

* Requirements

* A free Developer Edition of SQL Server 2017. (How to download and setup will be discussed in course)
* A free copy of SQL Server Management Studio 2017. (How to download and setup will be discussed in course)
* A computer running Windows Desktop or Windows Server:
* - Operating System Requirements: Windows 8
* 8.1
* 10 or Windows Server 2012
* 2016
* - Memory: Minimum: 1 GB
* Recommended: At least 4 GB
* - Hard Disk: requires a minimum of 6 GB of available hard-disk space.

Description

  • Hands-on learning of SQL and databases using Microsoft SQL Server
  • Download a free copy of SQL Server 2017 Edition and setting up a working environment
  • A basic structure of a SQL query structure
  • Different SQL clauses in a way that will make more sense for you to follow
  • Create various objects in SQL Server including tables, views, functions, and stored procedures
  • Manage data in SQL Server and protect it
  • Query data, sort, restrict the output and build sub-queries
  • Manipulate data insert, delete and update works
  • Group and summarize your data
  • Advanced concepts in SQL and how you can be able to build reports using Excel, SSRS, and Tableau
  • Where to get help when you face errors and some career advice to work as a SQL developer or analyst

Course content

11 sections • 79 lectures

Welcome! 1 lectures

Introduction 9 lectures

Section 1 - Introduction Preview 00:44

What is a database? Preview 00:58

What is the difference between different Editions of SQL Server? Preview 01:33

How to Installing MS SQL Server and SSMS? Preview 03:33

What an SSMS environment looks like? Important Short cuts Preview 08:57

How to create the course sample database? Preview 05:40

How/ Why comments in SQL? Preview 03:39

Basic SQL query structure Preview 02:35

Quiz 1: Databases and SQL Basics

This quiz measures how much you have learned from this section about what a database is and the basics of SQL

SELECT and ORDER BY clauses 12 lectures

Section 2 - Introduction Preview 00:37

How to use a basic SELECT clause? Preview 01:46

How to select all columns ? Preview 00:54

How to select some columns using column name and display only the top n values? Preview 01:17

How to change column headings and perform mathematical operations in SELECT? Preview 02:48

How to use other built in functions in SELECT clause? Preview 01:24

Conditional evaluations in SELECT clause Preview 02:50

How to filter duplicate in SELECT clause? Preview 01:07

How to use a basic ORDER BY clause? Preview 02:36

Section 2 - Exercise Preview 01:24

Section 2 - Exercise solution Preview 08:31

Quiz 2: SELECT and ORDER BY Clauses in SQL

This quiz measures how much you have learned from this section about SELECT and ORDER BY clauses

WHERE Clause 10 lectures

How to use the basic WHERE clause? Preview 01:32

How to handle different conditions in WHERE clause? Preview 00:47

How to use Boolean operators AND, OR, NOT? Preview 01:53

How to use LIKE operator to filter rows that match a certain pattern? Preview 01:18

How to use IN operator in WHERE clause? Preview 01:38

How to use EXISTS operator in WHERE clause? Preview 03:38

How to use BETWEEN operator in WHERE clause? Preview 01:32

How to handle NULL in WHERE clause? Preview 01:42

Quiz 3: WHERE Clause in SQL

This quiz measures how much you have learned from this section about the WHERE clause

Section 3 - Exercise solution Preview 14:39

GROUP BY and HAVING Clauses 6 lectures

How to use a basic GROUP BY clause? Preview 01:27

How to write sub queries combined with in GROUP BY clause? How to use aggregat Preview 02:39

How to use aggregate functions in ORDER BY? Preview 00:45

How to use a basic HAVING clause? Preview 00:45

Section 4 - Exercise solution Preview 26:59

Quiz 4: GROUP BY and HAVING Clauses in SQL

This quiz measures how much you have learned from this section about HAVING and GROUP BY clauses

FROM Clause 5 lectures

How to use a basic FROM clause? Preview 00:55

How to use "AS" or table alias in FROM clause Preview 00:36

Using simple JOIN Preview 01:16

Execution order in SQL Server Preview 01:15

Quiz 5: FROM Clause in SQL

This quiz measures how much you have learned from this section about the FROM clause

Create Tables, Relationships and Views 9 lectures

CREATE TABLE Preview 05:38

ALTER tables: add columns and change table name and DROP tables Preview 02:36

How to Create Temporary Tables? Preview 04:18

How to Create Table Relationships and How to Creating a Database Diagram? Preview 05:19

Constraints in SQL Server Preview 03:36

Indexes in SQL Server Preview 02:12

How to Create Views? Preview 01:48

How to Grant and Revoke Permissions to Users in SQL Server? Preview 09:34

Create Tables and Relationships

This quiz measures how much you have learned from this section about creating tables, views, relationships, SQL Server permissions.

Joins 8 lectures

How to use INNER JOIN or simply JOIN? Preview 01:29

How to use LEFT OUTER JOIN and RIGHT OUTER JOIN? Preview 02:14

What is FULL OUTER JOIN and CROSS JOIN? Preview 02:02

How to use Subqueries in FROM clause and join tables using a WHERE clause? Preview 04:12

How to use CROSS APPLY in FROM clause? Preview 01:58

How to Use Set Operations UNION, INTERSECT and EXCEPT? Preview 02:28

Type Casting Preview 04:08

Joins in SQL

This quiz measures how much you have learned from this section about SQL joins.

INSERT, UPDATE, and DELETE Data 6 lectures

Using a basic INSERT INTO, INSERT SELECT, and SELECT INTO to Create a New Table Preview 03:42

Import data from external file Preview 02:03

Using a basic UPDATE clause and UPDATE with WHERE clause Preview 01:59

Using a basic DELETE clause and DELETE with WHERE clause Preview 01:52

Using OUTPUT operator to log inserted/deleted data to a different table? Preview 01:59

Quiz 8: INSERT, UPDATE & DELETE data in SQL

This quiz measures how much you have learned from this section about data manipulation in SQL.

Advanced Topics 12 lectures

What is the purpose of using WITH(NOLOCK) in SQL Server? Preview 03:17

What is a difference B/N UNION and UNION ALL in SQL Server? Preview 01:21

How to use Variables and Table Variables in SQL Server? Preview 02:38

How to use CURSORS in SQL Server? Preview 03:19

How to use Transaction and safe DELETE in SQL Server? Preview 02:44

How to create Functions in SQL Server? Preview 02:27

How to create Stored Procedures in SQL Server? Preview 03:18

Working with some of SQL Server built-in Functions Preview 02:42

How to Backup/Restore Databases in SQL Server? Preview 02:05

How to create Reports in Excel from data in SQL Server? Preview 01:33

How to create SSRS Reports from data in SQL Server? Preview 02:43

How to create Tableau Reports from data in SQL Server? Preview 05:06

What is Next? 1 lectures

Where to get SQL help, job prospect in SQL, and Interview questions? Preview 05:10