• LOGIN
  • No products in the cart.

Login

Course Curriculum

Course Curriculum

Unit 01: Course and Instructor Introduction
Course and Instructor Introduction 00:05:00
Unit 02: Laying out the foundation - Overview & Installation
Pre-requisites & Different Editions of SQL Server 00:06:00
Downloading Express Edition & sample database 00:03:00
Installing the downloads & Configuration 00:19:00
The sa Login 00:04:00
Wrap up – what we went over! 00:01:00
Unit 03: Core concepts - Taming the RDBMS beast!
What is RDBMS? 00:12:00
Where does SQL Server fit in? 00:02:00
Basic database objects 00:16:00
Different Files that got installed – MDF & LDF 00:03:00
Wrap up – what we went over! 00:01:00
Unit 04: Tool of the trade - SQL Server Management Studio
Getting started with SSMS 00:07:00
Getting around Object Explorer 00:05:00
Query Window 00:06:00
Pre-built DB – system database 00:04:00
Wrap up – what we went over! 00:01:00
Unit 05: Simple SELECT
Bare Minimum: SELECTING a literal 00:05:00
Retrieving / querying data from a table – using FROM clause 00:06:00
Playing with Column Names 00:03:00
Rearranging columns to your liking 00:01:00
Wrap up – what we went over! 00:01:00
Unit 06: Filtering out unwanted data
Narrowing down and ordering result set – WHERE and ORDER clause 00:17:00
Narrowing down result set – BETWEEN / NOT BETWEEN 00:09:00
Narrowing down result set – IN and NOT IN operator 00:05:00
Narrowing down result set – Pattern Matching: LIKE and Wildcards 00:11:00
Wrap up – what we went over! 00:01:00
Unit 07: Expressions and Functions
Dealing with nothing: NULL 00:06:00
Working with strings: Concatenation and other string functions 00:15:00
Working with dates: Date Functions 00:07:00
Some System Functions 00:05:00
Wrap up – what we went over! 00:01:00
Unit 08: Getting data out of multiple tables
Joining multiple tables – INNER JOIN 00:09:00
Join types – OUTER JOIN – LEFT / RIGHT / FULL 00:08:00
Join types – CROSS JOIN 00:02:00
Holy UNION! 00:03:00
Subqueries 00:04:00
Wrap up – what we went over! 00:01:00
Unit 09: Summarizing and Grouping data
DISTINCT and ALL Predicates 00:02:00
Aggregate Functions 00:03:00
GROUP BY clause / HAVING clause 00:04:00
WHERE and ORDER BY in aggregate queries 00:04:00
Wrap up – what we went over! 00:01:00
Unit 10: Bonus
Bonus_Section 00:01:00

Basic Microsoft SQL Server

4.7( 9 REVIEWS )
15 STUDENTS
Duration: 3.83 Hours
$457.31
  • Course Highlights

The Basic Microsoft SQL Server server course is an amazing learning opportunity for those who have an enthusiasm for this topic and are interested in having a significant career in the relevant industry. It’s also for those who are already working in this field and are looking to polish their known knowledge and boost their career with this course.

In this course you will have both theoretical and practical knowledge on how Microsoft SQL server works that will help you to increase your productivity and stand out among the other competitors in the relevant field. Just like all our courses, this course and the curriculum has been outlined by experts so that teachers of the future can learn from the best and furnish themselves with all the requisite skills. The course consists of several modules; the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accustomed to studying at your own comfortable pace.

After purchasing a course, you will have 24/7 student support which would ensure quick and comprehensive attention whenever you are in need of it. Our expert instructors are always available to answer all your questions and make your learning experience exquisite.

Without waiting any further, enroll with us now!

  • Learning outcome
  • All the necessary core concepts
  • Tool of the trade
  • Filtering out unwanted data
  • Getting data out of multiple tables
  • Summarizing and Grouping data
  • Requirements
  • No formal qualifications required, anyone from any academic background can take this course.
  • Access to any internet-enabled smart device.
  • Why should I take this course?
  • 5+ hours of on-demand video lectures and downloadable resources.
  • Affordable premium-quality E-learning content, you can learn at your own pace.
  • You will receive a completion certificate upon completing the course.
  • Internationally recognized Accredited Qualification will boost up your resume.
  • You will learn the researched and proven approach adopted by successful salespeople to transform their careers.
  • You will be able to incorporate various practical sales techniques successfully and understand your customers better.
  • Who is this course for
  • Students
  • Recent graduates
  • Job seekers
  • Anyone interested in this topic
  • People already working in this field and wants to improve their knowledge

Testimonial

Hear what our happy students want to say
Select your currency
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only$68.11 / year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon