Introduction to SQL Server
- Offered byDataCamp
Introduction to SQL Server at DataCamp Overview
Duration | 4 hours |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Go to Website |
Credential | Certificate |
Introduction to SQL Server at DataCamp Highlights
- Earn a certificate after completion of the course
- Learn from the industry best faculty
Introduction to SQL Server at DataCamp Course details
Beginners and Newcomers
IT Professionals
Database Administrators (DBAs)
Data Analysts and Scientists
How to use SELECT statements to retrieve data
How to use SQL Server aggregate functions
How to manipulate text fields
How to retrieve data from multiple sources
All of the key aspects of working with data in SQL Server
This foundational course designed to provide a comprehensive introduction to one of the most popular relational database management system
This course will cover the essential concepts, tools, and techniques needed to get started with SQL Server, making it an ideal starting point for anyone looking to build a career in database management or data analysis
Introduction to SQL Server at DataCamp Curriculum
SELECTion Box
Simple selections
More selections
Ordering and filtering
Order by
Groups, strings, and counting things
Summing
Counting
MIN, MAX and AVG
Strings
LEN'gth of a string
Joining tables
Inner Joins - a perfect match
Inner Joins (II)
Inner Join (III) - Join 3 tables
LEFT & RIGHT JOIN
LEFT join
You've got the power
CRUD operations
Create tables
Insert, Update, Delete
Insert
Update