Key Concepts Covered by This Free Course:
- Setting up MS SQL environment and understanding SQL statements basics
- Filtering data rows and utilising SQL operators for advanced data manipulation
- GROUP BY statements and understanding JOINS for data consolidation
- Creation of databases and tables with primary and foreign keys for data organisation
- Utilizing SQL CRUD operations for data retrieval, modification, and deletion
- Understanding MS SQL constraints for data integrity and security
- Backup and restore functions for data protection and disaster recover
Course Overview:
Unlock the power of data management with the Complete Microsoft SQL Server from Scratch: Bootcamp. This course will equip you with essential SQL knowledge and skills from the ground up, taking you from basic SQL statement construction to advanced data manipulation techniques. Through the exciting modules, you'll learn how to filter, consolidate, and organise data and maintain data integrity and security with constraints. You'll also gain hands-on experience in setting up MS SQL environments, creating databases and tables, and utilising backup and restore functions for data protection. By the end of the course, you'll have a comprehensive understanding of SQL and the ability to handle complex data management tasks confidently.Course Benefits:
Invest in your career with the Complete Microsoft SQL Server from Scratch: Bootcamp. This course provides a valuable opportunity to develop in-demand skills and open up new career opportunities. By mastering SQL, you'll be able to contribute to the success of data-driven organisations and positively impact your career prospects. In addition to boosting your skills and knowledge, this course also offers flexible learning options, enabling you to study at your own pace and fit your learning around your schedule. With lifetime access to course materials, you can refresh your knowledge and stay up-to-date with the latest SQL trends and practices.Career Path:
- Database Administrator: Responsible for managing and maintaining database systems, ensuring data accuracy, security, and performance.
- Data Analyst: Responsible for collecting, analysing, and interpreting complex data sets to identify patterns, trends, and insights.
- Business Intelligence Developer: Responsible for designing and developing BI solutions, including data warehouses, ETL processes, and reporting tools.
- Software Developer: Responsible for developing software applications that interact with database systems, utilising SQL for data manipulation and retrieval.
- Data Scientist: Responsible for designing and implementing data-driven solutions, including statistical models and machine learning algorithms.
Course content
MSSQL Installation
00:27:00
MSSQL SSMS Installation
00:08:00
Connecting to MS-SQL (Windows Authentication)
00:05:00
Connecting to MS-SQL (SQL Server Authentication)
00:06:00
Overview of Challenges
00:03:00
SQL statement basic
00:13:00
SELECT Statement
00:17:00
SELECT DISTINCT
00:17:00
Column AS Statement
00:09:00
COUNT built-in Method usage
00:10:00
SELECT WHERE Clause – One
00:05:00
SELECT WHERE Clause – Two
00:12:00
SQL ORDER BY Statement
00:10:00
SQL Using BETWEEN with Same Column Data
00:13:00
How to Apply IN Operator
00:08:00
Wildcard Characters with LIKE and ILIKE
00:13:00
Overview of GROUP BY
00:03:00
Aggregation Function – SUM()
00:12:00
Aggregation Function – MIN()-MAX()
00:08:00
GROUP BY – Part One
00:11:00
GROUP BY – Part Two
00:14:00
HAVING on SQL Statement
00:04:00
Overview of JOINS
00:07:00
Introduction to JOINS
00:07:00
AS Statement
00:04:00
INNER Join
00:12:00
Full Outer Join
00:07:00
Left Outer Join
00:06:00
Right Outer Join
00:08:00
Union
00:07:00
Basic of Advanced SQL Commands
00:04:00
Timestamp
00:12:00
Extract from Timestamp
00:06:00
Mathematical Scalar Functions
00:11:00
String Functions
00:17:00
SubQuery
00:07:00
Basic of Database and Tables
00:10:00
Data Types
00:11:00
Select Datatype on SSMS
00:05:00
Create Table using SQL Script
00:07:00
How to set Primary Key
00:06:00
How to set Foreign Key
00:12:00
Insert Statement in MS SQL
00:06:00
Update Statement in MS SQL
00:08:00
Delete Statement in MS SQL
00:07:00
Alter / Modification Table in MS SQL
00:04:00
Drop Table in MS SQL
00:03:00
Check Constraint
00:14:00
NOT NULL Constraint
00:12:00
UNIQUE Constraint
00:11:00
Overview of Database and Tables
00:04:00
Creating a Database backup using SSMS
00:11:00
Restoring a Database from backup using SSMS
00:08: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.
