Season 1- Database, SQL Server, T-SQL

Season 1: Database, SQL Server, T-SQL, available at $54.99, has an average rating of 4.65, with 38 lectures, based on 137 reviews, and has 23414 subscribers.

You will learn about Familiarise with what, how, and why of SQL Server Setting up SQL Server and SQL Server Management Studio for continuous learning Getting introduced to Transaction SQL SQL Basics through curated examples on Data Definition Language, Data Manipulation, and Select Queries Deep Dive into SQL queries and Utilities Learning has to be a continuous process This course is ideal for individuals who are Someone who wishes to gets introduced to the world of organized data or Interest to start from basics and develop interest towards SQL development, Database Design, Data Engineering, Data Science, Azure Solutions, AI ML Deep learning or Data Engineer enthusiasts, who wish to start their journey ground up It is particularly useful for Someone who wishes to gets introduced to the world of organized data or Interest to start from basics and develop interest towards SQL development, Database Design, Data Engineering, Data Science, Azure Solutions, AI ML Deep learning or Data Engineer enthusiasts, who wish to start their journey ground up.

Enroll now: Season 1: Database, SQL Server, T-SQL

Summary

Title: Season 1: Database, SQL Server, T-SQL

Price: $54.99

Average Rating: 4.65

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will Learn

Familiarise with what, how, and why of SQL Server

Setting up SQL Server and SQL Server Management Studio for continuous learning

Getting introduced to Transaction SQL

SQL Basics through curated examples on Data Definition Language, Data Manipulation, and Select Queries

Deep Dive into SQL queries and Utilities

Learning has to be a continuous process

Who Should Attend

Someone who wishes to gets introduced to the world of organized data

Interest to start from basics and develop interest towards SQL development, Database Design, Data Engineering, Data Science, Azure Solutions, AI ML Deep learning

Data Engineer enthusiasts, who wish to start their journey ground up

Target Audiences

Someone who wishes to gets introduced to the world of organized data

Interest to start from basics and develop interest towards SQL development, Database Design, Data Engineering, Data Science, Azure Solutions, AI ML Deep learning

Data Engineer enthusiasts, who wish to start their journey ground up

This course introduces concepts around SQL Server, uses of SQL Server Management Studio and intends to get you familiar with applications of Transact-SQL. Consider this as your first Season amongst the many to follow, leading a path to Database, SQL, Reporting, Automation, Data Engineering, and Data Science.

Make the most out of this course by making sure you time block learning sessions into your daily routine. Additionally do not forget to share feedback and drop a message in case you feel there are any areas of improvement within the course curriculum.

The design of the courses is such that, it’s been partitioned into Seasons, this being the first of multiple to follow. The first Season focuses on breaking the barriers and forming a solid foundation on the concepts of SQL Server. We start right from basics of installing an instance in our local computer, and then moving on to introducing SQL Server Management Studio.

We will mostly use SSMS throughout this course. As we move ahead we will dissect what is SQL and Transact-SQL, what the basic types of statements viz. Data Definition Language, Data Manipulation Language, and Select. From basics to just about all the practical examples that you need to follow, to start your journey into the data ecosystem.

Course Curriculum

Chapter 1: Introduction and Basics

Lecture 1: S01E01. Season 1 Content

Lecture 2: S01E02. DBMS, SQL Server Basics

Chapter 2: Deep dive into Setup Essentials

Lecture 1: S01E03. Installation Setup, SQL Server Components

Lecture 2: S01E04. Installing SQL Server

Lecture 3: S01E05. Service & Service Accounts

Lecture 4: S01E06. Installing SSMS

Lecture 5: S01E07. SQL Browser Firewall Configuration

Chapter 3: Database, Tables and Querying

Lecture 1: S01E08. Database Table Introduction

Lecture 2: S01E09. SSMS is handy

Lecture 3: S01E10. Querying in SSMS

Chapter 4: T SQL Statements

Lecture 1: S01E11. CREATE USE INSERT BATCH GO

Lecture 2: S01E12. SELECT Statements

Lecture 3: S01E13. SQL Wildcard

Lecture 4: S01E14. ORDER by in SQL, TOP N, OFFSET N ROWS

Chapter 5: SQL Deep Dive & Utilities

Lecture 1: S01E15. SQL Function Sub Query

Lecture 2: S01E16. DDL DML

Lecture 3: S01E17. Import Export

Chapter 6: Schemas and Temporary Tables

Lecture 1: S01E18. Introducing Database Schema

Lecture 2: S01E19. Temp Table

Chapter 7: Data Types: an Overview

Lecture 1: S01E20. Introduction to Data Types

Lecture 2: S01E21. Deep Dive into using Datatypes: A practical approach

Chapter 8: Constraints: The Gatekeeper of Quality

Lecture 1: S01E22. Constraints: An Overview

Lecture 2: S01E23. Constraints: Deep Dive into Practical Implementation

Chapter 9: Index: the guide to query operations

Lecture 1: S01E24. Index: Introduction

Lecture 2: S01E25. Index: Practical Review

Chapter 10: Joins: Made Simple with Practical Examples

Lecture 1: S01E26. Joins: Lets Introduce

Lecture 2: S01E27. Inner Join: Match & Combine

Lecture 3: S01E28. Outer Join: LEFT, RIGHT & FULL

Lecture 4: S01E29. Cross Join: An Unbiased Combination

Lecture 5: S01E30. Joins: The Practical Approach

Chapter 11: Join Operators in SQL Server: The Algorithm and brain behind all our Joins

Lecture 1: S01E31. Introduction to Join Operators

Lecture 2: S01E32. Nested Loop Operator

Lecture 3: S01E33. Merge Join Operator

Lecture 4: S01E34. Hash Match Operator

Lecture 5: S01E35. Summarising Join Operator Types

Lecture 6: S01E36. Join Operators In action

Chapter 12: Group By and Having: Analyse data by dimensions

Lecture 1: S01E37. Introducing Group By and Having: Practical Case Study

Lecture 2: S01E38. Roll Up, Cube and Grouping: Our timer saver functional utilities

Instructors

The dataFactory
..lets learn, build, and share together

Rating Distribution

1 stars: 2 votes

2 stars: 3 votes

3 stars: 14 votes

4 stars: 43 votes

5 stars: 75 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!