Topic: SQL Basics in 30 Minutes - Part 2: We'll dive into CREATE command. We'll 'Create' Tables, Temp Tables, Table Variables and Variables. We are going to 'Insert' data into this table (INSERT INTO) and we'll occasionally 'DROP' the tables.
Topic: SQL Basics in ~30 Minutes - Part 1: Visual demonstration of Select, From and Where clauses in SQL Server 2005. I've created a little table in Excel so beginners can visual these SQL commands.
Business Intelligence and SQL go hand to hand. You cannot be an expert BI Consultant without knowing SQL proficiently. Sure, in a large enterprise scenario, BO Admins and Architects for example may never need to type a single SQL query, but you are not likely going to be a confident consultant. In the world of BI, SQL is your best friend!
This part 1 is for absolute beginners. I didn't wan't to jump into creating tables and stuff, and thought maybe it'd be helpful for the beginners to kind have most of the important commands in one short video series. I am going to cover few more important SQL commands in the next 2 videos including Create (Tables), Insert Into, Views and more.
We have completely RE-designed http://LetsLearnBI.com with friendlier features, intuitive navigation AND Interactive Forums! Please visit our new site!
1) Connect with SOCIAL CONNECT
3) "LETS-TALK" section to ask your questions to all active members, including me!
4) Create any topics to ask any questions to the the community to receive prompt answers for YOUR BI Tool.
4) Subscribe to our site OR your individual forum topics.
