
Fueling your journey to inspire, overcome, and motivate towards a brighter future. Join us today
Log In
Sign Up
Don’t have an account yet? Sign Up
Already have an account? Sign In
By signing up, I accept IOMH (Terms & Conditions)
Overview This course will unlock your full potential and will show you how to excel in a career in . …
Enrolled Students: 5
This Complete Microsoft SQL Server : Bootcamp course will unlock your full potential and will show you how to excel in a career in Complete Microsoft SQL Server : Bootcamp. So upskill now and reach your full potential. Everything you need to get started in Complete Microsoft SQL Server : Bootcamp is available in this course.
Learning and progressing are the hallmarks of personal development. This Complete Microsoft SQL Server : Bootcamp will quickly teach you the must-have skills needed to start in the relevant industry.
This Complete Microsoft SQL Server : Bootcamp course covers everything you must know to stand against the tough competition in the Complete Microsoft SQL Server : Bootcamp field.
The future is truly yours to seize with this Complete Microsoft SQL Server : Bootcamp. Enrol today and complete the course to achieve a Complete Microsoft SQL Server : Bootcamp certificate that can change your professional career forever.
Enrolling in the Complete Microsoft SQL Server : Bootcamp course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.
After studying the Complete Microsoft SQL Server : Bootcamp course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.
Upon successfully completing the Complete Microsoft SQL Server : Bootcamp course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.
This Complete Microsoft SQL Server : Bootcamp is suitable for anyone aspiring to start a career in Complete Microsoft SQL Server : Bootcamp; even if you are new to this and have no prior knowledge on Complete Microsoft SQL Server : Bootcamp, this course is going to be very easy for you to understand.
And if you are already working in the Complete Microsoft SQL Server : Bootcamp field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.
Taking this Complete Microsoft SQL Server : Bootcamp course is a win-win for you in all aspects.
This course has been developed with maximum flexibility and accessibility, making it ideal for people who don’t have the time to devote to traditional education.
This Complete Microsoft SQL Server : Bootcamp course has no prerequisite.
You don’t need any educational qualification or experience to enrol in the Complete Microsoft SQL Server : Bootcamp course.
Do note: you must be at least 16 years old to enrol.
Any internet-connected device, such as a computer, tablet, or smartphone, can access this online Complete Microsoft SQL Server : Bootcamp course.
Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.
| Course Introduction | |||
| Introduction | 00:04:00 | ||
| Course Curriculum overview | 00:04:00 | ||
| Overview of Databases | 00:09:00 | ||
| MS SQL Environment Setup | |||
| 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 | ||
| SQL Statement Basics | |||
| Overview of Challenges | 00:03:00 | ||
| SQL statement basic | 00:13:00 | ||
| SELECT Statement | 00:16:00 | ||
| SELECT DISTINCT | 00:17:00 | ||
| Column AS Statement | 00:09:00 | ||
| COUNT built-in Method usage | 00:10:00 | ||
| Filtering Data Rows | |||
| SELECT WHERE Clause – One | 00:05:00 | ||
| SELECT WHERE Clause – Two | 00:12:00 | ||
| SQL Operators | |||
| 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 | ||
| GROUP BY Statements | |||
| 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 | ||
| JOINS | |||
| 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 | ||
| Advanced SQL Commands | |||
| 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:04:00 | ||
| Creating Database and Tables | |||
| 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 | ||
| Primary Key and Foreign Key | |||
| How to set Primary Key | 00:06:00 | ||
| How to set Foreign Key | 00:12:00 | ||
| SQL CRUD Operations | |||
| 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 | ||
| MS SQL Constraints | |||
| Check Constraint | 00:14:00 | ||
| NOT NULL Constraint | 00:12:00 | ||
| UNIQUE Constraint | 00:11:00 | ||
| Backup and Restore Functions | |||
| 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 | ||
Save Up To 95% -
This course includes:
4.7 (8 reviews)
365 days
27 Students
4.7 (8 reviews)
365 days
28 Students
COPYRIGHT © 2021 Institute of Mental Health