Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development SQL Server

The Complete SQL Server For Beginners

The ultimate practical guide to master SQL Server as a developer (Downloadable SQL Scripts Included).
Rating: 4.2 out of 54.2 (420 ratings)
1,994 students
Created by Ahmad Mohey
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Install SQL Server and Management Studio.
  • Understand basics of cloud databases.
  • Create SQL Server instances on Microsoft Azure.
  • Create SQL Server instances on AWS (Amazon Web Services).
  • Connect Management Studio to your cloud databases.
  • Create SQL databases and schemas.
  • Create and manage users in database.
  • Install AdventureWorks database.
  • Create tables using SQL script.
  • Create tables using Management Studio.
  • Learn about different data types available in SQL Server.
  • Applying different constraints.
  • Create primary keys, foreign keys and composite keys.
  • Design relational databases and create relationships between tables.
  • Generate Entity Relationship Diagram (ERD).
  • Import and Export Data using Management Studio.
  • Create tables using Import Wizard.
  • Work with select statement.
  • Filter data using where clause.
  • Work with and, or, not operators.
  • Use like operator and wildcards.
  • Enhance your data selection using (In and between)
  • How to select distinct column only.
  • How to work with union and intersect, except operators.
  • Work with case statement.
  • Enhancing your data selection with subqueries.
  • Applying aggregate functions (Min, Max, Avg, Sum, Count)
  • Group table records using group by keyword.
  • Filter grouped records using having keyword.
  • Integrating aggregate functions with group by and having keywords.
  • Understand what is DML and DDL.
  • Add new records using insert statement.
  • Delete records using delete statement.
  • Update records using update statement.
  • Generate SQL scripts using Management Studio.
  • Create inner joins, left outer joins and right outer joins.
  • How to create multiple joins in one SQL query.
  • Create views using SQL Script.
  • Create views using Management.
  • Create a small human resources databases.
  • Perform different SQL statements on the human resources database.
  • Understand what is T-SQL.
  • Working with Stored procedures.
  • How to create a stored procedures with parameters.
  • Setting default value for stored procedure parameters.
  • How to use built-in string functions (CharIndex, Replace, Substring, Concat, Upper, Lower and Reverse).
  • How to use built-in date functions (GetDate, DateAdd, DateDiff and DateName).
  • How to use built-in numeric functions (Round, Ceiling, Floor, Abs, Rand and Sign).

Course content

