Descriptions
Complete SQL course with SQL server. The course will teach you how to interact with relational databases using SQL inside a SQL server. It also covers broader concepts such as data architecture and converting tables to JSON, which is useful for many web applications and APIs. It starts at the beginner level and then moves to the expert level. For those who need to quickly get up to speed, there is an accelerated route. This allows time-pressed students to learn SQL at a good level and return later when time allows to cover all the material. Each topic taught is structured so that it covers theory and then contains worked examples that you are encouraged to follow along with. Later in the course, a mini-project is created to explore advanced SQL capabilities. This section demonstrates practical problems that you are likely to encounter in the real world.
Advanced topics such as indexes and transactions are covered in detail to help you understand areas useful in the real world, such as query optimization and ACID compliance. From my 15 years of database development experience and teaching colleagues, I have selected all the topics that will enable you to become an expert SQL developer. The course is structured to accommodate people from a variety of backgrounds, from beginners with no programming experience to those with experience in other languages and already have some knowledge of SQL. Those with more experience will progress through the initial sections faster, but will also gain new development knowledge. They will also appreciate the depth of the subsequent sections. A complete beginner will appreciate the clear instructions and the lack of any prior knowledge.
What will you learn
- Set up SQL Server and use SQL Server Management Studio (SSMS) and Azure Data Studio to write queries.
- Set up a cloud instance of SQL Server Azure.
- Select, sort and filter data based on priority order.
- Modify data using string, date, and math functions.
- Convert data types and apply decision logic.
- Aggregate and group data both across the table and according to Windows functions.
- Simplify more complex requirements with subqueries.
- Table relationship structure and cardinality.
- Join tables using INNER, OUTER, FULL, and CROSS joins.
- Merging multiple data sets together.
Who is this course for?
- This course is for anyone who works with data. You may be a BI developer, data engineer, data analyst, data scientist, web developer, programmer, student, or work in a non-technical field like finance, but you need to extract and manipulate data from a database. The course will transform those with little or no knowledge into SQL experts.
Complete SQL Course Specification with SQL Server
- Publisher: Udemy
- Teacher: Robert Meldrum
- English language
- Level: Beginner
- Number of courses: 91
- Duration: 14 hours 42 minutes.
Content for 2024-2
Requirements
- The course assumes no prior knowledge and will guide you through every step. For those who already have some programming or SQL experience, your knowledge will be expanded and you will gain a deeper understanding of SQL development and database concepts.
Images
Sample clip
Installation instructions
Extract the files and watch on your favorite player
Subtitles: Not available
Quality: 720p
Download links
Password file(s): free download software
file size
4.07 GB