Season 1: Database, SQL Server, T-SQL
- Description
- Curriculum
- FAQ
- Reviews
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.
-
1
S01E01. Season 1 ContentIn this episode we list down everything that forms a part of our course curriculum, and also introduce you to The dataFactory and myself
00:00 Welcome to The dataFactory co
00:10 Season 1 Course Highlights (Getting Started with SQL Server & Transact SQL)
01:01 Season 1 Course Continued (SQL Server & Transact SQL Intermediate & Advanced)
02:01 Season 2 teaser: Performance & Query Tuning
02:32 Season 3 teaser: Azure SQL Development
02:58 About The dataFactory and myself
-
2
S01E02. DBMS, SQL Server Basics
Introducing:
Database Management System (DBMS)
Database Types
SQL Server and its advantages
Transact SQL
-
3
S01E03. Installation Setup, SQL Server Components
Setup required for SQL Server instance
A peek inside SQL Server
SQL Server Components
SQL Server Integration Services
SQL Server Analysis Services
SQL Server Reporting Services
Database engine SQL
Server Agent
00:00 Welcome to The dataFactory
00:11 Recap Season 1
00:36 Discuss about the Setup for practice
01:20 System Requirements
02:17 Peek into a typical SQL Server
04:00 Summary of steps we will follow
-
4
S01E04. Installing SQL Server
SQL Server installation steps
Evaluation Edition
Developer Edition
-
5
S01E05. Service & Service Accounts
Introducing to
Services in SQL Server
Service Accounts
Server Authentication
Database Authorization and Login
-
6
S01E06. Installing SSMS
Detailed steps
on how to install SQL Server Management Studio (SSMS)
Connecting to remote server on Azure
-
7
S01E07. SQL Browser Firewall Configuration
A short video to explain windows firewall configurations required for SQL Server instances and SQL Browser
-
8
S01E08. Database Table Introduction
Introducing SQL Server, Database, Tables, Columns, SQL
00:00: Welcome to The dataFactory co
00:11: Previously on The dataFactory
00:40: This episode
01:56: Inside an instance of SQL Server
05:29: Introducing Transact SQL
06:56: Types of SQL Statements | Data Definition Language | CREATE, ALTER, DROP
08:25: Data Manipulation Language | INSERT, UPDATE, DELETE
09:14: Introducing SQL SELECT Statement
-
9
S01E09. SSMS is handy
Ways in which we can use UI features in SQL Server Management Studio to our benefit
-
10
S01E10. Querying in SSMS
Lets start query SQL Server Management Studio and introduce Data Definition Language
-
11
S01E11. CREATE USE INSERT BATCH GO
We start introducing,
Data Definition Language:
CREATE statement
USE statement
INSERT INTO statement
BATCH & TRANSACTIONS
GO in T-SQL
-
12
S01E12. SELECT Statements
SQL SELECT Queries
Aliasing Column Names
Introducing WHERE clause
Conditionals and Comparators
AND, OR, IN, NOT IN clause
is NULL, is not NULL
BETWEEN, not BETWEEN
-
13
S01E13. SQL Wildcard
Introducing SQL Wildcard Operators
Pattern Recognition for Text
LIKE %
NOT LIKE %
Using brackets %[ ]%
-
14
S01E14. ORDER by in SQL, TOP N, OFFSET N ROWS
ORDER BY in SQL Query
Using TOP to sample resulting records from SQL query
Using OFFSET to exclude rows from SQL query records
-
15
S01E15. SQL Function Sub Query
Introducing SQL Function Sub Query
-
16
S01E16. DDL DML
DML queries:[already introduced INSERT]
UPDATE SET
DELETE FROM
DDL queries:[already introduced CREATE DB, TABLE]
TRUNCATE TABLE-- reinitialises, so DDL
ALTER TABLE ADD
ALTER TABLE ALTER COLUMN
ALTER TABLE DROP COLUMN
DROP TABLE
-
17
S01E17. Import Export
Import Data from Excel to Database using SSMS and SSIS
Export Data from Database to Excel using SSMS and SSIS
-
18
S01E18. Introducing Database Schema
Introducing
Database Schema
Creating Database Schema
Alter Schema of Database Table
Use of SQL Synonym
00:00 Welcome to The dataFactory
00:11 Recap Season 1
00:51 Skip Intro & Recap
01:06 Introduction to Database Schemas
03:39 Creating Database Schema using SQL
09:50 Alter Schema of a Database Table
11:12 Two Part Three Part Four Part Naming Convention in SQL
13:39 Introducing use of Synonym for aliasing objects in SQL
-
19
S01E19. Temp Table
Introducing Temporary Tables in Database: Local & Global
00:00 Welcome to The dataFactory
00:11 Recap Season 1
00:51 Skip Intro & Recap
01:01 Introduction to Temporary tables in Database
02:53 Creating local temporary table
04:30 Creating global temporary table
