4.2 Read 5 reviews
Overview
Context
Unlock the power of SQL Server to manipulate, analyze, and extract insights from vast amounts of data. In this SQL Server Fundamentals course offered by Data Camp, you'll learn how to use SQL Server to work with data at a scale and speed that Excel can't match, enabling you to efficiently analyze large datasets.
Gain Essential SQL Server Skills
Through hands-on exercises, you'll master the fundamental skills every data professional needs, including:
- Querying and filtering data from single and multiple tables
- Summarizing data using aggregate functions like SUM, AVG, and COUNT
- Joining tables to combine related data and gain deeper insights
- Using subqueries and common table expressions (CTEs) for complex analyses
- Manipulating dates, times, and strings with built-in SQL Server functions
Analyze Real-World Data Sets
You'll work with realistic data from various domains, such as sales, marketing, and finance, to identify trends in customer behavior, measure key performance indicators (KPIs), and detect anomalies that require further investigation. This section also covers generating reports for different stakeholders and performing time series analysis to forecast future trends.
Programme Structure
Courses
- Joining Data in SQL
- Intermediate SQL Server
- Time Series Analysis in SQL Server
- Functions for Manipulating Data in SQL Server
Key information
Duration
- Part-time
- 3 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
Campus Location
- New York City, United States
Disciplines
Business Intelligence Data Science & Big Data View 89 other Short Courses in Business Intelligence in United StatesWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- There are no prerequisites for this track
- This Track is suitable for both beginners and experienced professionals. Beginners will be introduced to the fundamentals of SQL Server and will get a chance to practice their skills with exercises and real-world data. Experienced users will be able to gain a deeper understanding of the features of SQL Server to develop more advanced skills.
- This Track is helpful to anyone in a role where they need to analyze data extracted from multiple databases. This could be roles in software engineering, data analysis, business intelligence, website analytics, and similar disciplines.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions
Funding
Improve page content