✓ Course SQL Script Included!
✓ SQL queries broken down into ACTIONABLE STEPS.
✓ Before you know it, you’ll be scripting SQL queries on your own!
✓ WRITE SQL Queries in Your SQL Server Databases
✓ CREATE Select Queries
✓ FILTER with the WHERE Clause
✓ SORT Your Database Records
✓ GROUP Your Records
✓ USE Aggregate Functions
✓ LEARN Different Date Functions
✓ GET Familiar with Functions You Can Use with Strings
✓ LEARN How to Join Tables
✓ CREATE Subqueries
✓ CREATE Tables Using SQL
✓ INSERT Records Into Your Tables
✓ CREATE Views
✓ … and more!
• Download the databases to follow along. This is covered in the lecture, “Installing the Exercise Databases”
• Access to one of the following versions of SQL Server & SQL Server Management Studio
• ———————
• SQL Sever 2017
• SQL Server 2016
• SQL Server 2014
• SQL Server 2012
• SQL Server 2008 R2
• SQL Server 2008
• This SQL course is for new SQL Server users who are not yet familiar with SQL syntax. This course is for those who will be gathering and mining for data, not for database administrators looking to learn about implementation, or security. No prior programming knowledge is needed. This course is probably not for you is you are looking to learn super advanced queries.
• This SQL course is not for you if you are already 100% comfortable with SQL.
• This SQL course is for SQL Server user who are looking to query databases.
• This SQL course is not for SQL user who are looking for information about database administration, or security policies.
IsáBel . has created 13 courses that got 3,486 reviews which are generally positive. IsáBel . has taught 30,838 students and received a 4.6 average review out of 3,486 reviews. Depending on the information available, we think that IsáBel . is an instructor that you can trust.
Would You Like to Get the Tips, Tools, and Exercises You Need for the Technical, Business, and Software Skills You Want?IsáBel Will Show You How.
ABOUT
Since 1999 IsáBel has been training you – the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsáBel.
Technical courses in everyday language are offered in her Udemy portfolio.
IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.
IsaBel grew up around teachers, so education was always important to her.
All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.
She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.
COURSES ON UDEMY.COM
SQL:
– Microsoft Access SQL: SQL for Non-Programmers
– SQL Made Simple: SQL Server Queries for Non-Programmers
Microsoft Office:
– Excel Pivot Tables: The Power of Pivot Tables… Made Easy
– Excel: Time Saving Tips That Will Boost Your Productivity ✔
– Excel VBA: The VBA Beginner’s Blueprint to Programming Excel
– Access: Time Saving Tips That Will Boost Your Productivity ✔
– Access Macros: Automate Your Access Databases
– Microsoft Access: Beyond the Basics of Access Bundle
– Access VBA: The Beginner’s Blueprint to Programming Access
– Microsoft Word: Forms, Mail Merge, and Field Code Rules
– Microsoft Word Time Saving Tips To Boost Your Productivity ✔
– Microsoft Office: Word, Excel and Access Productivity Bundle
SharePoint:
– SharePoint 2010: Survey Creation for SharePoint Admins
– SharePoint 2013: Survey Creation for SharePoint Admins
RESOURCES:
▶Subscribe to My YouTube Channel for Video Clips, because Change Matters, Growth Matters.