SQL Server Essentials, from Scratch

SQL Server Essentials, from Scratch, available at $109.99, has an average rating of 4.42, with 56 lectures, based on 1801 reviews, and has 8255 subscribers.

You will learn about By the end of the course, you will have a foundation in SQL Server and the vocabulary and understanding to talk about and use SQL Server with confidence. You will know how to navigate SQL Server Management Studio (SSMS) to find database objects and business data. You will understand how to take advantage of Management Studio to make you work faster and more efficient. You will understand the different pieces in SQL Server. Including, Tables, Views, Stored Procedures, Security, Backups, Indexes and Schemas to help you talk to DBA's, Programmers, IT and to sound smart when you are speaking about databases. You will know how to write SQL statements to CREATE, Retrieve, Update, and Delete data. You will be able to create basic Views and Stored Procedures. You will be able to Filter, Join, Sort, and Group data. You will be able to create basic Views, Stored Procedures, and Functions. You will have foundational knowledge in Security, Backups, and Indexes You will understand how all of these pieces work together in a database. This course is ideal for individuals who are Business Analysts or IT Professional or Business Professional or Accountants or Web Developers or Managers or Software Developers or Programming Students or Financial Analysts or Process Engineers or Anyone interested in understanding data and databases. It is particularly useful for Business Analysts or IT Professional or Business Professional or Accountants or Web Developers or Managers or Software Developers or Programming Students or Financial Analysts or Process Engineers or Anyone interested in understanding data and databases.

Enroll now: SQL Server Essentials, from Scratch

Summary

Title: SQL Server Essentials, from Scratch

Price: $109.99

Average Rating: 4.42

Number of Lectures: 56

Number of Published Lectures: 56

Number of Curriculum Items: 56

Number of Published Curriculum Objects: 56

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

By the end of the course, you will have a foundation in SQL Server and the vocabulary and understanding to talk about and use SQL Server with confidence.
You will know how to navigate SQL Server Management Studio (SSMS) to find database objects and business data.
You will understand how to take advantage of Management Studio to make you work faster and more efficient.
You will understand the different pieces in SQL Server. Including, Tables, Views, Stored Procedures, Security, Backups, Indexes and Schemas to help you talk to DBA's, Programmers, IT and to sound smart when you are speaking about databases.
You will know how to write SQL statements to CREATE, Retrieve, Update, and Delete data.
You will be able to create basic Views and Stored Procedures.
You will be able to Filter, Join, Sort, and Group data.
You will be able to create basic Views, Stored Procedures, and Functions.
You will have foundational knowledge in Security, Backups, and Indexes
You will understand how all of these pieces work together in a database.

Who Should Attend

Business Analysts
IT Professional
Business Professional
Accountants
Web Developers
Managers
Software Developers
Programming Students
Financial Analysts
Process Engineers
Anyone interested in understanding data and databases.

Target Audiences

Business Analysts
IT Professional
Business Professional
Accountants
Web Developers
Managers
Software Developers
Programming Students
Financial Analysts
Process Engineers
Anyone interested in understanding data and databases.

You learned a little SQL, but you are ready to take the next step and really understand how databases work. Or maybe you are a complete beginner. Here’s a little secret. It’s not that complicated. That’s right. Databases are actually a very simple concept that starts with a simple Table just like a spreadsheet in Excel. Everything else in the database is built around this little concept of a table.

With a little SQL Server knowledge, you can retrieve data yourself. You can automate your reporting. You can help management find information and troubleshoot problems. You can even transfer this knowledge to Oracle and MySQL.

In this course, veteran consultant, Joey Blue, takes you through the essentials of SQL Server right through advanced topics such as backups, security, and indexes. This course is recommended for all business and IT professionals that want to advance their careers by understanding their corporate database.

Course Curriculum

Chapter 1: Foundation

Lecture 1: Welcome

Lecture 2: Learning Plan

Lecture 3: Learning Outline

Lecture 4: Pre Assessment

Lecture 5: Vocabulary List

Lecture 6: Installing SQL Server Developer Edition

Lecture 7: Installing SQL Server Management Studio

Lecture 8: Installing Training Database – SQLTrainingOnlineSimpleDB

Lecture 9: Installing Training Database – AdventureWorks

Chapter 2: Module #1: Introduction to Databases

Lecture 1: Lesson #1: Overview of Databases

Lecture 2: Lesson #2: SQL – How to Talk to Databases

Lecture 3: Lesson #3: Client-Server Relationships Part 1

Lecture 4: Lesson #4: Client-Server Relationships Part 2

Chapter 3: Module #2: Management Studio

Lecture 1: Lesson #5: Introduction Management Studio Part 1

Lecture 2: Lesson #6: Introduction Management Studio Part 2

Lecture 3: Lesson #7: Database Objects Part 1

Lecture 4: Lesson #8: Database Objects Part 2

Lecture 5: Lesson #9: Tables Part 1

Lecture 6: Lesson #10: Tables Part 2

Lecture 7: Lesson #11: Creating Stuff Part 1

Lecture 8: Lesson #12: Creating Stuff Part 2

Lecture 9: Lesson #13: Creating Stuff with Scripts Part 1

Lecture 10: Lesson #14: Creating Stuff with Scripts Part 2

Chapter 4: Module #3: Writing SQL

Lecture 1: Lesson #15: CRUD Part 1

Lecture 2: Lesson #16: CRUD Part 2

Lecture 3: Lesson #17: Beginning Select Statements

Lecture 4: Lesson #18: Where Clause Part 1

Lecture 5: Lesson #19: Where Clause Part 2

Lecture 6: Lesson #20: Sorting

Lecture 7: Lesson #21: Column List Part 1

Lecture 8: Lesson #22: Column List Part 2

Lecture 9: Lesson #23: Group By

Lecture 10: Lesson #24: Having Clause

Lecture 11: Lesson #25: Joining Part 1

Lecture 12: Lesson #26: Joining Part 2

Chapter 5: Module #4: Advanced Objects

Lecture 1: Lesson #27: Views Part 1

Lecture 2: Lesson #28: Views Part 2

Lecture 3: Lesson #29: Scripting with Variables Part 1

Lecture 4: Lesson #30: Scripting with Variables Part 2

Lecture 5: Lesson #31: Stored Procedures Part 1

Lecture 6: Lesson #32: Stored Procedures Part 2

Lecture 7: Lesson #33: Functions Part 1

Lecture 8: Lesson #34: Functions Part 2

Chapter 6: Module #5: Advanced Database Concepts

Lecture 1: Lesson #35: Security Part 1

Lecture 2: Lesson #36: Security Part 2

Lecture 3: Lesson #37: Security Part 3

Lecture 4: Lesson #38: Backups Part 1

Lecture 5: Lesson #39: Backups Part 2

Lecture 6: Lesson #40: Indexes Part 1

Lecture 7: Lesson #41: Indexes Part 2

Lecture 8: Lesson #42: Indexes Part 3

Chapter 7: Bonuses

Lecture 1: Bonus #1: SQL and SQL Server Reporting Services

Lecture 2: Bonus #2: SQL and Microsoft Excel

Lecture 3: Bonus #3: SQL and Power Pivot

Lecture 4: Bonus #4: SQL and Microsoft Access

Lecture 5: Bonus #5: SQL Import and Export

Instructors

Joey Blue
Teacher of SQL, Power BI, Databases, and Reporting.

Rating Distribution

1 stars: 15 votes
2 stars: 31 votes
3 stars: 165 votes
4 stars: 645 votes
5 stars: 945 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!

Menu