Course Types
Course Categories
Animal Care
(27 Courses)
Art
(7 Courses)
Business
(46 Courses)
Care
(47 Courses)
Chemistry & Biology
(18 Courses)
Construction & Architecture
(10 Courses)
Cooking & Baking
(8 Courses)
Culture & Tradition
(5 Courses)
Design
(20 Courses)
Environment
(17 Courses)
Fashion & Beauty
(2 Courses)
Finance
(32 Courses)
Health
(204 Courses)
Hospitality
(22 Courses)
HR
(26 Courses)
IT
(45 Courses)
Language
(8 Courses)
Law & Regulations
(12 Courses)
Management
(85 Courses)
Marketing & Sales
(26 Courses)
Office Skill
(20 Courses)
Personal Development
(63 Courses)
Profession
(28 Courses)
Project Management
(10 Courses)
Property & Surveying
(8 Courses)
Safety
(22 Courses)
Science
(14 Courses)
Service
(26 Courses)
Teaching & Academics
(67 Courses)
Travel & Tourism
(2 Courses)
Writing
(8 Courses)Accident & Injuries
Anxiety
Clinical Care
Dementia
Diet
Disability
Food Safety
Health & Safety
Health And Fitness
Healthcare
Hygiene
Medical Administration
Medicine & Treatment
Mental Health
Nursing
Nutrition
Pharmacology
Physical Therapy
Physiology
Physiotherapy
Prevention & Control
Substance Abuse
Therapy
Trauma
-
Explore Course Categories
- Explore Course Categories
-
Environment
17 Courses -
Health
204 CoursesHealth View AllAccident & Injuries
Anxiety
Clinical Care
Dementia
Diet
Disability
Food Safety
Health & Safety
Health And Fitness
Healthcare
Hygiene
Medical Administration
Medicine & Treatment
Mental Health
Nursing
Nutrition
Pharmacology
Physical Therapy
Physiology
Physiotherapy
Prevention & Control
Substance Abuse
Therapy
Trauma
-
Language
8 Courses -
Management
85 Courses -
Marketing & Sales
26 Courses -
Personal Development
63 Courses -
Science
14 Courses -
Service
26 Courses
-
Explore Careers Categories
-
All Courses
-
Get Adams Premium (Remove Ads)
-
Adams Blog
-
Resume Builder
-
Adams For Business
-
Download the Adams App
Welcome Back!
What will you learn today? Find out with Adams Academy
Sign Up For Free
Join the World's Largest Free Learning Community
-
Welcome Back!
- Don't have an Adams account? Sign Up
or -
Sign Up For Free
Join the World’s Largest Free Learning Community
- Already have an Adams account? Log In
orThis is the name that will appear on your Certification
-
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
This course includes:
-
6 hours, 6 minutes -
CPD Accreditation
-
88 units
-
Full lifetime access
-
Access on mobile and TV
-
Certificate of completion
Share:
course plublisher
Course CloudKey Concepts Covered by This Free Course
- Introduction to SQL Server and its setup.
- Basic concepts of SQL databases, including data manipulation and definition languages.
- Understanding SQL statements and their use in filtering data rows.
- Advanced SQL commands like group by, joins, constraints, and views.
- In-depth exploration of SQL stored procedures and their use.
- Import and export of data and backup and restore of databases.
Course Overview
Looking to expand your database management skills? Our Microsoft SQL Server Bootcamp 2022 course covers all the essential concepts you need to know to become proficient in SQL server management. This comprehensive course is designed to provide a complete understanding of SQL server setup, database management, and advanced SQL commands.
In this course, you’ll learn the basics of SQL databases and SQL statements, including data manipulation, definition languages, and filtering data rows. You’ll also explore advanced concepts like joins, constraints, and views. Our curriculum is up-to-date with the latest industry trends and practices, ensuring that you have the most relevant skills and knowledge to succeed in the field.
Course Benefits
Investing in our Microsoft SQL Server Bootcamp 2022 course can have a significant impact on your career prospects. As a proficient database manager with in-demand SQL server management skills, you’ll be highly sought after in today’s job market. Our course is completely free, making it an accessible way to enhance your skills and increase your employability. Plus, our online platform makes it easy to access course materials from anywhere, at any time.
With your newfound skills and knowledge, you’ll be able to take on challenging projects, solve complex problems, and advance your career to the next level. Don’t miss out on this opportunity to gain valuable skills and stay ahead of the competition.
Career Path
- SQL Database Administrator – Responsible for managing, maintaining, and optimising SQL server databases.
- SQL Developer – Responsible for developing and implementing SQL server databases and queries.
- Business Intelligence Analyst – Responsible for gathering and analysing data from SQL server databases to inform business decisions.
- Data Analyst – Responsible for analysing and interpreting data from SQL server databases to inform business decisions.
- Data Scientist – Responsible for developing and implementing machine learning algorithms using SQL server databases.
Course content
Introduction -
Introduction 00:03:00 -
Course Curriculum 00:07:00
-
How to get course requirements 00:02:00
-
Getting started on Windows, Linux or Docker 00:01:00
-
How to ask great questions 00:01:00
-
FAQ’s 00:01:00
-
What is Source Code? 00:09:00
-
Section Introduction 00:02:00
-
Microsoft SQL Server Installation 00:19:00
-
SQL Server Management Studio (SSMS) Installation 00:08:00
-
How to connect MS SQL (Windows Authentication) 00:04:00
-
How to connect MS SQL (SQL Server Authentication) 00:03:00
-
Download and Restore Sample Database 00:07:00
-
Section Introduction 00:01:00
-
Overview of Databases 00:11:00
-
Creating Database 00:05:00
-
SQL Data Types 00:03:00
-
Column Data Types on SSMS 00:04:00
-
Creating Table 00:09:00
-
Overview of Primary Key and Foreign Key 00:04:00
-
Primary Key 00:04:00
-
Foreign Key 00:07:00
-
Creating Temporary tables 00:06:00
-
Section introduction 00:01:00
-
Insert statement 00:08:00
-
Update statement 00:05:00
-
Delete statement 00:03:00
-
Section Introduction 00:01:00
-
CREATE table statement 00:03:00
-
DROP statement 00:02:00
-
ALTER statement 00:05:00
-
TRUNCATE statement 00:04:00
-
COMMENT in query 00:01:00
-
RENAME 00:02:00
-
Create Database user 00:04:00
-
GRANT permissions 00:06:00
-
REVOKE permissions 00:04:00
-
Section Introduction 00:01:00
-
SQL Statement basic 00:03:00
-
SELECT Statement 00:07:00
-
SELECT DISTINCT 00:03:00
-
SELECT with column headings 00:03:00
-
Column AS statement 00:02:00
-
SELECT WHERE Clause – theory 00:04:00
-
SELECT WHERE Clause – practical 00:07:00
-
Sum() 00:08:00
-
Min()-Max() 00:06:00
-
Order By statement 00:05:00
-
SELECT TOP clause in SQL 00:04:00
-
BETWEEN command 00:08:00
-
IN operator 00:04:00
-
Wildcard Characters and LIKE 00:05:00
-
Section Introduction 00:01:00
-
Group by – theory 00:03:00
-
Group by – practical 00:05:00
-
HAVING statement 00:04:00
-
Overview of Joins 00:02:00
-
What are Joins 00:02:00
-
Inner join 00:08:00
-
Left outer join 00:03:00
-
Right outer join 00:02:00
-
Full outer join 00:01:00
-
Union 00:03:00
-
Cross join 00:03:00
-
Query Exercise 00:01:00
-
Solution for Query Exercise 00:01:00
-
Section introduction 00:01:00
-
Check constraint 00:07:00
-
NOT NULL constraint 00:08:00
-
UNIQUE constraint 00:05:00
-
Creating Views 00:04:00
-
Reporting with multiple tables 00:03:00
-
Section Introduction 00:01:00
-
Timestamp 00:04:00
-
Extract from timestamp 00:03:00
-
Mathematical scalar functions 00:04:00
-
String functions 00:05:00
-
SubQuery 00:03:00
-
SELECT with calculations 00:06:00
-
Create stored procedure 00:05:00
-
Stored procedure with parameter 00:04:00
-
Section Introduction 00:01:00
-
Import Flat File 00:05:00
-
Import .csv or excel file 00:03:00
-
Export Data to Excel or any format 00:06:00
-
Section Introduction 00:01:00
-
Creating Database backup 00:04:00
-
Restoring Database backup 00:04:00
Certify Your Skills
A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.
Stand Out From The Crowd
Add your Adams Certification to your resume and stay ahead of the competition.
Advance in Your Career
Share your Adams Certification with potential employers to show off your skills and capabilities.
About Course Publisher
Courses
Unlock your potential with Course Cloud, the UK's leading online provider of career-enhancing skills. With everything from IT and business to healthcare and skilled trades, our diverse range of courses are researched diligently and accredit-rated. Enjoy interactive, self-paced learning through diverse formats that include instructor-led sessions, multimedia lessons and expansive study material. You could be the next to power your career with us. Don't miss out on the opportunity of learning anything at any place with unprecedented flexibility through courseware available on any device. With dedicated tutor support, Course Cloud assures a learning journey that is not just informative but transformative. Join us in taking the first step towards achieving your career aspirations. Request the information today in English (UK) language.
More Free Online Courses by This Publisher
Certificate
Learn MySQL from Scratch for Data Science and Analytics
88
Lessons
15
Students
Certificate
Complete Python from Scratch: Start your career in Python 3+
60
Lessons
17
Students
Certificate
Email Marketing for Beginners
18
Lessons
11
Students
Certificate
Master JavaScript with Data Visualization
76
Lessons
18
Students
Certificate
C++ Programming for Absolute Beginners
77
Lessons
13
Students