Left Blocks Image | Learnfly Right Blocks Image | Learnfly
All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Learnfly | Menu Trigger Icons Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart
    Learnfly | Empty Cart Icons

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
4 days left at this price!

This plan includes

  • Limitedfree coursesaccess
  • Play & PauseCourse Videos
  • VideoRecorded Lectures
  • Learn onMobile/PC/Tablet
  • Quizzes andReal Projects
  • Lifetime CourseCertificate
  • Email & ChatSupport
Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to11,000+Courses
  • Adsfree experienceCourses
  • Play & PauseCourse Videos
  • Learnfly HD IconsHD VideoRecorded Lectures
  • Learn onMobile/PC/Tablet
  • Quizzes andReal Projects
  • Lifetime CourseCertificate
  • InstructorDirect Support
  • Email & ChatSupport
  • Cancel Anytime
$29
$29
$29
  • 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.

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.

  • NO PRIOR DATABASE OR SQL experience is required.
  • You need High speed Internet connection with a PC.
  • 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
View More...
  • Section 1 : Course and Instructor Introduction 1 Lectures 00:05:04

    • Lecture 1 :
    • Course and Instructor Introduction Preview
  • Section 2 : Laying out the foundation - Overview & Installation 6 Lectures 00:33:10

    • Lecture 1 :
    • Pre-requisites & Different Editions of SQL Server
    • Lecture 2 :
    • Learn SQL Server : New location for Adventure Works Database download
      ******** Learn SQL Server : New location for Adventure Works Database download ********** (1)Please go to the following Link: https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks2012 (2)Please download the file: “adventure-works-2012-oltp-data-file.mdf” (3)Then follow the instruction of “attaching a database MDF file” as outlined in video “Installing the Downloads & Configuration “under section 2. Thank you !
    • 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 !
  • Section 3 : Core concepts - Taming the RDBMS beast ! 5 Lectures 00:35:11

    • 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 !
  • Section 4 : Tool of the trade - SQL Server Management Studio 5 Lectures 00:23:05

    • 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 !
  • Section 5 : Simple SELECT 5 Lectures 00:15:49

    • 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 !
  • Section 6 : Filtering out unwanted data 5 Lectures 00:42:27

    • 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 !
  • Section 7 : Expressions and Functions 5 Lectures 00:34:59

    • 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 !
  • Section 8 : Getting data out of multiple tables 6 Lectures 00:27:47

    • 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 !
  • Section 9 : Summarizing and Grouping data 5 Lectures 00:10:10

    • 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 !
  • Learnfly Google Logo
  • Learnfly Facebook Logo
  • Learnfly Apple Logo
  • Learnfly EA Logo
  • Learnfly Amazon Logo
  • Learnfly IBM Logo
  • Learnfly Microsoft Logo
  • Learnfly Reddit Logo
  • Learnfly Spotify Logo
  • Learnfly Uber Logo
  • Learnfly Youtube Logo
  • Learnfly Instagram Logo
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
    Learnfly LMS Sample
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
User Images | Learnfly

8819 Course Views

1 Courses

  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • infinite-scroll-project-ajax-mysql-api-php-jquery

    Infinite Scroll Project AJAX MySQL ...

    By : Laurence Svekis

    Lectures 19 Beginner 1:26:34
  • learn-to-build-sql-query-ultimate-sql-and-database-concepts

    Learn to Build SQL Query Ultimate S...

    By : Jazeb Akram

    Lectures 24 Beginner 2:11:45
  • sql-nosql-big-data-and-hadoop

    SQL, NoSQL, Big Data and Hadoop

    By : Michael Enudi

    Lectures 129 All Level 19:51:53
  • oracle-apps-r12-general-ledger-course

    Oracle Apps R12 General Ledger Cour...

    By : koduru sridevi

    Lectures 14 All Level 5:53:1

Students learning on Learnfly works with Fortune 500 companies around the globe.

  • Learnfly | a-l-1a Icons
  • Learnfly | a-l-2a Icons
  • Learnfly | a-l-3a Icons
  • Learnfly | a-l-4a Icons
  • Learnfly | a-l-6a Icons
  • Learnfly | a-l-7a Icons
Sign Up & Start Learning
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.
Learnfly | Sign Up Icons