SQL Server 101 : Microsoft SQL Server for Absolute Beginners
- 3.1
-
![]()
![]()
![]()
4 hours on-demand video
$
12.99
Brief Introduction
A *** MUST HAVE *** to get you quickly started with SQL Server regardless of the version you are working with !Description
In this course you will learn:
- Start from scratch by installing Microsoft SQL Server Express edition
- Requirements for installing Microsoft SQL Server
- Core concepts of RDBMS
- Comparison of MS SQL Server with Oracle, IBM etc.
- Getting around SQL Server Management Studio
- Details of System databases
- Constructing SELECT statement starting with literals
- Using FROM clause
- Working with columns specified in the SELECT LIST
- Using WHERE clause
- Using ORDER BY clause
- Using BETWEEN / NOT BETWEEN operator
- Using IN / NOT IN operator
- Pattern matching using LIKE operator and wild card characters
- Working with NULL
- Using string functions including concatenation
- Using Date functions
- SQL Server System functions
- Working with JOINS – INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOIN
- Working with UNION / UNION ALL
- A look at sub queries
- Duplicate rows – DISTINCT / ALL predicates
- Aggregate functions
- Using GROUP BY clause
- Using HAVING clause
Requirements
- Requirements
- NO PRIOR DATABASE OR SQL experience is required.
- You need High speed Internet connection with a PC.
Rashid Khan
3.1 Raiting
The Complete Google BiqQuery Masterclass: Beginner to Expert
- 3.9
-
![]()
![]()
![]()
![]()
![]()
Master Google BigQuery Analytics with SQL used in Big Query to analyze Real data for data scientists, Developers, etc. This is a complete Google google bigquery training"...
SQL Server 101 : Microsoft SQL Server for Absolute Beginners
- 3.1
-
![]()
![]()
![]()
![]()
![]()
A *** MUST HAVE *** to get you quickly started with SQL Server regardless of the version you are working with !...
Microsoft SQL for Beginners (SQL Server and T-SQL)
- 4.2
-
![]()
![]()
![]()
![]()
![]()
Learn the basic of SQL and SQL Server with no previous experience needed! Are you interesting in learning a skill that can start you in a job between $85,000-$125,000?...
Azure Data Engineer Technologies for Beginners [Bundle]
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Microsoft Azure SQL Database, Data Lake, Data Factory, Synapse Analytics, Cosmos DB, Databricks, HDInsight, storage Why Microsoft Azure Data Engineer? Expected Outcomes...
