Key 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
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
Complete This CPD Accredited Course & Get Your Framed Certificate!
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
Training Express
185 Courses
Training Express is a leading course provider, established by a dedicated team of experts working across the UK. We deliver accredited certification and training to UK businesses looking to improve organisational performance. Our comprehensive courses cover a broad range of sectors and industries, with a focus on promoting high standards of food hygiene, business wellbeing and safety in the workplace.
