The 2023 Professional Microsoft SQL Database Development Bundle

2 Reviews
8 Courses & 22 Hours
$40.00$1,600.00
You save 97% -

What's Included

SQL for Beginners with Microsoft SQL Server Database
  • Experience level required: Beginner
  • Access 26 lectures & 2 hours of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

26 Lessons (2h)

  • Your First Program

  • Introduction

    Introduction1:47
    Installing the SQL Server3:01
    Understanding the SQL Server Structure4:25
    What is Normalization?4:26
    Restoring a Backup Database with AdventureWorks3:39
  • Finding Data in the Database

    SQL Query to Select Data from a Table12:39
    Selecting Top N records5:04
    Narrowing Down the Result Set with the WHERE Clause7:20
    Pattern Matching Using LIKE in the WHERE Clause4:46
    Specifying Multiple Values from a Column Using IN in the WHERE Clause5:05
    Sorting the Result Set4:48
    Selecting a Unique Result Set3:08
    Joining Multiple Tables to Get the Desired Result Set10:25
    Using Aliases in SQL7:38
    Aggregating the Data in SQL - COUNT, MIN, and MAX12:57
    Aggregating the Data in SQL - SUM and AVG4:05
    Identifying Null Values Using an Aggregate function3:52
    Using Aggregate Functions in the WHERE Clause4:04
  • Manipulating Data Using the SELECT Statement

    Combining Multiple Columns and String Values4:39
    Extracting Characters from a String - Learn LEFT, RIGHT, and SUBSTRING Functions5:19
    Finding the Length of a String/Column and Position of a Character in a Column3:57
  • Other Key SQL Statements

    Inserting Values in a Table Using SQL Statements5:03
    Updating Records in a Table Using SQL Statements4:45
    Deleting Records from a Table Using SQL Statements3:26
    Outer Join - Left and Right7:06
  • Conclusion

    Conclusion0:16

SQL for Beginners with Microsoft SQL Server Database

PP
Packt Publishing

Packt Publishing | Tech Knowledge in Motion

4.0/5 Instructor Rating: ★ ★ ★ ★

Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and information services to IT professionals. Working towards that vision, it has published over 4,000 books and videos so far, providing IT professionals with the actionable knowledge they need to get the job done–whether that’s specific learning on an emerging technology or optimizing key skills in more established tools.

Description

SQL is a powerful tool you can use to manage your data. This course will teach you how to extract data on your own and give you the confidence to use SQL with Microsoft SQL Server to pull data for conducting marketing analysis without relying on anyone.

4.8/5 average rating: ★ ★ ★ ★

  • Access 26 lectures & 2 hours of content 24/7
  • Know the difference between the query language & the databases
  • Understand the SQL Server Structure
  • Learn how to insert & delete values in a table using SQL Statements

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop or mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: beginner
  • Updates included
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Basic computer skills
  • Basic understanding of marketing
  • Basic understanding of marketing, web or digital analytics

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.
Your cart is empty. Continue Shopping!
Processing order...