SQL Server Essentials, from Scratch

Step-by-Step Beginner's Training Course in SQL Server. No prior database knowledge is needed.

  • 0.0 (0 Reviews)
  • 0 Students
  • 56 Lessons
  • Joey Blue

Course Overview

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.

See more

FAQ

FAQ area empty

Course curriculum

7 chương 56 bài học 13 giờ 16 phút 7 bài học thử miễn phí
Chương 1 Foundation
Chương 2 Module #1: Introduction to Databases
  • Lesson #1: Overview of Databases 16:20
  • Lesson #2: SQL – How to Talk to Databases 14:20
  • Lesson #3: Client-Server Relationships Part 1 15:25
  • Lesson #4: Client-Server Relationships Part 2 19:05
Chương 3 Module #2: Management Studio
  • Lesson #5: Introduction Management Studio Part 1 1:42
  • Lesson #6: Introduction Management Studio Part 2 31:49
  • Lesson #7: Database Objects Part 1 5:06
  • Lesson #8: Database Objects Part 2 17:29
  • Lesson #9: Tables Part 1 8:06
  • Lesson #10: Tables Part 2 28:33
  • Lesson #11: Creating Stuff Part 1 25:58
  • Lesson #12: Creating Stuff Part 2 29:52
  • Lesson #13: Creating Stuff with Scripts Part 1 20:10
  • Lesson #14: Creating Stuff with Scripts Part 2 28:51
Chương 4 Module #3: Writing SQL
  • Lesson #15: CRUD Part 1 24:30
  • Lesson #16: CRUD Part 2 25:55
  • Lesson #17: Beginning Select Statements 6:23
  • Lesson #18: Where Clause Part 1 15:56
  • Lesson #19: Where Clause Part 2 15:30
  • Lesson #20: Sorting 12:48
  • Lesson #21: Column List Part 1 14:23
  • Lesson #22: Column List Part 2 14:31
  • Lesson #23: Group By 16:45
  • Lesson #24: Having Clause 11:32
  • Lesson #25: Joining Part 1 12:43
  • Lesson #26: Joining Part 2 14:26
Chương 5 Module #4: Advanced Objects
  • Lesson #27: Views Part 1 30:05
  • Lesson #28: Views Part 2 27:02
  • Lesson #29: Scripting with Variables Part 1 10:17
  • Lesson #30: Scripting with Variables Part 2 15:17
  • Lesson #31: Stored Procedures Part 1 14:04
  • Lesson #32: Stored Procedures Part 2 18:24
  • Lesson #33: Functions Part 1 10:02
  • Lesson #34: Functions Part 2 13:01
Chương 6 Module #5: Advanced Database Concepts
  • Lesson #35: Security Part 1 5:38
  • Lesson #36: Security Part 2 20:05
  • Lesson #37: Security Part 3 26:42
  • Lesson #38: Backups Part 1 6:23
  • Lesson #39: Backups Part 2 13:13
  • Lesson #40: Indexes Part 1 9:28
  • Lesson #41: Indexes Part 2 6:45
  • Lesson #42: Indexes Part 3 13:44
Chương 7 Bonuses
  • Bonus #1: SQL and SQL Server Reporting Services 25:35
  • Bonus #2: SQL and Microsoft Excel 13:50
  • Bonus #3: SQL and Power Pivot 10:22
  • Bonus #4: SQL and Microsoft Access 20:57
  • Bonus #5: SQL Import and Export 16:06

Requirment

  • PC (Desktop or Laptop)

  • SQL Server Developer (FREE Edition)

  • Browser and Internet Connection

Outcomes

  • 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.

Instructor

...
Joey Blue

0.0

  • ... 0 Student
  • ... 1 Course
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all