13 sections • 139 lectures • 9h 11m total length

  • Preview04:15
  • Preview03:04
  • Relational Databases (Article)
    01:28
  • Install SQL Server
    06:14
  • SQL Server (Article)
    01:38
  • Management Studio
    04:14
  • Cloud Databases
    04:10
  • SQL Server Database on Microsoft Azure
    13:19
  • Microsoft Azure (Article)
    01:46
  • SQL Server Database on AWS
    Preview08:14
  • Amazon Web Services - AWS RDS (Article)
    01:42
  • Summary
    00:37

  • Introduction
    00:31
  • Preview08:44
  • Create and Manage Users
    09:25
  • Database Schema
    07:05
  • Exercise : Create User
    01:51
  • AdventureWorks Database
    02:35
  • Summary
    00:31

  • Introduction to The Chapter
    01:12
  • Preview16:12
  • Data Types
    11:49
  • Constraints
    09:52
  • Drop and Truncate Tables
    02:08
  • Exercise : Create Tables Employees and Jobs
    09:18
  • Column Properties
    04:56
  • Primary Keys
    07:34
  • Foreign Keys
    09:14
  • Exercise : Edit Country Column in Employees Table
    01:53
  • Exercise : Create Table Previous Experience
    05:57
  • Import and Export Data
    11:53
  • Create Table Using Import Wizard
    02:49
  • Exercise : Primary and Foreign Keys for Status Table
    02:04
  • Entity Relationship Diagram (ERD)
    04:49
  • Summary
    00:58

  • Introduction to The Chapter
    00:42
  • Preview05:47
  • Exercise : Select data from AdventureWorks
    02:37
  • Where Clause
    15:00
  • Exercise : Select data from AdventureWorks based on conditions
    01:55
  • Order by
    04:00
  • Create Table From Existing Table
    05:48
  • Exercise : Create Table From Another Table
    02:12
  • And, Or, Not, Is Null Operators
    09:43
  • Exercise : And, Or, Not, Is Null
    03:13
  • Like and Wildcards
    05:15
  • Exercise : Like and Wildcards
    03:48
  • Advanced Like and Wildcards
    03:44
  • In
    03:45
  • Between
    03:17
  • Exercise : Between
    03:44
  • Summary
    00:51

  • Introduction to The Chapter
    00:27
  • Distinct
    03:27
  • Percent
    01:46
  • Change The Rule of 1000
    02:41
  • Union Operator
    06:21
  • Exercise : Union Operator
    04:48
  • Intersect and Except
    03:37
  • CASE Statement
    09:46
  • Exercise : CASE Statement
    03:59
  • Exercise : Fill PreviousExpereince Table with Data
    01:41
  • Subqueries
    05:44
  • Exercise : Subquery
    03:48
  • Summary
    01:08

  • Introduction to The Chapter
    00:42
  • Aggregate Functions - Min and Max
    06:20
  • Aggregate Functions - Count
    05:40
  • Exercise : Create Table Budget with Some Queries
    07:05
  • Aggregate Functions - Avg and Sum
    05:18
  • Group By
    08:40
  • Having
    03:45
  • Exercise : All in one
    04:02
  • Summary
    00:47

  • Introduction to The Chapter
    00:20
  • DML and DDL
    01:30
  • Insert Into Statement
    06:01
  • Exercise : Insert Into Statement
    03:39
  • Insert Into Select Statement
    06:00
  • Delete Statement
    02:46
  • Update Statement
    05:18
  • Exercise : Update Statement
    03:28
  • Exercise : Update Status of Employees
    03:51
  • Generate Scripts
    02:29
  • Summary
    00:48

  • Introduction to The Chapter
    00:30
  • Upper, Lower and Reverse
    04:31
  • Replace, Substring and Concat
    13:45
  • Exercise : Gender
    01:19
  • Exercise : Country Name
    01:19
  • Len
    00:57
  • CharIndex
    04:25
  • Exercise : Extract Email Username
    02:48
  • Exercise : Extract Email Service Provider
    03:05
  • Coalesce
    02:30
  • Replicate
    02:06
  • Right and Left
    01:54
  • Trim
    02:46
  • Summary
    02:46

  • Introduction to The Chapter
    00:32
  • GetDate and DateAdd
    02:25
  • Exercise : Add Two Years to birth date
    03:00
  • DateDiff
    04:25
  • DateName
    03:15
  • Exercise : Get Age of Each Employee
    01:17
  • Round, Ceiling and Floor
    03:33
  • Abs, Rand and Sign
    02:35
  • Summary
    01:01

  • Introduction to The Chapter
    00:35
  • Inner Joins
    10:18
  • More Inner Joins
    02:14
  • Multiple Inner Joins
    05:52
  • Exercise : Joining Cities and Countries
    03:07
  • Exercise : No of Cities in Each Country
    03:04
  • Right Outer Join
    04:05
  • Left Outer Join
    02:52
  • Create a View using SQL Script
    03:59
  • Modifying The Structure of a View
    02:03
  • Create a View using Management Studio
    05:47
  • Exercise : Create View For Status of Each Employee
    01:49
  • Summary
    00:42

Requirements

  • SQL Server Developer Edition (Free)
  • Management Studio (Free)

Description

    Welcome to the Complete SQL Server For Beginners Course, The ultimate practical guide to master SQL Server for developers.

This course will start with you from zero level experience in SQL databases, starting to level up as we are going through the course. explaining all the questions you maybe asking yourself such as 

What is a relational database?  what is SQL Server?  what is a cloud database?

This course will guide you how to install SQL Server on a local machine step by step and even how to create your own cloud databases on the most required cloud services providers in the market...AWS (Amazon Web Services) and Microsoft Azure.

You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)

