0

  • No products in the cart.

Course Curriculum

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[iframevideo] [/iframevideo] 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

Related Courses

41 STUDENTS ENROLLED

    Related Courses Widget

    Top Rated Course

    Course Reviews

    • SEN Teaching Assistant

      Muhammad Sutton 5

      Incredible! Best course online
    • First Aid Training Course

      Happy with my course. 5

      I came across into this online course since I want to learn how to provide First Aid in our office, so I’m happy that my first experience is on this site. Not only they provide practical lessons, but also their staff responds promptly to my queries without hesitation.
    • Food Safety Level 2

      Excellent 5

      Everything I need to learn about food hygiene course is already provided. I can surely get that certification to work in the catering and hospitality industry now!
    • Diploma in Lean Process and Six Sigma

      Really helpful and informative course to study. 5

      I came across into this online course, and since I’m a curious person, I tried purchasing this course to check if it was worth it. And I can say, I did not regret the decision since it taught me all the Lean Six Sigma methodologies that could help my business succeed.
    • Food Safety Level 2

      Fantastic and well self explanatory course 5

      I'm so excited to be the part of this wonderful Oneeducation student, I got 78% as mark. The course would surly help me in searching for my waitress job.
     - Shows visitor's IP address
 - Shows continent name
 - Shows country name
 - Shows country code (like IN, US, UK)
 - Shows region code
 - Shows region/state name
 - Shows city name
 - **NEW!** Shows ZIP/postal code
 - Shows latitude
 - Shows longitude
 - Shows timezone
 - Shows local currency
 - Shows internet provider name
 - Shows if visitor is on mobile network
 - Shows if visitor is using proxy
 - Shows if IP is from hosting provider
 - Shows browser name
 - Shows operating system
 - Shows country flag
 - **NEW!** Shows visitor's current local time
 - **NEW!** Shows visitor's current local date