The Complete SQL Server For Beginners | Ahmad Mohey | Skillshare

The Complete SQL Server For Beginners

Ahmad Mohey, Software Developer & Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
52 Videos (4h 55m)
    • Introduction to The Course

      4:15
    • What is Relational Databases and SQL Server

      3:04
    • Cloud Databases

      4:10
    • Install SQL Server

      6:14
    • Management Studio

      4:14
    • SQL Server Database on AWS

      8:14
    • SQL Server Database on Microsoft Azure

      13:19
    • Create Your First Database

      8:44
    • Create and Manage Users

      9:25
    • Database Schema

      7:05
    • Exercise Create User

      1:51
    • AdventureWorks Database

      2:35
    • Database Tables

      16:12
    • Data Types

      11:49
    • Constraints

      9:52
    • Drop and Truncate Tables

      2:08
    • Exercise Create Tables Employees and Jobs

      9:18
    • Column Properties

      4:56
    • Primary Keys

      7:34
    • Foreign Keys

      9:14
    • Exercise Edit Country Column in Employees Table

      1:53
    • Execrise Create Table Previous Experience

      5:57
    • Create Table Using Import Wizard

      2:49
    • Import and Export Data

      11:53
    • Exercise Primary and Foreign Keys for Status Table

      2:04
    • Entity Relationship Diagram (ERD)

      4:49
    • Select Statement

      5:47
    • Exercise Select Data From AdventureWorks

      2:37
    • Where Clause

      15:00
    • Exercise Select Data From AdventureWorks Based on Conditions

      1:55
    • Order By

      4:00
    • Create Table From Existing Table

      5:48
    • Exercise Create Table From Another Table

      2:12
    • And, Or, Not, Is Null

      9:43
    • Exercise And, Or, Not, Is Null

      3:13
    • Like and Wildcards

      5:15
    • Exercise Like and Wildcards

      3:48
    • Advanced Like and wildcards

      3:44
    • In

      3:45
    • Between

      3:17
    • Exercise Between and In

      3:44
    • Distinct

      3:27
    • Percent

      1:46
    • Change The Rule of 1000

      2:41
    • Union Operator

      6:21
    • Exercise Union Operator

      4:48
    • Intersect and Except

      3:37
    • CASE Statement

      9:46
    • Exercise Case Statement

      3:59
    • Exercise Fill PreviousExpereince Table with Data

      1:41
    • Subquery

      5:44
    • Exercise Subquery

      3:48
19 students are watching this class

About This Class

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.

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.

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

50

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Ahmad Mohey

Software Developer & Instructor

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 b...

See full profile

Report class