HOT

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Development

Rating4.6
Enroll Now

SQL Server 101 : Microsoft SQL Server for Absolute Beginners, available at $54.99, has an average rating of 4.55, with 46 lectures, 2 quizzes, based on 148 reviews, and has 595 subscribers.

You will learn about At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself. You will be familiarized with some of the core concepts of RDBMS / SQL Server. You will learn the ins and outs of SQL Server Management studio. You will start constructing your SELECT statement to retrieve data from SQL Server. You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause. You will also know about some of the string functions, date functions, and system functions. You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS). You will also see how to use UNION / UNION ALL operators and as to how they differ from JOINS. You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions. This course is ideal for individuals who are Anyone who is just starting out on their database career. or Information workers who work with database. or Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant. or Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc. or Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461 or Quality Analyst people who need to understand the workings of a database while they do their software testing. or Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology. or Business Professional or Accountants or Software Developers or Programming Students or Financial Analysts It is particularly useful for Anyone who is just starting out on their database career. or Information workers who work with database. or Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant. or Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc. or Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461 or Quality Analyst people who need to understand the workings of a database while they do their software testing. or Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology. or Business Professional or Accountants or Software Developers or Programming Students or Financial Analysts.

Enroll now: SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Summary

Title: SQL Server 101 : Microsoft SQL Server for Absolute Beginners

Price: $54.99

Average Rating: 4.55

Number of Lectures: 46

Number of Quizzes: 2

Number of Published Lectures: 45

Number of Published Quizzes: 1

Number of Curriculum Items: 48

Number of Published Curriculum Objects: 46

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

  • At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.
  • You will be familiarized with some of the core concepts of RDBMS / SQL Server.
  • You will learn the ins and outs of SQL Server Management studio.
  • You will start constructing your SELECT statement to retrieve data from SQL Server.
  • You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.
  • You will also know about some of the string functions, date functions, and system functions.
  • You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).
  • You will also see how to use UNION / UNION ALL operators and as to how they differ from JOINS.
  • You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

Who Should Attend

  • Anyone who is just starting out on their database career.
  • Information workers who work with database.
  • Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant.
  • Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc.
  • Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461
  • Quality Analyst people who need to understand the workings of a database while they do their software testing.
  • Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology.
  • Business Professional
  • Accountants
  • Software Developers
  • Programming Students
  • Financial Analysts

Target Audiences

  • Anyone who is just starting out on their database career.
  • Information workers who work with database.
  • Healthcare professionals who need to understand the working of database in order to make sure that their PHI data remains HIPAA compliant.
  • Finance professionals who need to understand how their data is stored in database and as to how SQL Server provides a better data storing mechanism in strict regulatory environments, such as Sarbanes-Oxley (SOX), Dodd-Frank, Basel II etc.
  • Anyone looking for their first stepping stone to start working on their Microsoft Certification 70-461
  • Quality Analyst people who need to understand the workings of a database while they do their software testing.
  • Managers who need to understand as to how their data is handled by the database while they try to adopt agile development methodology.
  • Business Professional
  • Accountants
  • Software Developers
  • Programming Students
  • Financial Analysts

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, IBMetc.

· Getting around SQL Server Management Studio

· Details of System databases

· Constructing SELECT statementstarting 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 matchingusing 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/ ALLpredicates

· Aggregate functions

· Using GROUP BY clause

·Using HAVING clause

What you’ll learn

· At the completion of the course, you will know how to install SQL Server and create a practice environment for yourself.

· You will be familiarized with some of the core concepts of RDBMS / SQL Server.

· You will learn the ins and outs of SQL Server Management studio.

· You will start constructing your SELECT statement to retrieve data from SQL Server.

· You will know how to filter out unwanted data by using WHERE clause as well as, you would know how to order your result set by using ORDER BY clause.

· You will also know about some of the string functions, date functions, and system functions.

· You will see how to get data out of multiple tables using JOIN ( INNER / LEFT OUTER / RIGHT OUTER / FULL OUTER / CROSS JOINS).

· You will also see how to use UNION / UNION ALL operators and as to how they differ from JOINS.

· You will see how to group and summarize your data by using , GROUP BY clause, HAVING clause and Aggregate functions.

Course Curriculum

Chapter 1: Course and Instructor Introduction

Lecture 1: Course and Instructor Introduction

Chapter 2: Laying out the foundation – Overview & Installation

Lecture 1: Pre-requisites & Different Editions of SQL Server

Lecture 2: Learn SQL Server : New location for Adventure Works Database download

Lecture 3: Downloading Express Edition & sample database

Lecture 4: Installing the downloads & Configuration

Lecture 5: The sa Login

Lecture 6: Wrap up – what we went over !

Chapter 3: Core concepts – Taming the RDBMS beast !

Lecture 1: What is RDBMS ?

Lecture 2: Where does SQL Server fit in ?

Lecture 3: Basic database objects

Lecture 4: Different Files that got installed – MDF & LDF

Lecture 5: Wrap up – what we went over !

Chapter 4: Tool of the trade – SQL Server Management Studio

Lecture 1: Getting started with SSMS

Lecture 2: Getting around Object Explorer

Lecture 3: Query Window

Lecture 4: Pre built DB – system database

Lecture 5: Wrap up – what we went over !

Chapter 5: Simple SELECT

Lecture 1: Bare Minimum : SELECTING a literal

Lecture 2: Retrieving / Querying data from a table – using FROM clause

Lecture 3: Playing with Column Names

Lecture 4: Rearranging columns to your liking

Lecture 5: Wrap up – what we went over !

Chapter 6: Filtering out unwanted data

Lecture 1: Narrowing down and ordering result set – WHERE and ORDER clause

Lecture 2: Narrowing down result set – BETWEEN / NOT BETWEEN

Lecture 3: Narrowing down result set – IN and NOT IN operator

Lecture 4: Narrowing down result set – Pattern Matching : LIKE and Wildcards

Lecture 5: Wrap up – what we went over !

Chapter 7: Expressions and Functions

Lecture 1: Dealing with nothing : NULL

Lecture 2: Working with strings : Concatenation and other string functions

Lecture 3: Working with dates : Date Functions

Lecture 4: Some System Functions

Lecture 5: Wrap up – what we went over !

Chapter 8: Getting data out of multiple tables

Lecture 1: Joining multiple tables – INNER JOIN

Lecture 2: Join types – OUTER JOIN – LEFT / RIGHT / FULL

Lecture 3: Join types – CROSS JOIN

Lecture 4: Holy UNION !

Lecture 5: A bite of Sub…….queries

Lecture 6: Wrap up – what we went over !

Chapter 9: Summarizing and Grouping data

Lecture 1: DISTINCT and ALL Predicates

Lecture 2: Aggregate Functions

Lecture 3: GROUP BY clause / HAVING clause

Lecture 4: WHERE and ORDER BY in aggregate queries

Lecture 5: Wrap up – what we went over !

Chapter 10: Bonus

Lecture 1: Bonus

Lecture 2: Learn Microsoft SQL Server : Useful Links

Instructors

  • Rashid Khan
    Rashid Khan
    Microsoft Certified-Business Intelligence Consultant

Rating Distribution

  • 1 stars: 7 votes
  • 2 stars: 7 votes
  • 3 stars: 17 votes
  • 4 stars: 42 votes
  • 5 stars: 75 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

Email Marketing. Increase Sales With Email Marketing!

TikTok Marketing Domination : Mastering Marketing Strategies

Video Email Marketing Made Easy