SQL Server Essentials, from Scratch
Focused View
Joey Blue
13:15:33
43 View
001 Welcome.mp4
03:21
002 SqlEssentials-Learning-Plan.pdf
003 SqlEssentials-Learning-Outline.pdf
004 SqlEssentials-Pre-Assessment.pdf
005 SqlServerVocabularyWorksheet.pdf
006 Installing SQL Server Developer Edition.mp4
03:07
007 Installing SQL Server Management Studio.mp4
04:01
008 Installing Training Database - SQLTrainingOnlineSimpleDB.mp4
03:47
009 Installing Training Database - AdventureWorks.mp4
06:07
external-links.txt
001 Lesson #1 Overview of Databases.mp4
16:20
001 Lesson-1-Introduction-to-Databases-Review.pdf
001 Lesson-1-Sql-Training-Academy-Overview-of-Databases.pdf
002 Lesson #2 SQL How to Talk to Databases.mp4
14:20
002 Lesson-2-SQL-How-to-talk-to-Databases-Review.pdf
002 Lesson-2-Sql-Training-Academy-SQL-How-to-talk-to-a-database.pdf
003 Lesson #3 Client-Server Relationships Part 1.mp4
15:25
004 Lesson #4 Client-Server Relationships Part 2.mp4
19:05
004 Lesson-3-and-4-Client-Server-Relationships-Review.pdf
004 Lesson-4-Sql-Training-Academy-ClientServerRelationship.pdf
001 Lesson #5 Introduction Management Studio Part 1.mp4
01:42
002 Lesson #6 Introduction Management Studio Part 2.mp4
31:49
002 Lesson-5-and-6-Introduction-Management-Studio-Review.pdf
002 Lesson-6-Sql-Training-Academy-Management-Studio-Overview.pdf
003 Lesson #7 Database Objects Part 1.mp4
05:06
004 Lesson #8 Database Objects Part 2.mp4
17:29
004 Lesson-7-and-8-Database-Object-Hierarchy-Review.pdf
004 Lesson-8-Sql-Training-Academy-Database-Objects.pdf
005 Lesson #9 Tables Part 1.mp4
08:06
006 Lesson #10 Tables Part 2.mp4
28:33
006 Lesson-9-and-10-Tables-Review.pdf
006 Lesson-10-Sql-Training-Academy-Tables.pdf
007 Lesson #11 Creating Stuff Part 1.mp4
25:58
007 Lesson-11-Sql-Training-Academy-Creating-Stuff.pdf
008 Lesson #12 Creating Stuff Part 2.mp4
29:52
008 Lesson-11-and-12-Creating-Stuff-Review.pdf
009 Lesson #13 Creating Stuff with Scripts Part 1.mp4
20:10
009 Lesson-13-Sql-Training-Academy-Creating-Stuff-with-Scripts.pdf
010 Lesson #14 Creating Stuff with Scripts Part 2.mp4
28:51
010 Lesson-13-and-14-Creating-Stuff-with-Scripts-Review.pdf
001 Lesson #15 CRUD Part 1.mp4
24:30
001 Lesson-15-Sql-Training-Academy-CRUD.pdf
002 Lesson #16 CRUD Part 2.mp4
25:55
002 Lesson-15-and-16-CRUD-Review.pdf
003 Lesson #17 Beginning Select Statements.mp4
06:23
003 Lesson-17-to-26-Sql-Training-Academy-Select-Statements.pdf
004 Lesson #18 Where Clause Part 1.mp4
15:56
005 Lesson #19 Where Clause Part 2.mp4
15:30
005 Lesson-18-and-19-Where-Clause-Review.pdf
006 Lesson #20 Sorting.mp4
12:48
006 Lesson-20-Sorting-Review.pdf
007 Lesson #21 Column List Part 1.mp4
14:23
008 Lesson #22 Column List Part 2.mp4
14:32
008 Lesson-21-and-22-Column-List-Review.pdf
009 Lesson #23 Group By.mp4
16:45
009 Lesson-23-Group-By-Review.pdf
010 Lesson #24 Having Clause.mp4
11:32
010 Lesson-24-Having-Clause-Review.pdf
011 Lesson #25 Joining Part 1.mp4
12:43
012 Lesson #26 Joining Part 2.mp4
14:26
012 Lesson-25-and-26-Join-Clause-Review.pdf
001 Lesson #27 Views Part 1.mp4
30:05
001 Lesson-27-and-28-Sql-Training-Academy-Views.pdf
002 Lesson #28 Views Part 2.mp4
27:02
002 Lesson-27-and-28-View-Review.pdf
003 Lesson #29 Scripting with Variables Part 1.mp4
10:17
003 Lesson-29-and-30-Sql-Training-Academy-Scripting-with-Variables.pdf
004 Lesson #30 Scripting with Variables Part 2.mp4
15:17
004 Lesson-29-and-30-Scripting-with-Variables-Review.pdf
005 Lesson #31 Stored Procedures Part 1.mp4
14:04
005 Lesson-31-and-32-Sql-Training-Academy-Stored-Procedures.pdf
006 Lesson #32 Stored Procedures Part 2.mp4
18:25
006 Lesson-31-and-32-Stored-Procedures-Review.pdf
007 Lesson #33 Functions Part 1.mp4
10:02
007 Lesson-33-and-34-Sql-Training-Academy-Functions.pdf
008 Lesson #34 Functions Part 2.mp4
13:01
008 Lesson-33-and-34-Functions-Review.pdf
001 Lesson #35 Security Part 1.mp4
05:38
002 Lesson #36 Security Part 2.mp4
20:05
002 Lesson-36-and-37-Sql-Training-Academy-Security.pdf
003 Lesson #37 Security Part 3.mp4
26:42
003 Lesson-35-and-36-and-37-Security-Review.pdf
004 Lesson #38 Backups Part 1.mp4
06:23
005 Lesson #39 Backups Part 2.mp4
13:13
005 Lesson-38-and-39-Backups-Review.pdf
005 Lesson-39-Sql-Training-Academy-Backups.pdf
006 Lesson #40 Indexes Part 1.mp4
09:28
007 Lesson #41 Indexes Part 2.mp4
06:45
008 Lesson #42 Indexes Part 3.mp4
13:44
008 Lesson-40-and-41-and-42-Indexes-Review.pdf
008 Lesson-42-Sql-Training-Academy-Indexes.pdf
001 Bonus #1 SQL and SQL Server Reporting Services.mp4
25:35
002 Bonus #2 SQL and Microsoft Excel.mp4
13:50
003 Bonus #3 SQL and Power Pivot.mp4
10:22
004 Bonus #4 SQL and Microsoft Access.mp4
20:57
005 Bonus #5 SQL Import and Export.mp4
16:06
Description
Step-by-Step Beginner's Training Course in SQL Server. No prior database knowledge is needed.
What You'll 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 is this for?
What You Need to Know?
More details
Description 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.
Who this course is for:
- 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.
Who this course is for:
- 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.
User Reviews
Rating
average 0
Focused display
Category
Joey Blue
Instructor's CoursesJoey has been working with Data for over 21 years. He works during the day as a consultant in the Business Intelligence space, which includes SQL Server and its BI Stack. In the evenings, he creates videos on YouTube
to document some of the problems he runs into working with customers. On Udemy, Joey has put together some
excellent trainings. Don’t forget to visit Joey’s website to find
extra videos and discounts. “Send me a message if you have any questions
about my videos and training.”
Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 52
- duration 13:15:33
- English subtitles has
- Release Date 2023/09/13
