Brief Introduction
MSSQL 2017Description
In this course we will learn the basic-intermediate level about Structured Query Language A.K.A "Sequel" or SQL. We will use Sql server 2017 version but we will make a quick comparison between with it's predecessor. Since this is the first course that I created, bare with my deep accent and the way I pronounce the words. But the good thing is while I'm teaching and talking in front of my computer, It will improve my English proficiency. Happy programming :-)
Requirements
- Requirements
- Must have a Windows based computer for the sake of this course
Knowledge
- Install SSE and SSMS
- Configure SQL Server for remote connection and firewall (TCP/IP)
- Use Complete SQL SELECT statements
- Query against a single table
- Filter data using the WHERE clause
- Create Database, Tables using SQL and Create a Relationship
- Data Sorting using ORDER BY clause
- Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
- SQL statements that use aggregate functions
- Filter groups of data using the HAVING clause
- Group data together using the GROUP BY clause
Harry C.
3.3 Raiting
The Modern Angular Bootcamp
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Get job ready with Angular! Understand how to build, test, and deploy production-ready apps. If you want to build large, scalable apps, Angular is the Javascript framework to learn!...
MS SQL Server: Learn MS SQL Server from Scratch
- 4.5
-
![]()
![]()
![]()
![]()
![]()
This MS SQL server course teaches how to create database with MS SQL query, to manage SQL database ( MS SQL server )...
Ultimate Microsoft Office; Excel, Word, PowerPoint & Access
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019 **This course includes practice exercises and LIFETIME access**...
How You Can Master the Fundamentals of Transact-SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
A Real World Introduction to Transact-SQL COURSE REVIEWS: "This is a great course- I would fully recommend completing it. "Finest experience with Udemy they explain each and everything so clearly....
