70-761: Querying Data with Transact-SQL Introductory Course
70-761: Querying Data with Transact-SQL Introductory Course, available at $19.99, has an average rating of 4.6, with 15 lectures, based on 32 reviews, and has 623 subscribers.
You will learn about Understand database design Understand first, second and third normal form schemas Normalize Databases Create new tables, alter existing tables in Databases Create basic SQL Queries Create Left, Right, Inner and Full Outer joins This course is ideal for individuals who are Anybody who wants to learn SQL Server and earn Microsoft Certification. or Anybody who wants to better understand how to query databases and best practices or Anybody who wants to enhance their Data Science career It is particularly useful for Anybody who wants to learn SQL Server and earn Microsoft Certification. or Anybody who wants to better understand how to query databases and best practices or Anybody who wants to enhance their Data Science career.
Enroll now: 70-761: Querying Data with Transact-SQL Introductory Course
Summary
Title: 70-761: Querying Data with Transact-SQL Introductory Course
Price: $19.99
Average Rating: 4.6
Number of Lectures: 15
Number of Published Lectures: 15
Number of Curriculum Items: 15
Number of Published Curriculum Objects: 15
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will Learn
- Understand database design
- Understand first, second and third normal form schemas
- Normalize Databases
- Create new tables, alter existing tables in Databases
- Create basic SQL Queries
- Create Left, Right, Inner and Full Outer joins
Who Should Attend
- Anybody who wants to learn SQL Server and earn Microsoft Certification.
- Anybody who wants to better understand how to query databases and best practices
- Anybody who wants to enhance their Data Science career
Target Audiences
- Anybody who wants to learn SQL Server and earn Microsoft Certification.
- Anybody who wants to better understand how to query databases and best practices
- Anybody who wants to enhance their Data Science career
Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. Its utility lies in its ability to manage large amount of data for small, medium and large enterprise applications. It can be used for data storage as well as for data retrieval for applications which can be either on desktop or Web/Browser. Its nearest competitor product is Oracle Database. Microsoft has been withholding the right to choose, some other database mostly by bundling other Microsoft technologies and services with MS SQL Server. For example, every installation of SharePoint will use SQL Server as backend database and will not provide any other option.
This course is designed in a step function. It starts with most fundamental topics like what is Data and database. It then gradually builds upon this and gets into advanced topics like working with triggers, stored procedures and indexes. This is an ideal start up for those who are willing to find their career in programming web or windows applications using C# or using MSBI tools for data analysis and reports or may be eventually administer database as an SQL-Server DBA.
SQL Server coursehas been compiled together by Mrs. Vandana Soni who has immense experience both as a professional as well as a trainer. The content delivery is in the simplest possible language and it includes detailed explanation of every topic along with step by step approach to build a database schema likes tables, views, stored procedures, triggers, index etc…and write queries to fetch data from it. The video lecture follows the scientific learning methodology of Theory, Demonstration followed by Assignment, which cements your learning.
Course Curriculum
Chapter 1: Create Database
Lecture 1: Create Database
Chapter 2: Create Alter Drop Table
Lecture 1: Create Alter Drop Table
Chapter 3: Create Database Using T – SQL
Lecture 1: Create Database Using T – SQL
Chapter 4: Datatypes Overview
Lecture 1: Datatypes Overview
Chapter 5: Basic DML
Lecture 1: Basic DML
Chapter 6: Schema and Synonym
Lecture 1: Schema and Synonym
Chapter 7: T-SQL Select Queries Overview
Lecture 1: T-SQL Select Queries Overview
Chapter 8: Understanding Simple Select
Lecture 1: Understanding Simple Select
Chapter 9: Sorting Data
Lecture 1: Sorting Data
Chapter 10: Filter using predicates
Lecture 1: Filter using predicates
Chapter 11: Filter Using Top OFFSET – FETCH
Lecture 1: Filter Using Top OFFSET – FETCH
Chapter 12: Working with Unknown Value
Lecture 1: Working with Unknown Value
Chapter 13: Case Expression
Lecture 1: Case Expression
Chapter 14: Set Operation
Lecture 1: Set Operation
Chapter 15: BONUS LECTURE: What Next?
Lecture 1: BONUS LECTURE: What Next?
Instructors
-
Vandana Soni
Data Architect, Deccansoft
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 5 votes
- 4 stars: 13 votes
- 5 stars: 14 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
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024