After you learn the basic concepts of the SQL and relational databases and how to install it on a machine and on the cloud, now it will be about time to dive deeper into the world of SQL databases and learn :

  • How create databases and schemas.

  • How create tables and views.

  • Understand all the big concepts like DML, DDL, T-SQL and DBaaS.

  • You will learn how to create users to access your database based on specific permissions you gave them.

  • How to create different constraints.

  • Create primary keys, foreign keys and composite keys.

  • How to export and import a bulk of data in and out of your database.

  • How to retrieve data from your database using select statement.

  •  How to filter data using where clause.

  • How to use aggregate functions (Sum, Min, Max..etc).

  • Learn how to use group by and having with aggregate functions.

  • How to use case statement.

  • How to use the keywords like between, in, distinct and percent.

  • Understand how to create subqueries.

  • How to manipulate data using Insert, update, delete statements.

  • How to use joins to link two tables or more together.

  • How to design complex database relations.

  • How to create different stored procedures to perform different jobs.

  • You will learn how to use string functions such as replace, substring, CharIndex and more.

  • How to use the powerful date functions in sql server such as DateAdd, DateDiff and more.

  • You will learn how to use the numeric functions such as round, ceiling, floor and more.

You will be designing a small human resources database from scratch, and we will also work with the  AdventureWorks database. AdventureWorks Database is a Microsoft product sample. The AdventureWorks Database supports a fictitious, multinational manufacturing company called Adventure Works Cycles. You will learn how to install AdventureWorks database onto your database server and we are going to perform different sql queries and statements on both HumanResources and AdventureWorks.

You will learn how to increase your productivity with relational databases using joins and views, you will be creating inner joins, left outer joins and right outer joins.

You will have the chances to create joins in two different ways, first using SQL script and you will learn how to do this step by step, and visually using the management studio features which allows you to create joins much faster and easier.

With over 30 real world exercises to help you practice and learn more about almost each major topic in the course, I am going to solve all of the exercises with you while giving you some time to try to solve it on your own.

All the SQL scripts I will be using in this course are available for you to download anytime.

Give your CV a huge boost by mastering the SQL server with the Complete SQL Server for Beginners course, do not hesitate enrolling.

Who this course is for:

  • Complete beginners, no prior experience is required.
  • Anyone looking for a course to refresh and incredibly increase their SQL knowledge.
  • People who are looking for a career change.
  • Anyone want to learn relational databases and SQL Server and be familiar with SQL syntax.
  • Developers looking for a huge boost in CV.

Featured review

Steve Masterson
Steve Masterson
336 courses
24 reviews
Rating: 5.0 out of 5a year ago
I was going to wait until I was finished, but I have re-watched the first half a few times and practiced along. Ahmed is a great instructor. The delivery is excellent, he provides a lot of information to help the student understand the concepts. I have no doubt that the rest of the course will be will quality. Having now finished the course, it is very good and will be worthy of a rewatch.

Instructor

Ahmad Mohey
Software Developer & Instructor
Ahmad Mohey
  • 4.2 Instructor Rating
  • 2,649 Reviews
  • 34,360 Students
  • 8 Courses

      Hello there! My name is Ahmad Mohey I'm a senior full stack developer. I have been developing applications for the last 10 years and I hope more years of creative developing to come. I have been developing applications for oil and gas industry and the financial and human resources departments for many companies.

I love to learn about new technologies and what’s new in the world of development as it’s growing rapidly, I love to help people learn and solve their problems. I believe, we all shall share our knowledge and pass it to each others.

The path to become a developer or a programmer is never easy but it is not that hard, You just need to keep going and do not quit and always think of any skill you have now, remember that you did not master it from the first time, you had to keep trying to master it.

Far from the software world I love photography and you can check my photographs on my page on facebook or 500px website, I am passionate about learning management and emotional intelligence and I attended many courses about management, negotiations and leadership.

I love traveling a lot,I love to see new places, cities, countries, cultures and people if I were to choose one thing to continue doing the rest of my life I would choose traveling. 

One last thing and I think it might be relevant for me being a developer, is that I love computer games maybe that’s why I love programming :) . I hope one day I will make my own games.

Finally thanks for your time reading about me.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.