0.0 (0)
Data Science and Machine Learning

SQL Server: Basic Microsoft SQL Server

Overview: Welcome to our comprehensive online course, "SQL Server: Basic Microsoft SQL Server," designed to provide you with a solid foundation in ut...

Img

43 Lesson

Img

3hr 52min

Img

4 students enrolled

Overview:

Welcome to our comprehensive online course, "SQL Server: Basic Microsoft SQL Server," designed to provide you with a solid foundation in utilizing Microsoft SQL Server for database management and querying. Throughout this course, you'll learn essential SQL Server concepts and techniques, empowering you to effectively interact with databases, write SQL queries, and perform basic database administration tasks. Our interactive modules ensure an engaging learning experience, with practical exercises and real-world examples to reinforce your understanding of SQL Server fundamentals.
  • Interactive video lectures by industry experts
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • Introduction to Microsoft SQL Server and its architecture
  • Understanding SQL Server databases, tables, and relationships
  • Writing SQL queries to retrieve and manipulate data
  • Basic database administration tasks such as backup and restore
  • Hands-on exercises and quizzes for practical application
  • Guidance on best practices for SQL Server development and administration

Who Should Take This Course:

  • Beginners with little to no experience in SQL Server
  • Database administrators seeking to expand their skills to SQL Server
  • IT professionals interested in database management and querying

Learning Outcomes:

  • Understand the architecture and components of Microsoft SQL Server
  • Create and manage databases, tables, and relationships
  • Write SQL queries to retrieve and manipulate data
  • Perform basic database administration tasks such as backup and restore
  • Apply best practices for SQL Server development and administration
  • Troubleshoot common SQL Server issues
  • Interpret and analyze SQL Server query execution plans
  • Develop foundational skills for advanced SQL Server topics

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.
Course Content
43 Lectures 3hr 52min
  • ImgPre-requisites & Different Editions of SQL Server

  • ImgDownloading Express Edition & sample database

  • ImgInstalling the downloads & Configuration

  • ImgThe sa Login

  • ImgWrap up – what we went over!

  • ImgWhat is RDBMS?

  • ImgWhere does SQL Server fit in?

  • ImgBasic database objects

  • ImgDifferent Files that got installed – MDF & LDF

  • ImgWrap up – what we went over!

  • ImgGetting started with SSMS

  • ImgGetting around Object Explorer

  • ImgQuery Window

  • ImgPre-built DB – system database

  • ImgWrap up – what we went over!

  • ImgBare Minimum: SELECTING a literal

  • ImgRetrieving / querying data from a table – using FROM clause

  • ImgPlaying with Column Names

  • ImgRearranging columns to your liking

  • ImgWrap up – what we went over!

  • ImgNarrowing down and ordering result set – WHERE and ORDER clause

  • ImgNarrowing down result set – BETWEEN / NOT BETWEEN

  • ImgNarrowing down result set – IN and NOT IN operator

  • ImgNarrowing down result set – Pattern Matching: LIKE and Wildcards

  • ImgWrap up – what we went over!

  • ImgDealing with nothing: NULL

  • ImgWorking with strings: Concatenation and other string functions

  • ImgWorking with dates: Date Functions

  • ImgSome System Functions

  • ImgWrap up – what we went over!

  • ImgJoining multiple tables – INNER JOIN

  • ImgJoin types – OUTER JOIN – LEFT / RIGHT / FULL

  • ImgJoin types – CROSS JOIN

  • ImgHoly UNION!

  • ImgSubqueries

  • ImgWrap up – what we went over!

  • ImgDISTINCT and ALL Predicates

  • ImgAggregate Functions

  • ImgGROUP BY clause / HAVING clause

  • ImgWHERE and ORDER BY in aggregate queries

  • ImgWrap up – what we went over!