SQL for Developers and Analysts with MS SQL Server

سرفصل های دوره

Guide for beginners to intermediate using real life examples

1. Chapter 1

1. Welcome!

2. Introduction

1. Section 1 - Introduction

2.1 1-cia-factbook-schema.zip

2.2 2-cia-factbook-data.zip

2. Course resources.html

3. What is a database

4. What is the difference between different Editions of SQL Server

5. How to Installing MS SQL Server and SSMS

6. What an SSMS environment looks like Important Short cuts

7.1 1-cia-factbook-schema.zip

7.2 2-cia-factbook-data.zip

7. How to create the course sample database

8. How Why comments in SQL

9.1 lecture1.zip

9. Basic SQL query structure

10. Quiz 1 Databases and SQL Basics.html

3. SELECT and ORDER BY clauses

1. Section 2 - Introduction

2.1 lecture2.zip

2. How to use a basic SELECT clause

3. How to select all columns

4. Select all columns.html

5. How to select some columns using column name and display only the top n values

6. Select only some columns.html

7. How to change column headings and perform mathematical operations in SELECT

8. How to use other built in functions in SELECT clause

9. Conditional evaluations in SELECT clause

10. How to filter duplicate in SELECT clause

11. How to use a basic ORDER BY clause

12. Sort SQL result by a columns.html

13. Section 2 - Exercise

14.1 section2-excercise-solution.zip

14. Section 2 - Exercise solution

15. Quiz 2 SELECT and ORDER BY Clauses in SQL.html

4. WHERE Clause

1.1 lecture3.zip

1. How to use the basic WHERE clause

2. How to handle different conditions in WHERE clause

3. How to use Boolean operators AND, OR, NOT

4. How to use LIKE operator to filter rows that match a certain pattern

5. How to use IN operator in WHERE clause

6. How to use EXISTS operator in WHERE clause

7. How to use BETWEEN operator in WHERE clause

8. How to handle NULL in WHERE clause

9. Quiz 3 WHERE Clause in SQL.html

10.1 section3-excercise-solution.zip

10. Section 3 - Exercise solution

5. GROUP BY and HAVING Clauses

1.1 lecture4.zip

1. How to use a basic GROUP BY clause

2. How to write sub queries combined with in GROUP BY clause How to use aggregat

3. How to use aggregate functions in ORDER BY

4. How to use a basic HAVING clause

5.1 section4-excercise-solution.zip

5. Section 4 - Exercise solution

6. Quiz 4 GROUP BY and HAVING Clauses in SQL.html

6. FROM Clause

1.1 lecture5.zip

1. How to use a basic FROM clause

2. How to use AS or table alias in FROM clause

3. Using simple JOIN

4. Execution order in SQL Server

5. Quiz 5 FROM Clause in SQL.html

7. Create Tables, Relationships and Views

1.1 lecture6.zip

1. CREATE TABLE

2. ALTER tables add columns and change table name and DROP tables

3. How to Create Temporary Tables

4. How to Create Table Relationships and How to Creating a Database Diagram

5. Constraints in SQL Server

6. Indexes in SQL Server

7. How to Create Views

8. How to Grant and Revoke Permissions to Users in SQL Server

9. Create Tables and Relationships.html

8. Joins

1.1 lecture7.zip

1. How to use INNER JOIN or simply JOIN

2. How to use LEFT OUTER JOIN and RIGHT OUTER JOIN

3. What is FULL OUTER JOIN and CROSS JOIN

4. How to use Subqueries in FROM clause and join tables using a WHERE clause

5. How to use CROSS APPLY in FROM clause

6. How to Use Set Operations UNION, INTERSECT and EXCEPT

7. Type Casting

8. Joins in SQL.html

9. INSERT, UPDATE, and DELETE Data

1.1 lecture8.zip

1. Using a basic INSERT INTO, INSERT SELECT, and SELECT INTO to Create a New Table

2.1 Students.csv

2. Import data from external file

3. Using a basic UPDATE clause and UPDATE with WHERE clause

4. Using a basic DELETE clause and DELETE with WHERE clause

5. Using OUTPUT operator to log inserteddeleted data to a different table

6. Quiz 8 INSERT, UPDATE & DELETE data in SQL.html

10. Advanced Topics

1.1 lecture9.zip

1. What is the purpose of using WITH(NOLOCK) in SQL Server

2. What is a difference BN UNION and UNION ALL in SQL Server

3. How to use Variables and Table Variables in SQL Server

4. How to use CURSORS in SQL Server

5. How to use Transaction and safe DELETE in SQL Server

6. How to create Functions in SQL Server

7. How to create Stored Procedures in SQL Server

8. Working with some of SQL Server built-in Functions

9.1 SixthDatabase-bak.zip

9. How to BackupRestore Databases in SQL Server

10.1 Country-GDP-xlsx.zip

10. How to create Reports in Excel from data in SQL Server

11.1 Country-GDP-SSRS.zip

11. How to create SSRS Reports from data in SQL Server

12.1 Country-GDP-twbx.zip

12. How to create Tableau Reports from data in SQL Server

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy