Database Design & Development Basics
Fundamental principles and concepts
Database Administrator (DBA) | Developer- MS SQL Server,TSQL
Microsoft SQL Server Database Administration step by step
radio_button_checkedPersonal Plan
₹375/mo
₹50025% OFF
Get this course and thousands more with a Personal Plan subscription.
radio_button_uncheckedIndividual Course
₹449₹273984% OFF
Keep the course forever with lifetime access and receive a certificate.
Team Plan₹2,000.00 a month per user
₹24,000/mo
Enterprise PlanCustom Pricing
Custom Pricing
Why choose Personal Plan?
verifiedGet this course for free with the Personal Plan subscription.
✓ Compare courses before making a decision
Check Latest Price →Price may vary. Check latest price on provider site.
Course Insight
Suitable for intermediate learners. Works well as a continuation after mastering Database Design & Development fundamentals. It bridges the gap toward advanced, production-level engineering.
Intermediate FriendlyCertification FocusedSelf-Paced Learning
SKILLS TO
MASTER
Practical ApplicationTrending
Real-world project implementationBest Practices
Industry standard workflows and guidelinesCareers:Cloud Engineer, DevOps Engineer, Solutions Architect.
Quick Facts
Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.
What You’ll Learn
SQL Server
is Microsoft’s relational database management software and uses a common set of tools to deploy and manage databases both on-premises and in the cloud.
Microsoft SQL Server Management Studio
is a rich, integrated administrative client designed to meet the SQL Server and Azure SQL Database administrator's server management requirements. In Management Studio, administrative tasks are accomplished using Object Explorer, which allows you to connect to any server in the SQL Server family and graphically browse its contents. A server can be an instance of the Database Engine, Analysis Services, Reporting Services, Integration Services or Azure SQL Database. The tool components of Management Studio include Registered Servers, Object Explorer, Solution Explorer, Template Explorer, the Object Explorer Details page, and the document window. Use Management Studio to:
Register servers.
Connect to an instance of the Database Engine, SSAS, SSRS, SSIS or Azure SQL Database.
Configure server properties.
Manage database and SSAS objects such as cubes, dimensions, and assemblies.
Create objects, such as databases, tables, cubes, database users, and logins.
Manage files and filegroups.
Attach or detach databases.
Launch scripting tools.
Manage security.
View system logs.
Monitor current activity.
Configure replication.
Manage full-text indexes.
SQL Server Data Tools (SSDT)
is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
T-SQL
, which stands for Transact-SQL and is sometimes referred to as TSQL, is an extension of the SQL language used primarily within Microsoft SQL Server. This means that it provides all the functionality of SQL but with some added extras.
See how this course curriculum compares with alternatives
Outcomes
- Microsoft SQL Server Setup .
- Installing Sample Databases .
- Creating Database Objects .
- Database Design .
- Tracking database activities .
- Creating stored procedures .
- Database backup and recovery .
- Monitoring Database Performance .
- Database security and user accounts .
- Querying Database with T-SQL .
- Aggregating Data using aggregate functions .
- Filtering and sorting records .
- Extracting data from multiple tables Show moreShow less.
See side-by-side differences in learning outcomes
Course Curriculum
14 sections • 117 lectures • 10h 55m total length
FAQs
Instructor
BL
Bluelime Learning Solutions
4.2 Rating45,013 Reviews794,383 Students404 Courses
Bluelime Learning Solutions
Making Learning Simple
Welcome to the vibrant learning hub of Bluelime Learning Solutions! Based in the UK, we are dedicated to crafting high-quality, easily digestible eLearning experiences. With a robust following of over 776,000 students and backed by more than 43,000 reviews, we take pride in delivering educational content that not only enlightens but also empowers.
At Bluelime Learning Solutions, our approach is simple: clear, direct, and engaging. We specialize in 100% video-based courses filled with hands-on examples that provide practical skills applicable in real-world scenarios. Our courses are designed to translate complex concepts into easy-to-understand lessons that anyone, regardless of their background, can grasp and apply.
Our extensive experience includes collaborating on projects with Fortune 500 companies, equipping us with the insights needed to understand the essential skills that today’s employers value most. At Bluelime, we’re not just about teaching; we’re about equipping you with the tools and knowledge to excel in your career and personal growth endeavors.
Join us on this journey to unlock your potential and master new skills in an easy, enjoyable, and efficient way with Bluelime Learning Solutions, where learning is made simple and effective.
Reviews
⭐4.7 / 5 average rating from 62+ learners
View detailed reviews on Udemy →Unsure about these reviews? Compare with other top courses
Deals
This course is currently available at a discounted price ₹449 ₹2739 (84% OFF) on Udemy. Udemy also offers deals on other courses from time to time — click below to explore
Explore Deals on Udemy →Deals and prices are set by the provider and may change. Please check final details on the provider’s site.
Top Alternatives
Highly-rated courses worth your attention
⭐ 4.2(62+ learners)