Complete Microsoft SQL Server from Scratch: Bootcamp
Master Microsoft SQL Server with Real-World Data Science Exercises
Updated on Apr, 2024
Language - English
Development,Data Science,SQL Server
Lectures -59
Duration -8.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Microsoft SQL Server Bootcamp covers the full range of Microsoft SQL Server topics, from beginner to advanced. It is designed to give you the skills you need to develop and manage SQL databases in a real-world environment.
The Complete Microsoft SQL Server Bootcamp Overview
This course is designed for anyone who wants to learn Microsoft SQL Server from scratch. This course will teach you everything you need to know to succeed in SQL database application development. You will also learn how to develop a SQL database using SQL language and perform practical data science exercises.
Microsoft SQL Server is a powerful relational database management system (RDBMS) that is used by organizations of all sizes to store and manage data. It is known for its scalability, reliability, and security. In this course, you will learn the fundamentals of Microsoft SQL Server, including:
- SQL data types
- SQL queries
- SQL statements
- SQL built-in functions
- SQL programming
- SQL reading and updating data rows
- How to use SSMS for Microsoft SQL Server
- SQL commands, clauses, and operators
- Database import and export using GUI tools
Goals
What will you learn in this course:
- Use Microsoft SQL Server to store and manage data
- Write and execute SQL queries to retrieve and manipulate data
- Create, alter, and drop tables in a database
- Use SQL built-in functions to perform mathematical and logical operations
- Develop and maintain SQL programs
- Import and export data from a database using GUI tools
- Perform data science exercises using SQL
Prerequisites
What are the prerequisites for this course?
- Basic knowledge of computers.
- No prior technical experience is required.
Curriculum
Check out the detailed breakdown of what’s inside the course
Course Introduction
3 Lectures
-
Introduction
03:54
03:54
-
Course Curriculum overview
04:23
04:23
-
Overview of Databases
08:56
08:56
MS SQL Environment Setup
4 Lectures
SQL Statement Basics
6 Lectures
Filtering Data Rows
2 Lectures
SQL Operators
5 Lectures
GROUP BY Statements
6 Lectures
Assessment Test 1
1 Lectures
JOINS
8 Lectures
Advanced SQL Commands
6 Lectures
Creating Database and Tables
4 Lectures
Primary Key and Foreign Key
2 Lectures
SQL CRUD Operations
5 Lectures
MS SQL Constraints
3 Lectures
Backup and Restore Functions
3 Lectures
Instructor Details
Metla sudha sekhar
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now