A complete course in SQL with SQL server

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

This course will take you from novice to expert level in SQL development using SQL server

1. Introduction to the course and set up

1. Welcome to the course

2. What you will learn

3. How to learn the course

4. SQL server versions

5. Install SQL server

6. How to set up SQL server in the cloud on Azure

7. Install management studio

8. Install adventure works

9. How to use management studio

10. Azure data studio

2. Selecting, sorting and filtering data

1.1 selectingsyntaxandexamples.zip

1. Introduction

2. Select data from a table

3. Sort selected data

4. Data types

5. WHERE clause with comparison operators

6. Logical operators and NULL values

7. Logical operators and NULL values example

8. BETWEEN and IN functions

9. BETWEEN and IN function examples

10. LIKE function and wildcards

11. LIKE function and wildcard examples

12. Order of precedence

3. Calculations, data conversions, functions and logic

1.1 calculationssyntaxandexamples.zip

1. Introduction

2. Text concatenation and maths operators

3. String functions

4. String function examples

5. Date functions

6. Trigonometric functions

7. Trigonometric function examples

8. General maths functions

9. General maths function examples

10. Converting data types

11. Converting data type - examples

12. Decision logic

4. Grouping, aggregating and subqueries

1.1 groupingsyntaxandexamples.zip

1. Introduction

2. Aggregating and grouping data

3. Aggregating and grouping data examples

4. Subqueries

5. Subquery examples

6. Windows functions

7. Windows function examples

5. Table joins and unions

1.1 joinunionsyntaxandexample.zip

1. Introduction

2. Primary and foreign keys

3. Table relationships and cardinality

4. Inner join

5. Inner join - examples

6. Left and right outer joins

7. Left and right outer join - examples

8. Full outer and cross joins

9. Full outer and cross join - examples

10. Union and union all

6. Database architecture

1. Introduction

2. OLTP and normalisation

3. OLAP and star and snowflake architecture

7. DDL - databases, schemas, tables, indexes and CTEs

1.1 ddlsyntaxandexamples.zip

1. Indroduction

2. Databases - create and drop

3. Schemas - create and drop

4. Tables - create and drop

5. Columns - add, alter, and drop

6. Column constraints create

7. Column constraints alter

8. Column constraints drop

9. Primary key constraints

10. Foreign key constraints

11. Indexes

12. CTEs (common table expressions)

8. DML - insert, update and delete data

1.1 dmlsyntaxandexamples.zip

1. Introduction

2.1 sql_course.zip

2. Fast track route - restore backup file

3.1 Covid_Variant.csv

3.2 insertlists.zip

3. Insert data

4. Update data

5. Delete and truncate data

9. Advanced database features

1.1 advancefeaturessyntaxandexamples.zip

1. Introduction

2. Views

3. Stored procedures and parameters

4. Stored procedures with return values

5. Functions scalar

6. Functions - table valued

7. Locks, concurrency, ACID and transactions

8. Transactions

9. Cursors

10. XML

11. Trigger introduction and syntax

12. Trigger DML example

13. Trigger DDL example

10. Working with JSON data

1.1 jsonsyntaxandexamples.zip

1. Introduction

2. JSON structure and JSON path

3. JSON functions

4.1 jsondata.zip

4. JSON function and path - examples

5. Convert a table to JSON

6. Convert JSON to a table

11. Course review

1. Course review and what is next

139,000 تومان

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

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

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

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