HOT

The Complete SQL Server For Beginners

Development

Rating4.8
Enroll Now

The Complete SQL Server For Beginners, available at $94.99, has an average rating of 4.75, with 140 lectures, based on 549 reviews, and has 2401 subscribers.

You will learn about 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). This course is ideal for individuals who are Complete beginners, no prior experience is required. or Anyone looking for a course to refresh and incredibly increase their SQL knowledge. or People who are looking for a career change. or Anyone want to learn relational databases and SQL Server and be familiar with SQL syntax. or Developers looking for a huge boost in CV. It is particularly useful for Complete beginners, no prior experience is required. or Anyone looking for a course to refresh and incredibly increase their SQL knowledge. or People who are looking for a career change. or Anyone want to learn relational databases and SQL Server and be familiar with SQL syntax. or Developers looking for a huge boost in CV.

Enroll now: The Complete SQL Server For Beginners

Summary

Title: The Complete SQL Server For Beginners

Price: $94.99

Average Rating: 4.75

Number of Lectures: 140

Number of Published Lectures: 140

Number of Curriculum Items: 140

Number of Published Curriculum Objects: 140

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will 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).

Who Should Attend

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

Target Audiences

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

    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 databasesand 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 serverand 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 exercisesto 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 boostby mastering the SQL server with the Complete SQL Server for Beginners course, do not hesitate enrolling.

Course Curriculum

Chapter 1: Introduction to SQL Server and Cloud Databases

Lecture 1: Introduction to The Course

Lecture 2: What is Relational Databases and SQL Server?

Lecture 3: Relational Databases (Article)

Lecture 4: Install SQL Server

Lecture 5: SQL Server (Article)

Lecture 6: Management Studio

Lecture 7: Cloud Databases

Lecture 8: SQL Server Database on Microsoft Azure

Lecture 9: Microsoft Azure (Article)

Lecture 10: SQL Server Database on AWS

Lecture 11: Amazon Web Services – AWS RDS (Article)

Lecture 12: Summary

Chapter 2: Databases, Users and Authentications In SQL Server

Lecture 1: Introduction

Lecture 2: Create Your First Database

Lecture 3: Create and Manage Users

Lecture 4: Database Schema

Lecture 5: Exercise : Create User

Lecture 6: AdventureWorks Database

Lecture 7: Summary

Chapter 3: Database Tables, Primary and Foreign Keys In SQL Server

Lecture 1: Introduction to The Chapter

Lecture 2: Database Tables

Lecture 3: Data Types

Lecture 4: Constraints

Lecture 5: Drop and Truncate Tables

Lecture 6: Exercise : Create Tables Employees and Jobs

Lecture 7: Column Properties

Lecture 8: Primary Keys

Lecture 9: Foreign Keys

Lecture 10: Exercise : Edit Country Column in Employees Table

Lecture 11: Exercise : Create Table Previous Experience

Lecture 12: Import and Export Data

Lecture 13: Create Table Using Import Wizard

Lecture 14: Exercise : Primary and Foreign Keys for Status Table

Lecture 15: Entity Relationship Diagram (ERD)

Lecture 16: Summary

Chapter 4: Select Statements In SQL Server

Lecture 1: Introduction to The Chapter

Lecture 2: Select Statement

Lecture 3: Exercise : Select data from AdventureWorks

Lecture 4: Where Clause

Lecture 5: Exercise : Select data from AdventureWorks based on conditions

Lecture 6: Order by

Lecture 7: Create Table From Existing Table

Lecture 8: Exercise : Create Table From Another Table

Lecture 9: And, Or, Not, Is Null Operators

Lecture 10: Exercise : And, Or, Not, Is Null

Lecture 11: Like and Wildcards

Lecture 12: Exercise : Like and Wildcards

Lecture 13: Advanced Like and Wildcards

Lecture 14: In

Lecture 15: Between

Lecture 16: Exercise : Between

Lecture 17: Summary

Chapter 5: Advanced Select Statements In SQL Server

Lecture 1: Introduction to The Chapter

Lecture 2: Distinct

Lecture 3: Percent

Lecture 4: Change The Rule of 1000

Lecture 5: Union Operator

Lecture 6: Exercise : Union Operator

Lecture 7: Intersect and Except

Lecture 8: CASE Statement

Lecture 9: Exercise : CASE Statement

Lecture 10: Exercise : Fill PreviousExpereince Table with Data

Lecture 11: Subqueries

Lecture 12: Exercise : Subquery

Lecture 13: Summary

Chapter 6: Aggregate Functions In SQL Server

Lecture 1: Introduction to The Chapter

Lecture 2: Aggregate Functions – Min and Max

Lecture 3: Aggregate Functions – Count

Lecture 4: Exercise : Create Table Budget with Some Queries

Lecture 5: Aggregate Functions – Avg and Sum

Lecture 6: Group By

Lecture 7: Having

Lecture 8: Exercise : All in one

Lecture 9: Summary

Chapter 7: Data Manipulation In SQL Server

Lecture 1: Introduction to The Chapter

Lecture 2: DML and DDL

Lecture 3: Insert Into Statement

Lecture 4: Exercise : Insert Into Statement

Lecture 5: Insert Into Select Statement

Lecture 6: Delete Statement

Lecture 7: Update Statement

Lecture 8: Exercise : Update Statement

Lecture 9: Exercise : Update Status of Employees

Lecture 10: Generate Scripts

Lecture 11: Summary

Chapter 8: String Functions in SQL Server

Lecture 1: Introduction to The Chapter

Lecture 2: Upper, Lower and Reverse

Lecture 3: Replace, Substring and Concat

Lecture 4: Exercise : Gender

Lecture 5: Exercise : Country Name

Lecture 6: Len

Lecture 7: CharIndex

Instructors

Rating Distribution

  • 1 stars: 6 votes
  • 2 stars: 9 votes
  • 3 stars: 76 votes
  • 4 stars: 205 votes
  • 5 stars: 252 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Instagram Marketing Business Coach Certification Coaching

The Complete Instagram Marketing Masterclass

Amazon SEO & Listing Optimization SECRETS to Double Sales