0
  • No products in the basket.
IT and Software

Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero

4.5

2

33

Course Line

"Microsoft SQL Server Bootcamp 2022" e-course: Master SQL fundamentals and database expertise. From setup to advanced commands, learn SQL Server basics, data manipulation, constraints, JOINS, and more. Become a confident database pro through hands-on learning. Enrol now and elevate your database skills!

Microsoft SQL Server Bootcamp 2022_ Go from Zero to Hero
Original price was: £194.00.Current price is: £19.99.

Overview

"Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero" is an exciting e-course that teaches you the fundamentals of SQL Server and how to work with databases like a pro. Whether you're an absolute beginner or looking to expand your skills, this course has got you covered. In this e-course, you'll learn about the basics of SQL Server, starting with how to set it up on your computer. You'll then move on to the essentials of SQL databases and how to manipulate data with SQL DML. You'll learn about SQL DDL, SQL DCL, and basic SQL statements, so you can define and control your databases with confidence.

The e-course also covers filtering data rows, aggregate functions, and how to use the SQL Group by the statement. You'll learn about JOINS, SQL Constraints, Views, and advanced SQL commands. Additionally, you'll learn about SQL Stored procedures and how to import and export data. The course concludes with lessons on backup and restoring databases.

By the end of this e-course, you'll be a SQL Server expert, ready to take on any database project. With step-by-step guidance and hands-on exercises, you'll have the skills and knowledge you need to succeed. So, what are you waiting for? Join the Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero e-course and take your database skills to the next level!

What Will You Learn?

  • Setting up SQL Server on their computer
  • The fundamentals of SQL databases
  • Data manipulation with SQL DML
  • SQL Constraints, Views, Advanced SQL commands, Stored procedures, Import & Export data, Backup and Restore Database
  • Basic SQL statements and filtering data rows
  • Aggregate functions, SQL Group by the statement, and JOINs
  • SQL Constraints, Views, Advanced SQL commands, Stored procedures, Import & Export data, Backup and Restore Database
  • Data definition and control with SQL DDL and SQL DCL

Who Should Take The Microsoft SQL Server Bootcamp 2022 Course?

  • Absolute beginners with no prior knowledge of SQL Server
  • IT professionals looking to expand their database skills
  • Data analysts who want to learn SQL Server
  • Business professionals looking to leverage SQL Server for data analysis and reporting
  • Web developers looking to integrate SQL Server into their web applications
  • IT students who want to gain hands-on experience with SQL Server
  • Anyone interested in learning about databases and SQL Server

Requirements

To enrol in the "Microsoft SQL Server Bootcamp 2022: Go from Zero to Hero" e-learning course, students should have a basic understanding of computer systems and a willingness to learn. A laptop or desktop computer with an internet connection is necessary to access the course materials and complete the hands-on exercises. Familiarity with database concepts and SQL syntax is not required but would be beneficial. With an open mind and a commitment to learning, students will be well-equipped to succeed in this e-course.

Course Currilcum

    • Introduction 00:03:00
    • Course Curriculum 00:09:00
    • How to get course requirements 00:02:00
    • Getting started on Windows, Linux or Docker 00:01:00
    • How to ask great questions 00:01:00
    • FAQ’s 00:01:00
    • Source code file 00:10:00
    • Introduction 00:02:00
    • Microsoft SQL Server Installation 00:19:00
    • SQL Server Management Studio (SSMS) Installation 00:09:00
    • How to connect MS SQL (Windows Authentication) 00:04:00
    • How to connect MS SQL (SQL Server Authentication) 00:03:00
    • Download and Restore Sample Database 00:07:00
    • Overview of Databases 00:11:00
    • Creating Database 00:05:00
    • SQL Data Types 00:03:00
    • Column Data Types on SSMS 00:04:00
    • Creating Table 00:09:00
    • Overview of Primary Key and Foreign Key 00:04:00
    • Primary Key 00:04:00
    • Foreign Key 00:07:00
    • Creating Temporary tables 00:06:00
    • Introduction 00:01:00
    • Insert statement 00:08:00
    • Update statement 00:06:00
    • Delete statement 00:03:00
    • Introduction 00:02:00
    • CREATE table statement 00:04:00
    • DROP statement 00:02:00
    • ALTER statement 00:06:00
    • TRUNCATE statement 00:04:00
    • COMMENT in query 00:03:00
    • RENAME 00:02:00
    • Create Database user 00:04:00
    • GRANT permissions 00:06:00
    • REVOKE permissions 00:04:00
    • Introduction 00:03:00
    • SQL Statement basic 00:04:00
    • SELECT Statement 00:09:00
    • SELECT DISTINCT 00:03:00
    • SELECT with column headings 00:03:00
    • Column AS statement 00:02:00
    • SELECT WHERE Clause – theory 00:04:00
    • SELECT WHERE Clause – practical 00:07:00
    • Sum() 00:08:00
    • Min()-Max() 00:07:00
    • Order By statement 00:06:00
    • SELECT TOP clause in SQL 00:04:00
    • BETWEEN command 00:06:00
    • IN operator 00:04:00
    • Wildcard Characters and LIKE 00:05:00
    • Introduction 00:01:00
    • Group by – theory 00:03:00
    • Group by – practical 00:05:00
    • HAVING statement 00:04:00
    • Overview of Joins 00:02:00
    • What are Joins 00:02:00
    • Inner join 00:08:00
    • Left outer join 00:05:00
    • Right outer join 00:02:00
    • Full outer join 00:01:00
    • Union 00:03:00
    • Cross join 00:03:00
    • Query Exercise 00:01:00
    • Solution for Query Exercise 00:04:00
    • Introduction 00:01:00
    • Check constraint 00:07:00
    • NOT NULL constraint 00:08:00
    • UNIQUE constraint 00:08:00
    • Creating Views 00:04:00
    • Reporting with multiple tables 00:03:00
    • Introduction 00:01:00
    • Timestamp 00:06:00
    • Extract from timestamp 00:03:00
    • Mathematical scalar functions 00:04:00
    • String functions 00:05:00
    • Sub Query 00:03:00
    • SELECT with calculations 00:08:00
    • Create stored procedure 00:05:00
    • Stored procedure with parameter 00:04:00
    • Introduction 00:07:00
    • Import Flat File 00:07:00
    • Import .csv or excel file 00:03:00
    • Export Data to Excel or any format 00:08:00
    • Introduction 00:01:00
    • Creating Database backup 00:04:00
    • Restoring Database backup 00:06:00
    • Order Certificate 00:05:00
Template Design © Course Line. All rights reserved.