MSSQL | Azure SQL : SQL Management Studio : Transact SQL
MSSQL | Azure SQL : SQL Management Studio : Transact SQL, available at $49.99, has an average rating of 4.4, with 52 lectures, based on 61 reviews, and has 11193 subscribers.
You will learn about How to install SQL Server Database Management System How to install SQL Server Management Studio -SSMS How to create a database and table How to fetch data from a database with SELECT Statement How to update existing records inside a database table How to delete records Setup Free Azure Account How to provision an azure SQL Database Server How to create an azure database How to query azure SQL Database using azure portal Connect to Azure SQL using SSMS Connect to Azure SQL using Azure Data Studio This course is ideal for individuals who are Beginner Database Administrators or Beginner Data Analyst or Beginner SQL Analyst or Beginner Data Scientist It is particularly useful for Beginner Database Administrators or Beginner Data Analyst or Beginner SQL Analyst or Beginner Data Scientist.
Enroll now: MSSQL | Azure SQL : SQL Management Studio : Transact SQL
Summary
Title: MSSQL | Azure SQL : SQL Management Studio : Transact SQL
Price: $49.99
Average Rating: 4.4
Number of Lectures: 52
Number of Published Lectures: 52
Number of Curriculum Items: 52
Number of Published Curriculum Objects: 52
Original Price: $54.99
Quality Status: approved
Status: Live
What You Will Learn
- How to install SQL Server Database Management System
- How to install SQL Server Management Studio -SSMS
- How to create a database and table
- How to fetch data from a database with SELECT Statement
- How to update existing records inside a database table
- How to delete records
- Setup Free Azure Account
- How to provision an azure SQL Database Server
- How to create an azure database
- How to query azure SQL Database using azure portal
- Connect to Azure SQL using SSMS
- Connect to Azure SQL using Azure Data Studio
Who Should Attend
- Beginner Database Administrators
- Beginner Data Analyst
- Beginner SQL Analyst
- Beginner Data Scientist
Target Audiences
- Beginner Database Administrators
- Beginner Data Analyst
- Beginner SQL Analyst
- Beginner Data Scientist
MSSQLis a suite of database software published by Microsoft and used extensively within our enterprise. Typically, it includes a relational database engine, which stores data in tables, columns and rows, Integration Services (SSIS), which is a data movement tool for importing, exporting and transforming data, Reporting Services (SSRS), which is used to create reports and serve reports to end users, and also Analysis Services (SSAS), which is a multidimensional database used to query data from the main database engine.
Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.
Transact-SQL (T-SQL) is Microsoft’s and Sybase’s proprietary extension to the SQL (Structured Query Language) used to interact with relational databases. T-SQL expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. and changes to the DELETE and UPDATE statements.
Transact-SQL is central to using Microsoft SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.
Course Curriculum
Chapter 1: Microsoft SQL Server Setup
Lecture 1: Course Introduction
Lecture 2: What is SQL Server
Lecture 3: What is SQL
Lecture 4: What is MSSQL
Lecture 5: What is Transact SQL
Lecture 6: Hardware and Software Requirements
Lecture 7: SQL Server Editions
Lecture 8: Download SQL Server
Lecture 9: Install SQL Server
Lecture 10: Install SQL Server Management Studio
Lecture 11: Connect to SQL Server with SSMS
Lecture 12: SQL Server Configuration Manager
Lecture 13: Reset SA Account with SSMS
Lecture 14: Install sample database
Lecture 15: Database Concepts
Chapter 2: Creating Database Objects with Transact-SQL (T-SQL)
Lecture 1: Create a new database
Lecture 2: Create a table
Lecture 3: Insert records into table
Lecture 4: Querying database
Lecture 5: Updating records in database
Lecture 6: Deleting records in a database
Chapter 3: Filtering Data with SSMS & T-SQL
Lecture 1: Introduction
Lecture 2: Filtering data using Equality Filters
Lecture 3: Filtering data using Comparison Filters
Lecture 4: Filtering data using Logical Filters
Lecture 5: Filtering data using String Filters
Lecture 6: Filtering data using NULL Values
Chapter 4: Sorting Data with SSMS & T-SQL
Lecture 1: Introduction
Lecture 2: ORDER BY Clause
Lecture 3: Sorting data in ascending order
Lecture 4: Sorting data in descending order
Lecture 5: Sorting data by multiple columns
Chapter 5: Azure Setup
Lecture 1: What is Azure
Lecture 2: What is Azure SQL
Lecture 3: Create Azure account
Lecture 4: Accessing Azure services
Lecture 5: Create a database in azure portal
Lecture 6: Query SQL Database with azure portal
Chapter 6: Connect SQL Server Management Studio to Azure SQL
Lecture 1: Connecting to Azure SQL
Lecture 2: Inserting Data into Azure SQL Database
Lecture 3: Update data in Azure SQL Database
Lecture 4: Delete Data from Azure SQL Database
Lecture 5: Create tables in Azure SQL with SSMS
Lecture 6: Create database diagrams
Lecture 7: Install Command line utilities
Lecture 8: Bulk Load Data using BCP
Lecture 9: Query data with SSMS
Chapter 7: Connect to Azure SQL with Azure Data Studio
Lecture 1: Install Azure Data Studio
Lecture 2: Connect to Azure SQL Database
Lecture 3: Create a new database
Lecture 4: Create a table
Lecture 5: Insert data and query data
Instructors
-
Bluelime Learning Solutions
Making Learning Simple
Rating Distribution
- 1 stars: 2 votes
- 2 stars: 0 votes
- 3 stars: 6 votes
- 4 stars: 23 votes
- 5 stars: 30 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple