What you'll learn
- create, alter and drop tables in a database.
- know what data type to use in various situations.
- use functions to manipulate date, number and string data values.
- work towards objectives 1 and 8 from Microsoft Certification 70-461 "Querying Microsoft SQL Server 2012"
Description
If you are in UfB, welcome.
If you are not, don't buy this course. Instead, please look at my 70-461 Session 1-7: Querying Microsoft SQL Server (SQL code) course instead, which includes this course and 6 other courses.
Reviews:
"Best I've seen. Instead of just throwing information at me, I'm able to work along with the instructor. Thanks!!!" -- Charles Schweiger
"Lots of material covered in an easy-to-follow way. Not too slow, and not too face. Great job!" -- Anita Parks
This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012/2014".
Rather than present one huge course, this course takes some of the basics and then goes in depth. The basics presented are: how to install SQL Server, and how to create and drop tables.
We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.
In session 2 (the second half of this course), we'll look at the 6 principal clauses of the SELECT statement: SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. We'll look at how the FROM can be expanded to JOIN 2 or 3 tables, and then we'll finish by inserting, updating and deleting data.
No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!
There are regular quizzes to help you remember the information.
Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, and have an appreciation of how they can all be used in T-SQL.
Students also bought
2021 Complete Python Bootcamp From Zero to Hero in Python
The Complete JavaScript Course 2021: From Zero to Expert!
React - The Complete Guide (incl Hooks, React Router, Redux)
Información sobre el Instructor
- 4.5 Calificación
- 319973 Estudiantes
- 47 Cursos
Phillip Burton
Best Selling Instructor - over 300,000 students so far
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.
Student feedback
Course Rating
Reviews
good and understandable
It is a basic course, if you are new to sql server, this is the best you can learn. Thanks Mr. Burton